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();
}
