Skip to content

Instantly share code, notes, and snippets.

View menacestudio's full-sized avatar

Dennis Rongo menacestudio

8 followers · 2 following
View GitHub Profile
@menacestudio
menacestudio / upload.cs
Created June 12, 2014 22:32
File upload
HttpFileCollection uploadFiles = Request.Files;
// Build HTML listing the files received.
string summary = "<p>Files Uploaded:</p><ol>";
// Loop over the uploaded files and save to disk.
int i;
for (i = 0; i < uploadFiles.Count; i++)
{
HttpPostedFile postedFile = uploadFiles[i];
@menacestudio
menacestudio / 0_reuse_code.js
Created August 16, 2014 07:33
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@menacestudio
menacestudio / index.cshtml
Last active August 29, 2015 14:07
MVC app sample
@model ViewModels.IProjectViewModel
@{
var projects = Model.GetProjects(Model.ProjectModel.Id);
ViewBag.Title = "All Projects View";
}
@section scripts {
<script>
$(function () {
@menacestudio
menacestudio / user_defined_type.sql
Last active August 29, 2015 14:09
Using a user defined type in SQL.
ALTER PROCEDURE [dbo].[usp_SaveSearch]
@userId INT,
@searchId INT = 0,
@searchName VARCHAR(250) = '',
@searchCriteria dbo.TvpItem readonly
AS
BEGIN
SET NOCOUNT ON;
IF (@searchID = 0)
@menacestudio
menacestudio / dynamic_cursor_sample.sql
Created November 13, 2014 03:11
Dynamic and cursor sample
CREATE TABLE #codes ( code VARCHAR(10))
INSERT INTO #codes( code )
SELECT distinct c.someCode FROM dbo.tbl_Sample c WITH(NOLOCK) WHERE c.isDeleted=0 AND NOT ISNULL(c.parts,'')='C'
AND c.someDate1 >= @anotherDate AND c.someDate1 <= @endDate
AND c.providerID IN (SELECT userId from #tmpTable)
ORDER by c.someCode
-- Temp table for output
CREATE TABLE #tbl_Sample2 (userid INT, employee VARCHAR(200), type VARCHAR(150), results INT null)
@menacestudio
menacestudio / sample_cte_paging.sql
Created November 13, 2014 03:19
Sample paging in TSQL using common table expression (CTE)
-- Calculate paging
DECLARE @topRecord VARCHAR(20) = CAST(((@pageSize+@offset)+1) AS VARCHAR)
DECLARE @cte_query NVARCHAR(MAX)
SET @cte_query = WITH cte_res
AS ( SELECT ROW_NUMBER() OVER(ORDER BY ['+@sortBy+'] '+@sortDir+') AS rowid, count(*) over() as TotalRecords,* from (SELECT * FROM #someTable WITH(NOLOCK)) as table1)
select rowID, TotalRecords, id, someField from cte_res with(nolock) where rowid>'+ CAST(@offset AS VARCHAR) +' and rowid< ' + @topRecord
EXECUTE sp_executesql @cte_query
@menacestudio
menacestudio / controller.js
Last active August 29, 2015 14:10
Angular using Angular directives for Bootstrap
(function(app) {
app.controller('Ctrl', Ctrl);
app.controller('CtrlModal', CtrlModal);
//Ctrl.$inject = ['$scope', '$modal', 'dataservice'];
function Ctrl($scope, $modal, dataservice) {
var vm = this;
@menacestudio
menacestudio / service.js
Created December 7, 2014 09:46
Angular ngResource sample
angular.module("exampleApp", []).service('exampleService', ["$http", "$q" ,function ($http, $q) {
var service = {
returnedData: [],
dataLoaded:{},
getData = function(forceRefresh)
{
var deferred = $q.defer();
if(!service.dataLoaded.genericData || forceRefresh)
{
@menacestudio
menacestudio / index.html
Created December 9, 2014 05:20
Angular CRUD
<!DOCTYPE html>
<html>
<head>
<script data-require="angular.js@*" data-semver="1.3.5" src="https://code.angularjs.org/1.3.5/angular.js"></script>
<script src="https://code.angularjs.org/1.3.5/angular-route.js" data-semver="1.3.5" data-require="angular-route@*"></script>
<script data-require="angular-resource@1.3.5" data-semver="1.3.5" src="https://code.angularjs.org/1.3.5/angular-resource.js"></script>
<link href="style.css" rel="stylesheet" />
<script src="script.js"></script>
</head>
@menacestudio
menacestudio / scoreDirective.js
Created March 13, 2015 21:35
An AngularJS directive for handling score input.
scoreInput.$inject = [];
function scoreInput() {
return <ng.IDirective>{
restrict: 'E',
replace: true,
scope: {
model: '=ngModel',
isRequired: '=',
isReadonly: '=',