public bool AddTask(Task task) { using (FSDEntities db = new FSDEntities()) { if (task.Start_Date != Convert.ToDateTime("01-01-0001 00:00:00")) { Task taskManager = new Task(); taskManager.Task_Name = task.Task_Name; taskManager.Parent_Id = task.Parent_Id; taskManager.Priority = task.Priority; taskManager.Start_Date = task.Start_Date; taskManager.End_Date = task.End_Date; taskManager.Staus = true; taskManager.Project_Id = task.Project_Id; db.Tasks.Add(taskManager); db.SaveChanges(); } else { Parent_Task parent = new Parent_Task(); parent.Parent_Task1 = task.Task_Name; db.Parent_Task.Add(parent); db.SaveChanges(); } } return(true); }
public bool UpdateUser(User user) { try { using (FSDEntities db = new FSDEntities()) { var userData = (from p in db.Users where p.User_Id == user.User_Id select p).FirstOrDefault(); if (userData != null) { userData.First_Name = user.First_Name; userData.Last_Name = user.Last_Name; userData.Employee_id = user.Employee_id; db.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }
public bool UpdateTask(Task task) { using (FSDEntities db = new FSDEntities()) { db.Configuration.ProxyCreationEnabled = false; var taskManager = (from p in db.Tasks where p.Task_Id == task.Task_Id select p).FirstOrDefault(); if (taskManager != null) { taskManager.Task_Name = task.Task_Name; taskManager.Parent_Id = task.Parent_Id; taskManager.Priority = task.Priority; taskManager.Start_Date = task.Start_Date; taskManager.End_Date = task.End_Date; taskManager.Staus = true; taskManager.Project_Id = task.Project_Id; db.SaveChanges(); return(true); } else { return(false); } } }
public bool UpdateProject(Project project) { try { using (FSDEntities db = new FSDEntities()) { db.Configuration.ProxyCreationEnabled = false; var projectData = (from p in db.Projects where p.Project_Id == project.Project_Id select p).FirstOrDefault(); if (projectData != null) { projectData.Project_Name = project.Project_Name; projectData.Start_Date = project.Start_Date; projectData.End_Date = project.End_Date; projectData.Manager_Id = project.Manager_Id; projectData.Priority = project.Priority; db.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }
public bool AddUser(User user) { using (FSDEntities db = new FSDEntities()) { User taskManager = new User(); taskManager.Employee_id = user.Employee_id; taskManager.First_Name = user.First_Name; taskManager.Last_Name = user.Last_Name; db.Users.Add(taskManager); db.SaveChanges(); } return(true); }
public bool AddProject(Project project) { using (FSDEntities db = new FSDEntities()) { Project projectData = new Project(); projectData.Project_Name = project.Project_Name; projectData.Start_Date = project.Start_Date; projectData.End_Date = project.End_Date; projectData.Manager_Id = project.Manager_Id; projectData.Priority = project.Priority; db.Projects.Add(projectData); db.SaveChanges(); } return(true); }
public bool DeleteUser(int userId) { try { using (FSDEntities db = new FSDEntities()) { var userData = (from p in db.Users where p.User_Id == userId select p).FirstOrDefault(); db.Users.Remove(userData); db.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public bool EndTask(int id) { using (FSDEntities db = new FSDEntities()) { db.Configuration.ProxyCreationEnabled = false; var taskData = (from p in db.Tasks where p.Task_Id == id select p).FirstOrDefault(); if (taskData != null) { taskData.Staus = false; taskData.End_Date = System.DateTime.Now; db.SaveChanges(); return(true); } else { return(false); } } }
public bool DeleteProject(int projectId) { try { using (FSDEntities db = new FSDEntities()) { db.Configuration.ProxyCreationEnabled = false; var userData = (from p in db.Projects where p.Project_Id == projectId select p).FirstOrDefault(); db.Projects.Remove(userData); db.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }