Skip to content

Instantly share code, notes, and snippets.

View crowcoder's full-sized avatar

Bob crowcoder

17 followers · 3 following
View GitHub Profile
@crowcoder
crowcoder / OutputNoDefault
Last active October 15, 2016 16:13
private static void OutputNoDefault(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Output_No_Default";
SqlParameter par = new SqlParameter("@param1", SqlDbType.VarChar);
par.Direction = ParameterDirection.Output;
par.Size = 50;
par.Value = null;
cmd.Parameters.Add(par);
@crowcoder
crowcoder / usp_Output_No_Default
Last active October 15, 2016 16:22
CREATE PROCEDURE [dbo].[usp_Output_No_Default]
@param1 VARCHAR(50) OUTPUT
AS
SELECT @param1;
SET @param1 = 'changed by procedure';
RETURN 0
@crowcoder
crowcoder / StockServiceMocks
Created November 5, 2017 20:52
using Moq;
using Service;
using System;
namespace Business.Tests
{
public static class StockServiceMocks
{
/// <summary>
/// Causes GetCurrentPrice to return a specific price or optionally throws an exception.
@crowcoder
crowcoder / IStockService
Created November 5, 2017 20:56
namespace Service
{
public interface IStockService
{
Trade Buy(string ticker, decimal nbrShares);
decimal GetCurrentPrice(string ticker);
Trade GetLastTrade(string ticker);
Trade Sell(string ticker, decimal nbrShares);
}
}
@crowcoder
crowcoder / ILogService
Created November 5, 2017 20:57
namespace Service
{
public interface ILogService
{
void Log(string logMessage);
}
}
@crowcoder
crowcoder / StocksLogic
Created November 5, 2017 20:58
using Service;
using System;
namespace Business
{
public class StocksLogic
{
private readonly IStockService _stockService;
private readonly ILogService _logService;
@crowcoder
crowcoder / StockTest
Last active November 5, 2017 21:03
[TestMethod]
public void BuyWhenLastTradeWasSell_Test()
{
#region setup the stock service
decimal simulatedCurrentPrice = 8.03m;
Trade simulatedLastTrade = new Trade
{
Ticker = "ABC",
Side = "sell",
@crowcoder
crowcoder / BasicGameIntegration
Last active January 26, 2019 15:56
BasicGameIntegration
<!doctype html>
<html>
<head>
<!-- stuff... -->
</head>
<body>
<div id="gameDiv"></div>
<script src="https://newupwaititsfun.z13.web.core.windows.net/frog/game.js" integrity="sha384-qoRzVFhcu3MPqU4+hUIAG45mJWAXYwf1QDlkHQY2519KjBjFyETk7mTDV/wY9AD1"
crossorigin="anonymous"></script>
</body>
@crowcoder
crowcoder / CSharpBasicAlternateDataStream
Last active August 13, 2019 12:05
A bare-bones example of how to write alternate data streams with C#
using Microsoft.Win32.SafeHandles;
using System;
using System.IO;
using System.Runtime.InteropServices;
namespace AlternateDataStreams
{
class Program
{
[DllImport("kernel32.dll", SetLastError = true, CharSet = CharSet.Auto)]
@crowcoder
crowcoder / Cosmos StoredProcedure
Created October 14, 2019 20:00
using System;
using System.Net.Http;
using System.Threading.Tasks;
namespace CosmosCreateSproc
{
class Program
{
static async Task Main(string[] args)
{