public List <TaskViewModel> GetAll() { string parentTask = ""; ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); //taskDBEntities.TaskDetails.Include(x => x.TaskDetail1); List <TaskDetail> task = taskDBEntities.TaskDetails.ToList(); List <TaskViewModel> taskViewModelList = new List <TaskViewModel>(); foreach (var t in task) { parentTask = ""; string projName = ""; if (t.ParentTaskID != null) { parentTask = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == t.ParentTaskID).TaskName; } if (t.ProjectID != null) { projName = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectID == t.ProjectID).ProjectName; } taskViewModelList.Add( new TaskViewModel (t.TaskID, t.TaskName, parentTask, projName, t.StartDate.ToShortDateString(), t.EndDate.ToShortDateString(), t.Priority, t.Status)); } return(taskViewModelList); }
public List <UserViewModel> GetAll() { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); List <User> user = taskDBEntities.Users.ToList(); List <UserViewModel> userViewModelList = new List <UserViewModel>(); foreach (var t in user) { string taskName = ""; string projName = ""; if (t.TaskID != null) { taskName = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == t.TaskID).TaskName; } if (t.ProjectID != null) { projName = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectID == t.ProjectID).ProjectName; } userViewModelList.Add(new UserViewModel (t.UserID, t.FirstName, t.LastName, projName, t.EmployeeID, taskName)); } return(userViewModelList); }
public ProjectViewModel GetProject(int id) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); var project = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectID == id); return(new ProjectViewModel (project.ProjectID, project.ProjectName, project.StartDate.ToString(), project.EndDate.ToString(), project.Priority, project.Status)); }
private void DeleteAllTasks() { //Delete All tasks ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); taskDBEntities.Database.ExecuteSqlCommand("delete from users"); taskDBEntities.Database.ExecuteSqlCommand("delete from taskDetails"); taskDBEntities.Database.ExecuteSqlCommand("delete from project"); }
public void DeleteProject(int id) { ProjectTasksDBEntities projectDBEntities = new ProjectTasksDBEntities(); Project project = projectDBEntities.Projects.SingleOrDefault(p => p.ProjectID == id); var entry = projectDBEntities.Entry(project); if (entry.State == System.Data.Entity.EntityState.Detached) { projectDBEntities.Projects.Attach(project); } projectDBEntities.Projects.Remove(project); projectDBEntities.SaveChanges(); }
public void DeleteTask(int id) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); TaskDetail task = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == id); var entry = taskDBEntities.Entry(task); if (entry.State == System.Data.Entity.EntityState.Detached) { taskDBEntities.TaskDetails.Attach(task); } taskDBEntities.TaskDetails.Remove(task); taskDBEntities.SaveChanges(); }
public void DeleteUser(int id) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); User user = taskDBEntities.Users.SingleOrDefault(p => p.UserID == id); var entry = taskDBEntities.Entry(user); if (entry.State == System.Data.Entity.EntityState.Detached) { taskDBEntities.Users.Attach(user); } taskDBEntities.Users.Remove(user); taskDBEntities.SaveChanges(); }
public void AddProject(ProjectViewModel projectVM) { ProjectTasksDBEntities projectDBEntities = new ProjectTasksDBEntities(); Project project = new Project(); project.ProjectName = projectVM.ProjectName; project.StartDate = Convert.ToDateTime(projectVM.StartDate); project.EndDate = Convert.ToDateTime(projectVM.EndDate); project.Priority = projectVM.Priority; project.Status = (projectVM.Status == null) ? "" : projectVM.Status; projectDBEntities.Projects.Add(project); projectDBEntities.SaveChanges(); }
public void EditProject(ProjectViewModel projectVM) { ProjectTasksDBEntities projectDBEntities = new ProjectTasksDBEntities(); Project project = projectDBEntities.Projects.SingleOrDefault(p => p.ProjectID == projectVM.ProjectID); project.ProjectName = projectVM.ProjectName; project.StartDate = Convert.ToDateTime(projectVM.StartDate); project.EndDate = Convert.ToDateTime(projectVM.EndDate); project.Priority = projectVM.Priority; project.Status = (projectVM.Status == null) ? "" : projectVM.Status; projectDBEntities.Projects.Attach(project); projectDBEntities.Entry(project).State = System.Data.Entity.EntityState.Modified; projectDBEntities.SaveChanges(); }
public List <ProjectViewModel> GetAll() { ProjectTasksDBEntities projectDBEntities = new ProjectTasksDBEntities(); //taskDBEntities.TaskDetails.Include(x => x.TaskDetail1); List <Project> project = projectDBEntities.Projects.ToList(); List <ProjectViewModel> projectViewModelList = new List <ProjectViewModel>(); foreach (var p in project) { //var task = p.TaskDetails.SingleOrDefault(t => t.TaskName ); projectViewModelList.Add(new ProjectViewModel (p.ProjectID, p.ProjectName, p.StartDate.ToShortDateString(), p.EndDate.ToShortDateString(), p.Priority, p.Status)); } return(projectViewModelList); }
public UserViewModel GetUser(int id) { string taskName = ""; string projName = ""; ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); var user = taskDBEntities.Users.SingleOrDefault(p => p.UserID == id); if (user.TaskID != null) { taskName = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == user.TaskID).TaskName; } if (user.ProjectID != null) { projName = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectID == user.ProjectID).ProjectName; } return(new UserViewModel (user.UserID, user.FirstName, user.LastName, projName, user.EmployeeID, taskName)); }
public TaskViewModel GetTask(int id) { string parentTask = ""; string projName = ""; ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); var task = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == id); if (task.ParentTaskID != null) { parentTask = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == task.ParentTaskID).TaskName; } if (task.ProjectID != null) { projName = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectID == task.ProjectID).ProjectName; } return(new TaskViewModel (task.TaskID, task.TaskName, parentTask, projName, task.StartDate.ToShortDateString(), task.EndDate.ToShortDateString(), task.Priority, task.Status)); }
public void EditUser(UserViewModel userVM) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); User user = taskDBEntities.Users.SingleOrDefault(p => p.UserID == userVM.UserID); user.FirstName = userVM.FirstName; user.LastName = userVM.LastName; user.EmployeeID = userVM.EmployeeID; if (userVM.TaskName != null && userVM.TaskName != "") { user.TaskID = taskDBEntities.TaskDetails.SingleOrDefault(t => t.TaskName == userVM.TaskName).TaskID; } if (userVM.ProjectName != null && userVM.ProjectName != "") { user.ProjectID = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectName == userVM.ProjectName).ProjectID; } taskDBEntities.Users.Attach(user); taskDBEntities.Entry(user).State = System.Data.Entity.EntityState.Modified; taskDBEntities.SaveChanges(); }
public void AddTask(TaskViewModel taskVM) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); TaskDetail task = new TaskDetail(); task.TaskName = taskVM.TaskName; if (taskVM.ParentTaskName != null && taskVM.ParentTaskName != "") { task.ParentTaskID = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskName == taskVM.ParentTaskName).TaskID; } if (taskVM.ProjectName != null && taskVM.ProjectName != "") { task.ProjectID = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectName == taskVM.ProjectName).ProjectID; } task.StartDate = Convert.ToDateTime(taskVM.StartDate); task.EndDate = Convert.ToDateTime(taskVM.EndDate); task.Priority = taskVM.Priority; task.Status = taskVM.Status; taskDBEntities.TaskDetails.Add(task); taskDBEntities.SaveChanges(); }
public void AddUser(UserViewModel userVM) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); User user = new User(); user.FirstName = userVM.FirstName; user.LastName = userVM.LastName; user.EmployeeID = userVM.EmployeeID; if (userVM.TaskName != null && userVM.TaskName != "") { user.TaskID = taskDBEntities.TaskDetails.SingleOrDefault(t => t.TaskName == userVM.TaskName).TaskID; } if (userVM.ProjectName != null && userVM.ProjectName != "") { user.ProjectID = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectName == userVM.ProjectName).ProjectID; } taskDBEntities.Users.Add(user); taskDBEntities.SaveChanges(); }
public void EditTask(TaskViewModel taskVM) { ProjectTasksDBEntities taskDBEntities = new ProjectTasksDBEntities(); TaskDetail task = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskID == taskVM.TaskID); if (taskVM.ParentTaskName != null && taskVM.ParentTaskName != "") { task.ParentTaskID = taskDBEntities.TaskDetails.SingleOrDefault(p => p.TaskName == taskVM.ParentTaskName).TaskID; } if (taskVM.ProjectName != null && taskVM.ProjectName != "") { task.ProjectID = taskDBEntities.Projects.SingleOrDefault(p => p.ProjectName == taskVM.ProjectName).ProjectID; } task.StartDate = Convert.ToDateTime(taskVM.StartDate); task.EndDate = Convert.ToDateTime(taskVM.EndDate); task.Priority = taskVM.Priority; taskDBEntities.TaskDetails.Attach(task); taskDBEntities.Entry(task).State = System.Data.Entity.EntityState.Modified; taskDBEntities.SaveChanges(); }