public bool insertSugar(string PID, string testid, string value) { if (string.IsNullOrEmpty(value)) { return(false); } else { conn = ConnectionManager.GetConnection(); string query; string testno = checkBloodTestPatient(PID); MySqlCommand command; try { conn.Open(); if (testno != null) { query = "update lab_blood_test set Sugar=@sugar where Num=@num"; command = new MySqlCommand(query, conn); command.Parameters.AddWithValue("@num", Convert.ToInt32(testno)); command.Parameters.AddWithValue("@sugar", Convert.ToInt32(value)); } else { query = "insert into lab_blood_test(PatientID,Sugar) values(@PID,@sugar)"; command = new MySqlCommand(query, conn); command.Parameters.AddWithValue("@PID", Convert.ToInt32(PID)); command.Parameters.AddWithValue("@sugar", Convert.ToInt32(value)); } if (command.ExecuteNonQuery() > 0) { labtest.updateLabTestStatus(PID, testid); return(true); } else { return(false); } } catch (Exception e) { MessageBox.Show("DB Error :" + e.Message); return(false); } finally { conn.Close(); } } }
public bool insertCholestrolTest(string PID, string testid, string hdl, string ldl, string serum_cholesterol) { if (string.IsNullOrEmpty(ldl) || string.IsNullOrEmpty(hdl) || string.IsNullOrEmpty(serum_cholesterol)) { return(false); } else { string query; labtest = new LabTest(); //conn = ConnectionManager.GetConnection(); try { conn.Open(); query = "INSERT INTO lab_lipid_profile_test(PatientID,HDL,LDL,serum_cholesterol)VALUES(@PID,@HDL,@LDL,@serum_ch);"; var command = new MySqlCommand(query, conn); command.Parameters.AddWithValue("@PID", Convert.ToInt32(PID)); command.Parameters.AddWithValue("@HDL", Convert.ToDouble(hdl)); command.Parameters.AddWithValue("@LDL", Convert.ToDouble(ldl)); command.Parameters.AddWithValue("@serum_ch", Convert.ToDouble(serum_cholesterol)); if (command.ExecuteNonQuery() > 0) { labtest.updateLabTestStatus(PID, testid); return(true); } else { return(false); } } catch (Exception e) { MessageBox.Show("DB Error :" + e.Message); return(false); } finally { conn.Close(); } } }