private LedgerData MapLedgerToLedgerData(Ledger ledger)
{
LedgerData ledger_data = new LedgerData()
{
};
return(ledger_data);
}
public bool LedgerDelete(Ledger ledger)
{
return(ExecuteFaultHandledOperation(() =>
{
ILedgerRepository ledger_repo = _data_repository_factory.GetDataRepository <ILedgerRepository>();
LedgerData ledger_data = MapLedgerToLedgerData(ledger);
ledger_repo.Delete(ledger_data);
return true;
}));
}
private Ledger MapLedgerDataToLedger(LedgerData ledger_data)
{
Ledger ledger = new Ledger()
{
AddedUserID = ledger_data.AuditAddUserId,
AddedDateTime = ledger_data.AuditAddDatetime,
UpdateUserID = ledger_data.AuditUpdateUserId,
UpdateDateTime = ledger_data.AuditUpdateDatetime
};
return(ledger);
}
} // Map function closer
public List <SqlParameter> MapParamsForUpsert(LedgerData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@ledger_key", entity.LedgerKey));
sql_params.Add(new SqlParameter("@company_key", entity.CompanyKey));
sql_params.Add(new SqlParameter("@ledger_code", entity.LedgerCode));
sql_params.Add(new SqlParameter("@ledger_name", entity.LedgerName));
sql_params.Add(new SqlParameter("@ledger_desc", entity.LedgerDesc));
sql_params.Add(GetOutParam());
return(sql_params);
}
public IEnumerable <LedgerTxnData> GetAll(LedgerData gl_data)
{
Log.Info("Accessing LedgerTxnRepo GetAll function");
var pcol = new List <SqlParameter>()
{
Mapper.BuildParam("@ledger_key", gl_data.LedgerKey)
};
using (entity_context)
{
return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_ledger_txn_all")));
}
}
public void SetLedger(LedgerData ledgerData)
{
if (ledgerData == null)
{
throw new ArgumentNullException(nameof(ledgerData));
}
var existingLedger = Ledgers.FirstOrDefault(a => a.LedgeCode == ledgerData.LedgeCode);
if (existingLedger != null)
{
Ledgers.Remove(existingLedger);
}
Ledgers.Add(new Ledger(ledgerData));
}
public int LedgerSave(Ledger ledger)
{
if (ledger == null)
{
throw new ArgumentNullException(nameof(ledger));
}
return(ExecuteFaultHandledOperation(() =>
{
ILedgerRepository ledger_repo = _data_repository_factory.GetDataRepository <ILedgerRepository>();
int ledger_key;
LedgerData prod_data = MapLedgerToLedgerData(ledger);
ledger_key = ledger_repo.Insert(prod_data);
return ledger_key;
}));
}
public Ledger(LedgerData ledgerData)
{
if (ledgerData == null)
{
throw new ArgumentNullException(nameof(ledgerData));
}
LedgerId = ledgerData.LedgerId;
CompanyId = ledgerData.CompanyId;
LedgeCode = ledgerData.LedgeCode;
LedgeName = ledgerData.LedgeName;
LedgeDesc = ledgerData.LedgeDesc;
if (ledgerData.LedgerTxns != null)
{
foreach (var txn in ledgerData.LedgerTxns)
{
SetLedgerTxn(txn);
}
}
}
public Ledger GetLedgerByID(int ledger_key)
{
Log.Info("Accessing LedgerBusinessEngine GetLedgerByID function");
return(ExecuteFaultHandledOperation(() =>
{
ILedgerRepository ledger_repo = _data_repository_factory.GetDataRepository <ILedgerRepository>();
LedgerData ledger_data = ledger_repo.GetByID(ledger_key);
Log.Info("LedgerBusinessEngine GetByID function completed");
if (ledger_data.LedgerKey != 0)
{
Ledger ledger = MapLedgerDataToLedger(ledger_data);
return ledger;
}
else
{
NotFoundException ex = new NotFoundException(string.Format("Ledger with key {0} is not in database", ledger_key));
throw new FaultException <NotFoundException>(ex, ex.Message);
}
}));
}
public List <SqlParameter> MapParamsForDelete(LedgerData entity)
{
return(MapParamsForDelete(entity.LedgerKey));
}
