Wednesday, December 11, 2013

Keep password textbox value during postback asp.net


In this article, I will explain how to keep password & Retype password textbox value during postback in asp.net
 protected void Page_Load(object sender, EventArgs e)
    {
       if (!(String.IsNullOrEmpty(txtPassword.Text.Trim())))
        {
            txtPassword.Attributes["value"] = txtPassword.Text;
        }
        if (!(String.IsNullOrEmpty(txtRePassword.Text.Trim())))
        {
            txtRePassword.Attributes["value"] = txtRePassword.Text;
        }
   }



Hope freshers will find it helpful :)

Thursday, November 14, 2013

C# multiple value return from single function

There are a number of ways to return two object from one function. You can class or structure and another one as out parameter. Alternatively, you can use generic type with two members. Such type, in particular, it Tuple:

#I am using Tuple to returns 2 datetime value(fromDate , toDate )
  public Tuple GetDates()
   {

          DateTime fromDate = DateTime.Now;
          DateTime toDate = DateTime.Now;
          int year = Convert.ToInt32(this.ddlQYear.SelectedItem.Value);

            if (Convert.ToInt32(ddlQ.SelectedItem.Value) > 0)
            {
                int month = Convert.ToInt32(ddlQ.SelectedItem.Value);
                fromDate = new DateTime(year, month, 1);
                if (month == 12)
                    toDate = new DateTime(year + 1, 1, 1);
                else
                    toDate = new DateTime(year, month + 1, 1);
            }
            return new Tuple(fromDate, toDate);
   }
===========Call this function bellow way==============================
            
DateTime fromDate = GetDates().Item1;
DateTime toDate = GetDates().Item2;


#Another way use "out" keyword:

 public static int GetDates(out DateTime FDate, out DateTime TDate)
   {
            DateTime fromDate = DateTime.Now;
            DateTime toDate = DateTime.Now;

           // Calculate your date

            FDate=fromDate ;
            TDate=toDate
     

         return 1;
   }
Hope that this helps!!

Wednesday, November 13, 2013

Swap column values in sql server 2008

Suppose we have a table named USER with 3 columns: USERID, USERName, USERAddress.

              USERID: int 
USERName: varchar(100)
USERAddress: varchar(100)


Swap with the temporary variable:
-----------------------------------------------


DECLARE @temp AS varchar(10)
 
UPDATE USER SET @temp=USERAddress, USERAddress=USERName, USERName=@temp
 


Hope freshers will find it helpful :)

Thursday, November 7, 2013

C# “is inaccessible due to its protection level” [Solved]

Some time its happen when your modifier are private or protected but need to access anywhere that time just your function need to be protected to public.

I had happened same problem when i write code radio button "OnCheckedChanged" event. I have solved that way to change modifier protected to public.


 public void ShareTransferSelection(object sender, EventArgs e)
    {
      // Code here
    }


Happy Programming!!

Monday, October 21, 2013

RSS Feed Reader with jQuery

I am using the jQuery & FeedEk plugin to parse rss feed.

Step 1 – Include jQuery and FeedEk.js

 

Step 2 – Specify a DIV where you need the feed displayed

3- Add the Javascript that will populate the placeholder


Well there you have it; a slick, easy to use FeedEk RSS Reader!!

Friday, October 18, 2013

[Solved]How to delete an uploaded image in asp.net ?

Uploaded image you can easily delete by server side code.

try {
FileInfo TheFile = new FileInfo(MapPath(".") + "\\" + FileName);
if (TheFile.Exists) {
File.Delete(MapPath(".") + "\\" + FileName);
}
else {
throw new FileNotFoundException();
} 
} 

Good Day!!!

Saturday, September 21, 2013

Unable to convert MySQL date/time value to System.DateTime [Solved]

For this solution you must add (Convert Zero Datetime=True or Allow Zero Datetime=True) to your connection string, for example:
server=localhost;User Id=root;password=pass123;Persist Security Info=True;database=test;Convert Zero Datetime=True

or
server=localhost;User Id=root;password=pass123;Persist Security Info=True;database=test;Allow Zero Datetime=True


You can format the date/time data in your sql statement using DATE_FORMAT(date,format) .Actually mysql have a different format (yyyy-mm-dd) for the date/time data type.

Enjoy Programming...

Tuesday, July 9, 2013

Membership provider not found in separate class Library [Solved]

If you are trying to use a class library you'll have to Add reference System.Web and System.Web.ApplicationServices

Then Add a using directive to the System.Web.Security namespace in your class - this will give you direct access to the Membership class.
C#:
using System.Web.Security;
Example:
using System.Web.Security;

namespace ClassLibrary
{
    public class Class1 : MembershipProvider
    {
    }
}


Happy Programming :)

Wednesday, June 19, 2013

Convert IList to DataTable

To convert Ilist to datatable you can use bellow this code:
    public static DataTable ToDataTable(this IList data)
    {
        var properties = TypeDescriptor.GetProperties(typeof(T));
        var tableData = new DataTable();

        foreach (PropertyDescriptor prop in properties)
        {
            tableData.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
        }

        foreach (var item in data)
        {
            var row = tableData.NewRow();

            foreach (PropertyDescriptor prop in properties)
            {
                row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
            }

            tableData.Rows.Add(row);
        }

        return tableData;
    }
If you have any query, feel free to get in touch please.

Tuesday, June 4, 2013

ASP.NET MVC interview questions with answers


What is MVC (Model View Controller)? MVC is an architectural pattern which separates the representation and user interaction. It’s divided into three broader sections, Model, View, and Controller. Below is how each one of them handles the task.

