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