private void InitializeOverrideState()
{
// 2 provider boxes and insurance groups box
claim searchObject = new claim();
cmbOverrideStateProviderID.Items.Clear();
cmbOverrideStateProviderID.Items.Add("All");
cmbOverrideStateNewProviderID.Items.Clear();
claim.OverrideProviderList().ForEach(p =>
{
cmbOverrideStateProviderID.Items.Add(p.doctor_provider_id);
cmbOverrideStateNewProviderID.Items.Add(p.doctor_provider_id);
});
insurance_company_group icgs = new insurance_company_group();
DataTable allGroups = icgs.Search(icgs.SearchSQL + " ORDER BY name");
foreach (DataRow aRow in allGroups.Rows)
{
cmbOverrideStateInsurance.Items.Add(new insurance_company_group(aRow));
}
}
/// <summary>
/// Returns a list of all Insurance Company Groups and all Insurance Companies not in a group
/// </summary>
/// <returns></returns>
internal List <Claims_Primary.InsuranceCompanyGroups> GetInsuranceCompaniesAsGroup()
{
List <Claims_Primary.InsuranceCompanyGroups> allGroups = new List <Claims_Primary.InsuranceCompanyGroups>();
List <company> companiesInAGroup = new List <company>();
insurance_company_group icg = new insurance_company_group();
foreach (DataRow aRow in icg.GetAllData("name").Rows)
{
Claims_Primary.InsuranceCompanyGroups newGroup = new Claims_Primary.InsuranceCompanyGroups();
icg = new insurance_company_group(aRow);
List <company> matchingComps = icg.GetMatchingCompanies();
newGroup.Name = icg.name;
newGroup.Companies = matchingComps;
newGroup.Group = icg;
allGroups.Add(newGroup);
companiesInAGroup.AddRange(matchingComps);
}
DataTable companiesNotInGroup = icg.Search(string.Format("SELECT * FROM companies WHERE ID NOT IN ({0}) ORDER BY name", ClaimTrackerCommon.CompaniesToInString(companiesInAGroup)));
foreach (DataRow aRow in companiesNotInGroup.Rows)
{
company c = new company(aRow);
Claims_Primary.InsuranceCompanyGroups newGroup = new Claims_Primary.InsuranceCompanyGroups(c.name, c);
allGroups.Add(newGroup);
}
allGroups.Sort(SortInsuranceGroupsByName);
return(allGroups);
}
private string BuildBasicSQL()
{
string toReturn = "SELECT c.id AS CLAIMID, cmp.id AS COMPANYID, cmp.name AS NAME FROM claims c " +
"LEFT JOIN Companies cmp ON c.company_id = cmp.id " +
"LEFT JOIN users u ON c.owner_id = u.id WHERE c.[open] = 1 ";
// WHERE
if (cmbBasicCarrierGroup.SelectedIndex > 0) // 0 = ALL
{
string carrierSQL = "";
insurance_company_group icg = (insurance_company_group)cmbBasicCarrierGroup.SelectedItem;
foreach (insurance_company_groups_filters icgf in icg.Filters)
{
if (icgf.filter_text.StartsWith("NOT ", StringComparison.OrdinalIgnoreCase))
{
if (carrierSQL.Length > 0)
{
carrierSQL += " AND";
}
carrierSQL += string.Format(" cmp.name NOT LIKE '{0}'", icgf.filter_text.Substring(4));
}
else
{
if (carrierSQL.Length > 0)
{
carrierSQL += " OR";
}
carrierSQL += string.Format(" cmp.name LIKE '{0}'", icgf.filter_text);
}
}
carrierSQL = " AND (" + carrierSQL + ")";
toReturn += carrierSQL;
}
toReturn += BuildWherePatientName(txtBasicPatientName.Text, DataTypes.Text);
toReturn += BuildWhereSingle("c.subscriber_group_number", txtBasicGroupNumber.Text, DataTypes.Text);
toReturn += BuildWhereSingle("c.subscriber_group_name", txtBasicGroupName.Text, DataTypes.Text);
if (cmbBasicClinic.SelectedIndex > 0) // 0 = all clinics
{
toReturn += " AND c.clinic_id = " + ((clinic)cmbBasicClinic.SelectedItem).id;
}
toReturn += " ORDER BY cmp.name, c.subscriber_group_name, c.patient_last_name, c.patient_first_name";
return(toReturn);
}
private void InitializeCarrierGroups()
{
insurance_company_group icg = new insurance_company_group();
DataTable dt = icg.Search(icg.SearchSQL + " ORDER BY name");
cmbBasicCarrierGroup.Items.Clear();
cmbBasicCarrierGroup.Items.Add("");
foreach (DataRow aGroup in dt.Rows)
{
icg = new insurance_company_group();
icg.Load(aGroup);
cmbBasicCarrierGroup.Items.Add(icg);
}
}
private void thisRecordChanged(object sender, RecordChangedEventArgs e)
{
_linkedInsuranceCompanyGroup = null;
}
