public List <ReconciliationEgmTotals> GetWorkflowJobs()
{
// get workflows
WorkflowService workflowService = new WorkflowService();
List <Workflow> workflows = workflowService.ListWorkflows();
var HomeRIDs = workflows.AsEnumerable()
.Select(w => w.RefObjRID).Distinct().ToList();
// get sapphire egm totals by HomeRIDs
var sapphireEgmJobTotals = GetCompanyByJobNumber(GetSapphireEgmJobTotals(HomeRIDs));
if (!(sapphireEgmJobTotals is null) && sapphireEgmJobTotals.AsEnumerable().Any())
{
// Get pervasive egm totals by Job
PurchaseOrderHeaderRepository purchaseOrderHeaderRepository = new PurchaseOrderHeaderRepository();
DataTable pervasiveEgmJobTotals = purchaseOrderHeaderRepository.GetPervasiveRecords("JobCstActs_EGM");
if (!(pervasiveEgmJobTotals is null) && pervasiveEgmJobTotals.AsEnumerable().Any())
{
var egmJobTotalsAudit = AuditEgmJobTotals(sapphireEgmJobTotals, pervasiveEgmJobTotals);
return(egmJobTotalsAudit.ToList());
}
}
return(null);
}
public ReconciliationEgmTotals GetEgmAmounts(string jobNumber)
{
SapphireRepository sapphireRepository = new SapphireRepository();
DataTable sapphireEgmJobTotals = sapphireRepository.GetSapphireRecords("JobCstActs_EGM", jobNumber);
if (!(sapphireEgmJobTotals is null))
{
// Get pervasive egm totals by Job
PurchaseOrderHeaderRepository purchaseOrderHeaderRepository = new PurchaseOrderHeaderRepository();
DataTable pervasiveEgmJobTotals = purchaseOrderHeaderRepository.GetPervasiveRecords("JobCstActs_EGM", jobNumber);
if (!(pervasiveEgmJobTotals is null) && pervasiveEgmJobTotals.AsEnumerable().Any())
{
var egmJobTotalsAudit = AuditEgmJobTotals(sapphireEgmJobTotals, pervasiveEgmJobTotals);
ReconciliationEgmTotals egmTotals = new ReconciliationEgmTotals();
egmTotals.JobNumber = jobNumber;
egmTotals.SapphireEgmTotal = Convert.ToDecimal(egmJobTotalsAudit.ToList()[0].SapphireEgmTotal);
egmTotals.PervasiveEgmTotal = Convert.ToDecimal(egmJobTotalsAudit.ToList()[0].PervasiveEgmTotal);
egmTotals.EstimateApprovalDate = egmJobTotalsAudit.ToList()[0].EstimateApprovalDate;
return(egmTotals);
}
}
return(null);
}
public async Task Insert_GivenNewPurchaseOrderHeaderModel_ReturnsModelWithId()
{
var context = this.BuildContext();
var repo = new PurchaseOrderHeaderRepository(context);
PurchaseOrderHeaderModel[] result = (await repo.Insert(new PurchaseOrderHeaderModel())).ToArray();
Assert.NotNull(result);
Assert.Single(result);
Assert.Equal(1, result[0].PurchaseOrderId);
}
public async Task TestProfileMapping(TestCase <PurchaseOrderHeaderModel> testCase)
{
var context = this.BuildContext(new[] { (PurchaseOrderHeader)testCase.Data });
var repo = new PurchaseOrderHeaderRepository(context);
var testResult = await repo.FindAsync(1);
Assert.NotNull(testResult);
Assert.Equal(testResult.PurchaseOrderId, testCase.Expected.PurchaseOrderId);
Assert.Equal(testResult.RevisionNumber, testCase.Expected.RevisionNumber);
Assert.Equal(testResult.Status, testCase.Expected.Status);
Assert.Equal(testResult.EmployeeId, testCase.Expected.EmployeeId);
Assert.Equal(testResult.VendorId, testCase.Expected.VendorId);
Assert.Equal(testResult.ShipMethodId, testCase.Expected.ShipMethodId);
Assert.Equal(testResult.OrderDate, testCase.Expected.OrderDate);
Assert.Equal(testResult.ShipDate, testCase.Expected.ShipDate);
Assert.Equal(testResult.SubTotal, testCase.Expected.SubTotal);
Assert.Equal(testResult.TaxAmt, testCase.Expected.TaxAmt);
Assert.Equal(testResult.Freight, testCase.Expected.Freight);
Assert.Equal(testResult.TotalDue, testCase.Expected.TotalDue);
Assert.Equal(testResult.VendorDisplayName, testCase.Expected.VendorDisplayName);
Assert.Equal(testResult.ShipMethodDisplayName, testCase.Expected.ShipMethodDisplayName);
}
public PurchasingService(AdventureWorksContext context)
{
this._repo = new PurchaseOrderHeaderRepository(context);
}
