MVC- Custom Data Annotations validation server and client side

How to validate model in MVC?

Validation is most important part in any website which allows entering information.

Now, question is what is the easiest way to implement validation on MVC application?

Fortunately MVC provide a great facility for implement data validation using DataAnnotation.

I hope now day all are aware about of data annotation and attribute pattern for code, If you not aware then please do quick google for that.

In C# using data annotation we can validate our model using validation attributes

Need to add Data Annotation DLL: System.ComponentModel.DataAnnotations

It is inbuilt providing some validation attributes like required, string length etc..

In MVC we are prefer to working by model and we can validate model using data annotation class.

Example:

           public class TestModel2
            {
                public int Id { get; set; }
                [Required(ErrorMessage = "Name is Required")]
                public string Name { get; set; }
                [Required(ErrorMessage = "Email is Required")]
                [RegularExpression(@"^[\w\.=-]+@[\w\.-]+\.[\w]{2,3}$",
                     ErrorMessage = "Please enter valid email")]
                public string Email { get; set; }
                [StringLength(300)]
                public string Description { get; set; }
                [Compare("Email", ErrorMessage = 
                    "User name should be email id")]
                public string Username { get; set; }
                public DateTime PlanStratDate { get; set; }
                public DateTime PlanEndDate { get; set; }
                public string ExternalId { get; set; }
            }

           

We can validate model in both way at server side and also at client site.

For validation at client side we need to do some setting in web.config file.

In MVC 3 and onward that setting comes by default if u create project from internet website template.

