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); }