Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am brknlpr on github.
  • I am bubu33 (https://keybase.io/bubu33) on keybase.
  • I have a public key whose fingerprint is E59F FCB7 387E 8919 0BAF 833A 031A ACF5 F42A 73D0

To claim this, I am signing this object:

@brknlpr
brknlpr / sql iteration sample
Created December 29, 2015 11:36
Sql Iteration
declare @cnt INT
declare @bas INT
declare @gameId INT
declare @tarih Datetime
declare @getId CURSOR
declare @now Datetime
declare @fark INT
set @now = getdate()
set @getId = CURSOR for (select [gameId], Max(hitTime) as tarih from [Kelimelik11].[dbo].[GameSequence] where [gameId] In (
select [id] from [Kelimelik11].[dbo].[GameDetails] where [isFinished] = 0) group by [gameId])
@brknlpr
brknlpr / Create Random Username
Last active November 23, 2015 11:19
Random Username
private readonly Random _rng = new Random();
private const string _chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
private string RandomString(int Size)
{
char[] buffer = new char[Size];
for (int i = 0; i < Size; i++)
{
buffer[i] = _chars[_rng.Next(_chars.Length)];
@brknlpr
brknlpr / Time Helper
Created September 16, 2015 13:19
Time Helper Class
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace KelimelikWebService.Helper
{
public class TimeHelper
{
public static string TimeAgo(DateTime dt)
@brknlpr
brknlpr / Message Class
Created September 16, 2015 13:06
Return Message Helper
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace KelimelikWebService.Helper
{
public class message
{
public string _title { get; set; }
@brknlpr
brknlpr / Check isWord
Created September 16, 2015 12:58
Türkçe kelime kontrol - wiktionary api
public class Page
{
public int pageid { get; set; }
public int ns { get; set; }
public string title { get; set; }
}
public class Query
{
public Dictionary<int, Page> pages { get; set; }
@brknlpr
brknlpr / Tr to En Dictionary
Created September 16, 2015 12:54
Turkish to English Dictionary Api
public class Word
{
public string lang { get; set; }
public string uid { get; set; }
public string title { get; set; }
public string desc { get; set; }
}
public class Control
{
@brknlpr
brknlpr / image resize
Created May 11, 2015 13:11
image resize
byte[] getResizedImage(Image _image, int _max)
{
Bitmap imgIn = new Bitmap(_image);
double y = imgIn.Height;
double x = imgIn.Width;
double factor = 1;
if (y > _max)
factor = _max / y;
using DataLibrary.Model;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
namespace DataLibrary
{
public class DataContext : DbContext