Skip to content

Instantly share code, notes, and snippets.

View AsifMushtaq's full-sized avatar

Asif Mushtaq AsifMushtaq

20 followers · 33 following
View GitHub Profile
@AsifMushtaq
AsifMushtaq / FakeDbSet.cs
Created February 14, 2017 00:10
FakeDbSet with async support
public class FakeDbSet<T> : IDbSet<T>, IDbAsyncEnumerable<T> where T : class
{
readonly ObservableCollection<T> _data;
readonly IQueryable _queryable;
public FakeDbSet()
{
_data = new ObservableCollection<T>();
_queryable = _data.AsQueryable();
}
@AsifMushtaq
AsifMushtaq / Async and Await.md
Last active August 29, 2015 14:12
@AsifMushtaq
AsifMushtaq / Dynamic Pivot 2
Created August 21, 2014 05:03
-Create Temporary Table #CourseSales
CREATE TABLE #CourseSales
(Course VARCHAR(50),Year INT,Earning MONEY)
GO
--Populate Sample records
INSERT INTO #CourseSales VALUES('.NET',2012,10000)
INSERT INTO #CourseSales VALUES('Java',2012,20000)
INSERT INTO #CourseSales VALUES('.NET',2012,5000)
INSERT INTO #CourseSales VALUES('.NET',2013,48000)
INSERT INTO #CourseSales VALUES('Java',2013,30000)
@AsifMushtaq
AsifMushtaq / Dynamic Pivot
Created August 21, 2014 03:38
Dynamic Pivot
create table temp
(
date datetime,
category varchar(3),
amount money
)
insert into temp values ('1/1/2012', 'ABC', 1000.00)
insert into temp values ('2/1/2012', 'DEF', 500.00)
insert into temp values ('2/1/2012', 'GHI', 800.00)
@AsifMushtaq
AsifMushtaq / PIVOT 2
Created August 14, 2014 04:35
CREATE TABLE #t ( id int, Rscd varchar(10),Accd varchar(10),position int)
INSERT INTO #t Values (10,'A','B',1)
INSERT INTO #t Values (10,'C','D',2)
select id, [1], [2], [11], [12]
from
(
select id, col, value
@AsifMushtaq
AsifMushtaq / PIVOT
Created August 14, 2014 00:17
;WITH BaseQuery AS(
SELECT TotalDue, YEAR(OrderDate) AS OrderYear,
DATENAME(MONTH,OrderDate) AS OrderMonth
FROM Sales.SalesOrderHeader
)
SELECT OrderYear,January,February,March,April,May,
June,July,August,September,October,November,December
FROM BaseQuery
PIVOT(SUM(TotalDue) FOR OrderMonth IN (January,February,March,
April, May,June,July,August,September,October,November,
@AsifMushtaq
AsifMushtaq / Searching nearby points of interest based on Geo locaction
Created March 28, 2014 11:32
Searching nearby points of interest based on Geo locaction
Searching nearby points of interest based on Geo locaction
search?type=place&center=33.586685,73.090153&distance=1000
http://maps.google.com/?ll=33.586685,73.090153&q=33.586685,73.090153
Scheme III lat lon: 53.34316,-6.328168
@AsifMushtaq
AsifMushtaq / Hidding Data in Word List Implementation
Created March 10, 2014 11:20
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Threading;
namespace MissingLetterPuzzel
{
class Program
@AsifMushtaq
AsifMushtaq / Missing Letter Puzzel Implementation
Last active August 29, 2015 13:56
Missing Letter Puzzel Im
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace MissingWordPuzzel
{
class Program
{
@AsifMushtaq
AsifMushtaq / SQL XML
Created February 12, 2014 10:18
SQL SERVER – Simple Example of Creating XML File Using T-SQL
SELECT (
SELECT 'White' AS Color1,
'Blue' AS Color2,
'Black' AS Color3,
'Light' AS 'Color4/@Special',
'Green' AS Color4,
'Red' AS Color5
FOR
XML PATH('Colors'),
TYPE