public string HandOutMedication(Entities.User LoggedInuser, Entities.Medication medication)
{
MySql.Data.MySqlClient.MySqlCommand Using;
Using = new MySql.Data.MySqlClient.MySqlCommand("UPDATE medications set medications.HandedOut=1,medications.HandedOutDate=@handoutdate,medications.ExpirationDate=@expdate,medications.HandedOutByID=@donebyid where medications.ID=@id", con);
using (MySql.Data.MySqlClient.MySqlCommand cmd = Using)
{
try
{
cmd.Parameters.AddWithValue("@handoutdate", medication.HandedOutDate);
cmd.Parameters.AddWithValue("@expdate", medication.ExpirationDate);
cmd.Parameters.AddWithValue("@donebyid", medication.HandedOutByID);
cmd.Parameters.AddWithValue("@id", medication.ID);
con.Open();
cmd.ExecuteNonQuery();
if (con.State != System.Data.ConnectionState.Closed)
{
con.Close();
}
return("Succesvol opgeslagen");
}
catch (Exception ex)
{
if (con.State != System.Data.ConnectionState.Closed)
{
con.Close();
}
return("FOUT: " + ex.Message);
}
}
}
protected void SaveMedication_Click(object sender, EventArgs e)
{
try
{
int DoneByID = LoggedInUser.ID;
DateTime dateTimeHandedOut = DateTime.Parse(NewMedicationDate.Text);
DateTime expirationdate = DateTime.Parse(ExpirationDate.Text);
int medicationID = Convert.ToInt32(ListBoxMedication.SelectedValue);
Entities.Medication medication = new Entities.Medication();
medication.ExpirationDate = expirationdate;
medication.HandedOut = true;
medication.HandedOutDate = dateTimeHandedOut;
medication.ID = medicationID;
medication.HandedOutByID = DoneByID;
string result = dBMedication.HandOutMedication(LoggedInUser, medication);
showMessage(result);
}
catch (Exception ex)
{
showMessage(ex.Message);
}
}
