/// <summary> /// Delete from user list /// </summary> /// <param name="userModel"></param> /// <returns></returns> public bool DeleteUser(int userID) { //User_Master deleteUser = new User_Master(); User_Master deleteUser = dbContext.User_Master.Where(i => i.User_ID == userID).FirstOrDefault(); dbContext.User_Master.Remove(deleteUser); // dbContext.Entry(deleteUser).State = System.Data.Entity.EntityState.Deleted; dbContext.SaveChanges(); return(true); }
public bool AddTask(Task_Master task, ParentTask_Master parentTask) { try { var addTask = dbContext.Task_Master.Add(task); var addParentTask = dbContext.ParentTask_Master.Add(parentTask); User_Master user = dbContext.User_Master.Where(i => i.User_ID == task.userID).FirstOrDefault(); user.Project_ID = task.Project_ID; user.Task_ID = addTask.Task_ID; dbContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
/// <summary> /// Add update user /// </summary> /// <param name="userModel"></param> /// <returns></returns> public string AddOrUpdateUser(User_Master userModel) { if (userModel != null) { User_Master addUser = new User_Master(); addUser.First_Name = userModel.First_Name; addUser.Last_Name = userModel.Last_Name; addUser.Employee_ID = userModel.Employee_ID; if (userModel.User_ID == 0) { dbContext.User_Master.Add(addUser); } else { addUser.User_ID = userModel.User_ID; dbContext.Entry(addUser).State = EntityState.Modified; } dbContext.SaveChanges(); } return("true"); }