The View is responsible for the look and feel. Model represents the real world object and provides data to the View. The Controller is responsible for taking the end user request and loading the appropriate Model and View.

Figure: MVC (Model view controller) Explain MVC application life cycle? There are six broader events which occur in MVC application life cycle below diagrams summarize it.

Image Courtesy: - http://www.dotnetinterviewquestions.in/article_explain-mvc-application-life-cycle_210.html

Any web application has two main execution steps first understanding the request and depending on the type of the request sending out appropriate response. MVC application life cycle is not different it has two main phases first creating the request object and second sending our response to the browser.

Creating the request object: -The request object creation has four major steps. Below is the detail explanation of the same.

Step 1 Fill route: - MVC requests are mapped to route tables which in turn specify which controller and action to be invoked. So if the request is the first request the first thing is to fill the route table with routes collection. This filling of route table happens in the global.asax file.

Step 2 Fetch route: - Depending on the URL sent “UrlRoutingModule” searches the route table to create “RouteData” object which has the details of which controller and action to invoke.

Step 3 Request context created: - The “RouteData” object is used to create the “RequestContext” object.

Step 4 Controller instance created: - This request object is sent to “MvcHandler” instance to create the controller class instance. Once the controller class object is created it calls the “Execute” method of the controller class.

Creating Response object: - This phase has two steps executing the action and finally sending the response as a result to the view.

Is MVC suitable for both Windows and Web applications? The MVC architecture is suited for a web application than Windows. For Window applications, MVP, i.e., “Model View Presenter” is more applicable. If you are using WPF and Silverlight, MVVM is more suitable due to bindings.

What are the benefits of using MVC? There are two big benefits of MVC:

Separation of concerns is achieved as we are moving the code-behind to a separate class file. By moving the binding code to a separate class file we can reuse the code to a great extent. Automated UI testing is possible because now the behind code (UI interaction code) has moved to a simple .NET class. This gives us opportunity to write unit tests and automate manual testing. Is MVC different from a three layered architecture? MVC is an evolution of a three layered traditional architecture. Many components of the three layered architecture are part of MVC. So below is how the mapping goes:

Functionality Three layered / tiered architecture Model view controller architecture Look and Feel User interface View UI logic User interface Controller Business logic /validations Middle layer Model Request is first sent to User interface Controller Accessing data Data access layer Data Access Layer

Figure: Three layered architecture What is the latest version of MVC? When this note was written, four versions were released of MVC: MVC 1 , MVC 2, MVC 3, and MVC 4. So the latest is MVC 4.

What is the difference between each version of MVC? Below is a detailed table of differences. But during an interview it’s difficult to talk about all of them due to time limitation. So I have highlighted the important differences that you can run through before the interviewer.

MVC 2 MVC 3 MVC 4 Client-side validation Templated Helpers Areas Asynchronous Controllers Html.ValidationSummary Helper Method DefaultValueAttribute in Action-Method Parameters binding Binary data with Model Binders DataAnnotations Attributes Model-Validator Providers New RequireHttpsAttribute Action Filter Templated Helpers Display Model-Level Errors Razor Readymade project templates HTML 5 enabled templates Support for Multiple View Engines, JavaScript, and AJAX Model Validation Improvements ASP.NET Web API Refreshed and modernized default project templates. New mobile project template. Many new features to support mobile apps Enhanced support for asynchronous methods What are HTML helpers in MVC? HTML helpers help you to render HTML controls in the view. For instance if you want to display a HTML textbox on the view , below is the HTML helper code.

<%= Html.TextBox("LastName") %> For checkbox below is the HTML helper code. In this way we have HTML helper methods for every HTML control that exists.

<%= Html.CheckBox("Married") %> What is the difference between “HTML.TextBox” vs “HTML.TextBoxFor”? Both of them provide the same HTML output, “HTML.TextBoxFor” is strongly typed while “HTML.TextBox” isn’t. Below is a simple HTML code which just creates a simple textbox with “CustomerCode” as name.

Html.TextBox("CustomerCode") Below is “Html.TextBoxFor” code which creates HTML textbox using the property name ‘CustomerCode” from object “m”.

Html.TextBoxFor(m => m.CustomerCode) In the same way we have for other HTML controls like for checkbox we have “Html.CheckBox” and “Html.CheckBoxFor”.

What is routing in MVC? Routing helps you to define a URL structure and map the URL with the controller.

For instance let’s say we want that when a user types “http://localhost/View/ViewCustomer/”, it goes to the “Customer” Controller and invokes the DisplayCustomer action. This is defined by adding an entry in to the routes collection using the maproute function. Below is the underlined code which shows how the URL structure and mapping with controller and action is defined.

