public int InsertUserDetails(MODEL.User user) { using (dbcontext) { dbcontext.Users.Add(new Datalayer.User() { Last_Name = user.LastName, First_Name = user.FirstName, Employee_ID = user.EmployeeId }); return(dbcontext.SaveChanges()); } }
public int DeleteUserDetails(MODEL.User user) { using (dbcontext) { var editDetails = (from editUser in dbcontext.Users where editUser.User_ID == user.UserId select editUser).First(); if (editDetails != null) { dbcontext.Users.Remove(editDetails); } return(dbcontext.SaveChanges()); } }
public int UpdateUserDetails(MODEL.User user) { using (dbcontext) { var editDetails = (from editUser in dbcontext.Users where editUser.User_ID == user.UserId select editUser).First(); //if data exists update if (editDetails != null) { editDetails.First_Name = user.FirstName; editDetails.Last_Name = user.LastName; editDetails.Employee_ID = user.EmployeeId; } return(dbcontext.SaveChanges()); } }