.Net Core, ASP.Net

.Net Core – New Taste from Old School

After working few years with .Net , I started working with NodeJS Stack as Full Stack JavaScript is really awesome and isomorphic era attracted me a lot . I have worked with AngularJS , ReactJS , Electron and a lot of popular JavaScript Frameworks / libraries at frontend and backend.

After Mr. Satya started working as CEO , he has been doing a lot of changes. Making .Net open source was really a big move for MS.

Microsoft introduced .Net Core . And the concept of this seems similar(Conceptually) to NodeJS .

They removed old packages.config file and introduced project.json which is fully conceptually similar to NPM’s package.json , even the Keyword is similar “dependencies” , “scripts” etc .

They removed ASP.Net Forms , which is surely a good thing.

One of the cool things is that , Microsoft understood that Its high time to make .Net CrossPlatform , otherwise they would have lost the developers community as people moving to NodeJS , GO , and Functional programming stuffs who use Linux and/or MAC . Coz .Net was only for Windows users before. But now .Net core can be run in any platform which is awesome and definitely a good business trick for Microsoft.

Today , we will see how we can run .Net core in Ubuntu.

I am using Ubuntu 16.04

sudo sh -c 'echo "deb [arch=amd64] https://apt-mo.trafficmanager.net/repos/dotnet-release/ xenial main" > /etc/apt/sources.list.d/dotnetdev.list'

sudo apt-key adv --keyserver apt-mo.trafficmanager.net --recv-keys 417A0893

sudo apt-get update

sudo apt-get install dotnet-dev-1.0.0-preview2-003131

To verify run

dotnet -v

Always have an eye on this Page for Installing Updates .net-core-ubuntu

Advertisements
Standard
ASP.Net, ASP.Net MVC, C#, EntityFramework

EntityFramework in C# – Part2 : Calling MS SQL StoredProcedure

While we use EntiryFramework as ORM , we can use/call MS SQL StoredProcedure in our C# code . EF allows us to import StoredProcedures into our C# app as Functions .

Now I am gonna show , how we can use SP in EF . To know basic EF,please refer to my another article EntityFramework in C# – Part1 : Welcome To EF

For this demo , I have a simple SP which will return the data from a table.

StoredProcedure for EF in C#

I will fill an ASP.Net Grid with that data , and I am gonna pull the data using EF .

For this, after taking the update of EDMX , I will get the StoredProcedure inside the EDMX , and will add a Function for that SP like below —

EF - Add Function Import

Click Add Function Import and then…

EntityFramework with StoredProcedure - Function Import

Our SP is now ready in our app as a Function and we can just call that function as usual as we do.So my C# code for calling the function is like below :::

ImportantDBEntities dbEntities = new ImportantDBEntities();
            
            //Execute stored procedure as a function
            var employees = dbEntities.GetEmployees();
            if (employees != null)
            {
                employeeGrid.DataSource = employees;
                employeeGrid.DataBind();
            }

So our Grid is ready with data 🙂

Cheers

Standard
ASP.Net, ASP.Net MVC, C#, EntityFramework

EntityFramework in C# – Part1 : Welcome To EF

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

I am gonna write an article on EF with an easy approach and i am trying to clearly show a CRUD application with EF .

For this example , I used one DB Table for simplicity . My DB is like below :::

Welcome to EntityFramework

Welcome to EntityFramework

To make the app simple , I took a ASP.Net Form Application which has a UI like below :::

Welcome to EntityFramework ASP.Net C# Web

The Markup code for my UI is like below :::

<h2>
        Welcome to EntityFramework!
    </h2>
  

  <table>
   <tr>
    <td>    
       Name
    </td>  
    <td>
    :
    </td>
    <td>
        <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
    </td>
   </tr>
  

    <tr>
    <td>    
       Address
    </td>  
    <td>
    :
    </td>
    <td>
        <asp:TextBox ID="txtAddress" runat="server"></asp:TextBox>
    </td>
   </tr>

    <tr>
    <td>    
       Salary
    </td>  
    <td>
    :
    </td>
    <td>
        <asp:TextBox ID="txtSalary" runat="server"></asp:TextBox>
    </td>
   </tr>

     <tr>
    <td>    
   
    </td>  
    <td></td>
   
    <td>
        <asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" />
    </td>
   </tr>

  </table>

  <br />
       <asp:GridView ID="employeeGrid" runat="server">
    </asp:GridView>