MVC providing jquery.validate.js and [jquery.validate.unobtrusive.js for client side validation.

For more details about unobtrusive.js please refer blog : http://bradwilson.typepad.com/blog/2010/10/mvc3-unobtrusive-validation.html

In web.config file we need to add


Using built in validation attributes we covered almost every scenario. But in some case we need out of box validation.

For out of box validation we can create custom validation attributes and set on model.

Example:

       
        public class TestModel2
            {
                public int Id { get; set; }
                [Required(ErrorMessage = "Name is Required")]
                public string Name { get; set; }
                [Required(ErrorMessage = "Email is Required")]
                [RegularExpression(@"^[\w\.=-]+@[\w\.-]+\.[\w]{2,3}$", 
                ErrorMessage = "Please enter valid email")]
                public string Email { get; set; }
                [StringLength(300)]
                public string Description { get; set; }
                [Compare("Email", ErrorMessage =
                "User name should be email id")]
                public string Username { get; set; }
                public DateTime PlanStratDate { get; set; }
                [GratherThen("PlanStratDate")]
                public DateTime PlanEndDate { get; set; }
                [ExternalIdPattern]
                public string ExternalId { get; set; }
            }

        

First we need to create custom validation class and inherit from Validation Attribute class

After that need to implement one IsValidate override method and add your custom validation code in this method.

That's all almost done Now server side validation working for model.

Validation Class:

       public class ExternalIdPatternAttribute : ValidationAttribute , IClientValidatable
        {
            public ExternalIdPatternAttribute() : 
            base("External id should be match with system pattern") { }

            public override bool IsValid(object value)
            {
                const string matchingPattern = "code4help";
                return Convert.ToString(value).Contains(matchingPattern);
            }

            public IEnumerable[ModelClientValidationRule] GetClientValidationRules
            (ModelMetadata metadata, ControllerContext context)
                {
                   var errorMessage = ErrorMessageString;
                    var extidrule = new ModelClientValidationRule();
                    extidrule.ErrorMessage = errorMessage;
                    extidrule.ValidationType = "externalidpattern";
                    //extidrule.ValidationParameters.Add("otherpropertyname",
                         otherPropertyName);

                    yield return extidrule;
                }
         }


                
                


        public class GratherThenAttribute : ValidationAttribute , IClientValidatable
            {
                public string OtherProperty { get; set; }

                public GratherThenAttribute(string oprop)
                    : base("{0} should be grather then {1}")
                {
                    this.OtherProperty = oprop;
                }

                protected override ValidationResult IsValid(object value,
                 ValidationContext validationContext)
                {
                    var validationResult = ValidationResult.Success;
                    var otherPropertyval = 
                    validationContext.ObjectType.GetProperty(this.OtherProperty);
                    if (otherPropertyval.PropertyType == new DateTime().GetType())
                    {
                        var edate = (DateTime)value;
                        var sdate = 
                        (DateTime)otherPropertyval.GetValue(validationContext.ObjectInstance,
                         null);

                        if (edate.CompareTo(sdate) < 1)
                            validationResult = new ValidationResult(ErrorMessageString);
                    }
                    else
                        validationResult =
                            new ValidationResult(
                                "An error occurred while validating the property.
                                 OtherProperty is not of type DateTime");
                    return validationResult;
                }

                public IEnumerable[ModelClientValidationRule] 
                    GetClientValidationRules(ModelMetadata metadata, 
                    ControllerContext context)
                        {
                            var errorMessage = ErrorMessageString;

                            var extidrule = new ModelClientValidationRule();
                            extidrule.ErrorMessage = errorMessage;
                            extidrule.ValidationType = "gratherthen";
                            extidrule.ValidationParameters.Add("otherproperty", OtherProperty);

                            yield return extidrule;
                        }
                    }

            

For client side validation we need to implement IClientValidatable interface on custom validation class and get validation rule.

In validation rule validation type and all parameter should be in small case.

Now for start validation on client side we need to add custom javascript in unobtrusive script.

Code for custom validation client side:

            $.validator.addMethod("externalidpattern", function (value, element, params) {
            return Date.parse(value) > Date.parse($(params).val());
            });
            $.validator.unobtrusive.adapters.add("externalidpattern", [], function (options) {
                options.rules["externalidpattern"] = "#" + options.params.otherpropertyname;
                options.messages["externalidpattern"] = options.message;
            });

            $.validator.addMethod("gratherthen", function (value, element, params) {
                return Date.parse(value) > Date.parse($(params).val());
            });
            $.validator.unobtrusive.adapters.add("gratherthen", ["otherproperty"], function (options) {
                options.rules["gratherthen"] = "#" + options.params.otherpropertyname;
                options.messages["gratherthen"] = options.message;
            });

            

Okay now all done. Just need to add above js on page and all done for client and server side validation with custom attribute.

I Hope it will help!
Feel free to add comment. Enjoy coding.

JSON and XML serialization

Hello Friends, Today I will show how we do serialization in JSON and XML.
Today in technologies like JQuery and HTML5 and tons of JavaScript and JSON library, use of JSON and XML are very common.

Technologies like web 2.0 and onwards, MVVM and MVC most of everything done on client site using JSON and XML.

For use JSON and XML in web technology one thing is very important to know for batter use of serialization to object and object to JSON or XML.

In this post I will post some example to how to do serialization for object to JSON or XML and XML or JSON to object.

I am using MVC for demo. You can use this code where ever you want.

Frist we start with JSON Serialization:

1: Create Project and create model for test

             public class TestModel
            {
                public int id { get; set; }
                public string Name { get; set; }
                public List[string] lstskill { get; set; }
                public DateTime Birthday { get; set; }
                public bool Active { get; set; }
                public List[personaldata] Datalst { get; set; }
                public personaldata data { get; set; }
            }
            public class personaldata
            {
                public string data1 { get; set; }
                public string data2 { get; set; }
            }

           

2: Create JSON helper class for serialization

         NOTE: Please add reference of dll 
              [System.Runtime.Serialization.Json]
            
            

         public class JsonHelper
            {
                /// 

                /// JSON Serialization
                /// 
                public static string JsonSerializer[T](T t)
                {
                    DataContractJsonSerializer ser =
                     new DataContractJsonSerializer(typeof(T));
                    MemoryStream ms = new MemoryStream();
                    ser.WriteObject(ms, t);
                    string jsonString = Encoding.UTF8.GetString(ms.ToArray());
                    ms.Close();
                    return jsonString;
                }
                /// 

                /// JSON Deserialization
                /// 
                public static T JsonDeserialize[T](string jsonString)
                {
                    DataContractJsonSerializer ser =
                     new DataContractJsonSerializer(typeof(T));
                    MemoryStream ms =
                     new MemoryStream(Encoding.UTF8.GetBytes(jsonString));
                    T obj = (T)ser.ReadObject(ms);
                    return obj;
                }
            }

        

3: Code for test serialization

For testing add one controller and add action method

        public ActionResult Index()
           {
               var model = new Models.TestModel
               {
                   Active = true,
                   Birthday = DateTime.Now,
                   data = new Models.personaldata
                   {
                       data1 = "data1",
                       data2 = "data2",
                   },
                   Datalst = new List[Models.personaldata]
                   {
                       new Models.personaldata
                       {
                           data1 = "ldata1",
                           data2 = "ldata2",
                       },
                       new Models.personaldata
                       {
                           data1 = "ldata1",
                           data2 = "ldata2",
                       },
                   },
                   id = 3,
                   lstskill = new List[string]
                   {
                       "skill1",
                       "skill2",
                   },
                   Name = "name1"
               };

               var strjson = Helper.JsonHelper.
                       JsonSerializer[Models.TestModel](model);

               var strmodel = Helper.JsonHelper.
                           JsonDeserialize[Models.TestModel](strjson);


               return View();
           }

            

Now, same way can done for XML serialization also.

1: Create XML helper class for serialization

        public class XMLHelper
            {
                public static string XMLSerialize[T](T obj)
                {
                    XmlSerializer serializer = 
                    new XmlSerializer(obj.GetType());
                    using (StringWriter writer = new StringWriter())
                    {
                        serializer.Serialize(writer, obj);
                        return writer.ToString();
                    }
                }

                public static object XMLDeSerialize[T](string data)
                {
                    StringReader rdr = new StringReader(data);
                    XmlSerializer xmlSerializer =
                     new XmlSerializer(typeof(T));
                    var result = (T)xmlSerializer.Deserialize(rdr);
                    return result;
                }
            }

            

2: Code for test serialization

        public ActionResult Index1()
          {
              var model = new Models.TestModel1
              {
                  Active = true,
                  Birthday = DateTime.Now,
                  data = new Models.personaldata1
                  {
                      data1 = "data1",
                      data2 = "data2",
                  },
                  Datalst = new List[Models.personaldata1]
                  {
                      new Models.personaldata1
                      {
                          data1 = "ldata1",
                          data2 = "ldata2",
                      },
                      new Models.personaldata1
                      {
                          data1 = "ldata1",
                          data2 = "ldata2",
                      },
                  },
                  id = 3,
                  lstskill = new List[string]
                  {
                      "skill1",
                      "skill2",
                  },
                  Name = "name1"
              };

              var strXML = Helper.XMLHelper.XMLSerialize[Models.TestModel1](model);
              var strmodel = Helper.XMLHelper.XMLDeSerialize[Models.TestModel1](strXML);
              return View();
          }

            

3: For Map xml attributes to object properties you can use following code

        [XmlRoot("TestModel1")]
            public class TestModel1
            {
                public int id { get; set; }
                [XmlAttribute("Name")]
                public string Name { get; set; }
                [XmlElement(ElementName = "lstskill")]
                public List[string] lstskill { get; set; }
                [XmlAttribute("Birthday")]
                public DateTime Birthday { get; set; }
                public bool Active { get; set; }
                [XmlElement(ElementName = "Datalst")]
                public List[personaldata1] Datalst { get; set; }
                [XmlElement(ElementName = "data")]
                public personaldata1 data { get; set; }
            }
            public class personaldata1
            {
                [XmlAttribute("data1")]
                public string data1 { get; set; }
                [XmlAttribute("data2")]
                public string data2 { get; set; }
            }

             

I Hope it will help!
Feel free to add comment. Enjoy coding.

MVC – Authentication using OAuth

In this post I will show you how to integrate single sign on using OAuth 2.0 open source (http://oauth.net)

OAuth 2.0 LIB is open source for implement single sign by open ID like Facebook, Google, LinkedIn, Yahoo, Twitter etc...

Using OAuth LIB (http://oauth.net) we can implement single sign-in in our MVC application and provide facility for login using well known social media and OpenID.

For more details about Authentication and Authorization you can see my previous blog LINK

Okay, let’s start with OAuth 2.0 for implement single sign-in in MVC application.
We need to first create apps on FaceBook, LinkedIn, and Twitter for OAuth validation.

See Screens:

1. FaceBook

Use URL: http://developers.facebook.com
Create apps on facebook and get AppId and AppSecret



2. LinkedIn

Use URL: http://developer.linkedin.com/user/login
Create apps on LinkedIn and get APIKey and SecretKey





3. Twitter

Use URL: https://dev.twitter.com/apps
Create apps on twitter and get ConsumerKey and ConsumerSecret



Using that registration we get Consumer Key, Consumer Secrets, API key and API Secrets

Now, Second step is installing DotnetOpenAuth.AspNetfrom nugget packages using Package manager in VS by following command.

For more details check http://www.dotnetopenauth.net/developers/help/programmatic-openid-relying-party

I am using here MVC4 and OAuthWebSecurity class for demo. It is easiest way to implement OAuth, You can use only DotNetopenAuth dll and implement OAuth as per above link.

Okay, Now let's start with demo code..

Step1: Install Packages using Package Manager from NUGET

PM> Install-Package DotNetOpenAuth.AspNet
PM> Install-Package Microsoft.AspNet.WebPages.OAuth

Step1: Create class for register provider

            public static class OAuthReg
            {
                public static void RegisterOAuth()
                {
                    OAuthWebSecurity.RegisterLinkedInClient(
                         consumerKey: "111111",
                        consumerSecret: "11111111");

                    OAuthWebSecurity.RegisterTwitterClient(
                        consumerKey: "111111",
                        consumerSecret: "11111111");

                    OAuthWebSecurity.RegisterFacebookClient(
                        appId: "1111111",
                        appSecret: "11111111");

                    OAuthWebSecurity.RegisterGoogleClient();

                }
            }


            For register we need to add code in Global.asax file in Application Start Method 


            Models.OAuthReg.RegisterOAuth();
        

Step3: Add Controller and action method code

           public class HomeController : Controller
            {

                [HttpPost]
                public ActionResult Logon(string provider, string returnUrl)
                {
                    return new ExternerLoginResult(provider, 
                    Url.Action("LogonCallBack", new { returnUrl }));
                }

                [HttpPost]
                public ActionResult LogonCallBack(string returnUrl)
                {
                    AuthenticationResult result = 
                    OAuthWebSecurity.VerifyAuthentication(
                    Url.Action("LogonCallBack", new { ReturnUrl = returnUrl }));
                    if (!result.IsSuccessful)
                        return new EmptyResult();
                    ViewBag.UserName = result.UserName;
                    return View("LoginConfirm");
                }


                #region
                internal class ExternerLoginResult : ActionResult
                {
                    public ExternerLoginResult(string _provider,
                     string _returnUrl)
                    {
                        this.Provider = _provider;
                        this.ReturnUrl = _returnUrl;
                    }

                    public string Provider { get; set; }
                    public string ReturnUrl { get; set; }
                    public override void ExecuteResult(ControllerContext context)
                    {
                        OAuthWebSecurity.RequestAuthentication(this.Provider,
                         this.ReturnUrl);
                    }
                }
                #endregion
            }

        

Now, last step to add views

Step4: Add following views

           
            1: Logon
           
            @model ICollection
            @{
                ViewBag.Title = "Logon";
            }
            

                Logon
            @using (Html.BeginForm())
            {
                

                    @foreach (var item in Model)
                    {
                        
                    }
                
            }


            2: LoginConfirm

            @{
                ViewBag.Title = "LoginConfirm";
            }
            

                LoginConfirm
            @ViewBag.UserName

        

That's all we just done DotNetOpenAuth in MVC.

I hope its help!

Feel free to add comments!

MVC- Authentication/Authorization

Hello again! Today, I came with authentication and authorization in MVC.

Authentication and Authorization are common term in development cycle.
Authentication:It is a process to identify the user. System will check for user is valid or not base on user credentialed.

Authorization: It is a process to check what rights and roles of valid user for access system resources. System will check user rights and roles and decide what resources are accessible by user.

Type of authentication

1.Forms:It is custom authentication type. We can use our custom code for that auth. We can use membership provide for authentication. You can check my previous post LINK about custom membership provider in MVC for more details. We need to set In web.config file.

2.Windows:In this web pages will use local windows users and groups to authenticate and authorize resources. We set windows authentication by set In web.config file.

3.Passport:Passport authentication is based on the passport website provided by the Microsoft .So when user logins with credentials it will be reached to the passport website where authentication will happen. If Authentication is successful it will return a token to your website.

4.Anonymous Access:If there is none of above authentication then you will be anonymous access.

After authentication using authorization system will check and verify user has what rights and roles to access system.

In MVC we can verify user by Authorize attribute. We can set Authorize attribute on action method or controller for verify user.

            //
            // GET: /Index/
            [Authorize]
            public ActionResult Index()
            {
                return View();
            }
        

Above code will check for validate user before access Index action method.

            [Authorize]
            public class IndexController : Controller
            {
                //
                // GET: /Index/
                public ActionResult Index()
                {
                    return View();
                }

            }
        

For apply authorization to all action method in controller we can use above code block. We can set Authorize attribute on controller. It will validate user before access any action methods in particular controller.

For check user roles we can use same attribute and add roles in attribute in constructor of attribute. See following code.

            For Controller:

            [Authorize(Roles="Administrator, User")]
            public class IndexController : Controller
            {
                //
                // GET: /Index/

                public ActionResult Index()
                {
                    return View();
                }

            }

            For Action Method:

            //
            // GET: /Index/
            [Authorize(Roles = "Administrator, User")]
            public ActionResult Index()
            {
                return View();
            }

            [Authorize(Roles = "User")]
            public ActionResult User()
            {
                return View();
            }

        

In above code block user can access code base on assigned roles.

That all above code will check users and roles using default Membership Provider and Role Provider.

We can customize that authorize attribute to make custom code for validate user and set initialize all data at validation time.

MVC provide OnAuthorization override method, We can override this method and add our custom code on that override method.

For create custom authorize attribute create one class and inherit that class from AuthorizeAttribute class and override OnAuthorization method and add custom code.

See code:

            public class CustomAuth : AuthorizeAttribute
            {
                 public override void OnAuthorization(
                            AuthorizationContext filterContext)
                   {
                    base.OnAuthorization(filterContext);
                    if (filterContext.RequestContext.
                            HttpContext.User.Identity.IsAuthenticated)
                    {
                        //TODO: Add code for validate user
                    }
          }
      }


            For use this atherization code see below code block.


            [CustomAuth]
            public ActionResult Index1()
            {
                return View();
            }

        

That’s all for authorization and authentication in MVC.

See the final code more improve and flexible for authorization and authentication.

            public class CustomAuth : AuthorizeAttribute
            {
                public string[] _roles;
                public CustomAuth()
                {
                    _roles = new string[] { "Administrator" };
                }

                public CustomAuth(string[] roles)
                {
                    _roles = roles;
                }

                public override void OnAuthorization(
                        AuthorizationContext filterContext)
                {
                    base.OnAuthorization(filterContext);
                    if (filterContext.RequestContext.
                            HttpContext.User.Identity.IsAuthenticated)
                    {
                        //TODO: Add code for validate user
                        //TODO: Check Roles
                    }
                }
            }



            [CustomAuth(new [] { "Administrator", "User" })]
            public ActionResult Index2()
            {
                return View();
            }

        

I hope its help!

Feel free to add comments!

At End of year 2012

Happy New Year to all…

Finally 21-Dec-2012 is passed and we still alive 

At end of 2012 I would like to thanks all viewer of blog and I hope somehow it is helpful in your coding life.

I am sure all of you have done some new in 2012 and achieved your all goal which decided at start of the year. Of course, some are not finished yet and forwarded for 2013 and now time to make new list for 2013.

I did lot’s of thing in 2012. I enjoy 2012 a lot and looking forward for more fun.

In 2012 is very good for me. I learn MVC , Windows Azure, XTSL , HTML 5, CSS 3, VS 2012, Windows 8, SharePoint, Windows Phone and lot of others things…

I started 2012 with Windows Azure. I worked approx more than 1 year with windows azure and asp.net. I enjoyed windows azure and it was exciting for me to work in cloud platform.

After that for three month I started learn SharePoint. In SharePoint I tried all basic component, workflow and external data binding and so on… It was good experience to work with SharePoint. I am looking forward to work with DNN and SharePoint in coming year.

Then I moved again MVC and mysql with my new assignment. In this assignment all are very good and supportive peoples. We all are working remotely for this project. It is good experience for me.

2012 was good for all guys who love Microsoft. Microsoft released Windows 8 and Visual studio 2012. I tried both and I love it; Thanks to Microsoft.

At same time I did others fun stuff also. I saw most of video of build event and read MVC 4 and design pattern books.

Apart from technology I saw all know movies in 2012; I also seen Big Bang and Game of Thrones TV series with all episodes in this year. It was great fun!!
I am looking forward for Game of Thrones new season.

I read some great books also like The Monk Who Sold His Ferrari it is very good book for self help. Others fantasy books like Lord of The Rings and all books of Game of Thrones both are very good book full to time pass, worth to spend time.

That all for 2012 and yes most important thing is I started my blog and get chance to share my views.

So basically I did lots of code, read, music and video.

For 2013 I have lost of expectation and lots to learn with fun!!

I have set some points for 2013 and I am putting hear.

1) Learn Windows Azure more closely with all features
2) Want to work on SharePoint and DNN
3) Learn windows phone
4) Lear MVC mobile and Windows Azure
5) Learn project management and documentation
6) Want to learn async programming
7) More coding, architectures and design pattern
8) Honestly try to post one blog in week
9) Read some great books
10) Try to lots of new things
11) Want to do thing what I actually wanted
12) See some movies

