COuld someone guide me on my issue with button-click event? First condition works well but next-one doesn't execute. What could be possible reasons. Thanks for all the attention:
if (DDPax1.Text != "" & DDTitle1.Text != "" && TBName1.Text != "" && TBContact1.Text != "" && TBMail1.Text != "" && DDOcc1.Text != "")
{
DateTime datedT1 = new DateTime();
datedT1 = DateTime.Parse(Request.Form[TBox1.UniqueID]);
string conT1 = ConfigurationManager.ConnectionStrings["HbE"].ConnectionString;
SqlConnection connT1 = new SqlConnection(conT1);
connT1.Open();
SqlCommand cmdcountT1 = new SqlCommand("Select count (*) from OBook Where FBDt = @FBDt And FBTime = @FBTime And FBTNo = @FBTNo And FBStats = @FBStats", connT1);
cmdcountT1.Parameters.AddWithValue("@FBDt", datedT1);
cmdcountT1.Parameters.AddWithValue("@FBTime", DropDownList1.SelectedValue);
cmdcountT1.Parameters.AddWithValue("@FBTNo", Slot1.Text);
cmdcountT1.Parameters.AddWithValue("@FBStats", LblBStatus.Text);
int count1T1 = (int)cmdcountT1.ExecuteScalar();
if (count1T1 > 0)
{
LblResult1.Text = "Sorry - You're too late to book!";
LblResult1.ForeColor = System.Drawing.Color.Red;
connT1.Close();
}
else
{
SqlConnection sqlconnx1 = new SqlConnection(ConfigurationManager.ConnectionStrings["HbE"].ConnectionString);
sqlconnx1.Open();
SqlCommand sqlcommx1 = new SqlCommand("Select Max(FBBookingId)+1 as FBBookingId from OBook", sqlconnx1);
SqlDataReader sdr1 = sqlcommx1.ExecuteReader();
if (sdr1.Read())
{
LblBookingNo1.Text = sdr1["FBBookingId"].ToString();
sdr1.Close();
sqlconnx1.Close();
}
string T11 = LblBookingNo1.Text;
string T12 = LblPnlDBDt.Text;
string T13 = DDPax1.SelectedValue;
string T14 = LblPnlTime.Text;
string T15 = DDTitle1.SelectedValue;
string T16 = TBName1.Text;
string T17 = TBContact1.Text;
string T18 = TBMail1.Text;
string T19 = DDOcc1.SelectedValue;
string T110 = TBComment1.Text;
string T111 = Slot1.Text;
SqlConnection sT1 = new SqlConnection(ConfigurationManager.ConnectionStrings["HbE"].ConnectionString);
sT1.Open();
SqlCommand scom1 = new SqlCommand("INSERT INTO OBook (FBBookingId, FBDt, FBNOG, FBTime, FBTitle, FBName, FBTel, FBMail, FBSpl, FBRem, FBTNo, FBStats) VALUES (@FBBookingId, @FBDt, @FBNOG, @FBTime, @FBTitle, @FBName, @FBTel, @FBMail, @FBSpl, @FBRem, @FBTNo, 'Booked')", sT1);
scom1.Parameters.AddWithValue("@FBBookingId", T11);
scom1.Parameters.AddWithValue("@FBDt", T12);
scom1.Parameters.AddWithValue("@FBNOG", T13);
scom1.Parameters.AddWithValue("@FBTime", T14);
scom1.Parameters.AddWithValue("@FBTitle", T15);
scom1.Parameters.AddWithValue("@FBName", T16);
scom1.Parameters.AddWithValue("@FBTel", T17);
scom1.Parameters.AddWithValue("@FBMail", T18);
scom1.Parameters.AddWithValue("@FBSpl", T19);
scom1.Parameters.AddWithValue("@FBRem", T110);
scom1.Parameters.AddWithValue("@FBTNo", T111);
scom1.ExecuteNonQuery();
sT1.Close();
string siteurl1 = Server.HtmlEncode("http://localhost:52716/HBE/CancellationO.aspx?FBBookingId=" + T11 + "&FBDt=" + T12 + "&&FBNOG=" + T13 + "&&FBTime=" + T14 + "&&FBTel=" + T17 + "");
MailAddress addressTo1 = new MailAddress(T18);
MailAddress addressFrom1 = new MailAddress("mail@edit.com");
MailAddress addressBCC1 = new MailAddress("info@edit.com");
MailMessage mm1 = new MailMessage(addressFrom1, addressTo1);
mm1.Bcc.Add(addressBCC1);
mm1.Subject = "Booking Confirmation Alert! - " + T11;
mm1.Body = "Dear " + T15 + " " + T16 + ", " + "<br />" + "<br />"
+ "Thank you for choosing us. + "<br />" + "<br />"
+ "Date of patronizing: " + LblPnlDBDt.Text + "<br />"
+ "Booking status:" + T111 + " / Confirmed" + "<br />" + "<br />"
+ "You also agree to our <a href='http://localhost:52716/HBE/OTerms.aspx'>terms and conditions</a>" ;
mm1.IsBodyHtml = true;
SmtpClient smtp1 = new SmtpClient();
smtp1.Host = "webmail.edit.com";
smtp1.EnableSsl = false;
System.Net.NetworkCredential NetworkCred1 = new System.Net.NetworkCredential();
NetworkCred1.UserName = "uname";
NetworkCred1.Password = "pass";
smtp1.UseDefaultCredentials = true;
smtp1.Credentials = NetworkCred1;
smtp1.Port = 587;
smtp1.Send(mm1);
Btnbook1.Enabled = false;
Btnbook1.Visible = false;
Pnl1.Visible = false;
LblResult1.Text = "Success ! A confirmation mail has been sent to you !" + "<br/>";
LblResult1.ForeColor = System.Drawing.Color.Green;
}
}
else
{
LblResult1.Text = "Above fields are mandatory except the comments !";
LblResult1.ForeColor = System.Drawing.Color.Red;
}