protected void Button4_Click(object sender, EventArgs e)
{
DbCompanyEntities ce = new DbCompanyEntities();
short empno = short.Parse(TxtEmpno.Text);
Emp context = ce.Emps.SingleOrDefault(col => col.Empno == empno);
ce.DeleteObject(context);
ce.SaveChanges();
}
protected void Button4_Click(object sender, EventArgs e)
{
DbCompanyEntities ce = new DbCompanyEntities();
short empno = short.Parse(TxtEmpno.Text);
Emp context = ce.Emps.SingleOrDefault(col => col.Empno == empno);
ce.DeleteObject(context);
ce.SaveChanges();
}
protected void Button3_Click(object sender, EventArgs e)
{
DbCompanyEntities ce = new DbCompanyEntities();
short empno = short.Parse(TxtEmpno.Text);
Emp context = ce.Emps.SingleOrDefault(col => col.Empno == empno);
context.Ename = TxtName.Text;
context.Job = TxtJob.Text;
context.Salary = short.Parse(TxtSalary.Text);
ce.SaveChanges();
}
protected void Button3_Click(object sender, EventArgs e)
{
DbCompanyEntities ce = new DbCompanyEntities();
short empno = short.Parse(TxtEmpno.Text);
Emp context = ce.Emps.SingleOrDefault(col => col.Empno == empno);
context.Ename = TxtName.Text;
context.Job = TxtJob.Text;
context.Salary = short.Parse(TxtSalary.Text);
ce.SaveChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
#region Create a record
Emp rec = new Emp();
rec.Empno = short.Parse(TxtEmpno.Text);
rec.Ename = TxtName.Text;
rec.Job = TxtJob.Text;
rec.Salary = short.Parse(TxtSalary.Text);
#endregion
#region Add employ into db and save changes
DbCompanyEntities dce = new DbCompanyEntities();
dce.AddToEmps(rec);
dce.SaveChanges();
#endregion
}
protected void Button1_Click(object sender, EventArgs e)
{
#region Create a record
Emp rec = new Emp();
rec.Empno = short.Parse(TxtEmpno.Text);
rec.Ename = TxtName.Text;
rec.Job = TxtJob.Text;
rec.Salary = short.Parse(TxtSalary.Text);
#endregion
#region Add employ into db and save changes
DbCompanyEntities dce = new DbCompanyEntities();
dce.AddToEmps(rec);
dce.SaveChanges();
#endregion
}