private void FillGrid() { if (textDaysOldMin.Text.Trim() == "" || PIn.Double(textDaysOldMin.Text) == 0) { dateMin = DateTime.MinValue; } else { dateMin = DateTimeOD.Today.AddDays(-1 * PIn.Int(textDaysOldMin.Text)); } if (textDaysOldMax.Text.Trim() == "" || PIn.Double(textDaysOldMax.Text) == 0) { dateMax = DateTime.MinValue; } else { dateMax = DateTimeOD.Today.AddDays(-1 * PIn.Int(textDaysOldMax.Text)); } if (comboBoxMultiProv.SelectedIndices[0].ToString() == "0") { isAllProv = true; } else { isAllProv = false; provNumList = new List <long>(); for (int i = 0; i < comboBoxMultiProv.SelectedIndices.Count; i++) { provNumList.Add((long)ProviderC.ListShort[(int)comboBoxMultiProv.SelectedIndices[i] - 1].ProvNum); } } isPreauth = checkPreauth.Checked; Table = Claims.GetOutInsClaims(isAllProv, provNumList, dateMin, dateMax, isPreauth); gridMain.BeginUpdate(); gridMain.Columns.Clear(); ODGridColumn col; col = new ODGridColumn(Lan.g(this, "Carrier"), 180); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Phone"), 103); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Type"), 60); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Patient Name"), 140); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Date of Service"), 93); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Date Sent"), 70); gridMain.Columns.Add(col); col = new ODGridColumn(Lan.g(this, "Amount"), 85, HorizontalAlignment.Right); gridMain.Columns.Add(col); gridMain.Rows.Clear(); ODGridRow row; string type; total = 0; for (int i = 0; i < Table.Rows.Count; i++) { row = new ODGridRow(); row.Cells.Add(Table.Rows[i]["CarrierName"].ToString()); row.Cells.Add(Table.Rows[i]["Phone"].ToString()); type = Table.Rows[i]["ClaimType"].ToString(); switch (type) { case "P": type = "Primary"; break; case "S": type = "Secondary"; break; case "PreAuth": type = "Preauth"; break; case "Other": type = "Other"; break; case "Cap": type = "Capitation"; break; case "Med": type = "Medical"; //For possible future use. break; default: type = "Error"; //Not allowed to be blank. break; } row.Cells.Add(type); if (PrefC.GetBool(PrefName.ReportsShowPatNum)) { row.Cells.Add(Table.Rows[i]["PatNum"].ToString() + "-" + Table.Rows[i]["LName"].ToString() + ", " + Table.Rows[i]["FName"].ToString() + " " + Table.Rows[i]["MiddleI"].ToString()); } else { row.Cells.Add(Table.Rows[i]["LName"].ToString() + ", " + Table.Rows[i]["FName"].ToString() + " " + Table.Rows[i]["MiddleI"].ToString()); } DateTime dateService = PIn.Date(Table.Rows[i]["DateService"].ToString()); if (dateService.Year < 1880) { row.Cells.Add(""); } else { row.Cells.Add(dateService.ToShortDateString()); } row.Cells.Add(PIn.Date(Table.Rows[i]["DateSent"].ToString()).ToShortDateString()); row.Cells.Add(PIn.Double(Table.Rows[i]["ClaimFee"].ToString()).ToString("c")); gridMain.Rows.Add(row); total += PIn.Decimal(Table.Rows[i]["ClaimFee"].ToString()); } textBox1.Text = total.ToString("c"); gridMain.EndUpdate(); }