private void butExport_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
SaveFileDialog Dlg = new SaveFileDialog();
if (Directory.Exists(PrefB.GetString("ExportPath")))
{
Dlg.InitialDirectory = PrefB.GetString("ExportPath");
}
else if (Directory.Exists("C:\\"))
{
Dlg.InitialDirectory = "C:\\";
}
Dlg.FileName = "Fees" + DefB.GetName(DefCat.FeeSchedNames, SchedNum) + ".txt";
if (Dlg.ShowDialog() != DialogResult.OK)
{
Cursor = Cursors.Default;
return;
}
//MessageBox.Show(Dlg.FileName);//includes full path
//OverwritePrompt is already set to true
DataTable table = ProcedureCodes.GetProcTable("", "", "", new int[0], SchedNum, 0, 0);
double fee;
using (StreamWriter sr = File.CreateText(Dlg.FileName)){
for (int i = 0; i < table.Rows.Count; i++)
{
sr.Write(PIn.PString(table.Rows[i]["ADACode"].ToString()) + "\t");
fee = PIn.PDouble(table.Rows[i]["FeeAmt1"].ToString());
if (fee != -1)
{
sr.Write(fee.ToString("n"));
}
sr.Write("\t");
sr.Write(PIn.PString(table.Rows[i]["AbbrDesc"].ToString()) + "\t");
sr.WriteLine(PIn.PString(table.Rows[i]["Descript"].ToString()));
}
}
Cursor = Cursors.Default;
DialogResult = DialogResult.OK;
}
private void FillGrid()
{
if (listFeeSched.Items.Count == 0)
{
gridMain.BeginUpdate();
gridMain.Rows.Clear();
gridMain.EndUpdate();
MsgBox.Show(this, "You must have at least one fee schedule created.");
return;
}
string selected = "";
if (gridMain.GetSelectedIndex() != -1)
{
selected = ProcTable.Rows[gridMain.GetSelectedIndex()][3].ToString();
}
int scroll = gridMain.ScrollValue;
int[] cats = new int[listCategories.SelectedIndices.Count];
for (int i = 0; i < listCategories.SelectedIndices.Count; i++)
{
cats[i] = CatList[listCategories.SelectedIndices[i]].DefNum;
}
int feeSched = DefB.Short[(int)DefCat.FeeSchedNames][listFeeSched.SelectedIndex].DefNum;
int feeSchedComp1 = 0;
if (comboCompare1.SelectedIndex != 0)
{
feeSchedComp1 = DefB.Short[(int)DefCat.FeeSchedNames][comboCompare1.SelectedIndex - 1].DefNum;
}
int feeSchedComp2 = 0;
if (comboCompare2.SelectedIndex != 0)
{
feeSchedComp2 = DefB.Short[(int)DefCat.FeeSchedNames][comboCompare2.SelectedIndex - 1].DefNum;
}
ProcTable = ProcedureCodes.GetProcTable(textAbbreviation.Text, textDescription.Text, textCode.Text, cats, feeSched,
feeSchedComp1, feeSchedComp2);
gridMain.BeginUpdate();
gridMain.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableProcedures", "Category"), 90);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableProcedures", "Description"), 150);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableProcedures", "Abbr"), 90);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableProcedures", "Code"), 50);
gridMain.Columns.Add(col);
string heading = DefB.Short[(int)DefCat.FeeSchedNames][listFeeSched.SelectedIndex].ItemName;
if (heading.Length > 8)
{
heading = heading.Substring(0, 8);
}
col = new ODGridColumn(heading, 50, HorizontalAlignment.Right);
gridMain.Columns.Add(col);
heading = "";
if (comboCompare1.SelectedIndex != 0)
{
heading = DefB.Short[(int)DefCat.FeeSchedNames][comboCompare1.SelectedIndex - 1].ItemName;
}
if (heading.Length > 8)
{
heading = heading.Substring(0, 8);
}
col = new ODGridColumn(heading, 50, HorizontalAlignment.Right);
gridMain.Columns.Add(col);
heading = "";
if (comboCompare2.SelectedIndex != 0)
{
heading = DefB.Short[(int)DefCat.FeeSchedNames][comboCompare2.SelectedIndex - 1].ItemName;
}
if (heading.Length > 8)
{
heading = heading.Substring(0, 8);
}
col = new ODGridColumn(heading, 50, HorizontalAlignment.Right);
gridMain.Columns.Add(col);
gridMain.Rows.Clear();
ODGridRow row;
for (int i = 0; i < ProcTable.Rows.Count; i++)
{
row = new ODGridRow();
if (i == 0 || ProcTable.Rows[i - 1]["ProcCat"].ToString() != ProcTable.Rows[i]["ProcCat"].ToString())
{
row.Cells.Add(DefB.GetName(DefCat.ProcCodeCats, PIn.PInt(ProcTable.Rows[i]["ProcCat"].ToString())));
}
else
{
row.Cells.Add("");
}
row.Cells.Add(ProcTable.Rows[i]["Descript"].ToString());
row.Cells.Add(ProcTable.Rows[i]["AbbrDesc"].ToString());
row.Cells.Add(ProcTable.Rows[i]["ADACode"].ToString());
if (ProcTable.Rows[i]["FeeAmt1"].ToString() == "-1")
{
row.Cells.Add("");
}
else
{
row.Cells.Add(PIn.PDouble(ProcTable.Rows[i]["FeeAmt1"].ToString()).ToString("n"));
}
if (ProcTable.Rows[i]["FeeAmt2"].ToString() == "-1")
{
row.Cells.Add("");
}
else
{
row.Cells.Add(PIn.PDouble(ProcTable.Rows[i]["FeeAmt2"].ToString()).ToString("n"));
}
if (ProcTable.Rows[i]["FeeAmt3"].ToString() == "-1")
{
row.Cells.Add("");
}
else
{
row.Cells.Add(PIn.PDouble(ProcTable.Rows[i]["FeeAmt3"].ToString()).ToString("n"));
}
gridMain.Rows.Add(row);
}
gridMain.EndUpdate();
gridMain.ScrollValue = scroll;
if (selected != "") //if a row was previously selected
{
for (int i = 0; i < ProcTable.Rows.Count; i++)
{
if (ProcTable.Rows[i][3].ToString() == selected)
{
gridMain.SetSelected(i, true);
break;
}
}
}
}
