public User ReadUser(int?userId) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { return(FSECapsuleEntities.Users.Where(t => t.User_ID == userId).FirstOrDefault()); } }
public ParentTask ReadParentTask(int?TaskId) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { return(FSECapsuleEntities.ParentTasks.Where(t => t.Parent_ID == TaskId).FirstOrDefault()); } }
public List <User> ReadAllUsers() { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { return(FSECapsuleEntities.Users.ToList <User>()); } }
public Project ReadProject(int?projectId) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { return(FSECapsuleEntities.Projects.Where(t => t.Project_ID == projectId).FirstOrDefault()); } }
public List <ParentTask> ReadAllParentTask() { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { return(FSECapsuleEntities.ParentTasks.ToList <ParentTask>()); } }
public List <Project> ReadAllProjects() { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { return(FSECapsuleEntities.Projects.ToList <Project>()); } }
public void AddUser(User user) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { FSECapsuleEntities.Users.Add(user); FSECapsuleEntities.SaveChanges(); } }
public void AddProject(Project project) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { FSECapsuleEntities.Projects.Add(project); FSECapsuleEntities.SaveChanges(); } }
public void EndTask(Task taskId) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { Task task = FSECapsuleEntities.Tasks.Where(t => t.Task_ID == taskId.Task_ID).FirstOrDefault(); FSECapsuleEntities.Tasks.Remove(task); FSECapsuleEntities.SaveChanges(); } }
public void DeleteProject(Project project) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { Project currentProject = FSECapsuleEntities.Projects.Where(t => t.Project_ID == project.Project_ID).FirstOrDefault(); FSECapsuleEntities.Projects.Remove(currentProject); FSECapsuleEntities.SaveChanges(); } }
public void DeleteUser(User user) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { User currentUser = FSECapsuleEntities.Users.Where(t => t.User_ID == user.User_ID).FirstOrDefault(); FSECapsuleEntities.Users.Remove(currentUser); FSECapsuleEntities.SaveChanges(); } }
public void UpdateProject(Project project) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { Project currentProject = FSECapsuleEntities.Projects.Where(t => t.Project_ID == project.Project_ID).FirstOrDefault(); currentProject.Project1 = project.Project1; currentProject.Start_Date = project.Start_Date; currentProject.End_Date = project.End_Date; currentProject.Priority = project.Priority; FSECapsuleEntities.SaveChanges(); } }
public void UpdateUser(User user) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { User currentUser = FSECapsuleEntities.Users.Where(t => t.User_ID == user.User_ID).FirstOrDefault(); currentUser.Employee_ID = user.Employee_ID; currentUser.FirstName = user.FirstName; currentUser.LastName = user.LastName; currentUser.Task_ID = user.Task_ID; currentUser.Project_ID = user.Project_ID; FSECapsuleEntities.SaveChanges(); } }
public void UpdateTask(Task task) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { Task currentTask = FSECapsuleEntities.Tasks.Where(t => t.Task_ID == task.Task_ID).FirstOrDefault(); currentTask.Parent__ID = task.Parent__ID; currentTask.Task1 = task.Task1; currentTask.Priority = task.Priority; currentTask.Start_Date = task.Start_Date; currentTask.End_Date = task.End_Date; FSECapsuleEntities.SaveChanges(); } }
public void AddTask(Task task) { using (FSECapsuleEntities FSECapsuleEntities = new FSECapsuleEntities()) { try { FSECapsuleEntities.Tasks.Add(task); FSECapsuleEntities.SaveChanges(); } catch (Exception ex) { } } }