protected void Button2_Click(object sender, EventArgs e)
{
Label8.Text = "";
DateTime dt;
string dateTime = TextBox5.Text + " " + TextBox6.Text;
try
{
if (string.IsNullOrWhiteSpace(TextBox5.Text) || string.IsNullOrWhiteSpace(TextBox6.Text))
{
throw new Exception("Appointment Date and Appointment Time cannot be empty");
}
else if (!DateTime.TryParse(dateTime, out dt))
{
throw new Exception("Appointment date format should be: yyyy/MM/dd and appointment time format should be: HH:mm:ss.");
}
ADODatabaseService adodbs = new ADODatabaseService();
Boolean result = adodbs.AppointmentReschedule(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, Convert.ToDateTime(dateTime));
if (result == true)
{
Label8.Text = "Updated successfully";
}
}
catch (Exception ex)
{
Label8.Text = ex.Message;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Label8.Text = "";
try
{
if (string.IsNullOrWhiteSpace(TextBox2.Text) || string.IsNullOrWhiteSpace(TextBox3.Text))
{
throw new Exception("First name,Last name cannot be empty");
}
ADODatabaseService adodbs = new ADODatabaseService();
string[] result = adodbs.GetPatientInfo(TextBox2.Text, TextBox3.Text);
if (result != null)
{
TextBox1.Text = result[0];
TextBox4.Text = result[1];
TextBox5.Text = result[2];
TextBox6.Text = result[3];
}
else
{
TextBox1.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
Label8.Text = "Not found";
}
}
catch (Exception ex)
{
Label8.Text = ex.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Label8.Text = "";
try
{
int n;
if (string.IsNullOrWhiteSpace(TextBox1.Text) || string.IsNullOrWhiteSpace(TextBox2.Text) || string.IsNullOrWhiteSpace(TextBox3.Text) || string.IsNullOrWhiteSpace(TextBox4.Text) || string.IsNullOrWhiteSpace(TextBox5.Text))
{
throw new Exception("Health Insurance NO.,First name,Last name,Phone number,Address cannot be empty");
}
else if (!int.TryParse(TextBox4.Text, out n))
{
throw new Exception("Phone number shoule be an integer");
}
ADODatabaseService adodbs = new ADODatabaseService();
Boolean result = adodbs.PatientRegistration(TextBox1.Text, TextBox2.Text, TextBox3.Text, Convert.ToInt32(TextBox4.Text), TextBox5.Text, TextBox6.Text);
if (result == true)
{
Label8.Text = "Saved successfully";
}
else
{
Label8.Text = "Saved failed";
}
}
catch (Exception ex)
{
Label8.Text = ex.Message;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Label7.Text = "";
try
{
if (string.IsNullOrWhiteSpace(TextBox2.Text) || string.IsNullOrWhiteSpace(TextBox3.Text))
{
throw new Exception("First name,Last name cannot be empty");
}
ADODatabaseService adodbs = new ADODatabaseService();
DataSet result = adodbs.GetDoctorInfo(TextBox2.Text, TextBox3.Text);
if (result != null)
{
TextBox1.Text = result.Tables[0].Rows[0]["Medical Registration NO."].ToString();
DropDownList1.SelectedValue = result.Tables[0].Rows[0]["Health Profession"].ToString();
TextBox4.Text = result.Tables[0].Rows[0]["Phone number"].ToString();
TextBox5.Text = result.Tables[0].Rows[0]["Email"].ToString();
}
else
{
TextBox1.Text = "";
DropDownList1.SelectedValue = "";
TextBox4.Text = "";
TextBox5.Text = "";
Label7.Text = "Not found";
}
}
catch (Exception ex)
{
Label7.Text = ex.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Label8.Text = "";
try
{
if (string.IsNullOrWhiteSpace(TextBox1.Text) || string.IsNullOrWhiteSpace(TextBox2.Text) || string.IsNullOrWhiteSpace(TextBox3.Text) || string.IsNullOrWhiteSpace(TextBox4.Text))
{
throw new Exception("Patient's name and Doctor's name cannot be empty");
}
ADODatabaseService adodbs = new ADODatabaseService();
DataSet result = adodbs.GetAppointment(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text);
if (result != null)
{
string[] dateTime = result.Tables[0].Rows[0]["Appointment date & time"].ToString().Split(' ');
TextBox5.Text = dateTime[0];
TextBox6.Text = dateTime[1];
TextBox7.Text = result.Tables[0].Rows[0]["Clinic name"].ToString();
TextBox1.Enabled = false;
TextBox2.Enabled = false;
TextBox3.Enabled = false;
TextBox4.Enabled = false;
TextBox7.Enabled = false;
}
else
{
Label8.Text = "Not found";
}
}
catch (Exception ex)
{
Label8.Text = ex.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
DateTime dt;
string dateTime = TextBox5.Text + " " + TextBox6.Text + ":00";
if (string.IsNullOrWhiteSpace(TextBox1.Text) || string.IsNullOrWhiteSpace(TextBox2.Text) || string.IsNullOrWhiteSpace(TextBox3.Text) || string.IsNullOrWhiteSpace(TextBox4.Text) || string.IsNullOrWhiteSpace(TextBox5.Text) ||
string.IsNullOrWhiteSpace(TextBox6.Text) || string.IsNullOrWhiteSpace(TextBox7.Text))
{
throw new Exception("Patient's name, Doctor's name, Appointment Date, Appointment Time and Clinic Name cannot be empty");
}
else if (!DateTime.TryParse(dateTime, out dt))
{
throw new Exception("Appointment date format should be: yyyy-MM-dd and appointment time format should be: HH:mm.");
}
ADODatabaseService adodbs = new ADODatabaseService();
Boolean result = adodbs.AppointmentBooking(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, Convert.ToDateTime(dateTime), TextBox7.Text);
if (result == true)
{
Label8.Text = "Saved successfully";
}
else
{
Label8.Text = "Saved failed";
}
}
catch (Exception ex)
{
Label8.Text = ex.Message;
}
}
