public void AddParent(ParentTaskData Parent) { using (var ct = new ProjectManagerContext()) { ct.ParentTaskData.Add(Parent); ct.SaveChanges(); } }
public void AddUser(UserData User) { using (var ct = new ProjectManagerContext()) { ct.UserData.Add(User); ct.SaveChanges(); } }
public void AddProject(ProjectData Project) { using (var ct = new ProjectManagerContext()) { ct.ProjectData.Add(Project); ct.SaveChanges(); } }
public List <ProjectData> GetProject(string Project) { List <ProjectData> Projectmatch = new List <ProjectData>(); using (var ct = new ProjectManagerContext()) { Projectmatch = ct.ProjectData.Where(a => a.Project.Contains(Project)).ToList <ProjectData>(); } return(Projectmatch); }
public List <ProjectData> GetAllProjects() { List <ProjectData> ProjectDetails = new List <ProjectData>(); using (var ct = new ProjectManagerContext()) { ProjectDetails = (from r in ct.ProjectData select r).ToList <ProjectData>(); } return(ProjectDetails); }
public List <TaskData> GetAllTasks() { List <TaskData> TaskDetails = new List <TaskData>(); using (var ct = new ProjectManagerContext()) { TaskDetails = (from r in ct.TaskData where r.Status != "Completed" select r).ToList <TaskData>(); } return(TaskDetails); }
public TaskData GetTask(int ID) { TaskData TaskDetail = new TaskData(); using (var ct = new ProjectManagerContext()) { TaskDetail = ct.TaskData.Where(a => a.TaskID == ID).FirstOrDefault(); } return(TaskDetail); }
public List <ParentTaskData> GetParentTask() { List <ParentTaskData> TaskMatch = new List <ParentTaskData>(); using (var ct = new ProjectManagerContext()) { TaskMatch = (from r in ct.ParentTaskData select r).ToList <ParentTaskData>(); } return(TaskMatch); }
public List <UserData> GetUser(string Employee) { List <UserData> UserMatch = new List <UserData>(); using (var ct = new ProjectManagerContext()) { UserMatch = ct.UserData.Where(a => a.EmployeeID.Contains(Employee.ToString())).ToList <UserData>(); } return(UserMatch); }
public List <UserData> GetAllUsers() { List <UserData> UserDetails = new List <UserData>(); using (var ct = new ProjectManagerContext()) { UserDetails = (from r in ct.UserData select r).ToList <UserData>(); } return(UserDetails); }
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 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 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 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(); } }
public void AddTask(TaskData Task) { int ParentID = 0; using (var ct = new ProjectManagerContext()) { ParentID = Convert.ToInt32((from r in ct.ParentTaskData where r.ParentTask == Task.ParentTask select ParentID).FirstOrDefault()); if (ParentID == 0) { ParentTaskData parent = new ParentTaskData(); parent.ParentTask = Task.ParentTask; ct.ParentTaskData.Add(parent); ct.SaveChanges(); } Task.ParentID = ParentID; ct.TaskData.Add(Task); ct.SaveChanges(); } }