private void enterBtn_Click(object sender, EventArgs e)
{
int id = int.Parse(IDlbl.Text);
int doc = int.Parse(doctorIDTB.Text);
int staff = int.Parse(staffIDTB.Text);
int pat = int.Parse(patientTB.Text);
var sql = "UPDATE Room SET Doctor = @docID, Staff = @staffID, Patient = @patID, Occupied = @occ WHERE Room_Id = @roomID";
string connectionString = Emergancy_Room_Database.Properties.Settings.Default.ERDatabaseConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (var cmd = new SqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@patID", pat);
cmd.Parameters.AddWithValue("@docID", doc);
cmd.Parameters.AddWithValue("@staffID", staff);
cmd.Parameters.AddWithValue("@occ", occupiedTB.Text);
cmd.Parameters.AddWithValue("@roomID", id);
cmd.ExecuteNonQuery();
}
}
this.Hide();
displayRoomsTable displayRoomsTable = new displayRoomsTable();
displayRoomsTable.ShowDialog();
this.Close();
}
private void displayRoomsBtn_Click(object sender, EventArgs e)
{
this.Hide();
displayRoomsTable displayRoomsTable = new displayRoomsTable();
displayRoomsTable.ShowDialog();
this.Close();
}