ElaaNet

Use the following script to detect scroll up and scroll down events <script type="text/javascript"> $(document).ready(function(){ var LastScroll=0;   //  I am using div element's scroll here.     $("div").scroll(function(){          if(LastScroll<$("div").scrollTop())          {               //scroll down event           }           else            {                 //scroll up event             }              LastScroll=$("div").scrollTop();      }); }) </script>

Mapping .NET Data Types to MySQL Data Types .NET Data Types MySQL Data Types System.Boolean boolean, bit(1) System.Byte tinyint unsigned System.Byte[] binary, varbinary, blob, longblob System.DateTime datetime System.Decimal decimal System.Double double System.Guid char(36) System.Int16 smallint System.Int32 int System.Int64 bigint System.SByte tinyint System.Single float System.String char, varchar, text, longtext System.TimeSpan time DateTimeOffset type is not supported.

Solution : start-> Run--> c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -iru use of -iru option -ir Installs and registers ASP.NET 4. This option is the same as the -i option except that this option does not change the CLR version that is associated with any existing application pools.   -  iru                    If ASP.NET is not currently registered with IIS, performs the tasks described for -i . If a previous version of ASP.NET is already registered with IIS, this option performs the tasks described for -ir .

Stored Procedure to find data for x meter radious from a point using SQL Server geography data. Create Procedure GetXMeterRadiousData (  @RadiousInMeter INT=0,  @Point GEOGRAPHY=NULL,  @Mode VARCHAR(10)='DISTANCE' ) AS BEGIN DECLARE @g geography IF (@Mode='DISTANCE')   -- Using Distance method      BEGIN  -- Get the point             SELECT @g = geo FROM SpacialDataTable             WHERE geo = @Point             -- Get the results, radius @RadiousInMeter            SELECT * FROM SpacialDataTable            WHERE @g.STDistance(geo) <= @RadiousInMeter          END ELSE   -- Using INTERSECTS method       BEGIN  -- Get the center buffer, @RadiousInMeter radius  SELECT @g = geo.STBuffer(@RadiousInMeter) FROM SpacialDataTable  WHERE geo = @Point  -- Get the results within the buffer  SELECT * FROM SpacialDataTable WHERE @g.STIntersects(geo) = 1       END END

To convert .Net data type to sql server data type the following link will be very useful. Mapping CLR Parameter Data

Use the following method to invite a user to your facebook application. public bool InviteAFacebookUser(string AccessToken, string AppId, string Msg) {      bool result=false;      try      {            FacebookClient fbClient = new FacebookClient(AccessToken);            var args = new Dictionary<string, object>();            args["appId"] = AppId; //event id            args["message"] = Msg;            dynamic id = fbClient.Post("/me/apprequests", args);            result=true;        }        catch        {            //I am suppressing the exception.        }        return result; }

Use the following code to set width or any html attributes like style, class, etc. to Html.TextBoxFor html helper. @Html.TextBoxFor(m => m.Email, new { Class = "mystyle" }) 

Facebook - Use the following method to feed a post on facebook using FacebookClient api in C# public bool PostOnWall(IDictionary<string, object> Parameters,string AccessToken) {     if (Parameters.Keys.Count > 0)     try     {          FacebookClient fbClient = new FacebookClient(AccessToken);          fbClient.Post("/me/feed", Parameters);          return true;     }     catch { }     return false; }

Use the following method to get access permissions of a user for a facebook Application using FacebookClient api. public IDictionary<string, object> GetPermissions(string AccessToken) {      IDictionary<string, object> me = new Dictionary<string, object>();      try      {                 FacebookClient fbClient = new FacebookClient(AccessToken);                 me = fbClient.Get("me") as IDictionary<string, object>;       }       catch { //suppressing all exception }       return me; }

C# - Dynamic Object Use the following code to get Name and Value of a dynamic object's property. dynamic d = new { Property1= "Value1", Property2= "Value2"}; var properties = d.GetType().GetProperties(); foreach (var property in properties) {     var PropertyName= property.Name; //You get "Property1" as a result     var PropetyValue= d.GetType().GetProperty(property.Name).GetValue(d, null); //You get "Value1" as a result // you can use the PropertyName and Value here  }

// Use the following code to get the user ipaddress public string GetCurrentIpAddress(HttpContextBase httpContext) { if (httpContext != null && httpContext.Request != null && httpContext.Request.UserHostAddress != null) return httpContext.Request.UserHostAddress; else return string.Empty; } //syntax for calling the above method. string UserIp = GetCurrentIpAddress(Request.RequestContext.HttpContext);

I found a nice article on the following link http://www.meineck.net/2008/04/wcf-hosting-multiple-wcf-services-as.html

The following method used to set last session id to the new request. we can use the following mehtod to maintain the same session for a user with cross browser request or request from different locations ( different IP).     public void SetLastSession(string LastSessionId) {    HttpCookie cookie =      new HttpCookie ( "ASP.NET_SessionId" , LastSessionId) { Path = "/" ,   HttpOnly = true };    this .Context.Response.Cookies.Remove( "ASP.NET_SessionId" );    this .Context.Response.Cookies.Add(cookie); }