public void AddEmployee(tbl_employee emp) { using (var dbCtx = new ValtechDBEntities()) { dbCtx.tbl_employee.Add(emp); dbCtx.SaveChanges(); } }
public List <tbl_employee> GetAllEmps() { using (var dbCtx = new ValtechDBEntities()) { var result = dbCtx.tbl_employee.ToList(); return(result); } }
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(); } }
public void DeleteById(int ecode) { using (var dbCtx = new ValtechDBEntities()) { var record = dbCtx.tbl_employee .Where(o => o.Ecode == ecode) .SingleOrDefault(); //delete record dbCtx.tbl_employee.Remove(record); dbCtx.SaveChanges(); } }
public tbl_employee GetEmpById(int ecode) { using (var dbCtx = new ValtechDBEntities()) { var record = dbCtx.tbl_employee .Where(o => o.Ecode == ecode) .SingleOrDefault(); return(record); dbCtx.SaveChanges(); } }