public DataSet fillCholesterolReport(string PID) { string query; conn = ConnectionManager.GetConnection(); try { conn.Open(); query = "select lp.labPatientName,lp.labPatientAge,lp.labPatientGender,lpt.HDL,lpt.LDL,lpt.serum_cholesterol,la.labAppointmentDate,lp.labPatientID from lab_lipid_profile_test lpt,lab_patient lp,lab_appointment la where lp.labPatientID=lpt.PatientID and la.labPatientID=lp.labPatientID and lp.labPatientID=@PID"; var command = new MySqlCommand(query, conn); command.Parameters.AddWithValue("@PID", Convert.ToInt32(PID)); var da = new MySqlDataAdapter(command); var ds = new sugar(); ds.Clear(); da.Fill(ds.Tables["CholesterolTestTable"]); return(ds); } catch (Exception e) { MessageBox.Show("DB Error :" + e.Message); return(null); } finally { conn.Close(); } }
public DataSet fillCellcountReport(string PID) { string query; conn = ConnectionManager.GetConnection(); try { conn.Open(); query = "select lp.labPatientName,lp.labPatientAge,lp.labPatientGender,lbt.blood_cell_count_WBC,lbt.blood_cell_count_RBC,la.labAppointmentDate from lab_blood_test lbt,lab_patient lp,lab_appointment la where lp.labPatientID=lbt.PatientID and la.labPatientID=lp.labPatientID and lp.labPatientID=@PID"; var command = new MySqlCommand(query, conn); command.Parameters.AddWithValue("@PID", Convert.ToInt32(PID)); var da = new MySqlDataAdapter(command); var ds = new sugar(); ds.Clear(); da.Fill(ds.Tables["cellCount1"]); return(ds); } catch (Exception e) { MessageBox.Show("DB Error :" + e.Message); return(null); } finally { conn.Close(); } }