public Collection <ListItem> GetAccounts()
{
if (Switches.AllowParentAccountInGlTransaction())
{
if (SessionHelper.IsAdmin())
{
using (DataTable table = FormHelper.GetTable("core", "accounts"))
{
return(GetValues(table));
}
}
using (DataTable table = FormHelper.GetTable("core", "accounts", "confidential", "0"))
{
return(GetValues(table));
}
}
if (SessionHelper.IsAdmin())
{
using (DataTable table = FormHelper.GetTable("core", "account_view", "has_child", "0"))
{
return(GetValues(table));
}
}
using (DataTable table = FormHelper.GetTable("core", "account_view", "has_child, confidential", "0, 0"))
{
return(GetValues(table));
}
}
public Collection <ListItem> GetParties()
{
Collection <ListItem> values = new Collection <ListItem>();
using (DataTable table = FormHelper.GetTable("core", "parties"))
{
string displayField = ConfigurationHelper.GetDbParameter("PartyDisplayField");
table.Columns.Add("party", typeof(string), displayField);
foreach (DataRow dr in table.Rows)
{
values.Add(new ListItem(dr["party"].ToString(), dr["party_code"].ToString()));
}
}
return(values);
}
public Collection <ListItem> GetCashRepositories()
{
Collection <ListItem> values = new Collection <ListItem>();
using (DataTable table = FormHelper.GetTable("office", "cash_repositories"))
{
string displayField = ConfigurationHelper.GetDbParameter("CashRepositoryDisplayField");
table.Columns.Add("cash_repository", typeof(string), displayField);
foreach (DataRow dr in table.Rows)
{
values.Add(new ListItem(dr["cash_repository"].ToString(), dr["cash_repository_id"].ToString()));
}
}
return(values);
}
public Collection <ListItem> GetCashRepositories(string accountCode)
{
Collection <ListItem> values = new Collection <ListItem>();
if (Accounts.IsCashAccount(accountCode))
{
using (DataTable table = FormHelper.GetTable("office", "cash_repositories"))
{
foreach (DataRow dr in table.Rows)
{
values.Add(new ListItem(dr["cash_repository_name"].ToString(), dr["cash_repository_code"].ToString()));
}
}
}
return(values);
}
public Collection <ListItem> GetCashRepositoriesByAccountCode(string accountCode)
{
Collection <ListItem> values = new Collection <ListItem>();
if (Accounts.IsCashAccount(accountCode))
{
using (DataTable table = FormHelper.GetTable("office", "cost_centers"))
{
string displayField = ConfigurationHelper.GetDbParameter("CashRepositoryDisplayField");
table.Columns.Add("cash_repository", typeof(string), displayField);
foreach (DataRow dr in table.Rows)
{
values.Add(new ListItem(dr["cash_repository"].ToString(), dr["cash_repository_code"].ToString()));
}
}
}
return(values);
}
