public void UpdateBatchStatus(string batchJob, string companyID) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { context.spUpdateBatchStatus("", ""); } }
public void UpdateAccountsOnHoldJournal(string companyID) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { context.spUpdateAccountsOnHoldJournal(companyID); } }
public List <SalesInvoiceJournalEntity> GetSalesInvoiceJournal(string companyID, int batchSize) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <SalesInvoiceJournal> salesInvoices = context.SalesInvoiceJournals.Where(l => l.CompanyID == companyID && l.Amount != 0 && (l.ExtractStatus == Constants.notExtracted || l.ExtractStatus == null)).Take(batchSize).ToList(); return(Mapper.Map <List <SalesInvoiceJournal>, List <SalesInvoiceJournalEntity> >(salesInvoices)); } }
/// <summary> /// Get the purchase invoice lines from the header /// </summary> /// <param name="companyID"></param> /// <param name="invoiceDate"></param> /// <param name="externalInvID"></param> /// <param name="vendAccount"></param> /// <returns></returns> public List <PurchaseInvoiceLineEntity> GetPurchaseInvoiceLines(string companyID, DateTime invoiceDate, string externalInvID, string vendAccount) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <PurchaseInvoiceLine> purchaseInvoiceLines = context.PurchaseInvoiceLines.Where(i => i.EXTERNAL_INV_ID == externalInvID && i.VendAccount == vendAccount && i.InvoiceDate == invoiceDate).ToList(); return(Mapper.Map <List <PurchaseInvoiceLine>, List <PurchaseInvoiceLineEntity> >(purchaseInvoiceLines)); } }
/// <summary> /// Get the Purchase Invoice Headers for company /// </summary> /// <param name="companyID"></param> /// <param name="batchSize"></param> /// <returns></returns> public List <PurchaseInvoiceHeaderEntity> GetPurchaseInvoices(string companyID, int batchSize) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <PurchaseInvoiceHeader> purchaseInvoices = context.PurchaseInvoiceHeaders.Where(l => l.CompanyID == companyID && (l.ExtractStatus == Constants.notExtracted || l.ExtractStatus == null)).Take(batchSize).ToList(); return(Mapper.Map <List <PurchaseInvoiceHeader>, List <PurchaseInvoiceHeaderEntity> >(purchaseInvoices)); } }
/// <summary> /// Get Vendor Changes /// </summary> /// <param name="companyID">Ax Company ID</param> /// <param name="batchSize">No of records to return</param> /// <returns></returns> public List <VendorChangeEntity> GetVendorChanges(string companyID, int batchSize) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <VendorChange> vendorChanges = context.VendorChanges.Where(l => l.CompanyId == companyID && (l.ExtractStatus == Constants.notExtracted || l.ExtractStatus == null)).Take(batchSize).ToList(); return(Mapper.Map <List <VendorChange>, List <VendorChangeEntity> >(vendorChanges)); } }
public List <spExtractAxPaymentTerms_ResultEntity> GetAxPaymentTerms(string companyID) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <spExtractAxPaymentTerms_Result> paymentTerms = context.spExtractAxPaymentTerms(companyID).ToList(); return(Mapper.Map <List <spExtractAxPaymentTerms_Result>, List <spExtractAxPaymentTerms_ResultEntity> >(paymentTerms)); } }
/// <summary> /// /// </summary> /// <param name="companyID"></param> /// <param name="batchSize"></param> /// <returns></returns> public List <AOMProductChangeEntity> GetAOMProductChanges(string companyID, int batchSize) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <AOMProductChange> productChanges = context.AOMProductChanges.Where(s => s.DATAAREAID == companyID && (s.ExtractStatus == Constants.notExtracted || s.ExtractStatus == null)).Take(batchSize).ToList(); return(Mapper.Map <List <AOMProductChange>, List <AOMProductChangeEntity> >(productChanges)); } }
/// <summary> /// /// </summary> /// <param name="companyID"></param> /// <param name="orderNumber"></param> /// <param name="deliveryNumber"></param> /// <param name="aomPurchaseDeliveryHeaderID"></param> /// <returns></returns> public List <AOMPurchaseDeliveryLinesEntity> GetPurchaseDeliveryLines(string companyID, string orderNumber, int aomPurchaseDeliveryHeaderID) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { List <AOMPurchaseDeliveryLine> deliveryLines = context.AOMPurchaseDeliveryLines.Where(s => s.EXTERNAL_ORD_ID == orderNumber && s.AOMPurchaseDeliveryHeaderID == aomPurchaseDeliveryHeaderID).ToList(); return(Mapper.Map <List <AOMPurchaseDeliveryLine>, List <AOMPurchaseDeliveryLinesEntity> >(deliveryLines)); } }
/// <summary> /// /// </summary> /// <param name="companyID"></param> /// <param name="batchSize"></param> /// <returns></returns> public List <AOMPurchaseDeliveryHeadersEntity> GetPurchaseDeliveryHeaders(string companyID, int batchSize) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { //ToDo: Add in the company ID!! List<AOMPurchaseDeliveryHeadersEntity> deliveryHeaders = context.AOMPurchaseDeliveryHeaders.Where(l => l.CompanyId == companyID && (l.ExtractStatus == Constants.notExtracted || l.ExtractStatus == null)).Take(batchSize).ToList(); List <AOMPurchaseDeliveryHeader> deliveryHeaders = context.AOMPurchaseDeliveryHeaders.Where(l => (l.ExtractStatus == Constants.notExtracted || l.ExtractStatus == null) && l.HeaderProcessed == 1 && l.DATAAREAID == companyID).Take(batchSize).ToList(); return(Mapper.Map <List <AOMPurchaseDeliveryHeader>, List <AOMPurchaseDeliveryHeadersEntity> >(deliveryHeaders)); } }
/// <summary> /// Update the status on the prurchase invoice ID's /// </summary> /// <param name="purchaseInvoiceHeaderID"></param> /// <param name="extractStatus"></param> public void UpdateAOMPurchaseInvoiceHeaderExtractStatus(List <long> purchaseInvoiceHeaderID, int extractStatus) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { foreach (int id in purchaseInvoiceHeaderID) { context.PurchaseInvoiceHeaders.Find(id).ExtractStatus = (byte)extractStatus; } context.SaveChanges(); } }
/// <summary> /// Update Sales Invoice Journal Lines with extract status /// </summary> /// <param name="custChangeID"></param> /// <param name="extractStatus"></param> public void UpdateSalesInvoiceJournalExtractStatus(List <long> custChangeID, int extractStatus) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { foreach (int id in custChangeID) { context.SalesInvoiceJournals.Find(id).ExtractStatus = extractStatus; } context.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="vendorChangeID"></param> /// <param name="extractStatus"></param> public void UpdateVendorExtractStatus(List <int> vendorChangeID, int extractStatus) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { foreach (int id in vendorChangeID) { context.VendorChanges.Find(id).ExtractStatus = extractStatus; } context.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="addressChangeID"></param> /// <param name="extractStatus"></param> public void UpdateAddressExtractStatus(List <int> addressChangeID, int extractStatus) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { foreach (int id in addressChangeID) { context.AddressChanges.Find(id).ExtractStatus = extractStatus; } context.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="productChangeID"></param> /// <param name="extractStatus"></param> public void UpdateAOMProductExtractStatus(List <int> productChangeID, int extractStatus) { using (Ax2012InterfaceEntities context = new Ax2012InterfaceEntities()) { foreach (int id in productChangeID) { context.AOMProductChanges.Find(id).ExtractStatus = (byte)extractStatus; } context.SaveChanges(); } }