/// <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;
}
