public void EditUser(int ID, UserData User) { using (var ct = new ProjectManagerContext()) { var Upduser = ct.UserData.Where(a => a.UserID == ID).FirstOrDefault(); Upduser.FirstName = User.FirstName; Upduser.LastName = User.LastName; Upduser.EmployeeID = User.EmployeeID; ct.SaveChanges(); } }
public void EditProject(int ID, ProjectData Project) { using (var ct = new ProjectManagerContext()) { var UpdProject = ct.ProjectData.Where(a => a.ProjectID == ID).FirstOrDefault(); UpdProject.Project = Project.Project; UpdProject.ProjectStartDate = Project.ProjectStartDate; UpdProject.ProjectEndDate = Project.ProjectEndDate; UpdProject.ProjectPriority = Project.ProjectPriority; UpdProject.ProjectManager = Project.ProjectManager; ct.SaveChanges(); } }
public void DeleteUser(int ID) { using (var ct = new ProjectManagerContext()) { List <UserData> DelUser = new List <UserData>(); DelUser = (from r in ct.UserData select r).ToList <UserData>(); if (DelUser != null && DelUser.Count != 0) { ct.UserData.Remove(DelUser[0]); ct.SaveChanges(); } } }
public void DeleteProject(int ID) { using (var ct = new ProjectManagerContext()) { List <ProjectData> DelProject = new List <ProjectData>(); DelProject = (from r in ct.ProjectData select r).ToList <ProjectData>(); if (DelProject != null && DelProject.Count != 0) { ct.ProjectData.Remove(DelProject[0]); ct.SaveChanges(); } } }
public void DeleteTask(int ID) { using (var ct = new ProjectManagerContext()) { //List<TaskData> DelTask = new List<TaskData>(); //var DelTask = (from r in ct.TaskData select r).ToList<TaskData>(); var DelTask = ct.TaskData.Where(a => a.TaskID == ID).FirstOrDefault(); //if (DelTask != null && DelTask.Count != 0) //{ DelTask.Status = "Completed"; ct.SaveChanges(); //} } }
public void UpdateTask(int ID, TaskData Task) { int ParentID = 0; using (var ct = new ProjectManagerContext()) { var UpdTask = ct.TaskData.Where(a => a.TaskID == ID).FirstOrDefault(); UpdTask.Task = Task.Task; UpdTask.ParentID = ParentID; UpdTask.ParentTask = Task.ParentTask; UpdTask.Priority = Task.Priority; UpdTask.StartDate = Task.StartDate; UpdTask.EndDate = Task.EndDate; ct.SaveChanges(); } }