public virtual int InsertUserDetails(MODEL.User user) { using (dbContext) { dbContext.Users.Add(new DAC.User() { Last_Name = user.LastName, First_Name = user.FirstName, Employee_ID = user.EmployeeId }); return(dbContext.SaveChanges()); } }
public virtual int DeleteUserDetails(MODEL.User user) { using (dbContext) { var editDetails = (from editUser in dbContext.Users where editUser.User_ID == user.UserId select editUser).First(); // Delete existing record if (editDetails != null) { dbContext.Users.Remove(editDetails); } return(dbContext.SaveChanges()); } }
public virtual int UpdateUserDetails(MODEL.User user) { using (dbContext) { var editDetails = (from editUser in dbContext.Users where editUser.User_ID == user.UserId select editUser).First(); // Modify existing records if (editDetails != null) { editDetails.First_Name = user.FirstName; editDetails.Last_Name = user.LastName; editDetails.Employee_ID = user.EmployeeId; } return(dbContext.SaveChanges()); } }