public void DisplayBill(HospitalDatabaseDataSet.BillVisitDetailsDataTable billDetail) { decimal total = 0; Console.WriteLine("Test: " + billDetail.Rows[0]["Id"]); labPatientName.Text = "Patient Name: " + billDetail.Rows[0]["Forename"] + " " + billDetail.Rows[0]["Surname"]; labBillId.Text = "Bill ID: " + billDetail.Rows[0]["Id"].ToString(); labIssuedDate.Text = "Date Issued: " + ((DateTime)billDetail.Rows[0]["Date"]).ToString("dd/MM/yyyy"); labPatientId.Text = "Patient ID: " + billDetail.Rows[0]["PatientId"].ToString(); if (!billDetail.Rows[0]["RoomCharge"].Equals(null)) { total = (decimal)billDetail[0]["RoomCharge"]; labRoomCharge.Text = "Room Charge: €" + billDetail[0]["RoomCharge"].ToString(); } else { labRoomCharge.Text = ""; } labDoctorFees.Text = "Doctor Fee: €" + billDetail.Rows[0]["DoctorsFee"].ToString(); total = total + (decimal)billDetail.Rows[0]["DoctorsFee"]; labNote.Text = "Notes: " + billDetail.Rows[0]["Note"].ToString(); if (!billDetail.Rows[0]["MiscellaneousFee"].Equals(null)) { labMiscellaneous.Text = "Miscellaneous: €" + billDetail.Rows[0]["MiscellaneousFee"].ToString(); total = total + (decimal)billDetail.Rows[0]["MiscellaneousFee"]; } else { labMiscellaneous.Text = "Miscellaneous: €00.00"; } labTotal.Text = "Total: €" + total.ToString(); }
private void btnOpen_Click(object sender, EventArgs e) { Int32 selectedRowCount = dataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCount > 0) { Console.WriteLine(dataGridView1.SelectedCells[1].Value.ToString()); HospitalDatabaseDataSetTableAdapters.BillVisitTableAdaptor billingDetailsTableAdapter = new HospitalDatabaseDataSetTableAdapters.BillVisitTableAdaptor(); HospitalDatabaseDataSet.BillVisitDetailsDataTable billDataTable = billingDetailsTableAdapter.getDataByVisit((int)(dataGridView1.SelectedCells[1].Value)); Console.WriteLine("TEst 2: " + dataGridView1.SelectedCells[1].Value); form1.DisplayBill(billDataTable); Dispose(); } else { MessageBox.Show("Please select an invoice"); } }