public async Task TestWoToEmployee() { ProjectManagementModule pmMod = new ProjectManagementModule(); ProjectManagementWorkOrderToEmployee woToEmployee = new ProjectManagementWorkOrderToEmployee() { EmployeeId = 1, WorkOrderId = 2 }; List <ProjectManagementWorkOrderToEmployee> list = new List <ProjectManagementWorkOrderToEmployee>(); list.Add(woToEmployee); pmMod.WorkOrderToEmployee.AddProjectManagementWorkOrderToEmployees(list).Apply(); long?workOrderId = woToEmployee.WorkOrderId; IEnumerable <EmployeeView> employeeList = await pmMod.Employee.Query().GetEntitiesByWorkOrderId(workOrderId ?? 0); foreach (var item in employeeList) { output.WriteLine($"{item.EmployeeName}"); } pmMod.WorkOrderToEmployee.DeleteProjectManagementWorkOrderToEmployees(list).Apply(); }
public async Task TestTaskToProjectRollup() { ProjectManagementModule pmMod = new ProjectManagementModule(); ProjectManagementProject project = await pmMod.Project.Query().GetEntityById(1); ProjectManagementMilestone milestone = await pmMod.Milestone.Query().GetEntityById(1); Udc udc = await pmMod.Udc.Query().GetEntityById(21); ChartOfAccount account = await pmMod.ChartOfAccount.Query().GetEntityById(4); ProjectManagementTaskView view = new ProjectManagementTaskView() { Wbs = "1.3", TaskName = "test rollup", Description = "task to project rollup", EstimatedStartDate = DateTime.Parse("12/1/2019"), EstimatedHours = 1, EstimatedEndDate = DateTime.Parse("12/31/2019"), ActualStartDate = DateTime.Parse("12/23/2019"), ActualHours = 1, ActualEndDate = DateTime.Parse("12/23/2020"), Cost = 31, MileStoneId = milestone.MilestoneId, MilestoneName = milestone.MilestoneName, StatusXrefId = udc.XrefId, EstimatedCost = 29, ActualDays = 1, EstimatedDays = 1, ProjectId = project.ProjectId, AccountId = account.AccountId, Account = account.Account, ProjectName = project.ProjectName, }; NextNumber nnNextNumber = await pmMod.ProjectManagementTask.Query().GetNextNumber(); view.TaskNumber = nnNextNumber.NextNumberValue; ProjectManagementTask projectManagementTask = await pmMod.ProjectManagementTask.Query().MapToEntity(view); pmMod.ProjectManagementTask.AddProjectManagementTask(projectManagementTask).Apply(); RollupTaskToProjectView rollup = await pmMod.Project.Query().GetTaskToProjectRollupViewById(milestone.MilestoneId); ProjectManagementTask newProjectManagementTask = await pmMod.ProjectManagementTask.Query().GetEntityByNumber(view.TaskNumber); if (rollup.Cost < 3000) { Assert.True(false); } pmMod.ProjectManagementTask.DeleteProjectManagementTask(newProjectManagementTask).Apply(); }
public async Task TestGetWorkOrdersByProjectId() { int projectId = 1; ProjectManagementModule pmMod = new ProjectManagementModule(); IQueryable <ProjectManagementWorkOrder> query = await pmMod.WorkOrder.Query().GetEntitiesByProjectId(projectId); foreach (var item in query) { output.WriteLine($"{item.Description}"); } Assert.True(query.Count() > 0); }
public async Task TestGetMileStonesByProjectId() { int projectId = 1; ProjectManagementModule pmMod = new ProjectManagementModule(); IQueryable <ProjectManagementMilestone> query = await pmMod.Milestone.Query().GetEntitiesByProjectId(projectId); int count = 0; foreach (var item in query) { output.WriteLine($"{item.MilestoneName}"); count++; } Assert.True(count > 0); }
public async Task TestGetTasksByMilestoneId() { long milestoneId = 1; ProjectManagementModule pmMod = new ProjectManagementModule(); IQueryable <ProjectManagementTask> query = await pmMod.Task.Query().GetEntitiesByMilestoneId(milestoneId); int count = 0; foreach (var item in query) { output.WriteLine($"{item.TaskName}"); count++; } Assert.True(count > 0); }
public async Task TestCreateProjecttoWorkOrder() { ProjectManagementModule pmMod = new ProjectManagementModule(); NextNumber nnProject = await pmMod.Project.Query().GetNextNumber(); ProjectManagementProject newProject = new ProjectManagementProject() { ProjectName = "Test Project", Version = "1", Description = "Test Project Description", EstimatedStartDate = DateTime.Parse("4/1/2019"), EstimatedHours = 10, EstimatedEndDate = DateTime.Parse("4/1/2019"), EstimatedDays = 1, ProjectNumber = nnProject.NextNumberValue }; pmMod.Project.AddProject(newProject).Apply(); ProjectManagementProject project = await pmMod.Project.Query().GetEntityByNumber(nnProject.NextNumberValue); long projectId = project.ProjectId; project.Description = "Test Project Description Update"; pmMod.Project.UpdateProject(project).Apply(); project = await pmMod.Project.Query().GetEntityById(projectId); Assert.Contains(project.Description, "Test Project Description Update"); NextNumber nnWorkOrder = await pmMod.WorkOrder.Query().GetNextNumber(); ProjectManagementWorkOrder newWorkOrder = new ProjectManagementWorkOrder() { WorkOrderNumber = nnWorkOrder.NextNumberValue, Description = "Test Work Order", StartDate = DateTime.Parse("4/1/2019"), EndDate = DateTime.Parse("4/1/2019"), EstimatedAmount = 100, EstimatedHours = 10, AccountNumber = "Test Account", Instructions = "Test Instructions", ProjectId = projectId, Status = "Open", Location = "Test Location" }; pmMod.WorkOrder.AddProjectManagementWorkOrder(newWorkOrder).Apply(); ProjectManagementWorkOrder workOrder = await pmMod.WorkOrder.Query().GetEntityByNumber(nnWorkOrder.NextNumberValue); long workOrderId = workOrder.WorkOrderId; workOrder.Description = "Test Work Order Description Update"; pmMod.WorkOrder.UpdateProjectManagementWorkOrder(workOrder).Apply(); workOrder = await pmMod.WorkOrder.Query().GetEntityById(workOrderId); Assert.Contains(workOrder.Description, "Test Work Order Description Update"); NextNumber nnMileStone = await pmMod.Milestone.Query().GetNextNumber(); ProjectManagementMilestone mileStone = new ProjectManagementMilestone() { MileStoneNumber = nnMileStone.NextNumberValue, MilestoneName = "Test Milestone", ProjectId = projectId, EstimatedHours = 1.1M, ActualDays = 1, EstimatedDays = 1, ActualHours = 1.2M, ActualStartDate = DateTime.Now, ActualEndDate = DateTime.Now, EstimatedStartDate = DateTime.Now.AddDays(-7), EstimatedEndDate = DateTime.Now.AddDays(-1), Cost = 100.1M, Wbs = "1.1" }; pmMod.Milestone.AddProjectManagementMilestone(mileStone).Apply(); ProjectManagementMilestone milestoneLookup = await pmMod.Milestone.Query().GetEntityByNumber(nnMileStone.NextNumberValue); ProjectManagementWorkOrderToEmployee woToEmployee = new ProjectManagementWorkOrderToEmployee() { EmployeeId = 1, WorkOrderId = workOrderId }; List <ProjectManagementWorkOrderToEmployee> list = new List <ProjectManagementWorkOrderToEmployee>(); list.Add(woToEmployee); pmMod.WorkOrderToEmployee.AddProjectManagementWorkOrderToEmployees(list).Apply(); long workOrderId2 = woToEmployee.WorkOrderId; IEnumerable <EmployeeView> employeeList = await pmMod.Employee.Query().GetEntitiesByWorkOrderId(workOrderId2); foreach (var item in employeeList) { output.WriteLine($"{item.EmployeeName}"); } Assert.True(employeeList.Count() > 0); pmMod.WorkOrderToEmployee.DeleteProjectManagementWorkOrderToEmployees(list).Apply(); pmMod.Milestone.DeleteProjectManagementMilestone(mileStone).Apply(); pmMod.WorkOrder.DeleteProjectManagementWorkOrder(workOrder).Apply(); pmMod.Project.DeleteProject(project).Apply(); //ProjectManagementMilestones mileStone = new ProjectManagementMilestones(); }