public string EditProject(Project project)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
Project projectData = dbContext.Projects.Find(project.ProjectID);
projectData.ProjectDesc = project.ProjectDesc;
projectData.StartDate = project.StartDate;
projectData.EndDate = project.EndDate;
projectData.Priority = project.Priority;
if (dbContext.SaveChanges() > 0)
{
return("Record updated Successfully");
}
else
{
return("Failed. Plese try again later");
}
}
public string EditTask(Task task)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
Task taskData = dbContext.Tasks.Find(task.TaskID);
taskData.TaskDesc = task.TaskDesc;
taskData.StartDate = task.StartDate;
taskData.EndDate = task.EndDate;
taskData.Priority = task.Priority;
taskData.TaskStatus = task.TaskStatus;
taskData.TaskOwner = task.TaskOwner;
if (dbContext.SaveChanges() > 0)
{
return("Record updated Successfully");
}
else
{
return("Failed. Plese try again later");
}
}
public Project GetProject(int id)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Projects.Where(p => p.ProjectID == id).FirstOrDefault());
}
public AdminController(ProjectManagementDbContext dbContext, UserManager <User> userManager)
{
_userManager = userManager;
_dbContext = dbContext;
}
public ProjectRepository(ProjectManagementDbContext ctx) : base(ctx)
{
}
public UserController(ProjectManagementDbContext projectContext)
{
_context = projectContext;
}
public List <User> GetAllUsers()
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Users.ToList());
}
public DefaultEditionCreator(ProjectManagementDbContext context)
{
_context = context;
}
public int GetCompletedTaskCountByProject(int id)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Tasks.Where(t => t.ProjectID == id && t.TaskStatus == true).Count());
}
public int GetTaskCountByProject(int id)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Tasks.Where(t => t.ProjectID == id).Count());
}
public List <ParentTask> GetAllParentTasks()
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.ParentTasks.Distinct <ParentTask>().ToList());
}
public Task GetTask(int id)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Tasks.Include("ParentTask").Include("Project").Where(t => t.TaskID == id).FirstOrDefault());
}
public List <Task> GetAllTasks()
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Tasks.Include(p => p.ParentTask).Include(p => p.Project).ToList());
}
public DefaultTenantBuilder(ProjectManagementDbContext context)
{
_context = context;
}
public Repository(ProjectManagementDbContext ctx)
{
_ctx = ctx;
}
public TenantRoleAndUserBuilder(ProjectManagementDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public DefaultLanguagesCreator(ProjectManagementDbContext context)
{
_context = context;
}
public HostRoleAndUserCreator(ProjectManagementDbContext context)
{
_context = context;
}
public DefaultSettingsCreator(ProjectManagementDbContext context)
{
_context = context;
}
public User GetUser(int id)
{
ProjectManagementDbContext dbContext = new ProjectManagementDbContext();
return(dbContext.Users.Where(u => u.UserID == id).FirstOrDefault());
}
public CheckListItemRepository(ProjectManagementDbContext ctx) : base(ctx)
{
}
static void Main(string[] args)
{
using (ProjectManagementDbContext model = new ProjectManagementDbContext())
{
Project project = new Project();
project.ProjectID = 1;
project.ProjectDesc = "Test Project";
project.StartDate = Convert.ToDateTime("01/01/2017");
project.EndDate = Convert.ToDateTime("31/12/2018");
project.Priority = 10;
project.ProjectManager = 1;
model.Projects.Add(project);
project = new Project();
project.ProjectID = 2;
project.ProjectDesc = "Sample Project";
project.StartDate = Convert.ToDateTime("01/01/2018");
project.EndDate = Convert.ToDateTime("31/12/2018");
project.Priority = 15;
project.ProjectManager = 2;
model.Projects.Add(project);
ParentTask parentTask = new ParentTask();
parentTask.ParentTaskID = 1;
parentTask.ParentTaskDesc = "Parent 1";
List <Task> taskList = new List <Task>();
Task task = new Task();
task.TaskID = 1;
task.ParentTaskID = 1;
task.ProjectID = 1;
task.StartDate = Convert.ToDateTime("27/06/2018");
task.EndDate = Convert.ToDateTime("29/06/2018");
task.TaskDesc = "Sample Task Parent 1";
task.Priority = 10;
task.TaskOwner = 1;
taskList.Add(task);
task = new Task();
task.TaskID = 2;
task.ParentTaskID = 1;
task.ProjectID = 1;
task.StartDate = Convert.ToDateTime("20/06/2018");
task.EndDate = Convert.ToDateTime("25/06/2018");
task.TaskDesc = "This is test task Parent 1";
task.Priority = 20;
task.TaskOwner = 1;
taskList.Add(task);
task = new Task();
task.TaskID = 3;
task.ParentTaskID = 1;
task.ProjectID = 1;
task.StartDate = Convert.ToDateTime("27/06/2018");
task.EndDate = Convert.ToDateTime("29/06/2018");
task.TaskDesc = "Test Task Parent 1";
task.Priority = 5;
task.TaskOwner = 2;
taskList.Add(task);
parentTask.Tasks = taskList;
model.ParentTasks.Add(parentTask);
parentTask = new ParentTask();
parentTask.ParentTaskID = 2;
parentTask.ParentTaskDesc = "Parent 2";
taskList = new List <Task>();
task = new Task();
task.TaskID = 4;
task.ParentTaskID = 2;
task.ProjectID = 2;
task.StartDate = Convert.ToDateTime("27/04/2018");
task.EndDate = Convert.ToDateTime("29/06/2018");
task.TaskDesc = "Sample Task parent 2";
task.Priority = 15;
task.TaskOwner = 2;
taskList.Add(task);
task = new Task();
task.TaskID = 5;
task.ParentTaskID = 2;
task.ProjectID = 2;
task.StartDate = Convert.ToDateTime("20/03/2018");
task.EndDate = Convert.ToDateTime("25/05/2018");
task.TaskDesc = "This is test task Parent 2";
task.Priority = 21;
task.TaskOwner = 1;
taskList.Add(task);
task = new Task();
task.TaskID = 6;
task.ParentTaskID = 2;
task.ProjectID = 2;
task.StartDate = Convert.ToDateTime("27/06/2018");
task.EndDate = Convert.ToDateTime("29/09/2018");
task.TaskDesc = "Test Task Parent 2";
task.Priority = 30;
taskList.Add(task);
parentTask.Tasks = taskList;
model.ParentTasks.Add(parentTask);
User user = new User();
user.UserID = 1;
user.FirstName = "Riyaz";
user.LastName = "S";
user.EmployeeID = 123456;
model.Users.Add(user);
user = new User();
user.UserID = 2;
user.FirstName = "Sam";
user.LastName = "Troy";
user.EmployeeID = 423423;
model.Users.Add(user);
model.SaveChanges();
}
//TaskManagerBusinessLayer businessLayer = new TaskManagerBusinessLayer();
//List<Task> taskList = businessLayer.GetAllTasks();
//Task task = businessLayer.GetTask(1);
}
public CardService(ProjectManagementDbContext dbContext)
{
_dbContext = dbContext;
}
public InitialHostDbBuilder(ProjectManagementDbContext context)
{
_context = context;
}
public TeamMemberController(ProjectManagementDbContext dbContext, UserManager <User> userManager)
{
_userManager = userManager;
_dbContext = dbContext;
}
