public void AddPatientHistoryInfromation(Patient pa, Doctor dr, Clinic cl, PrescriptionClass pr)
{
try
{
string sql = @"insert into patienthistory (patientid,patientname,patientgender,patientemail,dateOfBirth,doctorid,date,time,clinicname,clinicid,divission,district,thana,symptom,disease,test,testclinicname,testclinicid,report,medicines) values ('" + pa.Userid + "','" + pa.Username + "','" + pa.Gender + "','" + pa.Email + "','" + pa.DateOfBirth + "','" + dr.Userid + "','" + dr.Date + "','" + dr.Time + "','" + cl.Username + "','" + cl.Userid + "','" + cl.Divission + "','" + cl.District + "','" + cl.Thana + "','" + pr.Symptom + "','" + pr.Diseases + "','" + pr.Test + "','" + pr.Testclinicname + "','" + pr.Testclinicid + "','" + pr.Report + "','" + pr.Medicines + "');";
DataAccess.ExecuteQuery(sql);
}
catch (Exception exc)
{
MessageBox.Show("Error: " + exc.Message);
}
}
public PhaseClass()
{
Prescription = new PrescriptionClass();
}