I hope, I get better in 2013 then what I am right now and learn new way to think and way of happiness!!


Now Days, life is too fast; All people are consider life as a competition and all trying to win competition and end of the day just getting frustration and depressions. All peoples are running to win and no one have time for others; All are running; Some are with others, Some are for others, Some are behind some one. We need to think differently and try to make happy our self that is most important in life. So stop looking life as a competition, stop running enjoy life and help others; because life is too short.

Imagination is most powerful thing then any others.

Do thing what you actually wanted.

And at last Happy New Year!!! Take care.

Feel free to add comments

Useful Code At End of 2012

I like to wish you happy New Year and best of luck for 2013, and end of the 2012 I am going to post some important code block which are in use day to day life.

1. IP Address Validation
2. Date Time according to the time zone
3. Properties automapper code for object

1. IP Address Validation
Validations of IP Address like in range, grater then or less then and equal to are easily done by Sytem.Net.IPAddress class.

            protected void Page_Load(object sender, EventArgs e)
            {
                var ip = "192.168.4.159";
                var ip1 = "192.168.3.158";
                var ip2 = "192.168.5.156";

                var v1 = IsGreaterOrEqual(ip1, string.Empty);
                var v3 = IsInRange(ip1, ip2, ip);
                var v4 = IsEqual(ip1, ip2);
            }
            public bool IsValidIP(string IP)
            {
                IPAddress ot;
                bool valid = false;
                if (string.IsNullOrEmpty(IP))
                {
                    valid = false;
                }
                else
                {
                    valid = IPAddress.TryParse(IP, out ot);
                }
                return valid;
            }
            public bool IsGreaterOrEqual(string IPFrom, string IPTo)
            {
                return IPAddressToLongBackwards(IPFrom) <= IPAddressToLongBackwards(IPTo);
            }
            public bool IsInRange(string IPFrom, string IPTo, string IP)
            {
                var ipf = IPAddressToLongBackwards(IPFrom);
                var ip = IPAddressToLongBackwards(IP);
                var ipt = IPAddressToLongBackwards(IPTo);
                if (ipf <= ip)
                {
                    if (ip <= ipt)
                        return true;
                    else
                        return false;
                }
                else
                    return false;
            }
            public bool IsEqual(string IPFrom, string IP)
            {
                return IPAddress.Parse(IPFrom).Equals(IPAddress.Parse(IP));
            }
            private uint IPAddressToLongBackwards(string IPAddr)
            {
                System.Net.IPAddress oIP = System.Net.IPAddress.Parse(IPAddr);
                byte[] byteIP = oIP.GetAddressBytes();

                uint ip = (uint)byteIP[0] << 24;
                ip += (uint)byteIP[1] << 16;
                ip += (uint)byteIP[2] << 8;
                ip += (uint)byteIP[3];

                return ip;
            }
         
        

