private void GetData()
{
ContactsDataContext dbContext = new ContactsDataContext();
//linq getting from store procedure
GridView1.DataSource = dbContext.GetEmployee();
GridView1.DataBind();
}
protected void btnGetEmployeeByDepartment_Click(object sender, EventArgs e)
{
using (ContactsDataContext dbContext = new ContactsDataContext())
{
string deptName = string.Empty;
GridView1.DataSource = dbContext.GetEmployeesByDepartment(1, ref deptName);
GridView1.DataBind();
lblDept.Text = "Department Name = " + deptName;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
using (ContactsDataContext dbContext = new ContactsDataContext())
{
Employee employee = dbContext.Employees.SingleOrDefault
(x => x.ID == 8);
dbContext.Employees.DeleteOnSubmit(employee);
dbContext.SubmitChanges();
}
GetData();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
using (ContactsDataContext dbContext = new ContactsDataContext())
{
Employee employee = dbContext.Employees.SingleOrDefault
(x => x.ID == 8);
employee.Salary = 6500;
dbContext.SubmitChanges();
}
GetData();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
using (ContactsDataContext dbContext = new ContactsDataContext())
{
Employee newEmployee = new Employee
{
FirstName = "Time",
LastName = "T",
Gender = "Male",
Salary = 5000,
DepartmentId = 1
};
dbContext.Employees.InsertOnSubmit(newEmployee);
dbContext.SubmitChanges();
}
GetData();
}