<h1>Delete One Row By Id</h1>

  <table>
   <tr>
    <td>    
       Put Delete Id
    </td>  
    <td>
    :
    </td>
    <td>
        <asp:TextBox ID="txtDeleteId" runat="server"></asp:TextBox>
    </td>
    <td>
       <asp:Button ID="btnDelete" runat="server" Text="Delete"
            onclick="btnDelete_Click"  />
    </td>
   </tr>
  </table>

   <h1>Update Value By Id</h1>

  <table>
   <tr>
    <td>    
       Put Update Id
    </td>  
    <td>
    :
    </td>
    <td>
        <asp:TextBox ID="TxtUpdateId" runat="server"></asp:TextBox>
    </td>

     <td>    
       Put New Address
    </td>  
    <td>
    :
    </td>
    <td>
        <asp:TextBox ID="txtUpdateAddress" runat="server"></asp:TextBox>
    </td>

    <td>
       <asp:Button ID="btnUpdate" runat="server" Text="Update" onclick="btnUpdate_Click"
             />
    </td>
   </tr>
  </table>

I have Three buttons for CREATE , UPDATE , DELETE and have a method for READ .

Lets see CREATE first .

protected void btnSave_Click(object sender, EventArgs e)
        {
            ImportantDBEntities dbEntities = new ImportantDBEntities();            
            EF_Employee employee = new EF_Employee();
            employee.Name = txtName.Text;
            employee.Address = txtAddress.Text;
            employee.Salary = Convert.ToDecimal(txtSalary.Text) ;

            dbEntities.EF_Employee.AddObject(employee);
            dbEntities.SaveChanges();

            FillEmployeeGrid();
        }

Here ImportantDBEntities is my SQL Server DB Context as you saw the DB image that my DB name is ImportantDB.

And That FillEmployeeGrid() method is my READ method which will pull the data from DB table .

private void FillEmployeeGrid()
        {
            ImportantDBEntities dbEntities = new ImportantDBEntities();

            if (dbEntities.EF_Employee != null)
            {
                var employees = dbEntities.EF_Employee;
                employeeGrid.DataSource = employees;
                employeeGrid.DataBind();
            }
        }

We can also Delete a record of an ID.

protected void btnDelete_Click(object sender, EventArgs e)
        {
            int Id = Convert.ToInt32(txtDeleteId.Text);

            ImportantDBEntities dbEntities = new ImportantDBEntities();
            EF_Employee employee = dbEntities.EF_Employee.SingleOrDefault(i => i.Id == Id);
            dbEntities.EF_Employee.DeleteObject(employee);
            dbEntities.SaveChanges();

            FillEmployeeGrid();
        }

Update is also not a big deal .

protected void btnUpdate_Click(object sender, EventArgs e)
        {
            int id = Convert.ToInt32(TxtUpdateId.Text);

            ImportantDBEntities dbEntities = new ImportantDBEntities();
            EF_Employee employee = dbEntities.EF_Employee.SingleOrDefault(i => i.Id == id);
            employee.Address = txtUpdateAddress.Text;
            dbEntities.SaveChanges();

            FillEmployeeGrid();
        }

Hope , it helps them who are new to EF .
I will write more deeper things related to EF in Part 2 .So keep an eye on my Site.

Till Then , Cheers …

Standard
ASP.Net, ASP.Net MVC, C#, EntityFramework, MVC WebAPI

Runtime error on REST WebAPI : failed to serialize the response body for content type ‘application/xml; charset=utf-8

In a Relational Database system , we may get this type of runtime error when calling WebAPI for a composite Object .

The exception looks like this :::

