public async Task <CreateProcessStatus> CreateSupplierLedgerFromView(SupplierLedgerView view) { try { SupplierLedger supplierLedger = new SupplierLedger(); var query = await(from e in _dbContext.SupplierLedgers where e.AccountId == view.AccountId && e.Amount == view.Amount && e.GLDate == view.GLDate && e.DocNumber == view.DocNumber select e ).FirstOrDefaultAsync <SupplierLedger>(); if (query == null) { applicationViewFactory.MapSupplierLedgerEntity(ref supplierLedger, view); AddObject(supplierLedger); return(CreateProcessStatus.Insert); } return(CreateProcessStatus.AlreadyExists); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }
public async Task <SupplierLedgerView> GetSupplierLedgerByDocNumber(long?docNumber, string docType) { try { var query = await(from a in _dbContext.SupplierLedgers where a.DocNumber == docNumber && a.DocType == docType select a).FirstOrDefaultAsync <SupplierLedger>(); SupplierLedgerView view = applicationViewFactory.MapSupplierLedgerView(query); return(view); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }
public async Task <CreateProcessStatus> UpdateSupplierLedger(SupplierLedgerView supplierLedgerView) { try { var query = await GetObjectAsync(supplierLedgerView.SupplierLedgerId); SupplierLedger supplierLedgerBase = query; if (query != null) { applicationViewFactory.MapSupplierLedgerEntity(ref supplierLedgerBase, supplierLedgerView); UpdateObject(supplierLedgerBase); return(CreateProcessStatus.Update); } return(CreateProcessStatus.Failed); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }