protected void Button1_Click(object sender, EventArgs e)
{
if (Calendar1.SelectedDate.Date.ToString("MM/dd/yyyy") == "01/01/0001")
{
//Response.Write("Must selest a date");
LabelMessage2.Text = "Must Select a Date!";
LabelMessage2.EnableViewState = true;
LabelMessage2.Visible = true;
}
else
{
SqlConnection con1 = new SqlConnection("Data Source=radon;Initial Catalog=Clinic;Integrated Security=True");
con1.Open();
SqlCommand cmd1 = new SqlCommand("getInfo", con1);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd1.ExecuteReader();
bool signal = false;
while (reader.Read())
{
if (reader["RegisteredUser"].ToString() == TextBoxUserName.Text)
{
if (reader["CareCardNo"].ToString() == TextBoxCareCard.Text)
{
signal = true;
reader.Close();
break;
}
}
}
if (signal)
{
DateTime markedDate = Calendar1.SelectedDate.Date;
string markedDateString = markedDate.ToString("MM/dd/yyyy");
if (validate(markedDateString))
{
//Response.Write("yes");
UserDetails userInfo = new UserDetails();
userInfo.Name = TextBoxUserName.Text;
userInfo.ClinicName = DropDownList1.Text;
userInfo.CareCardNo = TextBoxCareCard.Text;
userInfo.Date = Calendar1.SelectedDate.Date;
// Console.WriteLine(userInfo.Date);
userInfo.Time = TextBoxTime.Text;
userInfo.Email = TextBoxEmail.Text;
SqlConnection con = new SqlConnection("Data Source=radon;Initial Catalog=Clinic;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("update StatusTable set status='Booked' where date = @markedDateString and time = @markedTime and clinicname = @markedClinic", con);
cmd.Parameters.AddWithValue("@markedDateString", markedDateString);
cmd.Parameters.AddWithValue("@markedTime", userInfo.Time);
cmd.Parameters.AddWithValue("@markedClinic", userInfo.ClinicName);
int updateresult = 0;
updateresult = cmd.ExecuteNonQuery();
if (updateresult != 0)
{
//message = "inserted successfully";
//Console.WriteLine(message);
string result = obj.InsertUserDetails(userInfo);
LabelMessage.Text = result;
LabelMessage.EnableViewState = true;
LabelMessage.Visible = true;
}
else
{
LabelMessage3.Text = "Already Booked by Someone Else!";
LabelMessage3.EnableViewState = true;
LabelMessage3.Visible = true;
}
}
else
{
LabelMessage3.Text = "There is no available appointment!";
LabelMessage3.EnableViewState = true;
LabelMessage3.Visible = true;
}
}
else
{
LabelMessage.Text = "User Name/CareCard No invalid";
LabelMessage.EnableViewState = true;
LabelMessage.Visible = true;
}
}
}
