protected void Button1_Click(object sender, EventArgs e)
{
MedicalHistory mh = new MedicalHistory(IDBox.Text, DropDownList1.SelectedValue.ToString(), descBox.Text);
PatientDAO dao = new PatientDAO();
string result = dao.addMedicalHistory(mh);
resultLabel.Text = result;
}
public string addMedicalHistory(MedicalHistory mh)
{
string result = "Added successfully!";
SqlConnection sqlconnection = new SqlConnection(connectstring);
string query = "Insert into MedicalHistory values('@PID','@Type','@Desc');";
try
{
query = query.Replace("@PID", mh.getPID())
.Replace("@Type", mh.getType())
.Replace("@Desc", mh.getDesc());
sqlconnection.Open();
SqlCommand sqlcommand = new SqlCommand(query, sqlconnection);
sqlcommand.ExecuteNonQuery();
}catch (Exception c)
{
result = c.Message;
}
finally
{
sqlconnection.Close();
}
return(result);
}
