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 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 List <ProjectTaskInfo> GetAllTasks() { List <ProjectTaskInfo> TaskList = new List <ProjectTaskInfo>(); using (ProductDBEntities tstDb = new ProductDBEntities()) { //ProductDBEntities tstDb = new ProductDBEntities(); var lstTask = from k in tstDb.TblTasks select k; foreach (var item in lstTask) { ProjectTaskInfo _task = new ProjectTaskInfo(); _task.Task_Id = item.Task_ID; _task.Project_ID = item.Project_ID; _task.Task = item.Task; _task.StartDate = item.StartDate; _task.EndDate = item.EndDate; _task.Priority = item.Priority; _task.Parent_ID = item.Parent_ID; _task.Project_ID = item.Project_ID; _task.Status = item.Status; TaskList.Add(_task); } } return(TaskList); }
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 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 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 CheckUserDependencyById(int UserId) { int Retval = -1; ProductDBEntities tstDb = new ProductDBEntities(); ObjectResult <Nullable <int> > usercount = tstDb.sp_CheckifUserUsed(UserId); foreach (Nullable <int> result in usercount) { Retval = result.Value; break; } return(Retval); }
public ProjectInfo GetProjectById(int id) { ProductDBEntities tstDb = new ProductDBEntities(); var lstUsr = from k in tstDb.TblProjects where k.Project_ID == id select k; ProjectInfo ProjInfo = new ProjectInfo(); foreach (var item in lstUsr) { ProjInfo.Project_ID = item.Project_ID; ProjInfo.Project = item.Project; ProjInfo.StartDate = item.StartDate; ProjInfo.EndDate = item.EndDate; ProjInfo.Priority = item.Priority; } return(ProjInfo); }
public UserInfo GetAllUsersById(int id) { ProductDBEntities tstDb = new ProductDBEntities(); var lstUsr = from k in tstDb.TblUsers where k.User_ID == id select k; UserInfo userProfile = new UserInfo(); foreach (var item in lstUsr) { userProfile.User_ID = item.User_ID; userProfile.FirstName = item.FirstName; userProfile.LastName = item.LastName; userProfile.Project_ID = item.Project_ID; userProfile.Employee_ID = item.EmployeeID; userProfile.Task_ID = item.Task_ID; } return(userProfile); }
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 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 ProjectTaskInfo GetTaskById(int Taskid) { ProductDBEntities tstDb = new ProductDBEntities(); var lstUsr = from k in tstDb.TblTasks where k.Task_ID == Taskid select k; ProjectTaskInfo TaskInfo = new ProjectTaskInfo(); foreach (var item in lstUsr) { TaskInfo.Project_ID = item.Project_ID; TaskInfo.StartDate = item.StartDate; TaskInfo.EndDate = item.EndDate; TaskInfo.Priority = item.Priority; TaskInfo.Task = item.Task; TaskInfo.Parent_ID = item.Parent_ID; TaskInfo.Status = item.Status; } return(TaskInfo); }
public List <ParentTaskInfo> GetAllParentTasks() { List <ParentTaskInfo> ParentTaskList = new List <ParentTaskInfo>(); using (ProductDBEntities tstDb = new ProductDBEntities()) { //ProductDBEntities tstDb = new ProductDBEntities(); var lstTask = from k in tstDb.TblParentTasks select k; foreach (var item in lstTask) { ParentTaskInfo _task = new ParentTaskInfo(); _task.ParentTask_Id = item.Parent_ID; _task.ParentTaskName = item.Parent_Task; ParentTaskList.Add(_task); } } return(ParentTaskList); }
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 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); }
public List <UserInfo> GetAllUsers() { List <UserInfo> UserLst1 = new List <UserInfo>(); using (ProductDBEntities tstDb = new ProductDBEntities()) { //ProductDBEntities tstDb = new ProductDBEntities(); var lstUser = from k in tstDb.TblUsers select k; foreach (var item in lstUser) { UserInfo upr = new UserInfo(); upr.User_ID = item.User_ID; upr.FirstName = item.FirstName; upr.LastName = item.LastName; upr.Project_ID = item.Project_ID; upr.Employee_ID = item.EmployeeID; upr.Task_ID = item.Task_ID; // tstDb.Entry(upr).State = EntityState.Detached; UserLst1.Add(upr); } } return(UserLst1); }
public List <ProjectInfo> GetAllProjects() { List <ProjectInfo> UserLst = new List <ProjectInfo>(); List <ProjectInfo> UserLst1 = new List <ProjectInfo>(); using (ProductDBEntities tstDb = new ProductDBEntities()) { //ProductDBEntities tstDb = new ProductDBEntities(); var lstUser = from k in tstDb.TblProjects select k; foreach (var item in lstUser) { ProjectInfo upr = new ProjectInfo(); upr.Project_ID = item.Project_ID; upr.Project = item.Project; upr.StartDate = item.StartDate; upr.EndDate = item.EndDate; upr.Priority = item.Priority; UserLst1.Add(upr); } } return(UserLst1); }