private void button1_Click(object sender, EventArgs e)
{
if (textBox1.TextLength == 0)
{
label7.Visible = true;
}
if (richTextBox1.TextLength == 0)
{
label8.Visible = true;
}
if (textBox2.TextLength == 0)
{
label9.Text = "*Required Field";
label9.Visible = true;
}
if (textBox2.TextLength > 0 && textBox2.TextLength < 10)
{
label9.Text = "Enter a valid mobile number";
label9.Visible = true;
}
if (label7.Visible == true || label8.Visible == true || label9.Visible == true)
{
return;
}
else
{
conn.Open();
SqlCommand readLastPatientId = new SqlCommand("select ssn from patient order by ssn desc", conn);
SqlDataReader reader;
int patientId = 1001;
try {
reader = readLastPatientId.ExecuteReader();
if (reader.Read())
{
patientId = reader.GetInt32(0) + 1;
}
reader.Close();
string query = "insert into patient values(" + patientId + ",'" + textBox1.Text + "','" + richTextBox1.Text + "','" + textBox2.Text + "','" + dateTimePicker1.Value.Year + "/" + dateTimePicker1.Value.Month + "/" + dateTimePicker1.Value.Day + "');";
SqlCommand enterPatientIntoDB = new SqlCommand(query, conn);
enterPatientIntoDB.ExecuteNonQuery();
enterPatientIntoDB.Dispose();
conn.Close();
MessageBox.Show("Patient Registration Successful", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
panel1.Controls.Clear();
BookAppointments bookAppointment = new BookAppointments(textBox1.Text);
bookAppointment.TopLevel = false;
bookAppointment.AutoScroll = true;
panel1.Controls.Add(bookAppointment);
bookAppointment.Show();
Console.WriteLine(dateTimePicker1.Value.ToShortDateString());
}
catch (Exception E) {
MessageBox.Show(E.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally {
conn.Close();
}
}
//MessageBox.Show("Patient Registration Successful","Success",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
private void button2_Click(object sender, EventArgs e)
{
if (radioButton1.Checked)
{
panel1.Controls.Clear();
PatientRegistration registration = new PatientRegistration(panel1);
registration.TopLevel = false;
registration.AutoScroll = true;
panel1.Controls.Add(registration);
registration.Show();
}
else
{
panel1.Controls.Clear();
BookAppointments obj = new BookAppointments(patientName);
obj.TopLevel = false;
obj.AutoScroll = true;
panel1.Controls.Add(obj);
obj.Show();
}
}
