public static List <provider_eligibility_restrictions> GetAllDataAsList()
{
List <provider_eligibility_restrictions> toReturn = new List <provider_eligibility_restrictions>();
provider_eligibility_restrictions per = new provider_eligibility_restrictions();
DataTable dt = per.GetAllData();
foreach (DataRow aRow in dt.Rows)
{
per = new provider_eligibility_restrictions();
per.Load(aRow);
toReturn.Add(per);
}
return(toReturn);
}
/// <summary>
/// Adds a restriction ID / group ID for a provider_eligibility_restriction
/// </summary>
/// <param name="restrictionID"></param>
/// <param name="groupID"></param>
/// <param name="checkExistBeforeInsert"></param>
internal static void AddGroup(int restrictionID, int groupID, bool checkExistBeforeInsert)
{
provider_eligibility_restrictions per = new provider_eligibility_restrictions();
if (checkExistBeforeInsert)
{
DataTable dt = per.Search(
string.Format("SELECT COUNT(*) FROM provider_eligibility_restriction_groups where insurance_group_id = {0} and provider_eligibility_restriction_id = {1}", groupID, restrictionID));
if ((int)dt.Rows[0][0] > 0)
{
return; // Already exists
}
}
per.ExecuteNonQuery(string.Format("INSERT INTO provider_eligibility_restriction_groups (provider_eligibility_restriction_id, insurance_group_id) VALUES ({0}, {1})",
restrictionID, groupID));
}
public static List <provider_eligibility_restrictions> GetAllDataAsList(bool enabledOnly = true)
{
List <provider_eligibility_restrictions> toReturn = new List <provider_eligibility_restrictions>();
provider_eligibility_restrictions per = new provider_eligibility_restrictions();
DataTable dt = per.GetAllData();
foreach (DataRow aRow in dt.Rows)
{
per = new provider_eligibility_restrictions();
per.Load(aRow);
if (per.is_enabled || !enabledOnly)
{
var initialize = per.LinkedInsuranceCompanyGroup.LinkedFilters.Count;
toReturn.Add(per);
}
}
return(toReturn);
}
