protected void BtmUpdate(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employees employee = dbContext.Employees.SingleOrDefault(x => x.ID == 8);
employee.Salary = 65000;
dbContext.SubmitChanges();
}
GetData();
}
protected void BtmDelete(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
try
{
Employees employee = dbContext.Employees.SingleOrDefault(x => x.ID == 10);
dbContext.Employees.DeleteOnSubmit(employee);
dbContext.SubmitChanges();
}
catch (Exception ex)
{
ExceptionMethod(ex);
}
}
GetData();
}
protected void BtmInsert(object sender, EventArgs e)
{
try
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employees newEmployee = new Employees
{
FirstName = "jean",
LastName = "Fred",
Gender = "Male",
Salary = 50000,
DepartmentId = 1,
};
dbContext.Employees.InsertOnSubmit(newEmployee);
dbContext.SubmitChanges();
}
GetData();
}
catch (Exception ex)
{
ExceptionMethod(ex);
}
}