routes.MapRoute( "View", // Route name "View/ViewCustomer/{id}", // URL with parameters new { controller = "Customer", action = "DisplayCustomer", id = UrlParameter.Optional }); // Parameter defaults Where is the route mapping code written? The route mapping code is written in "RouteConfig.cs" file and registered using "global.asax" application start event.

Can we map multiple URL’s to the same action? Yes, you can, you just need to make two entries with different key names and specify the same controller and action.

Explain attribute based routing in MVC? This is a feature introduced in MVC 5. By using the "Route" attribute we can define the URL structure. For example in the below code we have decorated the "GotoAbout" action with the route attribute. The route attribute says that the "GotoAbout" can be invoked using the URL structure "Users/about".

public class HomeController : Controller { [Route("Users/about")] public ActionResult GotoAbout() { return View(); } } What is the advantage of defining route structures in the code? Most of the time developers code in the action methods. Developers can see the URL structure right upfront rather than going to the “routeconfig.cs” and see the lengthy codes. For instance in the below code the developer can see right upfront that the “GotoAbout” action can be invoked by four different URL structure.

This is much user friendly as compared to scrolling through the “routeconfig.cs” file and going through the length line of code to figure out which URL structure is mapped to which action.

public class HomeController : Controller { [Route("Users/about")] [Route("Users/WhoareWe")] [Route("Users/OurTeam")] [Route("Users/aboutCompany")] public ActionResult GotoAbout() { return View(); } } How can we navigate from one view to another using a hyperlink? By using the ActionLink method as shown in the below code. The below code will create a simple URL which helps to navigate to the “Home” controller and invoke the GotoHome action.

<%= Html.ActionLink("Home","Gotohome") %> How can we restrict MVC actions to be invoked only by GET or POST? We can decorate the MVC action with the HttpGet or HttpPost attribute to restrict the type of HTTP calls. For instance you can see in the below code snippet the DisplayCustomer action can only be invoked by HttpGet. If we try to make HTTP POST on DisplayCustomer, it will throw an error.

[HttpGet] public ViewResult DisplayCustomer(int id) { Customer objCustomer = Customers[id]; return View("DisplayCustomer",objCustomer); } How can we maintain sessions in MVC? Sessions can be maintained in MVC by three ways: tempdata, viewdata, and viewbag.

What is the difference between tempdata, viewdata, and viewbag?

Figure: Difference between tempdata, viewdata, and viewbag Temp data - Helps to maintain data when you move from one controller to another controller or from one action to another action. In other words when you redirect, tempdata helps to maintain data between those redirects. It internally uses session variables. View data - Helps to maintain data when you move from controller to view. View Bag - It’s a dynamic wrapper around view data. When you use Viewbag type, casting is not required. It uses the dynamic keyword internally.

Figure: dynamic keyword Session variables - By using session variables we can maintain data from any entity to any entity. Hidden fields and HTML controls - Helps to maintain data from UI to controller only. So you can send data from HTML controls or hidden fields to the controller using POST or GET HTTP methods. Below is a summary table which shows the different mechanisms for persistence.

Maintains data between ViewData/ViewBag TempData Hidden fields Session Controller to Controller No Yes No Yes Controller to View Yes No No Yes View to Controller No No Yes Yes What is difference between TempData and ViewData ? “TempData” maintains data for the complete request while “ViewData” maintains data only from Controller to the view.

Does “TempData” preserve data in the next request also? “TempData” is available through out for the current request and in the subsequent request it’s available depending on whether “TempData” is read or not.

So if “TempData” is once read it will not be available in the subsequent request.

What is the use of Keep and Peek in “TempData”? Once “TempData” is read in the current request it’s not available in the subsequent request. If we want “TempData” to be read and also available in the subsequent request then after reading we need to call “Keep” method as shown in the code below.

@TempData[“MyData”]; TempData.Keep(“MyData”); The more shortcut way of achieving the same is by using “Peek”. This function helps to read as well advices MVC to maintain “TempData” for the subsequent request.

string str = TempData.Peek("Td").ToString(); If you want to read more in detail you can read from this detailed blog on MVC Peek and Keep.

What are partial views in MVC? Partial view is a reusable view (like a user control) which can be embedded inside other view. For example let’s say all your pages of your site have a standard structure with left menu, header, and footer as shown in the image below.

Figure: Partial views in MVC For every page you would like to reuse the left menu, header, and footer controls. So you can go and create partial views for each of these items and then you call that partial view in the main view.

How did you create a partial view and consume it? When you add a view to your project you need to check the “Create partial view” check box.

Figure: Create partial view Once the partial view is created you can then call the partial view in the main view using the Html.RenderPartial method as shown in the below code snippet:

<% Html.RenderPartial("MyView"); %>


How can we do validations in MVC? One of the easiest ways of doing validation in MVC is by using data annotations. Data annotations are nothing but attributes which can be applied on model properties. For example, in the below code snippet we have a simple Customer class with a property customercode.

This CustomerCode property is tagged with a Required data annotation attribute. In other words if this model is not provided customer code, it will not accept it.

public class Customer { [Required(ErrorMessage="Customer code is required")] public string CustomerCode { set; get; } }

In order to display the validation error message we need to use the ValidateMessageFor method which belongs to the Html helper class.

<% using (Html.BeginForm("PostCustomer", "Home", FormMethod.Post)) { %> <%=Html.TextBoxFor(m => m.CustomerCode)%> <%=Html.ValidationMessageFor(m => m.CustomerCode)%> <%}%>

Later in the controller we can check if the model is proper or not by using the ModelState.IsValid property and accordingly we can take actions.

public ActionResult PostCustomer(Customer obj) { if (ModelState.IsValid) { obj.Save(); return View("Thanks"); } else { return View("Customer"); } } Below is a simple view of how the error message is displayed on the view.

Figure: Validations in MVC Can we display all errors in one go? Yes, we can; use the ValidationSummary method from the Html helper class.

<%= Html.ValidationSummary() %> What are the other data annotation attributes for validation in MVC?

If you want to check string length, you can use StringLength.

[StringLength(160)] public string FirstName { get; set; } In case you want to use a regular expression, you can use the RegularExpression attribute.

[RegularExpression(@"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}")]public string Email { get; set; } If you want to check whether the numbers are in range, you can use the Range attribute.

[Range(10,25)]public int Age { get; set; } Sometimes you would like to compare the value of one field with another field, we can use the Compare attribute.

public string Password { get; set; }[Compare("Password")]public string ConfirmPass { get; set; } In case you want to get a particular error message , you can use the Errors collection.

var ErrMessage = ModelState["Email"].Errors[0].ErrorMessage; If you have created the model object yourself you can explicitly call TryUpdateModel in your controller to check if the object is valid or not.

TryUpdateModel(NewCustomer); In case you want add errors in the controller you can use the AddModelError function.

ModelState.AddModelError("FirstName", "This is my server-side error."); How can we enable data annotation validation on client side? It’s a two-step process: first reference the necessary jQuery files.

The second step is to call the EnableClientValidation method.

<% Html.EnableClientValidation(); %> What is Razor in MVC? It’s a light weight view engine. Till MVC we had only one view type, i.e., ASPX. Razor was introduced in MVC 3.

Why Razor when we already have ASPX? Razor is clean, lightweight, and syntaxes are easy as compared to ASPX. For example, in ASPX to display simple time, we need to write:

<%=DateTime.Now%> In Razor, it’s just one line of code:

@DateTime.Now So which is a better fit, Razor or ASPX? As per Microsoft, Razor is more preferred because it’s light weight and has simple syntaxes.

How can you do authentication and authorization in MVC? You can use Windows or Forms authentication for MVC.

How to implement Windows authentication for MVC? For Windows authentication you need to modify the web.config file and set the authentication mode to Windows.

Then in the controller or on the action, you can use the Authorize attribute which specifies which users have access to these controllers and actions. Below is the code snippet for that. Now only the users specified in the controller and action can access it.

[Authorize(Users= @"WIN-3LI600MWLQN\Administrator")] public class StartController : Controller { // // GET: /Start/ [Authorize(Users = @"WIN-3LI600MWLQN\Administrator")] public ActionResult Index() { return View("MyView"); } }

How do you implement Forms authentication in MVC? Forms authentication is implemented the same way as in ASP.NET. The first step is to set the authentication mode equal to Forms. The loginUrl points to a controller here rather than a page.

We also need to create a controller where we will check if the user is proper or not. If the user is proper we will set the cookie value.

public ActionResult Login() { if ((Request.Form["txtUserName"] == "Shiv") && (Request.Form["txtPassword"] == "Shiv@123")) { FormsAuthentication.SetAuthCookie("Shiv",true); return View("About"); } else { return View("Index"); } } All the other actions need to be attributed with the Authorize attribute so that any unauthorized user making a call to these controllers will be redirected to the controller (in this case the controller is “Login”) which will do the authentication.

[Authorize] PublicActionResult Default() { return View(); } [Authorize] publicActionResult About() { return View(); }

How to implement AJAX in MVC? You can implement AJAX in two ways in MVC:

AJAX libraries jQuery

Below is a simple sample of how to implement AJAX by using the “AJAX” helper library. In the below code you can see we have a simple form which is created by using the Ajax.BeginForm syntax. This form calls a controller action called getCustomer. So now the submit action click will be an asynchronous AJAX call.

<% var AjaxOpt = new AjaxOptions{OnSuccess="OnSuccess"}; %> <% using (Ajax.BeginForm("getCustomer","MyAjax",AjaxOpt)) { %>

<%} %>

In case you want to make AJAX calls on hyperlink clicks, you can use the Ajax.ActionLink function as shown in the below code.

Figure: Implement AJAX in MVC So if you want to create an AJAX asynchronous hyperlink by name GetDate which calls the GetDate function in the controller, below is the code for that. Once the controller responds, this data is displayed in the HTML DIV tag named DateDiv.

<%: Ajax.ActionLink("Get Date","GetDate", new AjaxOptions {UpdateTargetId = "DateDiv" }) %> Below is the controller code. You can see how the GetDate function has a pause of 10 seconds.

public class Default1Controller : Controller { public string GetDate() { Thread.Sleep(10000); return DateTime.Now.ToString(); } }

The second way of making an AJAX call in MVC is by using jQuery. In the below code you can see we are making an AJAX POST call to a URL /MyAjax/getCustomer. This is done by using $.post. All this logic is put into a function called GetData and you can make a call to the GetData function on a button or a hyperlink click event as you want.

function GetData() { var url = "/MyAjax/getCustomer"; $.post(url, function (data) { $("#txtCustomerCode").val(data.CustomerCode); $("#txtCustomerName").val(data.CustomerName); } ) } What kind of events can be tracked in AJAX?

Figure: Tracked in AJAX What is the difference between ActionResult and ViewResult? ActionResult is an abstract class while ViewResult derives from the ActionResult class. ActionResult has several derived classes like ViewResult, JsonResult, FileStreamResult, and so on. ActionResult can be used to exploit polymorphism and dynamism. So if you are returning different types of views dynamically, ActionResult is the best thing. For example in the below code snippet, you can see we have a simple action called DynamicView. Depending on the flag (IsHtmlView) it will either return a ViewResult or JsonResult.

public ActionResult DynamicView() { if (IsHtmlView) return View(); // returns simple ViewResult else return Json(); // returns JsonResult view }

What are the different types of results in MVC?

Note: It’s difficult to remember all the 12 types. But some important ones you can remember for the interview are ActionResult, ViewResult, and JsonResult. Below is a detailed list for your interest:

There 12 kinds of results in MVC, at the top is the ActionResult class which is a base class that can have 11 subtypes as listed below:

ViewResult - Renders a specified view to the response stream PartialViewResult - Renders a specified partial view to the response stream EmptyResult - An empty response is returned RedirectResult - Performs an HTTP redirection to a specified URL RedirectToRouteResult - Performs an HTTP redirection to a URL that is determined by the routing engine, based on given route data JsonResult - Serializes a given ViewData object to JSON format JavaScriptResult - Returns a piece of JavaScript code that can be executed on the client ContentResult - Writes content to the response stream without requiring a view FileContentResult - Returns a file to the client FileStreamResult - Returns a file to the client, which is provided by a Stream FilePathResult - Returns a file to the client What are ActionFilters in MVC? ActionFilters help you to perform logic while an MVC action is executing or after an MVC action has executed.

Figure: ActionFilters in MVC Action filters are useful in the following scenarios:

Implement post-processing logic before the action happens. Cancel a current execution. Inspect the returned value. Provide extra data to the action. You can create action filters by two ways:

Inline action filter. Creating an ActionFilter attribute. To create an inline action attribute we need to implement the IActionFilter interface. The IActionFilter interface has two methods: OnActionExecuted and OnActionExecuting. We can implement pre-processing logic or cancellation logic in these methods.

public class Default1Controller : Controller , IActionFilter { public ActionResult Index(Customer obj) { return View(obj); } void IActionFilter.OnActionExecuted(ActionExecutedContext filterContext) { Trace.WriteLine("Action Executed"); } void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext) { Trace.WriteLine("Action is executing"); } }

The problem with the inline action attribute is that it cannot be reused across controllers. So we can convert the inline action filter to an action filter attribute. To create an action filter attribute we need to inherit from ActionFilterAttribute and implement the IActionFilter interface as shown in the below code.

public class MyActionAttribute : ActionFilterAttribute , IActionFilter { void IActionFilter.OnActionExecuted(ActionExecutedContext filterContext) { Trace.WriteLine("Action Executed"); } void IActionFilter.OnActionExecuting(ActionExecutingContext filterContext) { Trace.WriteLine("Action executing"); } } Later we can decorate the controllers on which we want the action attribute to execute. You can see in the below code I have decorated the Default1Controller with the MyActionAttribute class which was created in the previous code.

[MyActionAttribute] public class Default1Controller : Controller { public ActionResult Index(Customer obj) { return View(obj); } }

Can we create our custom view engine using MVC? Yes, we can create our own custom view engine in MVC. To create our own custom view engine we need to follow three steps:

Let’ say we want to create a custom view engine where in the user can type a command like “” and it should display the current date and time.

Step 1: We need to create a class which implements the IView interface. In this class we should write the logic of how the view will be rendered in the render function. Below is a simple code snippet for that.

public class MyCustomView : IView { private string _FolderPath; // Define where our views are stored public string FolderPath { get { return _FolderPath; } set { _FolderPath = value; } } public void Render(ViewContext viewContext, System.IO.TextWriter writer) { // Parsing logic // read the view file string strFileData = File.ReadAllText(_FolderPath); // we need to and replace datetime.now value string strFinal = strFileData.Replace("", DateTime.Now.ToString()); // this replaced data has to sent for display writer.Write(strFinal); } }

Step 2: We need to create a class which inherits from VirtualPathProviderViewEngine and in this class we need to provide the folder path and the extension of the view name. For instance, for Razor the extension is “cshtml”; for aspx, the view extension is “.aspx”, so in the same way for our custom view, we need to provide an extension. Below is how the code looks like. You can see the ViewLocationFormats is set to the Views folder and the extension is “.myview”.

public class MyViewEngineProvider : VirtualPathProviderViewEngine { // We will create the object of Mycustome view public MyViewEngineProvider() // constructor { // Define the location of the View file this.ViewLocationFormats = new string[] { "~/Views/{1}/{0}.myview", "~/Views/Shared/{0}.myview" }; //location and extension of our views } protected override IView CreateView( ControllerContext controllerContext, string viewPath, string masterPath) { var physicalpath = controllerContext.HttpContext.Server.MapPath(viewPath); MyCustomView obj = new MyCustomView(); // Custom view engine class obj.FolderPath = physicalpath; // set the path where the views will be stored return obj; // returned this view paresing // logic so that it can be registered in the view engine collection } protected override IView CreatePartialView(ControllerContext controllerContext, string partialPath) { var physicalpath = controllerContext.HttpContext.Server.MapPath(partialPath); MyCustomView obj = new MyCustomView(); // Custom view engine class obj.FolderPath = physicalpath; // set the path where the views will be stored return obj; // returned this view paresing logic // so that it can be registered in the view engine collection } } Step 3: We need to register the view in the custom view collection. The best place to register the custom view engine in the ViewEngines collection is the global.asax file. Below is the code snippet for that.

protected void Application_Start() { // Step3 :- register this object in the view engine collection ViewEngines.Engines.Add(new MyViewEngineProvider()); ….. } Below is a simple output of the custom view written using the commands defined at the top.

Figure: Custom view engine using MVC If you invoke this view, you should see the following output:

How to send result back in JSON format in MVC In MVC, we have the JsonResult class by which we can return back data in JSON format. Below is a simple sample code which returns back a Customer object in JSON format using JsonResult.

public JsonResult getCustomer() { Customer obj = new Customer(); obj.CustomerCode = "1001"; obj.CustomerName = "Shiv"; return Json(obj,JsonRequestBehavior.AllowGet); } Below is the JSON output of the above code if you invoke the action via the browser.

What is WebAPI? HTTP is the most used protocol. For the past many years, browser was the most preferred client by which we consumed data exposed over HTTP. But as years passed by, client variety started spreading out. We had demand to consume data on HTTP from clients like mobile, JavaScript, Windows applications, etc.

For satisfying the broad range of clients REST was the proposed approach. You can read more about REST from the WCF chapter.

WebAPI is the technology by which you can expose data over HTTP following REST principles.

But WCF SOAP also does the same thing, so how does WebAPI differ? SOAP WEB API Size Heavy weight because of complicated WSDL structure. Light weight, only the necessary information is transferred. Protocol Independent of protocols. Only for HTTP protocol Formats To parse SOAP message, the client needs to understand WSDL format. Writing custom code for parsing WSDL is a heavy duty task. If your client is smart enough to create proxy objects like how we have in .NET (add reference) then SOAP is easier to consume and call. Output of WebAPI are simple string messages, JSON, simple XML format, etc. So writing parsing logic for that is very easy. Principles SOAP follows WS-* specification. WebAPI follows REST principles. (Please refer to REST in WCF chapter.) With WCF you can implement REST, so why WebAPI? WCF was brought into implement SOA, the intention was never to implement REST. WebAPI is built from scratch and the only goal is to create HTTP services using REST. Due to the one point focus for creating REST service, WebAPI is more preferred.

How to implement WebAPI in MVC

Below are the steps to implement WebAPI:

Step 1: Create the project using the WebAPI template.

Figure: Implement WebAPI in MVC Step 2: Once you have created the project you will notice that the controller now inherits from ApiController and you can now implement POST, GET, PUT, and DELETE methods of the HTTP protocol.

public class ValuesController : ApiController { // GET api/values public IEnumerable Get() { return new string[] { "value1", "value2" }; } // GET api/values/5 public string Get(int id) { return "value"; } // POST api/values public void Post([FromBody]string value) { } // PUT api/values/5 public void Put(int id, [FromBody]string value) { } // DELETE api/values/5 public void Delete(int id) { } }

Step 3: If you make an HTTP GET call you should get the below results:

Figure: HTTP How can we detect that an MVC controller is called by POST or GET? To detect if the call on the controller is a POST action or a GET action we can use the Request.HttpMethod property as shown in the below code snippet.

public ActionResult SomeAction() { if (Request.HttpMethod == "POST") { return View("SomePage"); } else { return View("SomeOtherPage"); } }

What is bundling and minification in MVC? Bundling and minification helps us improve request load times of a page thus increasing performance.

How does bundling increase performance? Web projects always need CSS and script files. Bundling helps us combine multiple JavaScript and CSS files in to a single entity thus minimizing multiple requests in to a single request.

For example consider the below web request to a page . This page consumes two JavaScript files Javascript1.js and Javascript2.js. So when this is page is requested it makes three request calls:

One for the Index page. Two requests for the other two JavaScript files: Javascript1.js and Javascript2.js. The below scenario can become worse if we have a lot of JavaScript files resulting in multiple requests, thus decreasing performance. If we can somehow combine all the JS files into a single bundle and request them as a single unit that would result in increased performance (see the next figure which has a single request).

So how do we implement bundling in MVC? Open BundleConfig.cs from the App_Start folder.

In BundleConfig.cs, add the JS files you want bundle into a single entity in to the bundles collection. In the below code we are combining all the javascript JS files which exist in the Scripts folder as a single unit in to the bundle collection.

bundles.Add(new ScriptBundle("~/Scripts/MyScripts").Include( "~/Scripts/*.js")); Below is how your BundleConfig.cs file will look like:

public class BundleConfig { public static void RegisterBundles(BundleCollection bundles) { bundles.Add(new ScriptBundle("~/Scripts/MyScripts").Include( "~/Scripts/*.js")); BundleTable.EnableOptimizations = true; } } Once you have combined your scripts into one single unit we then to include all the JS files into the view using the below code. The below code needs to be put in the ASPX or Razor view.

<%= Scripts.Render("~/Scripts/MyScripts") %> If you now see your page requests you would see that script request is combined into one request.

How can you test bundling in debug mode? If you are in a debug mode you need to set EnableOptimizations to true in the bundleconfig.cs file or else you will not see the bundling effect in the page requests.

BundleTable.EnableOptimizations = true; Explain minification and how to implement it Minification reduces the size of script and CSS files by removing blank spaces , comments etc. For example below is a simple javascript code with comments.

// This is test var x = 0; x = x + 1; x = x * 2; After implementing minification the JavaScript code looks like below. You can see how whitespaces and comments are removed to minimize file size, thus increasing performance.

var x=0;x=x+1;x=x*2; How do we implement minification? When you implement bundling, minification is implemented by itself. In other words the steps to implement bundling and minification are the same.

Explain Areas in MVC? Areas help you to group functionalities in to independent modules thus making your project more organized. For example in the below MVC project we have four controller classes and as time passes by if more controller classes are added it will be difficult to manage. In bigger projects you will end up with 100’s of controller classes making life hell for maintenance.

If we can group controller classes in to logical section like “Invoicing” and “Accounting” that would make life easier and that’s what “Area” are meant to.

You can add an area by right clicking on the MVC solution and clicking on “Area” menu as shown in the below figure.

In the below image we have two “Areas” created “Account” and “Invoicing” and in that I have put the respective controllers. You can see how the project is looking more organized as compared to the previous state.

Explain the concept of View Model in MVC? A view model is a simple class which represents data to be displayed on the view.

For example below is a simple customermodel object with “CustomerName” and “Amount” property.

CustomerViewModel obj = new CustomerViewModel(); obj.Customer.CustomerName = "Shiv"; obj.Customer.Amount = 1000; But when this “Customer” model object is displayed on the MVC view it looks something as shown in the below figure. It has “CustomerName” , “Amount” plus “Customer Buying Level” fields on the view / screen. “Customer buying Level” is a color indicationwhich indicates how aggressive the customer is buying.

“Customer buying level” color depends on the value of the “Amount property. If the amount is greater than 2000 then color is red , if amount is greater than 1500 then color is orange or else the color is yellow.

In other words “Customer buying level” is an extra property which is calculated on the basis of amount.

So the Customer viewmodel class has three properties

“TxtCustomerName” textbox takes data from “CustomerName” property as it is. “TxtAmount” textbox takes data from “Amount” property of model as it is. “CustomerBuyingLevelColor” displays color value depending on the “Amount “ value. Customer Model Customer ViewModel CustomerName TxtCustomerName Amount TxtAmount CustomerBuyingLevelColor What kind of logic view model class will have? As the name says view model this class has the gel code or connection code which connects the view and the model.

So the view model class can have following kind of logics:-

Color transformation logic: - For example you have a “Grade” property in model and you would like your UI to display “red” color for high level grade, “yellow” color for low level grade and “green” color of ok grade. Data format transformation logic :-Your model has a property “Status” with “Married” and “Unmarried” value. In the UI you would like to display it as a checkbox which is checked if “married” and unchecked if “unmarried”. Aggregation logic: -You have two differentCustomer and Address model classes and you have view which displays both “Customer” and “Address” data on one go.

Structure downsizing: - You have “Customer” model with “customerCode” and “CustomerName” and you want to display just “CustomerName”. So you can create a wrapper around model and expose the necessary properties.

How can we use two ( multiple) models with a single view?

Let us first try to understand what the interviewer is asking. When we bind a model with a view we use the model dropdown as shown in the below figure. In the below figure we can only select one model.

But what if we want to bind “Customer” as well as “Order” class to the view.

For that we need to create a view model which aggregates both the classes as shown in the below code. And then bind that view model with the view.

Collapse | Copy Code public class CustOrderVM { public Customer cust = new Customer(); public Order Ord = new Order(); } In the view we can refer both the model using the view model as shown in the below code. Collapse | Copy Code <%= model.cust.Name %> <%= model.Ord.Number %> Explain the need of display mode in MVC? Display mode displays views depending on the device the user has logged in with. So we can create different views for different devices anddisplay mode will handle the rest.

For example we can create a view “Home.aspx” which will render for the desktop computers and Home.Mobile.aspx for mobile devices. Now when an end user sends a request to the MVC application, display mode checks the “user agent” headers and renders the appropriate view to the device accordingly.

Explain MVC model binders? Model binder maps HTML form elements to the model. It acts like a bridge between HTML UI and MVC model. Many times HTML UI names are different than the model property names. So in the binder we can write the mapping logic between the UI and the model.

Explain the concept of MVC Scaffolding?

Note :- Do not get scared with the word. Its actually a very simple thing. Scaffolding is a technique in which the MVC template helps to auto-generate CRUD code. CRUD stands for create, read, update and delete.

So to generate code using scaffolding technique we need to select one of the types of templates (leave the empty one).

For instance if you choose “using Entity framework” template the following code is generated.

It creates controller code, view and also table structure as shown in the below figure.

What does scaffolding use internally to connect to database? It uses Entity framework internally.

Please do read this blog which has detailed steps of how model binders can be created using “IModelBinder” interface: - Explain MVC model Binders?

Saturday, May 25, 2013

Reading a complex XML file using LinQ [Solved]

This sample code will help you to parse XML data using LinQ C# . The XML file has a lot of levels, I capture all value in one ILIST<> . there are more tags in items.
The XML has the following syntax:

  
    
      19
      2
      Guatemala
      502
      GT
      TIGO
      7.0
    
    
      20
      2
      Guatemala
      502
      GT
      TIGO
      10.0
    
    
      21
      2
      Guatemala
      502
      GT
      TIGO
      14.0
    
  

Just follow this code to Read XML.
using System.Xml.XPath;
...

var chartrate = from a in xmlDoc.XPathSelectElements ("/root/items/*")

                     select new 
                     {
                         Product = a.Element("product_id").Value,
                         Menu= a.Element("menu_rank").Value,
                         Country= a.Element("menu_country").Value

                     };
If you have any query, feel free to get in touch please.

Tuesday, April 23, 2013

Export to Excel from GridView in C#

This sample code will help you export data from GridView to Excel and formatting Excel file in C# . Follow the below process:
    protected void ExportToExcel_Click(object sender, EventArgs e)
    {
        BindgvPDRecovery(); // Bind GridView1
        Response.ClearContent();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Report.xls"));
        Response.ContentType = "application/vnd.xls";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.AllowPaging = false; GridView1.DataBind();
        GridView1.HeaderRow.Style.Add("background-color", "#000000");
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
}

If have any query feel free ask me please.
Hope this helps !!

Tuesday, April 9, 2013

ASP.NET Interview Questions and Answers

=>
What is ASP.NET?

ASP.NET is a server side scripting technology that enables scripts (embedded in web pages) to be executed by an Internet server.
ASP.NET provides increased performance by running compiled code.
=>
What is Difference between Namespace and Assembly?

Namespace is a logical design-time naming convenience, whereas an assembly establishes the name scope for types at run time.

=>
What is the difference between early binding and late binding?

Calling a non-virtual method, decided at a compile time is known as early binding. Calling a virtual method (Pure Polymorphism), decided at a runtime is known as late binding.

=>
What is the difference between Server.Transfer and response.Redirect?

The Server.Transfer () method stops the current page from executing, and runs the content on the specified page, when the execution is complete the control is passed back to the calling page.
While the Response.Redirect () method transfers the control on the specified page and the control is never passed back to calling page after execution.


Wednesday, April 3, 2013

HR Interview Questions and Answers

# Tell me about yourself.

I'm XY from Dhaka.First of all I would like to thank you for given wonderful opportunity to introduce myself.Coming to my education background...I have completed MSc. in Computer science & Engineering from Islamic University Bangladesh. BSc in Computer science & engineering from Islamic University Bangladesh. Higher Secondary Certificate completed from Kushtia govt. college my schooling in Kushtia Zilla school. Coming to my area of interest.....My interest is software development and web application development. I always want to give optimal functionality to my Project that should be different from others. I have 6 years experience on software development. I am Microsoft certified technology specialist. My hobbies are playing cricket and listening songs. My strengths are I'm a Goal Oriented Person, I'm also team player (also I can work alone) , Fast Learner, and Keen to Details. I just believe in hard working and punctuality. Thanks to be a part of best listener.

#why should I hire you ?

Sir, you should hire me because, I will fulfill the all requirements required for this job, and I think this is the correct platform where I can enhance my skills in organization and explore my skills in the organization. I know your company is a wonderful opportunity for me to improve and achieve my goals.

#What are your strengths and weaknesses ?

My strengths are, I am a positive attitude person, quick learner and I am a hard worker as well as smart worker. I will be very flexible for given environment.

I am straightforward person & very emotional. I never comfortable feel until finish my work.

#Why do you want to work at our company ?

Everybody wants to work in reputed company like your and this organization is the good platform where I can improve my skills and learn new thing also.

#What are your goals?

My short term goal is to get a job in reputed company where I can utilize my skills and improve my career path. My long term goal is to be in respectable position in that organization.

#How long would you expect to work for us if hired ?

Sir, if you will give me a chance to work with this organization. I will work for the organization as long company will require my services. I would love to the part of organization as long as my skills and my knowledge will benefit both of us.

#Do you have any questions for me ?

I would like to know about the career growth I can expect being with this company. I am quite an ambitious person and this information will be helpful.

#Ideal Company

An ideal company is one where I can utilize my skills and abilities and can gain more knowledge. An ideal job is one which gives self satisfaction to me.
I can adapt to any new environment.

#Why did you resign from your previous job ?

I am very thankful to my previous organization because I have learnt lot things from there. According to me changes are necessary for everyone to enhance my skills, knowledge personal growth and financial growth. Your organization is the good platform where I can learn more.
Moreover new environment is always motivate us and gives the energy to do something better in the life. Why have you had so many jobs

#Why have you had many company?

Though I have changed lot of jobs but due to this I have learn different set of skills. And these skills help me a lot in dealing with different kinds of children and people. It show negativity on my part but my skills and learning ability have increased.

#How could you have improved your career progress?

To improve carrier, self confidence, +ve attitude, smart working, hardworking, dedication, punctuation, honesty and wish to learn new thing are required. And I have those points so because of that I could have improved myself.

Tuesday, April 2, 2013

[Solved]Flash file upload, windows authentication problem IIS7

[The problem When i try to upload file then asks me for windows authentication by windows dialogue box.
Its working fine my development machine but on live system it comes up with windows authentication.]

I have solved this problem to configure iis. Please see bellow image.


Right Click on "Windows Authintication" then select --> "Advance Settings"-->"Extended Protection"-->Select "Required" from dropdown-->Click "OK"
Happy Programming :)

Monday, April 1, 2013

[Solved]Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack

In this case you have to do this:
In place of Response.End() you have to use HttpContext.Current.ApplicationInstance.CompleteRequest()

and in place of Response.Redirect, use the Response.Redirect ("Error.aspx", false);
and in place of Server.Transfer, use the Server.Execute method

Wednesday, March 27, 2013

How to get distinct rows from a list using LINQ??

Let’s say that you have a list of objects that contains duplicate items and you want to extract a subset of distinct items. Just follow this code.

var TeamList = _context.tbl_user.ToList();// _context is a entity connection string
TeamList = TeamList.GroupBy(i => i.Team).Select(g => g.First()).ToList();
// OR
var distinctItems = items.GroupBy(x => x.PropertyToCompare).Select(x => x.First());



Happy Programming!!
Just because I can…

Wednesday, March 13, 2013

How found max id use LINQ?

If you want max Id from your table using LINQ then you can use bellow code.

int maxIdProd = context.Product.OrderBy(o => o.Id).Last();
// OR
var max = context.Product.Select(x=>x.ProductID).Max(); 


Enjoy!!

Thursday, March 7, 2013

how to display alert by using serverside code in asp.net C#?


If you want an alert message box in your application which returns a value. Now i am using a code for an alertmessage which returns value.
Response.Write(""); 
*Please correct spelling alert, Session["UserID"] is a server side variable .
Or
 ClientScript.RegisterStartupScript(GetType(), "TestAlert", "alert(\'This is test alert.\');", true);
Do let me know your feedback, comments.......

Wednesday, February 13, 2013

C#.Net Interview Question and Answers

=>
What is C#?

§  C# (pronounced "C sharp") is a simple, modern, object-oriented, and type-safe programming language.
§  It will immediately be familiar to C and C++ programmers.
§  C# combines the high productivity of Rapid Application Development (RAD) languages.

=>
What are the types of comment in C#?

There are 3 types of comments in C#.
§  Single line (//)
§  Multi (/* */)
§  Page/XML Comments (///).

=>
What are the namespaces used in C#.NET?

Namespace is a logical grouping of class.
§  using System;
§  using System.Collections.Generic;
§  using System.Windows.Forms;