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 cmbTask_SelectedIndexChanged(object sender, EventArgs e)
{
if (!Utils.isEmpty(cmbTask.Text))
{
String[] split = cmbTask.Text.Split(':');
double cost = DatabaseHandler.getInstance().getDoubleData(String.Format(Queries.select_task_info_cost_based_code_and_name, split[0], split[1]));
txtCost.Text = Convert.ToString(cost);
}
}
public static void limitedNumberInputOnly(object sender, int max)
{
if (!handled)
{
TextBox obj = (TextBox)sender;
if (Utils.hasExceeded(obj.Text, max) || !Utils.isValidNumber(Utils.getLastCharacter(obj.Text)))
{
handled = true;
if (!Utils.isEmpty(obj.Text))
{
obj.Text = obj.Text.Substring(0, obj.Text.Length - 1);
}
}
}
else
{
handled = false;
}
}