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