protected void btnDatHangDangNhap_Click(object sender, EventArgs e)
{
if (Session["UserName"] != null)
{
var oAddressBook = new AddressBook();
var dtAddressBook = oAddressBook.AddressBookSelectAll("", "", "", "", "", "", "", Session["UserName"].ToString(), "", "", "", "", "", "", "", "", "", "", "", "").DefaultView;
Session["FullName"] = dtAddressBook[0]["FirstName"].ToString();;
Session["Phone"] = dtAddressBook[0]["HomePhone"].ToString();;
Session["Email"] = dtAddressBook[0]["Email"].ToString();
Session["Address"] = dtAddressBook[0]["Address1"].ToString();
Session["ProvinceName"] = dtAddressBook[0]["ProvinceName"].ToString();
Session["DistrictName"] = dtAddressBook[0]["DistrictName"].ToString();
Response.Redirect("thanh-toan.aspx");
}
}
protected void btnLoginButton_Click(object sender, EventArgs e)
{
string UserName = txtUserName.Text;
MembershipUser mu = Membership.GetUser(UserName);
bool bValid = Membership.ValidateUser(UserName, txtPassword.Text);
//Session["PWD"] = Login1.Password;
if (UserName != null)
{
if (bValid)
{
Session["IsLogin"] = "******";
if (Request.QueryString["ReturnURL"] != null)
{
Response.Redirect(Request.QueryString["ReturnURL"]);
}
else
{
string[] roleUser = Roles.GetRolesForUser(UserName.ToString());
for (int i = 0; i < roleUser.Length; i++)
{
if (roleUser[i] == "admin")
{
Response.Redirect("ad/bilingual/");
}
else
{
Session["UserName"] = UserName;
Session["IsLogin"] = true;
var oAddressBook = new AddressBook();
var a = oAddressBook.AddressBookSelectAll("", "", "", "", "", "", "", UserName, "", "", "", "", "", "", "", "", "", "", "", "member").DefaultView;
Session["FullNameUser"] = a[0]["FirstName"].ToString();
Response.Redirect("~/");
}
}
}
}
else
{
lblErrorLogin.Text = "Đăng nhập không thành công, vui lòng thử lại.";
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "runtime", " $(document).ready(function () {$('.dn').trigger('click');});", true);
}
}
}
protected void LoginButton_Click(object sender, EventArgs e)
{
string UserName = txtUserName.Text;
MembershipUser mu = Membership.GetUser(UserName);
bool bValid = Membership.ValidateUser(UserName, txtPassword.Text);
var oAddressBook = new AddressBook();
//Session["PWD"] = Login1.Password;
if (UserName != null)
{
if (bValid)
{
Session["UserName"] = UserName;
var a = oAddressBook.AddressBookSelectAll("", "", "", "", "", "", "", UserName, "", "", "", "", "", "", "", "", "", "", "", "member").DefaultView;
Session["FullNameUser"] = a[0]["FirstName"].ToString();
Session["IsLogin"] = "******";
if (Request.QueryString["ReturnURL"] != null)
{
Response.Redirect(Request.QueryString["ReturnURL"]);
}
else
{
string[] roleUser = Roles.GetRolesForUser(UserName.ToString());
for (int i = 0; i < roleUser.Length; i++)
{
if (roleUser[i] == "admin")
{
Response.Redirect("ad/bilingual/");
}
else
{
Response.Redirect("~/");
}
}
}
}
else
{
lblErrorLogin.Text = "Đăng nhập không thành công, vui lòng thử lại.";
}
}
}
protected void Login1_LoggedIn(object sender, EventArgs e)
{
string UserName = Login1.UserName;
MembershipUser mu = Membership.GetUser(UserName);
//Session["PWD"] = Login1.Password;
if (Request.QueryString["ReturnURL"] != null)
{
Response.Redirect(Request.QueryString["ReturnURL"]);
}
else
{
string[] roleUser = Roles.GetRolesForUser(UserName.ToString());
for (int i = 0; i < roleUser.Length; i++)
{
if (roleUser[i] == "admin")
{
Response.Redirect("ad/bilingual/");
}
else
{
Session["UserName"] = UserName;
Session["IsLogin"] = true;
var oAddressBook = new AddressBook();
var a = oAddressBook.AddressBookSelectAll("", "", "", "", "", "", "", UserName, "", "", "", "", "", "", "", "", "", "", "", "member").DefaultView;
Session["FullNameUser"] = a[0]["FirstName"].ToString();
Response.Redirect("~/");
}
}
}
//if (Request.QueryString["ReturnURL"] != null)
//{
// Response.Redirect(Request.QueryString["ReturnURL"]);
//}
//else
//{
// Response.Redirect("~/");
//}
}
protected void btnBook_Click(object sender, EventArgs e)
{
if (IsValid)
{
var dtCart = Session["Cart"] as DataTable;
var oAddressBook = new AddressBook();
var dtAddressBook = oAddressBook.AddressBookSelectAll("", "", "", "", "", "", "", Session["UserName"].ToString(), "", "", "", "", "", "", "", "", "", "", "", "").DefaultView;
var txtFullName = dtAddressBook[0]["FirstName"].ToString();
var txtEmail = dtAddressBook[0]["Email"].ToString();
var txtAddress = dtAddressBook[0]["Address1"].ToString();
var txtPhuongXa = dtAddressBook[0]["Address2"].ToString();
var txtPhone = dtAddressBook[0]["HomePhone"].ToString();
var ddlProvince = dtAddressBook[0]["ProvinceName"].ToString();
var ddlDistrict = dtAddressBook[0]["DistrictName"].ToString();
if (dtCart != null)
{
Session["HoanThanh"] = "true";
string CreateBy = "admin";
string OrderNumber = DateTime.Now.ToString("ddMMyy") + Guid.NewGuid().GetHashCode().ToString("X").Substring(0, 4);
//Session["OrderNumber"] = OrderNumber;
string Email = "";
string FirstName = "";
string Address = "";
string PhoneNumber = "";
double TotalPrice = 0;
double SumTotalPrice = 0;
string PaymentMethods = "";
string OrderQuantity = "0";
string OrderStatusID = "";
Session["OrderNumber"] = OrderNumber;
Email = txtEmail;
FirstName = txtFullName;
Address = txtAddress + " ," + txtPhuongXa + " ," + ddlProvince + " ," + ddlDistrict;
// City = txtTinh.Text.Trim().ToString();
PhoneNumber = txtPhone;
//TotalPrice = Session["tongtien"].ToString();
//OrderQuantity = Session["Quantity"].ToString();
OrderStatusID = "1";
PaymentMethods = "Thanh Toán Trực Tiếp";
string Price = "0";
// them don hang
var oOrders = new Orders2();
oOrders.Orders2Insert(
OrderNumber,
CreateBy,
DateTime.Now.ToString("MM/dd/yyyy"),
PaymentMethods,
FirstName,
Address,
PhoneNumber,
"",
Email,
OrderStatusID);
// don hang chi tiet
var oOrderDetail = new OrderDetail2();
foreach (DataRow dr in dtCart.Rows)
{
string ProductID = dr["ProductID"].ToString();
var Quantity = Convert.ToInt32(dr["Quantity"]);
if (dr["ProductPrice"] != null)
{
Price = (Convert.ToInt32(dr["Quantity"]) * (Convert.ToDouble(string.IsNullOrEmpty(dr["ProductPrice"].ToString()) ? 0 : dr["ProductPrice"]))).ToString();
}
if (Session["UserName"] != null)
{
CreateBy = Session["UserName"].ToString();
}
oOrderDetail.OrderDetail2Insert(
OrderNumber,
ProductID,
Quantity.ToString(),
Price,
CreateBy
);
}
// hinh thuc thanh toan
if (rbtMoney.Checked == true)
{
string FullName = FirstName;
Session["FullName"] = FullName;
Session["Address"] = Address;
PaymentMethods = "Thanh Toán Trực Tiếp";
// noi dung mail xac nhan
string Body = "<div style='width: 100%; font-size: 14px; font-family: Arial;'>";
Body += "<h3 style='color: rgb(204,102,0); font-size: 22px; border-bottom-color: gray; border-bottom-width: 1px;border-bottom-style: dashed; margin-bottom: 20px; font-family: Times New Roman;'>Cảm ơn bạn đã đặt hàng/Thanks for Your Order!</h3>";
Body += "<div style='padding: 10px; background-color: rgb(255,244,234); font-family: Verdana;font-size: 11px; margin-bottom: 20px;'>";
Body += "<p>Mã số đơn hàng của bạn là <b>" + Session["OrderNumber"] + "</b>. Chi tiết đơn hàng được liệt kê ở phía dưới. </p>";
Body += "</div>";
Body += "<p><b>Người nhận</b></p>";
Body += "<p>Họ và tên: " + txtFullName + "</p>";
Body += "<p>Email: " + txtEmail + "</p>";
Body += "<p>Điện thoại: " + txtPhone + "</p>";
Body += "<p>Địa chỉ: " + txtAddress + "</p>";
//Body += "<p>Loại địa chỉ: " + dropLoaiDiaChi.SelectedItem.Text + "</p>";
Body += "<p>Tỉnh/Thành phố: " + ddlProvince + "</p>";
Body += "<p>Quận/Huyện: " + ddlDistrict + "</p>";
Body += "<p>Ghi chú: " + txtGhiChu.Text + "</p>";
Body += "</div>";
Body += "<p><b>* Phương thức thanh toán</b>: " + PaymentMethods + "</p>";
Body += "<table style='font-size: 11px; font-family: Verdana; padding: 10px; border: 1px solid #C7D7DB; width: 100%;border-collapse: collapse;' cellpadding='0' cellspacing='0'>";
//Body += "<tr><th align='left' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Sản phẩm/Cart Items</th><th style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Cỡ/Size</th><th style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Số lượng/Qty</th><th align='center' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Giá/Item Price</th><th align='right' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Thành tiền/Item Total</th></tr>";
Body += "<tr><th align='left' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Sản phẩm/Cart Items</th><th style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Số lượng/Qty</th><th align='center' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Giá/Item Price</th><th align='right' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Thành tiền/Item Total</th></tr>";
foreach (DataRow dr in dtCart.Rows)
{
//string ProductCode = dr["Tag"].ToString();
string ProductID = dr["ProductID"].ToString();
string ProductName = dr["ProductName"].ToString();
string Quantity = dr["Quantity"].ToString();
Price = dr["ProductPrice"].ToString();
//string ProductOptionCategoryName = dr["ProductOptionCategoryName"].ToString();
// string ProductLengthName = dr["ProductLengthName"].ToString();
double tPrice = Convert.ToDouble(Price) * Convert.ToDouble(Quantity);
var itemPrice = string.Format("{0:##,###.##}", tPrice).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ";
var sPrice = string.Format("{0:##,###.##}", dr["ProductPrice"]).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ";
//Amount += Convert.ToDouble(Price) * Convert.ToDouble(Quantity);
Body += "<tr>";
Body += "<td style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + ProductName + "</td>";
//Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + ProductCode + "</td>";
//Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + ProductLengthName + "</td>";
//Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'><div style='background: " + ProductOptionCategoryName + "; width: 30px; height: 30px;'></div></td>";
Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + Quantity + "</td>";
Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + sPrice + "</td>";
Body += "<td align='right' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + itemPrice + "</td>";
Body += "</tr>";
TotalPrice += tPrice;
}
if (!string.IsNullOrEmpty(hdnSavePrice.Value))
{
SumTotalPrice = TotalPrice - Convert.ToDouble(hdnSavePrice.Value);
}
else
{
SumTotalPrice = TotalPrice;
}
Body += "</table>";
Body += "<div style='clear: both;'></div>";
Body += "<table style='font-size: 13px; font-family: Verdana; text-align: right; margin: 10px 0; width: 100%; float: right;' cellpadding='0' cellspacing='0'>";
Body += "<tr><td style='width:85%;'>Thành tiền:</td><td style='width:15%;'>" + string.Format("{0:##,###.##}", TotalPrice).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ" + "</td></tr>";
Body += "<tr><td>Giảm:</td><td>" + string.Format("{0:##,###.##}", Convert.ToDouble(hdnSavePrice.Value)).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ" + "</td></tr>";
Body += "<tr><td><b>Tổng tiền:</b></td><td><b>" + string.Format("{0:##,###.##}", SumTotalPrice).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ" + "</b></td></tr>";
Body += "</table>";
Body += "<div style='clear: both;'></div>";
Common.SendMail("smtp.gmail.com", 587, "*****@*****.**", "web123master", txtEmail, "*****@*****.**", "Đặt Hàng PALACIO PERFUME", Body, true);
/////////////////////////////////////////////////////////////////////////////////
//txtFullName.Text = "";
//txtPhone.Text = "";
//txtEmail.Text = "";
//txtAddress.Text = "";
txtGhiChu.Text = "";
lblSavePrice.Text = "";
hdnSavePrice.Value = "";
var oShoppingCart = new ShoppingCart();
oShoppingCart.DeleteAllItem();
Session["Cart"] = null;
Session["SavePrice"] = null;
ListView2.DataBind();
Response.Redirect("dat-hang-thanh-cong.aspx");
}
else if (rbtEmail.Checked == true)
{
string FullName = FirstName;
Session["FullName"] = FullName;
Session["Address"] = Address;
PaymentMethods = "Thanh Toán Chuyển Khoản";
oOrders.Orders2Update(
OrderNumber,
CreateBy,
DateTime.Now.ToString("MM/dd/yyyy"),
PaymentMethods,
FirstName,
Address,
PhoneNumber,
"",
Email,
OrderStatusID);
// noi dung mail xac nhan
string Body = "<div style='width: 100%; font-size: 14px; font-family: Arial;'>";
Body += "<h3 style='color: rgb(204,102,0); font-size: 22px; border-bottom-color: gray; border-bottom-width: 1px;border-bottom-style: dashed; margin-bottom: 20px; font-family: Times New Roman;'>Cảm ơn bạn đã đặt hàng/Thanks for Your Order!</h3>";
Body += "<div style='padding: 10px; background-color: rgb(255,244,234); font-family: Verdana;font-size: 11px; margin-bottom: 20px;'>";
Body += "<p>Mã số đơn hàng của bạn là <b>" + Session["OrderNumber"] + "</b>. Chi tiết đơn hàng được liệt kê ở phía dưới. </p>";
Body += "</div>";
Body += "<p><b>Người nhận</b></p>";
Body += "<p>Họ và tên: " + txtFullName + "</p>";
Body += "<p>Email: " + txtEmail + "</p>";
Body += "<p>Điện thoại: " + txtPhone + "</p>";
Body += "<p>Địa chỉ: " + txtAddress + "</p>";
//Body += "<p>Loại địa chỉ: " + dropLoaiDiaChi.SelectedItem.Text + "</p>";
Body += "<p>Tỉnh/Thành phố: " + ddlProvince + "</p>";
Body += "<p>Quận/Huyện: " + ddlDistrict + "</p>";
Body += "<p>Ghi chú: " + txtGhiChu.Text + "</p>";
Body += "</div>";
Body += "<p><b>* Phương thức thanh toán</b>: " + PaymentMethods + "</p>";
Body += "<table style='font-size: 11px; font-family: Verdana; padding: 10px; border: 1px solid #C7D7DB; width: 100%;border-collapse: collapse;' cellpadding='0' cellspacing='0'>";
//Body += "<tr><th align='left' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Sản phẩm/Cart Items</th><th style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Cỡ/Size</th><th style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Số lượng/Qty</th><th align='center' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Giá/Item Price</th><th align='right' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Thành tiền/Item Total</th></tr>";
Body += "<tr><th align='left' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Sản phẩm/Cart Items</th><th style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Số lượng/Qty</th><th align='center' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Giá/Item Price</th><th align='right' style='padding: 8px 5px; border-collapse: collapse; background-color: rgb(2,11,111);color: #fff;'>Thành tiền/Item Total</th></tr>";
foreach (DataRow dr in dtCart.Rows)
{
//string ProductCode = dr["Tag"].ToString();
string ProductID = dr["ProductID"].ToString();
string ProductName = dr["ProductName"].ToString();
string Quantity = dr["Quantity"].ToString();
Price = dr["Price"].ToString();
//string ProductOptionCategoryName = dr["ProductOptionCategoryName"].ToString();
//string ProductLengthName = dr["ProductLengthName"].ToString();
double tPrice = Convert.ToDouble(Price) * Convert.ToDouble(Quantity);
var itemPrice = string.Format("{0:##,###.##}", tPrice).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VND";
var sPrice = string.Format("{0:##,###.##}", dr["ProductPrice"]).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VND";
//Amount += Convert.ToDouble(Price) * Convert.ToDouble(Quantity);
Body += "<tr>";
Body += "<td style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + ProductName + "</td>";
//Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + ProductCode + "</td>";
//Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + ProductLengthName + "</td>";
//Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'><div style='background: " + ProductOptionCategoryName + "; width: 30px; height: 30px;'></div></td>";
Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + Quantity + "</td>";
Body += "<td align='center' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + sPrice + "</td>";
Body += "<td align='right' style='padding: 5px; border-collapse: collapse; border-bottom: 1px solid #C7D7DB;'>" + itemPrice + "</td>";
Body += "</tr>";
TotalPrice += tPrice;
}
if (!string.IsNullOrEmpty(hdnSavePrice.Value))
{
SumTotalPrice = TotalPrice - Convert.ToDouble(hdnSavePrice.Value);
}
else
{
SumTotalPrice = TotalPrice;
}
Body += "</table>";
Body += "<div style='clear: both;'></div>";
Body += "<table style='font-size: 13px; font-family: Verdana; text-align: right; margin: 10px 0; width: 100%; float: right;' cellpadding='0' cellspacing='0'>";
Body += "<tr><td style='width:85%;'>Thành tiền:</td><td style='width:15%;'>" + string.Format("{0:##,###.##}", TotalPrice).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ" + "</td></tr>";
Body += "<tr><td>Giảm:</td><td>" + string.Format("{0:##,###.##}", Convert.ToDouble(hdnSavePrice.Value)).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ" + "</td></tr>";
Body += "<tr><td><b>Tổng tiền:</b></td><td><b>" + string.Format("{0:##,###.##}", SumTotalPrice).Replace('.', '*').Replace(',', '.').Replace('*', ',') + " VNĐ" + "</b></td></tr>";
Body += "</table>";
Body += "<div style='clear: both;'></div>";
Common.SendMail("smtp.gmail.com", 587, "*****@*****.**", "web123master", txtEmail, "*****@*****.**", "Đặt Hàng PALACIO PERFUME", Body, true);
/////////////////////////////////////////////////////////////////////////////////
//txtFullName.Text = "";
//txtPhone.Text = "";
//txtEmail.Text = "";
//txtAddress.Text = "";
lblSavePrice.Text = "";
hdnSavePrice.Value = "";
txtGhiChu.Text = "";
var oShoppingCart = new ShoppingCart2();
oShoppingCart.DeleteAllItem();
Session["Cart"] = null;
Session["SavePrice"] = null;
ListView2.DataBind();
Response.Redirect("dat-hang-thanh-cong.aspx");
}
}
}
}
