public rptClinicReport(int TreatmentID)
{
InitializeComponent();
//reatments.ID AS TreatmentID, Treatments.TreatmentDate, Patient.ID AS PatientID, Patient.PatientName, Patient.Address, Patient.PhoneNo, Patient.Sex, Year(Now())-Year(Patient.DateOfBirth) AS Age, Treatments.MainComplain, Treatments.Examination, Treatments.Treatment, Treatments.Medicine
ClinicReport c = new ClinicReport();
TreatmentContext tx = new TreatmentContext();
c = tx.GetClinicReport(TreatmentID);
lbTDT.Text = c.TreatmentDate.ToShortDateString();
lbPID.Text = c.PatientID;
lbPNM.Text = c.PatientName;
lbADR.Text = c.Address;
lbAGE.Text = c.Age.ToString();
lbSEX.Text = c.Sex;
lbCMP.Text = c.Complain;
lbEXM.Text = c.Examination;
lbTMP.Text = c.Treatment;
lbMED.Text = "";
foreach (string med in c.Medicine)
{
lbMED.Text += med;
lbMED.Text += Environment.NewLine;
}
}
public ClinicReport GetClinicReport(int TreatmentID)
{
ClinicReport c = new ClinicReport();
OleDbCommand cmd = new OleDbCommand("SELECT Treatments.ID AS TreatmentID, Treatments.TreatmentDate, Patient.ID AS PatientID, Patient.PatientName, Patient.Address, Patient.PhoneNo, Patient.Sex, Year(Now())-Year(Patient.DateOfBirth) AS Age, Treatments.MainComplain, Treatments.Examination, Treatments.Treatment, Treatments.Medicine FROM Patient INNER JOIN Treatments ON Patient.ID = Treatments.PatientID WHERE Treatments.ID=" + TreatmentID, cm);
try
{
cm.Open();
OleDbDataReader rd = cmd.ExecuteReader();
rd.Read();
c.TreatmentID = Convert.ToInt32(rd[0]);
c.TreatmentDate = DateTime.Parse(rd[1].ToString());
c.PatientID = rd[2].ToString();
c.PatientName = rd[3].ToString();
c.Address = rd[4].ToString();
c.PhoneNo = rd[5].ToString();
c.Sex = rd[6].ToString();
c.Age = Convert.ToInt32(rd[7]);
c.Complain = rd[8].ToString();
c.Examination = rd[9].ToString();
c.Treatment = rd[10].ToString();
string[] med = rd[11].ToString().Split(',').ToArray();
c.Medicine = med;
rd.Close();
}
catch {; }
finally { cm.Close(); }
return(c);
}
