public List <DataIntegrityRule> GetStandardIntegrityRules()
{
List <DataIntegrityRule> standardIntegrityRules = new List <DataIntegrityRule>();
DataTable dt = dataConnection.SelectQuery("Select query to retrieve only the Standard Integrity Rules");
foreach (DataRow dr in dt.Rows)
{
standardIntegrityRules.Add(new DataIntegrityRule());
}
return(standardIntegrityRules);
}
/// <summary>
/// Gets all billing companies.
/// </summary>
/// <returns></returns>
public List <BillingCompany> GetAllBillingCompanies()
{
List <BillingCompany> billingCompanies = new List <BillingCompany>();
DataTable dt = dataConnection.SelectQuery("Select query to retrieve All Billing Companies");
foreach (DataRow dr in dt.Rows)
{
billingCompanies.Add(new BillingCompany((BillingCompanyId)dr["billingCompanyId"], (string)dr["companyName"]));
}
return(billingCompanies);
}
public List <APSUser> GetAllAPSUsers()
{
List <APSUser> APSUsers = new List <APSUser>();
DataTable dt = dataConnection.SelectQuery("Select query to retrieve all APS Users");
foreach (DataRow dr in dt.Rows)
{
APSUsers.Add(new APSUser((APSUserId)dr["apsUserId"], (string)dr["APSUsername"],
(string)dr["APSPassword"]));
}
return(APSUsers);
}
/// <summary>
/// Gets all billing accounts.
/// </summary>
/// <returns></returns>
public List <BillingAccount> GetAllBillingAccounts()
{
List <BillingAccount> billingAccounts = new List <BillingAccount>();
DataTable dt = dataConnection.SelectQuery("Select query to retrieve All Billing Accounts");
foreach (DataRow dr in dt.Rows)
{
billingAccounts.Add(new BillingAccount((BillingAccountId)dr["billingAccountId"],
(BillingCompanyId)dr["billingCompanyId"], (string)dr["billingAccountUsername"],
(string)dr["billingAccountPassword"], new APSUser(new APSUserId("1"), "username1", "password1")));
}
return(billingAccounts);
}
