DataTable QueryVisits()
{
var visitService = new VisitService();
var data = visitService.getVisitsTable(patient.id,dictIndexId);
int nVisits = data.Rows.Count;
float paid = 0, costs = 0;
for (int i = 0; i < nVisits; i++)
{
paid += float.Parse(data.Rows[i]["Paid"].ToString());
costs += float.Parse(data.Rows[i]["Cost"].ToString());
}
float remaining = costs - paid;
CostSum_txt.Text = costs.ToString();
PaidSum_txt.Text = paid.ToString();
RemainingSum_txt.Text = remaining.ToString();
return data;
}
private void saveVisitBtn_Click(object sender, EventArgs e)
{
VisitService visitService = new VisitService();
visitService.addVisit(createVisitFromForm(), patient_id);
owner.fillGridView();
this.Close();
}
private void save_edits_btn_Click_1(object sender, EventArgs e)
{
VisitService visitService = new VisitService();
visitService.update(visit_id, createVisitFromForm());
owner.fillGridView();
this.Close();
}
void fillFormFromVisit()
{
VisitService visitService = new VisitService();
Visit visit = visitService.getVisitById(visit_id);
complaint_textBox.Text = visit.complaint;
diagnosis_textBox.Text = visit.diagnosis;
tooth_textBox.Text = visit.tooth;
treatmet_textBox.Text = visit.treatment;
cost_num.Value = (int)visit.cost;
paid_num.Value = (int)visit.paid;
oldXrayName = visit.xray;
}
