private LedgerTxnData MapLedgerTxnToLedgerTxnData(LedgerTxn ledger_txn)
{
LedgerTxnData ledger_txn_data = new LedgerTxnData()
{
};
return(ledger_txn_data);
}
public bool LedgerTxnDelete(LedgerTxn ledger_txn)
{
return(ExecuteFaultHandledOperation(() =>
{
ILedgerTxnRepository ledger_txn_repo = _data_repository_factory.GetDataRepository <ILedgerTxnRepository>();
LedgerTxnData ledger_txn_data = MapLedgerTxnToLedgerTxnData(ledger_txn);
ledger_txn_repo.Delete(ledger_txn_data);
return true;
}));
}
//public List<LedgerTxn> GetLedgerTxnsByCompany(Company company)
//{
// if (company == null)
// throw new ArgumentNullException(nameof(company));
// return ExecuteFaultHandledOperation(() =>
// {
// ILedgerTxnRepository ledger_txn_repo = _data_repository_factory.GetDataRepository<ILedgerTxnRepository>();
// // _business_engine_factory
// List<LedgerTxn> ledger_txns = new List<LedgerTxn>();
// CompanyData comp = new CompanyData();
// comp.CompanyKey = company.CompanyKey;
// IEnumerable<LedgerTxnData> ledger_txns_data = ledger_txn_repo.GetAll(comp);
// foreach (LedgerTxnData ledger_txn_data in ledger_txns_data)
// {
// LedgerTxn ledger_txn = MapLedgerTxnDataToLedgerTxn(ledger_txn_data);
// ledger_txns.Add(ledger_txn);
// }
// return ledger_txns;
// });
//}
private LedgerTxn MapLedgerTxnDataToLedgerTxn(LedgerTxnData ledger_txn_data)
{
LedgerTxn ledger_txn = new LedgerTxn()
{
AddedUserID = ledger_txn_data.AuditAddUserId,
AddedDateTime = ledger_txn_data.AuditAddDatetime,
UpdateUserID = ledger_txn_data.AuditUpdateUserId,
UpdateDateTime = ledger_txn_data.AuditUpdateDatetime
};
return(ledger_txn);
}
public void SetLedgerTxn(LedgerTxnData txnData)
{
if (txnData == null)
{
throw new ArgumentNullException(nameof(txnData));
}
var existingTx = LedgerTxns.FirstOrDefault(a => a.LedgerTxnNum == txnData.LedgerTxnNum);
if (existingTx != null)
{
LedgerTxns.Remove(existingTx);
}
LedgerTxns.Add(new LedgerTxn(txnData));
}
public LedgerTxn(LedgerTxnData ledgerTxnData)
{
if (ledgerTxnData == null)
{
throw new ArgumentNullException(nameof(ledgerTxnData));
}
LedgerTxnId = ledgerTxnData.LedgerTxnId;
LedgerId = ledgerTxnData.LedgerId;
Comment = ledgerTxnData.Comment;
AccountFrom = ledgerTxnData.AccountFrom;
AccountTo = ledgerTxnData.AccountTo;
EntryDate = ledgerTxnData.EntryDate;
PostDate = ledgerTxnData.PostDate;
Credit = ledgerTxnData.Credit;
Debit = ledgerTxnData.Debit;
LedgerTxnNum = ledgerTxnData.LedgerTxnNum;
}
public int LedgerTxnSave(LedgerTxn ledger_txn)
{
if (ledger_txn == null)
{
throw new ArgumentNullException(nameof(ledger_txn));
}
return(ExecuteFaultHandledOperation(() =>
{
ILedgerTxnRepository ledger_txn_repo = _data_repository_factory.GetDataRepository <ILedgerTxnRepository>();
int ledger_txn_key;
LedgerTxnData prod_data = MapLedgerTxnToLedgerTxnData(ledger_txn);
ledger_txn_key = ledger_txn_repo.Insert(prod_data);
return ledger_txn_key;
}));
}
public LedgerTxn GetLedgerTxnByID(int ledger_txn_key)
{
Log.Info("Accessing LedgerTxnBusinessEngine GetLedgerTxnByID function");
return(ExecuteFaultHandledOperation(() =>
{
ILedgerTxnRepository ledger_txn_repo = _data_repository_factory.GetDataRepository <ILedgerTxnRepository>();
LedgerTxnData ledger_txn_data = ledger_txn_repo.GetByID(ledger_txn_key);
Log.Info("LedgerTxnBusinessEngine GetByID function completed");
if (ledger_txn_data.LedgerTxnKey != 0)
{
LedgerTxn ledger_txn = MapLedgerTxnDataToLedgerTxn(ledger_txn_data);
return ledger_txn;
}
else
{
NotFoundException ex = new NotFoundException(string.Format("LedgerTxn with key {0} is not in database", ledger_txn_key));
throw new FaultException <NotFoundException>(ex, ex.Message);
}
}));
}
} // Map function closer
public List <SqlParameter> MapParamsForUpsert(LedgerTxnData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@ledger_txn_key", entity.LedgerTxnKey));
sql_params.Add(new SqlParameter("@ledger_key", entity.LedgerKey));
sql_params.Add(new SqlParameter("@txn_comment", entity.TxnComment));
sql_params.Add(new SqlParameter("@acct_from", entity.AcctFrom));
sql_params.Add(new SqlParameter("@dept_from", entity.DeptFrom));
sql_params.Add(new SqlParameter("@lob_from", entity.LobFrom));
sql_params.Add(new SqlParameter("@acct_to", entity.AcctTo));
sql_params.Add(new SqlParameter("@dept_to", entity.DeptTo));
sql_params.Add(new SqlParameter("@lob_to", entity.LobTo));
sql_params.Add(new SqlParameter("@txn_num", entity.TxnNum));
sql_params.Add(new SqlParameter("@post_date", entity.PostDate));
sql_params.Add(new SqlParameter("@entry_date", entity.EntryDate));
sql_params.Add(new SqlParameter("@credit", entity.Credit));
sql_params.Add(new SqlParameter("@debit", entity.Debit));
sql_params.Add(new SqlParameter("@entity_key", entity.EntityKey));
sql_params.Add(new SqlParameter("@entity_type_key", entity.EntityTypeKey));
sql_params.Add(GetOutParam());
return(sql_params);
}
public List <SqlParameter> MapParamsForDelete(LedgerTxnData entity)
{
return(MapParamsForDelete(entity.LedgerTxnKey));
}
