Skip to content

Instantly share code, notes, and snippets.

View orhanveli's full-sized avatar

orhan orhanveli

  • Finbyte GmbH
  • Turkiye
  • 07:36 (UTC +03:00)
View GitHub Profile
@orhanveli
orhanveli / yyyymmdd.sql
Last active September 28, 2015 04:28
MySQL Format a date in SQL like yyyymmdd
SELECT
DATE_FORMAT(wk,'%Y%m%d'),
wk,
song
FROM totp
WHERE singer='Madness'
@orhanveli
orhanveli / count.cs
Created December 2, 2011 20:39
nhibernate record cound example
public int GetListCount(params ICriterion[] where)
{
var criteria = Session.CreateCriteria(typeof(T));
if (where != null)
foreach (var criterion in where)
{
criteria.Add(criterion);
}
@orhanveli
orhanveli / merge-lists.cs
Created December 11, 2011 17:25
c# merging two List<T>
using System.Collections.Generic;
List<CMSPage> list = new List<CMSPage>();
List<CMSPage> list2 = new List<CMSPage>();
list.Add(new CMSPage{ Title = "Bu Sayfa üst sayfa olsun", Id = 0 });
list.AddRange(list2);
@orhanveli
orhanveli / seo.js
Created December 11, 2011 19:40
JavaScript string.toSeaoString() extension
String.prototype.toSeoString = function (seperator) {
var s = this;
sprtr = !seperator ? "-" : seperator;
var seoFrinedly = new Array();
var chars = "SsUuOoIiCcGg";
for (i = 0; i < s.length; i++) {
var cChar = s[i];
if (cChar == sprtr || cChar == ".") {
continue;
@orhanveli
orhanveli / null.cs
Created December 14, 2011 10:15
NHibernate nullable field restriction
crit.Add(Restrictions.IsNull("ParentPage"));
@orhanveli
orhanveli / groupby.cs
Created December 14, 2011 17:43
NHibernate group by example
var list = crit.SetProjection(
Projections.ProjectionList().Add(Projections.GroupProperty("SourceName"))
).List<CMSNews>();
@orhanveli
orhanveli / distinct.cs
Created December 14, 2011 19:16
Nhibernate distinct by specific column example
crit.SetProjection(
Projections.Distinct(
Projections.Alias( Projections.Property("SourceName"), "SourceName" )
)
);
crit.SetResultTransformer( new NHibernate.Transform.AliasToBeanResultTransformer(typeof(CMSNews)));
@orhanveli
orhanveli / horizontal-scroll-with-mouse.js
Created December 19, 2011 20:25
jQuery Scroll Page Horizontally With Mouse Wheel
$(function() {
$("body").mousewheel(function(event, delta) {
this.scrollLeft -= (delta * 30);
event.preventDefault();
});
@orhanveli
orhanveli / flood.js
Created February 6, 2012 20:39
flood
var i = 0;
function runme() {
$("textarea[name='body']").val("test"+i);
$(".nq-submit input").click();
if(i < 10){
setTimeout("runme()", 1000);
}
}
runme();
@orhanveli
orhanveli / web_api_reader.cs
Created April 16, 2012 08:35
ASP.NET Web API den c# ile data okumak
var url = String.Format(String.Concat(PageConsts.C_ApiUrl, "/GetIsUserNameInUse?appKey={0}&userName={1}"), PageConsts.C_AppKey, username);
var wc = new WebClient();
bool isUserNameInUseResult = wc.DownloadString(url).ToBool();
if (isUserNameInUseResult)
{
r.ResultCode = "err";
r.ErrorMessages.Add(