/// <summary> /// Returns a list of all companies sorted by name /// </summary> /// <returns></returns> internal static List <company> GetSortedList() { List <company> toReturn = new List <company>(); company workingCompany = new company(); DataTable allData = workingCompany.GetAllData("name"); foreach (DataRow aRow in allData.Rows) { workingCompany = new company(); workingCompany.Load(aRow); toReturn.Add(workingCompany); } return(toReturn); }
private void InitializeInsuranceDropdown() { clbInsuranceCompanies.Items.Add("All"); company c = new company(); foreach (DataRow aRow in c.GetAllData("name").Rows) { c = new company(); c.Load(aRow); clbInsuranceCompanies.Items.Add(c); } DataTable matches = c.Search("SELECT * FROM question_insurance_companies WHERE question_id = " + _formQuestion.id); if (matches.Rows.Count > 0) { foreach (DataRow aMatch in matches.Rows) { for (int i = 1; i < clbInsuranceCompanies.Items.Count; i++) { if (((company)clbInsuranceCompanies.Items[i]).id == (int)aMatch["insurance_id"]) { clbInsuranceCompanies.SetItemChecked(i, true); break; } } } } else { clbInsuranceCompanies.SetItemChecked(0, true); } }