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); }