Skip to content

Instantly share code, notes, and snippets.

View KerryRitter's full-sized avatar

Kerry Ritter KerryRitter

View GitHub Profile
@KerryRitter
KerryRitter / FormRepository.cs
Last active March 16, 2017 18:32
xamarin.forms form example
using System;
using System.Collections.Generic;
using System.Linq;
using Realms;
using StubbsTest.Models;
namespace StubbsTest.Data
{
public class FormRepository : IDisposable
{
{
"compilerOptions": {
"declaration": false,
"emitDecoratorMetadata": true,
"experimentalDecorators": true,
"module": "none",
"moduleResolution": "node",
"sourceMap": true,
"target": "es5",
"inlineSources": true,
@KerryRitter
KerryRitter / loadingService.ts
Created January 17, 2017 19:07
Angular Loading service using Bootstrap UI
import { Inject, Service } from "core/decorators";
@Service("loadingService")
export class LoadingService {
private _modal: ng.ui.bootstrap.IModalServiceInstance;
constructor(
@Inject("$uibModal") private _modalService: ng.ui.bootstrap.IModalService
) {
}
@KerryRitter
KerryRitter / app.ts
Created December 13, 2016 02:32
webpack typescript test
import { Person } from "./person";
import "test";
const person = new Person("Kerry", "Ritter");
alert(person.fullName);
@KerryRitter
KerryRitter / dappermap.cs
Created December 9, 2016 17:19
dapper mapping
public class OmgDapperRules
{
public List<ProjectVersionField> GetAllForVersion(int projectVersionId)
{
using (var connection = _connectionFactory.Create())
{
var fields = connection.Query<ProjectVersionField, ProjectTemplateField, ProjectTemplateFieldType, ProjectVersionField>(@"
SELECT pvf.*, ptf.*, ptft.*
FROM [dbo].[ProjectVersionField] pvf
INNER JOIN [dbo].[ProjectTemplateField] ptf ON ptf.Id = pvf.ProjectTemplateFieldId
@KerryRitter
KerryRitter / CigarController.cs
Last active November 7, 2016 16:53
bedframe example
public class CigarSerializer : Serializer<Cigar, CigarDto>
{
public Cigar Serialize(CigarDto request)
{
return new Cigar
{
Name = request.Name,
Brand = request.Brand
};
}
@KerryRitter
KerryRitter / example.cs
Last active November 3, 2016 14:36
Dapper relationship query example
using (var connection = new SqlConnection(_config["Connection"]))
{
string query = @"SELECT *
FROM [Template]
WHERE [Type] = @type;
SELECT tct.TemplateId as TemplateId, tc.Name as CategoryName
FROM [TemplateCategory_Template] tct
JOIN [TemplateCategory] tc ON tct.TemplateCategoryId = tc.Id;
@KerryRitter
KerryRitter / ContextFactory.cs
Last active November 3, 2016 14:16
Dapper.Contrib test
using System.Data.SqlClient;
using System.Configuration;
namespace DapperTest
{
public static class ContextFactory
{
public static SqlConnection Create() => new SqlConnection(ConfigurationManager.ConnectionStrings["MyCxn"].ConnectionString);
}
}
@KerryRitter
KerryRitter / gist:1de4f773391a77214942
Last active September 13, 2016 18:49
AsMockDbSet extension for IEnumerables
public static Mock<DbSet<T>> AsMockDbSet<T>(this IEnumerable<T> data) where T : class
{
var mockSet = new Mock<DbSet<T>>();
var queryable = data.AsQueryable();
mockSet.As<IQueryable<T>>().Setup(m => m.Provider).Returns(() => queryable.Provider);
mockSet.As<IQueryable<T>>().Setup(m => m.Expression).Returns(() => queryable.Expression);
mockSet.As<IQueryable<T>>().Setup(m => m.ElementType).Returns(() => queryable.ElementType);
mockSet.As<IQueryable<T>>().Setup(m => m.GetEnumerator()).Returns(() => queryable.GetEnumerator());
@KerryRitter
KerryRitter / CsvBuilder.cs
Created August 17, 2016 20:34
CsvBuilder.cs
/// <summary>
/// Class for building CSV outputs
/// </summary>
/// <seealso cref="System.IDisposable" />
public class CsvBuilder : IDisposable
{
private readonly StringBuilder _stringBuilder;
private readonly string _delimiter;