protected void btnconfirm_Click(object sender, EventArgs e)
{
double currentcredit = 0;
double total = Convert.ToDouble(lbltotals.Text.ToString());
if (Session["UserID"] != null)
{
using (users objo = new users())
{
objo.uid = Convert.ToInt64(Session["UserID"].ToString());
DataSet dsr = new DataSet();
dsr = objo.user_select_byid();
if (dsr.Tables[0].Rows.Count > 0)
{
currentcredit = Convert.ToDouble(dsr.Tables[0].Rows[0]["Balance"].ToString());
}
if (currentcredit > total)
{
currentcredit = currentcredit - total;
objo.balanceid = currentcredit;
objo.user_updatebalance();
using (cart obj = new cart())
{
obj._userid = Convert.ToInt64(Session["UserID"].ToString());
obj._sessionid = Session["Current"].ToString();
obj._orderid = Convert.ToInt64("0");
DataSet ds = new DataSet();
ds = obj.cart_details();
using (order objc = new order())
{
WebClient client = new WebClient();
String htmlcode = client.DownloadString(Server.MapPath("Order.htm"));
htmlcode = htmlcode.Replace("###username###", Session["Name"].ToString());
htmlcode = htmlcode.Replace("###credit###", lbltotals.Text.ToString());
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "Dream Multimedia");
mail.To.Add(Session["Email"].ToString());
mail.Subject = "Order Massage";
string Body = htmlcode;
mail.Body = Body;
mail.IsBodyHtml = true;
Attachment ob;
//ob= new Attachment(Server.MapPath("my_friends_166225.jpg"));
//mail.Attachments.Add(ob);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
objc._uid = Convert.ToInt64(Session["UserID"].ToString());
objc._date = Convert.ToDateTime(System.DateTime.Now);
objc._cname = ds.Tables[0].Rows[i]["cname"].ToString();
objc._pname = ds.Tables[0].Rows[i]["pdname"].ToString();
objc._pcode = ds.Tables[0].Rows[i]["pcode"].ToString();
objc._image = ds.Tables[0].Rows[i]["image"].ToString();
objc._res = ds.Tables[0].Rows[i]["res"].ToString();
objc._size = ds.Tables[0].Rows[i]["size"].ToString();
objc._credit = Convert.ToInt64(ds.Tables[0].Rows[i]["credit"].ToString());
objc._prname = ds.Tables[0].Rows[i]["prname"].ToString();
Int64 ppid = Convert.ToInt64(ds.Tables[0].Rows[i]["PPID"].ToString());
objc._ppid = Convert.ToInt64(ds.Tables[0].Rows[i]["PPID"].ToString());
objc.order_insert();
using (productparameter obcpp = new productparameter())
{
DataSet pp = new DataSet();
obcpp.id = ppid;
pp = obcpp.productparameter_select_byid();
ob = new Attachment(Server.MapPath("Admin\\upload\\orignal\\") + pp.Tables[0].Rows[0]["OProduct"].ToString());
mail.Attachments.Add(ob);
}
}
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Dream143");
smtp.EnableSsl = true; // Other then smtp.gmail.com = false;
smtp.Send(mail);
mail = null;
smtp = null;
}
obj._orderid = Convert.ToInt64("1");
obj.cart_updateorderid();
}
}
else
{
Response.Redirect("Packagesub.aspx");
}
}
Response.Redirect("Currentorder.aspx");
}
}