public int AddParentTask(string Taskname) { int Retval = -1; try { TblParentTask usrprfl = new TblParentTask(); usrprfl.Parent_Task = Taskname; var context = new ProductDBEntities(); context.TblParentTasks.Add(usrprfl); context.Entry(usrprfl).State = EntityState.Added; Retval = context.SaveChanges(); // this is where the error msg is being thrown. } 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 AddProjectInfo(string project, DateTime StartDate, DateTime EndDate, int Priority, int User_ID) { int newPK = -1; using (var context = new ProductDBEntities()) { TblProject Projectinfo = new TblProject() { Project = project, StartDate = StartDate, EndDate = EndDate, Priority = Priority, }; context.TblProjects.Add(Projectinfo); context.Entry(Projectinfo).State = EntityState.Added; context.SaveChanges(); context.Entry(Projectinfo).GetDatabaseValues(); //int newPK = Projectinfo.Project_ID; newPK = context.TblProjects.Max(p => p.Project_ID); } UserInfo detailmyuser = GetAllUsersById(User_ID); int ret = UpdateUser(User_ID, detailmyuser.FirstName, detailmyuser.LastName, newPK, detailmyuser.Employee_ID, 0); return(ret); }
public int UpdateUser(int UserId, string FirstName, string LastName, int Project_ID, string Employee_ID, int TaskID) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); UserInfo tempProd = new UserInfo();; tempProd.User_ID = UserId; tempProd.FirstName = FirstName; tempProd.LastName = LastName; tempProd.Project_ID = Project_ID; tempProd.Employee_ID = Employee_ID; tempProd.Task_ID = TaskID; TblUser result = tstDb.TblUsers.SingleOrDefault(b => b.User_ID == UserId); if (result != null) { result.User_ID = UserId; result.FirstName = FirstName; result.LastName = LastName; result.Project_ID = Project_ID; result.EmployeeID = Employee_ID; result.Task_ID = TaskID; tstDb.Entry(result).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }
public int AddUserInfo(string FirstName, string LastName, string EmployeeID, int Project_ID, int Task_ID) { int Retval = -1; try { TblUser usrprfl = new TblUser(); usrprfl.FirstName = FirstName; usrprfl.LastName = LastName; usrprfl.EmployeeID = EmployeeID; usrprfl.Project_ID = Project_ID; usrprfl.Task_ID = Task_ID; var context = new ProductDBEntities(); context.TblUsers.Add(usrprfl); context.Entry(usrprfl).State = EntityState.Added; Retval = context.SaveChanges(); // this is where the error msg is being thrown. } 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 LogErrorinDB(string error_info_Message, string error_info_Type) { int Retval = -1; try { using (var context = new ProductDBEntities()) { ErrorInfoDetail errorInfo = new ErrorInfoDetail(); errorInfo.ErrorInfoMessage = error_info_Message; errorInfo.ErrorInfoType = error_info_Type; context.ErrorInfoDetails.Add(errorInfo); Retval = context.SaveChanges(); } } 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 UpdateProjectUserInfo(int ProjectID, string project, DateTime startDate, DateTime endDate, int priority, int userID) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); ProjectInfo tempProd = new ProjectInfo();; tempProd.Project_ID = ProjectID; tempProd.Project = project; tempProd.StartDate = startDate; tempProd.EndDate = endDate; tempProd.Project_ID = priority; TblProject result = tstDb.TblProjects.SingleOrDefault(b => b.Project_ID == ProjectID); if (result != null) { //result.Project_ID = UserId; result.Project = project; result.StartDate = startDate; result.EndDate = endDate; result.Priority = priority; tstDb.Entry(result).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } //return Retval; TblUser resultuser = tstDb.TblUsers.SingleOrDefault(b => b.User_ID == userID); if (resultuser != null) { resultuser.User_ID = resultuser.User_ID; //resultuser.FirstName = resultuser.User_ID; //resultuser.LastName = LastName; resultuser.Project_ID = ProjectID; //resultuser.EmployeeID = Employee_ID; //resultuser.Task_ID = TaskID; tstDb.Entry(resultuser).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }
public int DeleteUserById(int UserId) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); TblUser userProfile = new TblUser(); userProfile.User_ID = UserId; tstDb.Entry(userProfile).State = EntityState.Deleted; Retval = tstDb.SaveChanges(); return(Retval); }
public int DeleteProjectById(int ProjectId) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); TblProject projInfo = new TblProject(); projInfo.Project_ID = ProjectId; tstDb.Entry(projInfo).State = EntityState.Deleted; Retval = tstDb.SaveChanges(); TblUser resultuser = tstDb.TblUsers.SingleOrDefault(b => b.Project_ID == ProjectId); if (resultuser != null) { resultuser.User_ID = resultuser.User_ID; resultuser.Project_ID = 0; tstDb.Entry(resultuser).State = EntityState.Modified; Retval = tstDb.SaveChanges(); } return(Retval); }
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); }