The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8

We can solve this problem by adding the below lines in WebApiConfig.cs file under App_Start folder inside WebAPI project .

var json = config.Formatters.JsonFormatter;
            json.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;

Will write few full step by step articles on EntityFramework and WebAPI on this blog , so Please Keep an eye on this Blog .

Thanks 🙂

Standard
ASP.Net, C#

Bind C# List of object data with HTML without using ASP.Net control in ASP.Net

In ASP.Net we always use so may ASP.Net controls . But we also know ASP.Net controls have ViewState , so we should ignore using ASP.Net controls as much as possible to reduce the Load time of DOM .

In my example , I will show how we can bind and show the data to HTML without using ASP.Net Control in ASP.Net.

I have a List of a custom object like below :

protected List<voNote> notes = new List<voNote>();

This is a list of a ViewModel . and the ViewModel of my example is like below :::

public class voNote
    {
        public string Note { get; set; }

        public DateTime Date { get; set; }

        public string NoteCreatedBy { get; set; }

        public string TicketUrgency { get; set; }
    }

Let, We have populated the List from Database Server . Now we have to show/Bind the Data to the UI .

So my markup code will be just simple like below :

<%
        foreach (voNote note in notes)
        {
    %>
            <hr class="NoteBorder" />
            <div><%=note.Date %> | <%=note.NoteCreatedBy %> | <%= note.TicketUrgency %></div>
           
            <div class="NoteDiv"><%=note.Note %></div>
    <%
        }
    
    %>

So , its done 🙂

Standard
ASP.Net, C#, JavaScript

Show JavaScript Confirmation message while deleting ASP.Net Grid Row

Many a time , we need a confirmation Message on deleting ASP.Net Gird Row . Coz if any User mistakenly clicks the delete button , the data will be gone . So its always the Best to use Confirmation on Deleting .

We will see a demo now how to Show JavaScript/Client Side Confirmation Msg while deleting an ASP.Net Grid Row .

A long time ago ,I had to use more brain processing power to do this requirement 🙂 So I thought to share with all .

Lets see the below image for what I am gonna do :

Show JavaScript Confirmation message while deleting  ASP.Net Grid Row

Show JavaScript Confirmation message while deleting ASP.Net Grid Row

Add this markup inside your ASP.Net Grid .

<asp:TemplateField HeaderText="" ShowHeader="False" HeaderStyle-HorizontalAlign="Left">
                            <ItemTemplate>      
                                      <asp:LinkButton ID="lnkDelete" runat="server" CausesValidation="False" CommandName="Delete"
                                    Text="Delete" OnClientClick="ConfirmDelete(this.id)" ></asp:LinkButton>
                            </ItemTemplate>
                            <HeaderStyle HorizontalAlign="Left" />
                      </asp:TemplateField>

And the JavaScript method implementation of the ConfirmDelete(this.id) is like below –

function ConfirmDelete(RowId)
     {
         var rowNoStr = RowId.split('_');
         rowNo = parseInt(rowNoStr[3]) + 1;              
    
         var confirm_value = document.createElement("INPUT");
         confirm_value.type = "hidden";
         confirm_value.name = "confirm_value";

         var grid = document.getElementById('<%=gvTicketDetails.ClientID%>');

         var delText = "Are you sure to delete - ";
         var ticketNo ="Tk " + grid.rows[rowNo].cells[0].innerText + " : ";
         var ticketTitle = grid.rows[rowNo].cells[1].innerText + " ?";
         var delMsg = delText.concat(ticketNo, ticketTitle);

         var answer = confirm(delMsg);
         if (answer)
         {
             confirm_value.value = "Yes";
         }
         else
         {
             confirm_value.value = "No";
         }
         document.forms[0].appendChild(confirm_value);       
     }

And now using the below code , you can easily get the confirmation value at server side .

protected void gvTicketDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string confirmValue = Request.Form["confirm_value"];
            if (confirmValue.ToUpper() == "YES")
            {
                
            }
        }

You are done 🙂 Cheers

Standard