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