public int UpdateTask(int TaskId, bool taskStatus) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); ProjectTaskInfo tempProd = new ProjectTaskInfo();; TblTask result = tstDb.TblTasks.SingleOrDefault(b => b.Task_ID == TaskId); if (result != null) { result.Status = taskStatus; tstDb.Entry(result).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }
public int AddTask(int ParentId, int ProjectId, string Task, DateTime StartDate, DateTime EndDate, int Priority, bool status, int UserID) { int Retval = -1; try { TblTask usrTask = new TblTask(); usrTask.Parent_ID = ParentId; usrTask.Project_ID = ProjectId; usrTask.Task = Task; usrTask.StartDate = StartDate; usrTask.EndDate = EndDate; usrTask.Priority = Priority; usrTask.Status = status; var context = new ProductDBEntities(); context.TblTasks.Add(usrTask); context.Entry(usrTask).State = EntityState.Added; Retval = context.SaveChanges(); int newTaskId = -1; newTaskId = context.TblTasks.Max(p => p.Task_ID); UserInfo detailmyuser = GetAllUsersById(UserID); int ret = UpdateUser(UserID, detailmyuser.FirstName, detailmyuser.LastName, ProjectId, detailmyuser.Employee_ID, newTaskId); //context.SaveChanges(); return(ret); /// } catch (DbEntityValidationException EX) { foreach (DbEntityValidationResult entityErr in EX.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { Console.WriteLine("Error: {0}", error.ErrorMessage); } } } return(Retval); }
public int UpdateTaskDetails(int TaskId, int ParentId, int ProjectId, string Task, DateTime StartDate, DateTime EndDate, int Priority, bool status) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); ProjectTaskInfo tempProd = new ProjectTaskInfo();; TblTask result = tstDb.TblTasks.SingleOrDefault(b => b.Task_ID == TaskId); if (result != null) { result.Parent_ID = ParentId; result.Project_ID = ProjectId; result.Task = Task; result.StartDate = StartDate; result.EndDate = EndDate; result.Priority = Priority; result.Status = status; tstDb.Entry(result).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }