EDM Framework CRUD Operations using DataContextObject

AllowSorting="True" DataKeyNames="Id"
BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black"
GridLines="None" onpageindexchanging="GridView1_PageIndexChanging"
onrowdeleting="GridView1_RowDeleting" >
<AlternatingRowStyle BackColor="PaleGoldenrod" />
<FooterStyle BackColor="Tan" />

<HeaderStyle BackColor="Tan" Font-Bold="True" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />

<SortedAscendingCellStyle BackColor="#FAFAE7" />
<SortedAscendingHeaderStyle BackColor="#DAC09E" />
<SortedDescendingCellStyle BackColor="#E1DB9C" />
<SortedDescendingHeaderStyle BackColor="#C2A47B" />
<Columns>
<asp:BoundField HeaderText="Id" DataField="Id" SortExpression="Id" ReadOnly="true" />
<asp:TemplateField HeaderText="FirstName">
<ItemTemplate>
<%#Eval("FirstName") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%#Eval("FirstName") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="LastName">
<ItemTemplate>
<%#Eval("LastName") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("LastName") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Age">

<ItemTemplate>
<%#Eval("Age") %>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%#Eval("Age") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<span onclick="return confirm('Are you Sure Want to Delete Data ')">
<asp:LinkButton ID="LinkButton3" runat="server" Text="Delete" CommandName="Delete"></asp:LinkButton>
</span>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<table>
<tr>
<td></td>
<td>
<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click"> Click Here to Insert Data </asp:LinkButton>
</td>
</tr>
</table>
<br />
<br />
<h1>Modify Data Here</h1>
<table>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Please Enter Id"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="Please Enter FirstName"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="Please Enter LastName"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text="Please Enter Age"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td></td>
<td>
<asp:Button ID="Button1" runat="server" Text="Click Here to Modify" onclick="Button1_Click" Width="119px" />
</td>
</tr>
</table><br />
<table>
<tr>
<td>
</td>
<td>
<asp:Label ID="Label5" runat="server" Visible="false" ForeColor="Red" Font-Bold="true" Font-Size="Large">
</asp:Label>
</td>
</tr>
</table>
</center>
</div>
</form>
</body>
</html>

The Complete Code of WebForm2.aspx.cs looks like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace EDM_Application

{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Select();
}
}
protected void Select()
{
var objEntities = new CandidateEntities();
var query = from r in objEntities.Person select r;
GridView1.DataSource = query; GridView1.DataBind();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Redirect("~/WebForm1.aspx");
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
Select();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
var objEntities = new CandidateEntities();
var Id1 = GridView1.DataKeys[e.RowIndex].Value; var id = Convert.ToInt32(Id1);
var query = objEntities.Person.Where(a => a.Id == id);
if (query.Count() > 0)
{
foreach (Person person in query)
{
objEntities.DeleteObject(person);
} objEntities.SaveChanges();
} Select();
Label5.Text = ("Records Deleted Successfully");
Label5.Visible = true;
}
catch (ArgumentOutOfRangeException exception)
{
exception.Message.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (TextBox4.Text == "" || TextBox5.Text == "" || TextBox6.Text == "" || TextBox7.Text == "")
{
Label5.Text = ("Please Enter Some Values");
Label5.Visible = true;
}
else
{
var objEntities = new CandidateEntities();
var id1 = Convert.ToInt32(TextBox4.Text);
var person = objEntities.Person.Where(a => a.Id == id1).FirstOrDefault();
person.FirstName = TextBox5.Text;
person.LastName = TextBox6.Text;
person.Age = Convert.ToInt32(TextBox7.Text);
objEntities.SaveChanges();
Select();
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
Label5.Text = ("Records Updated Successfully");
Label5.Visible = true;
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
}

The Output of the WebForm1.aspx Application looks like this:

The Insertion Operation of the Application looks like this:

The Output of the WebForm2.aspx Application looks like this:

The Output of Data Modification for the Application looks like this:

The Output of Data Update Application looks like this:

The Output of Data Deletion Application looks like this:

The Output of Data Deleted Application looks like this:

I hope this article is useful for your. I look forward for your comments and feedback. Thanks Vijay Prativadi...