private void PopulateFields()
{
DataTable dt = prescription.GetPrescription(prescriptionId);
DataRow row = dt.Rows[0];
labelPrescriptionId.Text = row["Prescription Id"].ToString();
labelDoctorName.Text = row["Doctor"].ToString();
labelPatientName.Text = row["Patient"].ToString();
labelDosage.Text = row["Dosage"].ToString();
if (dt.Rows != null && dt.Rows.Count != 0)
{
DataTable drugDt = drug.GetDrugsFromPrescriptionID(prescriptionId);
dgvAllDrugs.DataSource = drugDt;
}
}
private void SetValues()
{
DataTable dt = invoice.GetInvoiceData(appointmentID);
DataRow row = dt.Rows[0];
String docFName = row["Doctor First Name"].ToString();
String docLName = row["Doctor Last Name"].ToString();
String patFName = row["Patient First Name"].ToString();
String patLName = row["Patient Last Name"].ToString();
labelInvoiceNum.Text = row["Appointment ID"].ToString();
labelPatientName.Text = patFName + " " + patLName;
labelDoctorName.Text = docFName + " " + docLName;
labelDoctorSpecialty.Text = row["Doctor Specialty"].ToString();
labelDate.Text = DateTime.Now.ToShortDateString();
labelPatientAddress.Text = row["Patient Address"].ToString();
labelPatienContact.Text = row["Patient Contact"].ToString();
DataTable labTestDT = labTest.GetAllAppointmentLabTest(appointmentID);
List <Tuple <string, string, decimal> > invoiceBilling = new List <Tuple <string, string, decimal> >();
DataTable invoiceDataTable = new DataTable();
invoiceDataTable.Columns.Add("Service / Drug".ToString());
invoiceDataTable.Columns.Add("Cost".ToString());
decimal totalCost = 0;
if (labTestDT.Rows != null && labTestDT.Rows.Count != 0)
{
foreach (DataRow testRow in labTestDT.Rows)
{
int testID = Convert.ToInt32(testRow["test_id"]);
DataTable serviceDt = labService.GetAllLabServiceForTest(testID);
foreach (DataRow serviceRow in serviceDt.Rows)
{
Console.WriteLine("Row");
Tuple <string, string, decimal> serivceInfo = new Tuple <string, string, decimal>("Service", serviceRow["Service"].ToString(), Convert.ToDecimal(serviceRow["Cost"]));
invoiceBilling.Add(serivceInfo);
totalCost = totalCost + Convert.ToDecimal(serviceRow["Cost"]);
DataRow dr = invoiceDataTable.NewRow();
dr["Service / Drug"] = "Service: " + serviceRow["Service"].ToString();
dr["Cost"] = serviceRow["Cost"].ToString();
invoiceDataTable.Rows.Add(dr);
//DataGridViewRow dgr = new DataGridViewRow();
//dgr.
}
}
}
DataTable prescriptionDt = prescription.getPrescriptionIDFromAppointment(appointmentID);
if (prescriptionDt.Rows != null && prescriptionDt.Rows.Count != 0)
{
int prescriptionID = Convert.ToInt32(prescriptionDt.Rows[0]["prescription_id"]);
DataTable drugsDT = drug.GetDrugsFromPrescriptionID(prescriptionID);
if (drugsDT.Rows != null && drugsDT.Rows.Count != 0)
{
foreach (DataRow drugRow in drugsDT.Rows)
{
Tuple <string, string, decimal> drugInfo = new Tuple <string, string, decimal>("Drug", drugRow["Drug"].ToString(), Convert.ToDecimal(drugRow["Cost"]));
invoiceBilling.Add(drugInfo);
totalCost = totalCost + Convert.ToDecimal(drugRow["Cost"]);
DataRow dr = invoiceDataTable.NewRow();
dr["Service / Drug"] = "Drug: " + drugRow["Drug"].ToString();
dr["Cost"] = drugRow["Cost"].ToString();
invoiceDataTable.Rows.Add(dr);
}
}
}
DataRow dataRow = invoiceDataTable.NewRow();
dataRow["Service / Drug"] = "Total";
dataRow["Cost"] = totalCost.ToString();
invoiceDataTable.Rows.Add(dataRow);
for (int i = 0; i < invoiceBilling.Count; i++)
{
Console.WriteLine(invoiceBilling[i]);
}
dgvInvoice.DataSource = invoiceDataTable;
//labelAppointmentID.Text = appointmentID.ToString();
//labelDoctorName.Text = docFName + " " + docLName;
//labelDoctorSpecialty.Text = patFName + " " + patLName;
//labelPatientAllergies.Text = allergies;
//labelPatientDOB.Text = DOB;
//labelPatientBloodType.Text = bloodType;
//labelAppointmentStatus.Text = status;
}
