/// <summary> /// To fetch all task /// </summary> /// <returns></returns> public List <ParentTask> GetAllTasks() { using (var context = new ProjectManagerContext()) { return(context.ParentTasks.ToList()); } }
public List <User> GetAllUsers() { using (var context = new ProjectManagerContext()) { return(context.Users.ToList()); } }
/// <summary> /// Get all project /// </summary> /// <returns></returns> public List <Project> GetAllProject() { using (var context = new ProjectManagerContext()) { return(context.Projects.Where(x => x.Status == "Active").Include(x => x.Users).Include(x => x.Tasks).ToList()); } }
public List <Task> GetAllTasks() { using (var context = new ProjectManagerContext()) { return(context.Tasks.Include(x => x.User).Include(x => x.Project).Include(x => x.ParentTask).ToList()); } }
public User GetUserById(long userId) { using (var context = new ProjectManagerContext()) { return(context.Users.Where(x => x.User_ID == userId).FirstOrDefault()); } }
public void DeleteTestData() { using (var context = new ProjectManagerContext()) { var Task = context.Tasks.FirstOrDefault(x => x.Task1 == "XUnit-Test"); if (Task != null) { context.Tasks.Remove(Task); context.SaveChanges(); } var parentTask = context.ParentTasks.FirstOrDefault(x => x.Parent_Task == "XUnit-Test"); if (parentTask != null) { context.ParentTasks.Remove(parentTask); context.SaveChanges(); } var oUser = context.Users.FirstOrDefault(x => x.First_Name == "XUnit-Test"); if (oUser != null) { context.Users.Remove(oUser); context.SaveChanges(); } var Projects = context.Projects.FirstOrDefault(x => x.Project1 == "XUnit-Test"); if (Projects != null) { context.Projects.Remove(Projects); context.SaveChanges(); } } }
/// <summary> /// To add parent task /// </summary> /// <param name="oTask"></param> /// <returns></returns> public ParentTask AddParentTask(ParentTask oTask) { using (var context = new ProjectManagerContext()) { oTask = context.ParentTasks.Add(oTask); context.SaveChanges(); return(oTask); } }
public User AddUser(User oUser) { using (var context = new ProjectManagerContext()) { context.Users.Add(oUser); context.SaveChanges(); return(oUser); } }
/// <summary> /// Add project /// </summary> /// <param name="oProject"></param> /// <returns></returns> public Project AddProject(Project oProject) { using (var context = new ProjectManagerContext()) { oProject = context.Projects.Add(oProject); context.SaveChanges(); return(oProject); } }
/// <summary> /// to update parent task /// </summary> /// <param name="oTask"></param> /// <returns></returns> public ParentTask UpdateParentTask(ParentTask oTask) { using (var context = new ProjectManagerContext()) { oTask = context.ParentTasks.Attach(oTask); context.Entry(oTask).State = EntityState.Modified; context.SaveChanges(); return(oTask); } }
public bool DeleteUser(User oUser) { using (var context = new ProjectManagerContext()) { oUser = context.Users.FirstOrDefault(x => x.User_ID == oUser.User_ID); context.Users.Remove(oUser); context.SaveChanges(); return(true); } }
public User UpdateUser(User oUser) { using (var context = new ProjectManagerContext()) { context.Users.Attach(oUser); context.Entry(oUser).State = EntityState.Modified; context.SaveChanges(); return(oUser); } }
/// <summary> /// Update Project /// </summary> /// <param name="oProject"></param> /// <returns></returns> public Project UpdateProject(Project oProject) { using (var context = new ProjectManagerContext()) { context.Projects.Attach(oProject); context.Entry(oProject).State = EntityState.Modified; context.SaveChanges(); return(oProject); } }
public ProjectRepository(ProjectManagerContext context) { _context = context; }