protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var strOrderStatusID = ((RadComboBox)row.FindControl("ddlOrderStatus")).SelectedValue;
if (e.CommandName == "PerformInsert")
{
var strOrderID = Guid.NewGuid().GetHashCode().ToString("X");
ObjectDataSource1.InsertParameters["Order2ID"].DefaultValue = strOrderID;
ObjectDataSource1.InsertParameters["OrderStatusID"].DefaultValue = strOrderStatusID;
ObjectDataSource1.InsertParameters["UserName"].DefaultValue = User.Identity.Name;
}
else
{
ObjectDataSource1.UpdateParameters["OrderStatusID"].DefaultValue = strOrderStatusID;
ObjectDataSource1.UpdateParameters["UserName"].DefaultValue = User.Identity.Name;
}
}
else if (e.CommandName == "QuickUpdate")
{
string OrderID, OrderStatusID;
var oOrder = new Orders2();
foreach (GridDataItem item in RadGrid1.Items)
{
OrderID = item.GetDataKeyValue("Order2ID").ToString();
OrderStatusID = ((RadComboBox)item.FindControl("ddlOrderStatus")).SelectedValue;
oOrder.Order2QuickUpdate(
OrderID,
OrderStatusID
);
}
}
}
protected void btnBookNoLogin_Click(object sender, EventArgs e)
{
if (IsValid)
{
var dtCart = Session["Cart"] as DataTable;
var txtFullName = txtFullName2.Text;
var txtEmail = txtEmail2.Text;
var txtAddress = txtAddress2.Text;
var txtPhuongXa = txtPhuongXa2.Text;
var txtPhone = txtPhone2.Text;
var ddlProvince = ddlProvince2.SelectedItem.Text;
var ddlDistrict = ddlDistrict2.SelectedItem.Text;
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);
/////////////////////////////////////////////////////////////////////////////////
txtFullName2.Text = "";
txtPhone2.Text = "";
txtEmail2.Text = "";
txtAddress2.Text = "";
txtGhiChu2.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);
/////////////////////////////////////////////////////////////////////////////////
txtFullName2.Text = "";
txtPhone2.Text = "";
txtEmail2.Text = "";
txtAddress2.Text = "";
lblSavePrice.Text = "";
hdnSavePrice.Value = "";
txtGhiChu2.Text = "";
var oShoppingCart = new ShoppingCart2();
oShoppingCart.DeleteAllItem();
Session["Cart"] = null;
Session["SavePrice"] = null;
ListView2.DataBind();
Response.Redirect("dat-hang-thanh-cong.aspx");
}
}
}
}
public void Load(DataGrid DatagridOrder, DataGrid DatagridOrderCepsa, BillingDataSet.OrdersSummariesDataTable TableOrders, DataGrid OrdersDataCepsa)
{
try
{
if (TableOrders.Rows.Count > 0)
{
Orders.Clear();
Orders2.Clear();
OrdersMoreDatas.Clear();
DataRow[] result;
BillingDataSet.OrdersSummariesDataTable Orders2Datatable = new BillingDataSet.OrdersSummariesDataTable();
Orders2Datatable = createSecondList();
foreach (BillingDataSet.OrdersSummariesRow row in TableOrders.Rows)
{
result = Orders2Datatable.Select("Reference ='" + row["reference"].ToString() + "'");
// el pedido de la grid se encuentra en los pedidos de cepsa
//miramos discrepancias si existen
if (result.Count() > 0)
{
/*
* var cellStyle = new Style { TargetType = typeof(DataGridCell) };
* var cellTrigger = new Trigger { Property = DataGridCell.IsSelectedProperty, Value = true };
* cellTrigger.Setters.Add(new Setter(DataGridCell.ForegroundProperty, System.Windows.Media.Brushes.Black));
* cellTrigger.Setters.Add(new Setter(DataGridCell.BackgroundProperty, System.Windows.Media.Brushes.LightGray));
* cellStyle.Triggers.Add(cellTrigger);
*
* DatagridOrder.CellStyle = cellStyle;
* DatagridOrderCepsa.CellStyle = cellStyle;
*/
//si hay discrepancias agregamos a las dos grid el dato
if (result[0]["reference"].ToString().Trim() != row["reference"].ToString().Trim() || result[0]["Address"].ToString().Trim() != row["Address"].ToString().Trim() || Convert.ToInt32(result[0]["RequestedAmount"].ToString().Trim()) != Convert.ToInt32(row["RequestedAmount"].ToString().Trim()))
{
//rellenamos primera grid
Orders.Add(row);
//rellenamos segunda grid
Orders2.Add(CreateRowOrderSummaries2(result));
//pintamos las discrepancias en las dos dataGrid
OrdersMoreDatas.Add(GetCompareMoreDataCepsa(row["reference"].ToString().Trim()));
//si la discrepancia es por la direccion
if (result[0]["Address"].ToString().Trim() != row["Address"].ToString().Trim())
{
//DataRowView axel = DatagridOrder.Items[0] as DataRowView;
//DataRow pedro = axel.Row;
//pintamos la letra de toda la columna
//DataGridColumn axel = DatagridOrder.Columns[1].GetCellContent(DatagridOrder.get);
//DataGridCell pedro;
DataGridCell cell = GetCell(0, 0, DatagridOrder);
cell.Background = new SolidColorBrush(Colors.Red);
// DatagridOrderCepsa.Columns[1].CellStyle = (Style)XamlServices.Parse("<Style xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" xmlns:x=\"http://schemas.microsoft.com/winfx/2006/xaml\" TargetType=\"{x:Type DataGridCell}\"> <Setter Property=\"Foreground\" Value=\"Green\"></Setter></Style>");
}
//si la discrepancia es por la cantidad
if (Convert.ToInt32(result[0]["RequestedAmount"].ToString().Trim()) != Convert.ToInt32(row["RequestedAmount"].ToString().Trim()))
{
DatagridOrder.Columns[2].CellStyle = (Style)XamlServices.Parse("<Style xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" xmlns:x=\"http://schemas.microsoft.com/winfx/2006/xaml\" Binding={Binding Reference} TargetType=\"{x:Type DataGridCell}\"> <Setter Property=\"Foreground\" Value=\"Green\"></Setter></Style>");
DataGridCell cell = GetCell(0, 0, DatagridOrder);
cell.Background = new SolidColorBrush(Colors.Red);
//DataRowView axel = DatagridOrder.Items[0] as DataRowView;
//DataRow pedro = axel.Row;
//pintamos la letra de toda la columna
//DatagridOrderCepsa.Columns[2].CellStyle = (Style)XamlServices.Parse("<Style xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" xmlns:x=\"http://schemas.microsoft.com/winfx/2006/xaml\" TargetType=\"{x:Type DataGridCell}\"> <Setter Property=\"Foreground\" Value=\"Green\"></Setter></Style>");
}
}
}
}
}
}
catch (Exception e)
{
}
}
