internal void SaveFilters(System.Windows.Forms.ListBox.ObjectCollection filters) { // Clear the existing filters then add the new ones ExecuteNonQuery("DELETE FROM insurance_company_groups_filters WHERE icg_id = " + id); foreach (string aFilter in filters) { insurance_company_groups_filters icg = new insurance_company_groups_filters(); icg.icg_id = id; icg.filter_text = aFilter; icg.Save(); } }
private List <insurance_company_groups_filters> GetLinkedCompanyFilters() { List <insurance_company_groups_filters> toReturn = new List <insurance_company_groups_filters>(); insurance_company_groups_filters icgf; claim c = new claim(); DataTable dt = c.Search("SELECT * FROM insurance_company_groups_filters WHERE icg_id = " + insurance_group_id); foreach (DataRow aMatch in dt.Rows) { icgf = new insurance_company_groups_filters(); icgf.Load(aMatch); toReturn.Add(icgf); } return(toReturn); }