public TeethModifier(Teeth teeth, String iPatient_id)
{
InitializeComponent();
modified = false;
teeths = new PictureBox[] { teeth1, teeth2, teeth3, teeth4, teeth5, teeth6, teeth7, teeth8, teeth9, teeth0 };
for (int a = 0; a < teeths.Length; a++)
{
teeths[a].Click += new EventHandler(teethClick);
}
controls = new Control[] { lblToothNumber, lblPart, lblLabel, lblArea };
taskControls = new Control[] { cmbTask, txtCost, txtNotes };
teeth.copyTo(patientTeeth);
lblToothNumber.Text = teeth.Number;
patient_id = iPatient_id;
id = DatabaseHandler.getInstance().getIntData(String.Format(Queries.select_teeth_info_id_based_patient_id_and_number, iPatient_id, teeth.Number));
teethTaskInfoList.fill(DatabaseHandler.getInstance().getTable(String.Format(Queries.select_teeth_task_info_based_teeth_id, id)));
List <DataRow> rows = DatabaseHandler.getInstance().getListRow(Queries.select_task_info);
if (!Utils.isObjectNull(rows))
{
for (int a = 0; a < rows.Count; a++)
{
cmbTask.Items.Add(rows[a]["code"].ToString() + ":" + rows[a]["name"].ToString());
}
}
teethTaskInfoList.setEditorHandler(new EventHandler(editor_lostFocus));
teethTaskInfoList.setSelectedIndexChanged(new EventHandler(list_SelectedIndexChanged));
teethTaskInfoList.setViewItemDeleted(new EventHandler(list_itemDeleted));
lblLabel.Text = teeth.IsPermanent == true ? "PERMANENT" : "TEMPORARY";
}
private void button3_Click(object sender, EventArgs e)
{
if (!Utils.isEmpty(cmbTask.Text))
{
string code = cmbTask.Text.Split(':')[0];
//MessageBox.Show(String.Format(Queries.select_teeth_task_info_task_code_and_teeth_id, code, patientTeeth.ID));
DataTable table = DatabaseHandler.getInstance().getTable(String.Format(Queries.select_teeth_task_info_based_task_code_and_teeth_id, code, patientTeeth.ID));
if (Utils.isObjectNull(table))
{
if (!DatabaseHandler.getInstance().modifyTable(String.Format(Queries.insert_teeth_task_info, id, code, txtCost.Text, txtNotes.Text)))
{
}
else
{
/////////will fix later to add latest value directly to table
teethTaskInfoList.fill(DatabaseHandler.getInstance().getTable(String.Format(Queries.select_teeth_task_info_based_teeth_id, id)));
}
}
else
{
MessageBox.Show("This teeth already has diagnosis code " + code);
}
}
else
{
MessageBox.Show("Choose a task first");
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
if (!Utils.isObjectNull(clickHandler))
{
clickHandler(this, e);
}
}
private void lblNumber_Click(object sender, EventArgs e)
{
if (!Utils.isObjectNull(clickHandler))
{
clickHandler(this, e);
}
}
public String getStringData(String query)
{
Object obj = getSingleData(query);
if (!Utils.isObjectNull(obj))
{
return(Convert.ToString(getSingleData(query)));
}
return("");
}
public double getDoubleData(String query)
{
Object obj = getSingleData(query);
if (!Utils.isObjectNull(obj))
{
return(Convert.ToDouble(obj));
}
return(0.0);
}
public Object getData(String query, String column)
{
DataRow row = getRow(query);
if (!Utils.isObjectNull(row))
{
return(row[column]);
}
return(null);
}
public Object getSingleData(String query)
{
DataRow row = getRow(query);
if (!Utils.isObjectNull(row))
{
return(row[0]);
}
return(null);
}
public bool getBoolData(String query)
{
Object obj = getSingleData(query);
if (!Utils.isObjectNull(obj))
{
return(Convert.ToBoolean(getSingleData(query)));
}
return(false);
}
public DataRow getRow(String query)
{
DataTable table = getTable(query);
if (!Utils.isObjectNull(table))
{
return(table.Rows[0]);
}
return(null);
}
public int getIntData(String query)
{
Object obj = getSingleData(query);
if (!Utils.isObjectNull(obj))
{
return(Convert.ToInt32(getSingleData(query)));
}
return(0);
}
void records_itemDeleted(object sender, EventArgs e)
{
int id = patientInfoList.getDeletedId();
if (!deleteRecord(Queries.delete_patient_info_based_id, id))
{
MessageBox.Show("Couldnt delete patient....");
}
List <String> teeth_ids = DatabaseHandler.getInstance().getListStringSingleData(String.Format(Queries.select_teeth_info_id_based_patient_id, id));
if (!Utils.isObjectNull(teeth_ids))
{
for (int a = 0; a < teeth_ids.Count; a++)
{
String teeth_id = teeth_ids[a];
if (!deleteRecord(Queries.delete_teeth_task_info_based_teeth_id, Utils.toInt(teeth_id)))
{
// MessageBox.Show("couldnt delete teeth tasks");
}
else
{
// MessageBox.Show(String.Format(Queries.delete_teeth_task_info_based_teeth_id, Utils.toInt(teeth_id)));
}
if (!deleteRecord(Queries.delete_teeth_diagram_info_based_teeth_id, Utils.toInt(teeth_id)))
{
// MessageBox.Show("couldnt delete teeth diagram");
}
}
}
else
{
//MessageBox.Show("null");
}
List <String> teeth_task_info_teeth_ids = DatabaseHandler.getInstance().getListStringSingleData(String.Format(Queries.select_teeth_task_info_teeth_id));
for (int a = 0; a < teeth_task_info_teeth_ids.Count; a++)
{
}
if (!deleteRecord(Queries.delete_teeth_info_based_patient_id, id))
{
// MessageBox.Show("couldnt delete teeths");
}
if (!deleteRecord(Queries.delete_question_info_based_patient_id, id))
{
//5 MessageBox.Show("couldnt delete question infos");
}
if (!deleteRecord(Queries.delete_history_info_based_patient_id, id))
{
// MessageBox.Show("couldnt delete history infos");
}
}
public void fill(DataTable table)
{
if (Utils.isObjectNull(table))
{
return;
}
view.Clear();
for (int column = 0; column < table.Columns.Count; column++)
{
view.Columns.Add(table.Columns[column].ToString(), 200, HorizontalAlignment.Left);
}
fillRow(table);
}
public void editor_lostFocus(object sender, EventArgs e)
{
ListViewItem item = view.Items[rowCol.Y];
item.SubItems[rowCol.X].Text = editor.Text;
view.Controls.Remove(editor);
editedCell.columnName = view.Columns[rowCol.X].Text;
editedCell.newVal = editor.Text;
editedCell.id = item.SubItems[0].Text;
if (!Utils.isObjectNull(editorEventHandlerLostFocus))
{
editorEventHandlerLostFocus(sender, e);
}
}
public List <String> getListStringSingleData(String query)
{
List <String> data = new List <String>();
List <DataRow> row = getListRow(query);
if (!Utils.isObjectNull(row))
{
for (int a = 0; a < row.Count; a++)
{
data.Add(row[a][0].ToString());
}
}
return(data);
}
public List <DataRow> getListRow(String query)
{
DataTable table = getTable(query);
if (!Utils.isObjectNull(table))
{
List <DataRow> list = new List <DataRow>();
for (int a = 0; a < table.Rows.Count; a++)
{
list.Add(table.Rows[a]);
}
return(list);
}
return(null);
}
public Diagram(String patient_id)
{
InitializeComponent();
teeths = new Teeth[] { teeth1, teeth2, teeth3, teeth4, teeth5, teeth6, teeth7, teeth8, teeth9, teeth10, teeth11, teeth12, teeth13, teeth14, teeth15, teeth16, teeth17, teeth18, teeth19, teeth20, teeth21, teeth22, teeth23, teeth24, teeth25, teeth26, teeth27, teeth28, teeth29, teeth30, teeth31, teeth32, teeth33, teeth34, teeth35, teeth36, teeth37, teeth38, teeth39, teeth40, teeth41, teeth42, teeth43, teeth44, teeth45, teeth46, teeth47, teeth48, teeth49, teeth50, teeth51, teeth52, teeth53, teeth54, teeth55, teeth56 };
List <DataRow> teeth_infos = DatabaseHandler.getInstance().getListRow(String.Format(Queries.select_teeth_info_based_patient_id, patient_id));
/////////////////unoptimized
if (!Utils.isObjectNull(teeth_infos))
{
for (int a = 0; a < teeth_infos.Count; a++)
{
for (int b = 0; b < teeths.Length; b++)
{
if (teeth_infos[a]["number"].ToString() == teeths[b].Number)
{
teeths[b].ID = (int)teeth_infos[a]["id"];
teeths[b].IsPermanent = (bool)teeth_infos[a]["is_permanent"];
teeths[b].Part = teeth_infos[a]["part"].ToString();
teeths[b].Area = teeth_infos[a]["area"].ToString();
List <DataRow> teeth_diagram_infos = DatabaseHandler.getInstance().getListRow(String.Format(Queries.select_teeth_diagram_info_path_based_teeth_id_and_is_activated, teeths[b].ID));
if (!Utils.isObjectNull(teeth_diagram_infos))
{
for (int d = 0; d < teeth_diagram_infos.Count; d++)
{
String path = teeth_diagram_infos[d]["color"].ToString();
path = "Assets\\" + path + "\\" + path + teeth_diagram_infos[d]["diagram"].ToString() + ".png";
teeths[b].Images.Add(Utils.loadImageFromFileRelativeToCWD(path));
teeths[b].Colors.Add(Utils.strToColor(path));
teeths[b].Indexes.Add(Utils.toInt(teeth_diagram_infos[d]["diagram"].ToString()) - 1);
}
teeths[b].Refresh();
}
break;
}
}
}
}
for (int a = 0; a < teeths.Length; a++)
{
teeths[a].setClickHandler(clickHandler);
}
patientID = patient_id;
}
private void records_SelectedIndexChanged(object sender, EventArgs e)
{
ListView records = (ListView)sender;
if (records.SelectedItems.Count > 0)
{
button1.Enabled = true;
diseaseList.Items.Clear();
ListViewItem item = records.SelectedItems[0];
for (int a = 1; a < item.SubItems.Count; a++)
{
controls[a - 1].Text = item.SubItems[a].Text;
}
DataTable question = DatabaseHandler.getInstance().getTable(String.Format(Queries.select_question_info_answer_based_patient_id, item.SubItems[0].Text));
if (!Utils.isObjectNull(question))
{
for (int a = 0; a < 6; a++)
{
questions[a].Answer = (bool)question.Rows[a][0];
}
}
DataTable history = DatabaseHandler.getInstance().getTable(String.Format(Queries.select_history_info_disease_based_id, item.SubItems[0].Text));
if (!Utils.isObjectNull(history))
{
for (int a = 0; a < history.Rows.Count; a++)
{
for (int b = 0; b < diseases.Length; b++)
{
diseases[b].Check = false;
if (diseases[b].Type == history.Rows[a][0].ToString())
{
diseases[b].Check = true;
break;
}
}
}
}
}
else
{
button1.Enabled = false;
}
}
public void fillRow(DataTable table)
{
if (Utils.isObjectNull(table))
{
return;
}
view.Items.Clear();
for (int row = 0; row < table.Rows.Count; row++)
{
DataRow currRow = table.Rows[row];
ListViewItem item = new ListViewItem(currRow[0].ToString());
for (int column = 1; column < table.Columns.Count; column++)
{
item.SubItems.Add(currRow[column].ToString());
}
view.Items.Add(item);
}
}
public Graph()
{
InitializeComponent();
bargraph2.ChartAreas[0].AxisY.Maximum = 100;
bargraph1.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
bargraph2.ChartAreas[0].AxisX.LabelStyle.Interval = 1;
List <String> tasks = DatabaseHandler.getInstance().getListStringSingleData(Queries.select_task_info_code);
DataTable teeth_task_info = DatabaseHandler.getInstance().getTable(Queries.select_teeth_task_info);
if (!Utils.isObjectNull(teeth_task_info))
{
for (int a = 0; a < tasks.Count; a++)
{
string task = tasks[a];
bargraph1.Series[0].Points.AddXY(task, DatabaseHandler.getInstance().getDoubleData(String.Format(Queries.select_total_teeth_task_info_based_task_code, task)));
bargraph2.Series[0].Points.AddXY(task, DatabaseHandler.getInstance().getDoubleData(String.Format(Queries.select_percentage_teeth_task_info_based_task_code, task)));
}
}
}
void reScan()
{
analysis.TabPages.Clear();
List <DataRow> rows = DatabaseHandler.getInstance().getListRow(Queries.select_teeth_task_info_task_code_and_teeth_id);
DataTable table = new DataTable();
table.Columns.Add("PATIENT ID");
table.Columns.Add("ITEM");
if (!Utils.isObjectNull(rows))
{
for (int a = 0; a < rows.Count; a++)
{
DataRow row = rows[a];
bool found = false;
String id = DatabaseHandler.getInstance().getStringData(String.Format(Queries.select_teeth_info_patient_id_based_id, row["teeth_id"]));
for (int b = 0; b < table.Rows.Count; b++)
{
DataRow currRow = table.Rows[b];
if (currRow[0].ToString() == id)
{
currRow[1] = currRow[1] + "," + row["task_code"].ToString();
found = true;
break;
}
}
if (!found)
{
table.Rows.Add(id, row["task_code"].ToString());
}
}
}
Set <String> rootSet = new Set <String>();
for (int a = 0; a < table.Rows.Count; a++)
{
Item <String> newItem = new Item <String>();
String[] items = table.Rows[a]["ITEM"].ToString().Split(',');
for (int b = 0; b < items.Length; b++)
{
newItem.add(new Data <String>(items[b]));
}
rootSet.add(newItem);
}
Utils.fillRowListView(ref root, table);
AprioriAlgorithm <String> aa = AprioriAlgorithm <String> .createInstance(rootSet, Utils.toInt(cmbSupport.Items[cmbSupport.SelectedIndex].ToString()));
Set <String> next = new Set <String>();
int scanCount = 1;
while (next != null)
{
if ((next = aa.nextScan()) != null)
{
TabPage newPage = new TabPage("Scan " + scanCount);
analysis.TabPages.Add(newPage);
ScanResultView resultView = new ScanResultView();
ListView halfResultView = resultView.View1;
Utils.fillListView(ref halfResultView, mapScanResultToTable(next));
if ((next = aa.finalizeCurrentScan()) != null)
{
ListView finalResultView = resultView.View2;
Utils.fillListView(ref finalResultView, mapScanResultToTable(next));
scanCount++;
}
resultView.Size = newPage.Size;
newPage.Controls.Add(resultView);
}
}
}
