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) { } }