public async Task <CreateProcessStatus> CreateLedgerFromView(CustomerLedgerView view)
{
try
{
CustomerLedger customerLedger = new CustomerLedger();
var query = await(from e in _dbContext.CustomerLedgers
where e.AccountId == view.AccountId &&
e.Amount == view.Amount &&
e.GLDate == view.GLDate &&
e.DocNumber == view.DocNumber &&
e.Comment == view.Comment
select e
).FirstOrDefaultAsync <CustomerLedger>();
if (query == null)
{
applicationViewFactory.MapCustomerLedgerEntity(ref customerLedger, view);
AddObject(customerLedger);
return(CreateProcessStatus.Insert);
}
return(CreateProcessStatus.AlreadyExists);
}
catch (Exception ex)
{ throw new Exception(GetMyMethodName(), ex); }
}
public async Task <CustomerLedgerView> GetCustomerLedgerByDocNumber(long?docNumber, string docType)
{
try
{
var query = await(from a in _dbContext.CustomerLedgers
where a.DocNumber == docNumber &&
a.DocType == docType
select a).FirstOrDefaultAsync <CustomerLedger>();
CustomerLedgerView view = applicationViewFactory.MapCustomerLedgerView(query);
return(view);
}
catch (Exception ex)
{ throw new Exception(GetMyMethodName(), ex); }
}