public void AddEmployee(tbl_employee emp)
{
using (var dbCtx = new ValtechDBEntities())
{
dbCtx.tbl_employee.Add(emp);
dbCtx.SaveChanges();
}
}
public void UpdateEmp(tbl_employee emp)
{
using (var dbCtx = new ValtechDBEntities())
{
var record = dbCtx.tbl_employee
.Where(o => o.Ecode == emp.Ecode)
.SingleOrDefault();
//delete record
record.salary = emp.salary;
dbCtx.SaveChanges();
}
}