private void save_Click(object sender, EventArgs e)
{
checkid();
int xx = checkid() - 1;
int z = checkk();
if (z > xx)
{
string cns = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\DoctorAppoinment\DoctorAppoinment\Doctor.mdf;Integrated Security=True";
SqlConnection cn1 = new SqlConnection(cns);
cn1.Open();
// SqlCommand cmd1 = new SqlCommand("INSERT INTO patientserial (id,serialNumber,patientName,_date) VALUES ('" + textBox1.Text + "' , '" + textBox3.Text + "', '" + textBox4.Text + "', '" + dateTimePicker1.Text + "')", cn1);
SqlCommand cmd1 = new SqlCommand("INSERT INTO ps (_date,id,serialNum,patientName) VALUES ('" + dateTimePicker1.Text + "','" + textBox1.Text + "','" + textBox3.Text + "','" + textBox4.Text + "' )", cn1);
try
{
cmd1.ExecuteNonQuery();
MessageBox.Show("Successfully Saved");
}
catch (Exception ex)
{
//Error when save data
MessageBox.Show(ex.Message);
cn1.Close();
}
if (type == "New")
{
patientinfo p = new patientinfo();
p.Show();
}
}
else
{
MessageBox.Show("Schedule limit reached for today. ");
}
}
private void addToolStripMenuItem2_Click(object sender, EventArgs e)
{
patientinfo p = new patientinfo();
p.Show();
}