2. Date Time according to the time zone
Display date time according to the region time zone is now very common.
We can achieve that by convert data time object according to time zone by System. TimeZoneInfo class.
I am adding here some sample to convert date time according to time zone using TimeZoneInfo class.

            var mydatetime = DateTime.Now;

            var aest = TimeZoneInfo.FindSystemTimeZoneById("AUS Eastern Standard Time");
            var cst = TimeZoneInfo.FindSystemTimeZoneById("Central Europe Standard Time");

            //Response.Write(mydatetime.ToString());
            //Response.Write(mydatetime.ToUniversalTime());


            var tempdate1 = TimeZoneInfo.ConvertTime(mydatetime, aest);
            var tempdate2 = TimeZoneInfo.ConvertTime(mydatetime, cst);

            var tempoffset1 = cst.GetUtcOffset((tempdate1));
            var tempoffset2 = aest.GetUtcOffset((tempdate2));


            var ct = TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time");
            var tempoffset3 = ct.GetUtcOffset((mydatetime));

            Response.Write(tempoffset1);
            Response.Write(tempoffset2);

            Response.Write(tempoffset3);


            Response.Write(tempoffset1 - tempoffset2);

       

3. Properties automapper code for object
The last but not least Auto mapper code for object. In our code we need to map object properties.
For that we need to map properties one by one. Hear some code will help to map all properties automatically.

            public class ProjectResource
            {
                public int Id { get; set; }
                public string Name { get; set; }
                public int Hour { get; set; }
                public int Rate { get; set; }
                public double Salary { get; set; }
                public int Type { get; set; }
            }

           var p = new ProjectResource { Hour = 2, Id = 8, Name = "project1", Rate = 5, Salary = 40000, Type = 5 };

            var p1 = new ProjectResource();

            foreach (var item in p.GetType().GetProperties().Where(x => x.Name != "EntityKey" && x.Name != "EntityState"))
            {
                p1.GetType().GetProperty(item.Name).SetValue(p1, item.GetValue(p, null), null);
            }

          

