protected void Button1_Click(object sender, EventArgs e)
{
dt = new DataTable();
dt = (DataTable)Session["addtocart"];
string str = Session["UID"].ToString();
string adrress = Session["shippingaddress"].ToString();
if (Txtcardnumber.Text.Length == 15)
{
lblMessage.Text = "<font color=red>Please enter your 16 digit card number.</Font>";
return;
}
if (Txtpwd.Text.Length == 3)
{
lblMessage.Text = "<font color=red>Please enter 4 digit Password.</Font>";
return;
}
DateTime dates = new DateTime();
dates = Convert.ToDateTime(txtcurrentdate.Text);
string QueryOrder = "insert into order_detail values ('" + str + "','" + dates + "') select scope_identity()";
string oid = ado.ExecuteScalerByQuery(QueryOrder);
DateTime dp = new DateTime();
dp = Convert.ToDateTime(Txtdate.Text);
string QueryPayment = "insert into paymentdetail values('" + str + "','" + oid + "','" + DropDownList1.SelectedValue + "','" + Txtcardnumber.Text + "','" + dp + "')";
ado.InsertUpdateByQuery(QueryPayment);
string QueryShipping = "insert into shippingdetail values('" + oid + "','" + adrress + "')";
ado.InsertUpdateByQuery(QueryShipping);
Session["billnum"] = oid.ToString();
Session["paymentmode"] = DropDownList1.SelectedItem.Text;
Session["cardnumber"] = Txtcardnumber.Text;
Session["xpirydate"] = Txtdate.Text;
Session["currentdate"] = txtcurrentdate.Text;
string ODetail = "";
foreach (DataRow dr in dt.Rows)
{
ODetail = "insert into oderdetail values('" + oid + "','" + dr["iname"].ToString() + "','" + Convert.ToInt32(dr["Qty"]) + "','" + Convert.ToDouble(dr["total"]) + "')";
ado.InsertUpdateByQuery(ODetail);
}
Response.Redirect("billgeneration.aspx");
}
