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