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