I hope this will be help you.
Feel free to add comments!

Razor with MVC 3

Razor is new view engine for mvc

This post is for getting started with razor view engine. Hear some razor syntaxes for quick reference.

1. Code Block

               
               @{ var total = 7; }
               @{ var myMessage = "Hello World"; }
               
The value of your account is: @total 
               
The value of myMessage is: @myMessage
               @{var greeting = "Welcome to our site!";
                var weekDay = DateTime.Now.DayOfWeek;
                var greetingMessage = greeting + " Today is: " + weekDay;
                }
                
The greeting is: @greetingMessage

           

2. Expression HTML Encoded

            @Html.Raw(model.Message)
            @:Model.Message (Not render html as a part of output

         

3. Loop

            
               @foreach (var item in Model)
                {
                    
                        
                            @item.Message
                        
                    
                }

                @for (int i = 0; i < Model.ToList().Count(); i++)
                {
                    @Model.ToList()[i].Age
                }

            

4. Conditions

            
             @if (false)
              {
                @Model.Message;
              }
             else if (true)
              {
                @DateTime.Now;
              }
              else
              {
                @DateTime.Now;
              }

          

5. EmailID

             
             Razor automatically detect email id
            
ranmal.work@gmail.com
 
         

6. Print @

              @@my name will print @my name

          

7. Comment

              
              @*code here *@
              
          

8. Print string and model

              
             Hello word @ViewBag.Message, How r u?
              
          

9. Method in razor

              
             @(method)
              
          

10. Razor in html elements

              
            Click Me
            Click Me
            


            Product
            Product
              
          

11. Javascript and Resources

              
            
                
                    @Html.GetResource("label_first", ResourceScreenConstant.YourPage)
                
            
          
          

I Hope it will help!
Feel free to add comment. Enjoy coding and life.

Cod First using entity framework with MVC

Entity framework is support three different ways to interaction with database and develops application.

DB First: In DB First technique we first create database and then create .edmx file using entity framework.

Model First: In Model First technique we first create all data models using .edmx file of entity framework. After model design done we can create generate create script for that model and used to create database.

Code First: Code First is a most popular technique in now days for interact with database.

In Code First we create POCO (Plain Old CLR Object) models in code as a class object and entity framework convert that POCO model into database table.
So now we can create our entire database using POCO models as a class object and EF will convert that POCO models into database.
In this post I will demonstrate how, we can create database from POCO models using Entity Framework in MVC.

I am using MVC 3 and Entity Framework 4.3.1 version for demo code first. Entity Framework now available on nugget page also. Use install-package entityframework command for download entity framework.

Ok! Now let’s start demo. We will create one table for store project information

STEP: 1 Create POCO Model
Create MVC project for demo and install entity framework from nugget package manager.
Create class name with project in model.
By default EF will create tables with same name of model. We can set Table name attribute for set table name in database.

                [Table("ProjectData")]
                public class Project
                {
                    public int Id { get; set; }
                    public string Name { get; set; }
                    public string Description { get; set; }

                }
            

STEP: 2 Create Data Context Class
Create one class which inherits from System.Data.Entity.DBContext.
By default EF will create database using class name. we can set custom database name and connection strings if any then.
Now, Create property using DbSet[project] for project table.

                public class DATABContext : DbContext
                {
                    public DATABContext()
                        : base("ReportDB")
                    {
                        this.Database.CreateIfNotExists();
                    }
                    public DATABContext(string ConnectionString)
                        : base(ConnectionString)
                    {
                        this.Database.CreateIfNotExists();
                    }

                    public DbSet[Product] Products { get; set; }
                }
            

We have done almost using default settings for create database and tables from POCO. Now, next is how to use the models? We can use it in controller using following code.

                public class Default1Controller : Controller
                    {
                        private DATABContext db = new DATABContext();

                        //
                        // GET: /Default1/

                        public ViewResult Index()
                        {

                            return View(db.Products.ToList());
                        }
                   }
            

STEP: 3 Run Project
We have set all basic requirements for default database creation by Entity Framework. By default it use Sql Express server for create database and it will create ReportDB database with one table ProjectData.

STEP: 4 Use Existed Database
If we have already a database how can we use in CODE First technique?
It is actually easy and configurable. We can set database connection string by web.config file as well as by code.
By default DBContext class used connection string name of DBContext class.

                Connection string : 
                 
                    
                  
                
                By code we can set connection string using properties 

                Database.DefaultConnectionFactory = new SqlConnectionFactory("Data Source=RANMAL; Integrated Security=True; MultipleActiveResultSets=True");
                            

I Hope it will help!
Feel free to add comment. Enjoy coding and life.