private void optionsToolStripMenuItem1_Click(object sender, EventArgs e)
{
DialogResult signOutResult = MessageBox.Show("Are you sure to log out?", "Sign Out", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (signOutResult == DialogResult.Yes)
{
onlineUser = null;
this.Dispose();
this.Close();
}
}
// 3. Delete rows (without procedures)
private void deleteAccountToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult deleteResult = MessageBox.Show("Are you sure to delete your account?", "Delete account", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
string[] info_to_delete = { @"DELETE FROM assigned_for WHERE ID = :id",
@"DELETE FROM drug_history WHERE ID = :id",
@"DELETE FROM attends WHERE ID = :id",
@"DELETE FROM preexisting_condition WHERE ID = :id",
@"DELETE FROM Patient_history WHERE ID = :id",
@"DELETE FROM Patient WHERE ID = :id" };
if (deleteResult == DialogResult.Yes)
{
for (int i = 0; i < info_to_delete.Length; ++i)
{
try
{
OracleCommand cmd = new OracleCommand
{
Connection = OrclDatabase.conn,
CommandText = info_to_delete[i],
CommandType = CommandType.Text
};
cmd.Parameters.Add("id", onlineUser.ID);
int r = cmd.ExecuteNonQuery();
if (r != -1 && i == info_to_delete.Length - 1)
{
onlineUser = null;
this.Dispose();
this.Close();
MessageBox.Show("User deleted from Database", "Operation Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
}
}
}
}
public BookingAppointmentForm(SystemPersona loggedinUser)
{
onlineUser = loggedinUser;
randomFees = new Random();
InitializeComponent();
}
public AppointmentsForm(SystemPersona loggedinUser)
{
onlineUser = loggedinUser;
InitializeComponent();
}
public MainForm(SystemPersona loggedinUser)
{
onlineUser = loggedinUser;
InitializeComponent();
}
