public static CashRepository GetCashRepository(int? cashRepositoryId)
{
CashRepository cashRepository = new CashRepository();
if (cashRepositoryId != null && cashRepositoryId != 0)
{
const string sql = "SELECT * FROM office.cash_repositories WHERE cash_repository_id=@CashRepositoryId;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@CashRepositoryId", cashRepositoryId);
using (DataTable table = DbOperations.GetDataTable(command))
{
if (table != null)
{
if (table.Rows.Count.Equals(1))
{
cashRepository = GetCashRepository(table.Rows[0]);
}
}
}
}
}
return cashRepository;
}
private static CashRepository GetCashRepository(DataRow row)
{
CashRepository cashRepository = new CashRepository();
cashRepository.CashRepositoryId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "cash_repository_id"));
cashRepository.OfficeId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "office_id"));
cashRepository.Office = Offices.GetOffice(cashRepository.OfficeId);
cashRepository.CashRepositoryCode = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "cash_repository_code"));
cashRepository.CashRepositoryName = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "cash_repository_name"));
cashRepository.ParentCashRepositoryId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "parent_cash_repository_id"));
cashRepository.ParentCashRepository = GetCashRepository(cashRepository.ParentCashRepositoryId);
cashRepository.Description = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "description"));
return cashRepository;
}
