private static void DeleteEmployee(int empId) { var context = new TestDBEntities(); var emp = context.EmployeeDetails.SingleOrDefault(e => e.Emp_Id == empId); context.EmployeeDetails.Remove(emp); context.SaveChanges(); }
private static void UpdateEmployeeDetails(int empId, int mgrId, string name, string designation) { var context = new TestDBEntities(); var emp = context.EmployeeDetails.Find(empId); emp.Emp_MgrId = mgrId; emp.Emp_Name = name; emp.Emp_Designation = designation; context.SaveChanges(); }
private static void SaveEmployeeDetails(int empId, int mgrId, string name, string designation) { var context = new TestDBEntities(); var emp = new EmployeeDetail() { Emp_Id = empId, Emp_MgrId = mgrId, Emp_Name = name, Emp_Designation = designation }; context.EmployeeDetails.Add(emp); context.SaveChanges(); }