protected void Button2_Click(object sender, EventArgs e)
{
string res = "";
string sOrderId = "";
try
{
if (TotalAmount.Text == "")
{
MsgBox("Please add to cart for create order");
return;
}
var details = (DataTable)ViewState["DT"];
SqlCommand cmdProc = new SqlCommand("CreateOrder", con);
cmdProc.CommandType = CommandType.StoredProcedure;
cmdProc.Parameters.AddWithValue("@Usercode", TextBox1.Text);
cmdProc.Parameters.AddWithValue("@Usercode1", TextBox1.Text);
cmdProc.Parameters.AddWithValue("@FrenchiseID", ConfigurationManager.AppSettings["FrenchiseID"].ToString());
cmdProc.Parameters.AddWithValue("@UserPaymentDate", DateTime.Now);
cmdProc.Parameters.AddWithValue("@PaymentMode", DropDownList1.SelectedValue);
cmdProc.Parameters.AddWithValue("@Amount", TotalAmount.Text);
cmdProc.Parameters.AddWithValue("@TotalBv", TotalBV.Text);
cmdProc.Parameters.AddWithValue("@ChequeDate", "");
cmdProc.Parameters.AddWithValue("@BankName", "");
cmdProc.Parameters.AddWithValue("@DDBankName", "");
cmdProc.Parameters.AddWithValue("@ChequeNo", "");
cmdProc.Parameters.AddWithValue("@DDDate", "");
cmdProc.Parameters.AddWithValue("@DDNo", "");
cmdProc.Parameters.AddWithValue("@Referencenumber", "");
cmdProc.Parameters.AddWithValue("@Impsdate", "");
cmdProc.Parameters.AddWithValue("@InvoiceType", "DP");
cmdProc.Parameters.AddWithValue("@Neftdate", "");
cmdProc.Parameters.AddWithValue("@debitrefno", "");
cmdProc.Parameters.AddWithValue("@NeftRefNo", "");
cmdProc.Parameters.AddWithValue("@debitrefdate", "");
cmdProc.Parameters.AddWithValue("@CashBack", CashBack.Text);
cmdProc.Parameters.AddWithValue("@SelfCashBack", txtselcashback.Text);
cmdProc.Parameters.AddWithValue("@RedemptionPoint", "0");
cmdProc.Parameters.AddWithValue("@Details", details);
LogControl.WriteALine("Details: " + details); LogControl.WriteALine("");
SqlParameter result = new SqlParameter("@Result", SqlDbType.VarChar, 200);
result.Direction = ParameterDirection.Output;
LogControl.WriteALine("result Direction Output: " + result.Direction); LogControl.WriteALine("");
cmdProc.Parameters.Add(result);
SqlParameter orderid = new SqlParameter("@orderID", SqlDbType.VarChar, 200);
orderid.Direction = ParameterDirection.Output;
LogControl.WriteALine("orderid Direction Output: " + orderid.Direction); LogControl.WriteALine("");
cmdProc.Parameters.Add(orderid);
con.Open();
cmdProc.ExecuteNonQuery();
res = result.Value.ToString();
LogControl.WriteALine("Order result: " + res); LogControl.WriteALine("");
sOrderId = orderid.Value.ToString();
LogControl.WriteALine("Order id: " + sOrderId); LogControl.WriteALine("");
if (res != "Product Saved Successfully")
{
MsgBox("Error");
return;
}
con.Close();
if (res == "Product Saved Successfully")
{
Label7.Text = "Product Saved Successfully";
string email = ""; string name = "";
SqlConnection con1 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString());
SqlCommand cmd3 = new SqlCommand("select * from tblmembermaster where usercode=@user_code1", con1);
cmd3.Parameters.AddWithValue("@user_code1", TextBox1.Text);
con1.Open();
SqlDataReader dr = cmd3.ExecuteReader();
while (dr.Read())
{
name = dr["UserName"].ToString();
HiddenField5.Value = dr["Email"].ToString();
}
dr.Close();
con1.Close();
string date1 = "";
string amount = "";
string paymentmode = "";
SqlConnection con2 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString());
SqlCommand cmd4 = new SqlCommand("select * from ordermaster where orderid=@order_id", con2);
cmd4.Parameters.AddWithValue("@order_id", sOrderId);
con2.Open();
SqlDataReader dr1 = cmd4.ExecuteReader();
while (dr1.Read())
{
date1 = DateTime.Parse(dr1["Date"].ToString()).Date.ToString("dd MMM yyyy");
amount = dr1["Amount"].ToString();
paymentmode = dr1["PaymentMode"].ToString();
}
dr1.Close();
con2.Close();
string Msg = "";
Msg = "Order details are as follow :<br /><br />OrderID :" + sOrderId + "<br />Date :" + date1 + "<br />Payment Mode :" + paymentmode + "<br />Amount :" + amount + "<br /><br />You can login to view the invoice.<br /><br />Thanks,<br />With regards!<br /><br /> Diwakar Retails Limited";
string msgadmin = "";
msgadmin = "Order details are as follow :<br /><br />MemberID : " + TextBox1.Text + "<br/>Name : " + name + "<br />OrderID :" + sOrderId + "<br />Date :" + date1 + "<br />Payment Mode :" + paymentmode + "<br />Amount :" + amount;
// [email protected]
// [email protected]
//Gen obj1 = new Gen();
//obj1.SendEmail("*****@*****.**", msgadmin, TextBox1.Text + "/" + name + " Ordered Products with Order Id " + sOrderId, ConfigurationManager.AppSettings["Email"]);
//obj1.SendEmail(" [email protected]", msgadmin, TextBox1.Text + "/" + name + " Ordered Products with Order Id " + sOrderId, ConfigurationManager.AppSettings["Email"]);
//if (email != "")
//{
// obj1.SendEmail(email, Msg, TextBox1.Text + "/" + name + " Ordered Products with Order Id " + sOrderId, ConfigurationManager.AppSettings["Email"]);
//}
Response.Redirect("AdminGstInvoice.aspx?ID=" + sOrderId + "&BVpointsTotal=" + Bvtotal, false);
LogControl.WriteALine("Response Redirect Order id: " + sOrderId); LogControl.WriteALine("");
}
//Response.Redirect("GSTInvoice.aspx?ID=" + sOrderId + "&BVpointsTotal=" + Bvtotal);
}
catch (Exception ex)
{
LogControl.WriteALine("");
LogControl.WriteALine("create order stack Trace : " + ex.StackTrace); LogControl.WriteALine("");
LogControl.WriteALine("create order catch : " + ex.Message); LogControl.WriteALine("");
}
}
