private void buttonRoomDelete_Click(object sender, EventArgs e)
{
if (textBoxRoomID.Text.Length != 0)
{
DatabaseOps databaseOps = new DatabaseOps();
databaseOps.delete("ROOM", textBoxRoomNo.Text);
display();
}
else
{
MessageBox.Show("Unable to delete Data, Select a row which you want to delete", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (textBoxid.Text.Length != 0)
{
DatabaseOps databaseOps = new DatabaseOps();
DatabaseOps db = new DatabaseOps();
databaseOps.DeleteTimeSlots(DoctorID);
db.delete("DOCTORS", textBoxid.Text);
display();
}
else
{
MessageBox.Show("Unable to delete Data, Select a row which you want to delete", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonCancelAppointment_Click(object sender, EventArgs e)
{
if (textBoxAppointmentID.Text.Length != 0)
{
DatabaseOps databaseOps = new DatabaseOps();
int oldslotid = databaseOps.gettimeslotidfromappointment(textBoxAppointmentID.Text);
databaseOps.updatetimeslotavailability(oldslotid, 1);
databaseOps.delete("APPOINTMENT", textBoxAppointmentID.Text);
display();
}
else
{
MessageBox.Show("Unable to Cancel Appointment, Select a row which you want to Cancel", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
