protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cancel") { OrderDBO db_handler = new OrderDBO(); Order ord = new Order(); ord.OrderID = Convert.ToInt16(e.CommandArgument); db_handler.cancelOrder(ord); } }
public OrderVM(OrderDBO row) { Id = row.Id; Name = row.Name; Number = row.Number; Mail = row.Mail; City = row.City; Addres = row.Addres; Post = row.Post; Note = row.Note; Complete = row.Complete; }
public IActionResult Buy(OrderDBO model) { // //content = // //content.Replace("\\", string.Empty). // //Replace("|", string.Empty). // //Replace("(", string.Empty). // //Replace(")", string.Empty). // //Replace("[", string.Empty). // //Replace("]", string.Empty). // //Replace("*", string.Empty). // //Replace("?", string.Empty). // //Replace("}", string.Empty). // //Replace("{", string.Empty). // //Replace("^", string.Empty). // //Replace("+", string.Empty); if (ModelState.IsValid) { MailAddress from = new MailAddress("*****@*****.**", "Glorius new order"); MailAddress to = new MailAddress("*****@*****.**"); using (MailMessage message = new MailMessage(from, to)) using (SmtpClient smtp = new SmtpClient()) { message.Subject = "Новый заказ"; message.IsBodyHtml = true; message.Body = HtmlCart(model); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential(from.Address, "gloriusorder7878"); smtp.Send(message); } HttpContext.Session.Clear(); return(Redirect("/buy_")); } else { ModelState.AddModelError("", "Введен запрещенный символ"); return(Redirect("/cart")); } }
protected void Button1_Click(object sender, EventArgs e) { int neworderid = 0; OrderDBO db_handler = new OrderDBO(); Item obj = db_handler.itemDetails(TextBox1.Text); Response.Write("<script>alert('Item Price is" + obj.ItemPrice + "')</script>"); //System.Diagnostics.Debug.Write(obj.ItemPrice); if (obj.Quantity < Convert.ToInt16(TextBox2.Text)) { Response.Write("<script>alert('This quantity is not available for this item. Max available is " + obj.Quantity + "')</script>"); } else { Label7.Text = (Convert.ToDouble(obj.ItemPrice) * Convert.ToInt16(TextBox2.Text)).ToString(); Order ord = new Order(TextBox1.Text, Convert.ToInt16(TextBox2.Text), obj.ItemPrice * Convert.ToInt16(TextBox2.Text), TextBox3.Text, TextBox4.Text, TextBox5.Text); neworderid = db_handler.addOrder(ord); Response.Write("<script>alert('Order placed successfully. Order ID is " + neworderid + "')</script>"); } }
public string HtmlCart(OrderDBO model) { var cart = SessionHelper.Get <List <CartLine> >(HttpContext.Session, "cart"); string cartLine = ""; int total = 0; foreach (var item in cart) { int sum = 0; if (item.Product.Discount != 0) { sum = (item.Quantity * (int)item.Product.Discount); total = total + (item.Quantity * (int)item.Product.Discount); } else { sum = (item.Quantity * (int)item.Product.Price); total = total + (item.Quantity * (int)item.Product.Price); } cartLine += String.Format(@" <tr style=""text-align: center; border-bottom: 1px solid #000000""> <td>{0}</td> <td><a href=""glorious.com.ua/product/{0}"" style=""text-decoration: none;"">{1}</a></td> <td>{2}</td> <td>{3}</td> </tr>" , item.Product.ProductCode, item.Product.Name, item.Quantity.ToString(), sum.ToString("0.00")); } string result = String.Format(@"<table bgcolor=""#F7F7F7"" border=""0"" cellpadding=""0"" cellspacing=""0"" style=""margin:0; padding:0 "" width=""100%""> <tr style=""display: grid;""> <td height=""100%"" style=""margin: 10px""> <table style=""border-collapse: collapse; font-family: sans-serif; padding: 20px; box-shadow: 5px 5px 5px grey; background-color: #fff; margin: 0 auto;"" cellpadding=""10px""> <tr style=""background-color: #000000; color: #ffffff;""> <th>Code</th> <th>Name</th> <th>Quantity</th> <th>Sum</th> </tr> {0} <tr style=""border-bottom: 2px solid #000000""><td colspan=""4"" style=""font-weight: bold; text-align: right;"">Total: {1}</td></tr> </table> </td> <td height=""100%"" style=""margin: 10px""> <table style=""border-collapse: collapse; font-family: sans-serif; padding: 20px; box-shadow: 5px 5px 5px grey; background-color: #fff; margin: 0 auto;"" cellpadding=""10px""> <tr> <td>ФИО: </td> <td>{2}</td> </tr> <tr> <td>Телефон: </td> <td>{3}</td> </tr> <tr> <td>Email:</td> <td>{4}</td> </tr> <tr> <td>Город: </td> <td>{5}</td> </tr> <tr> <td>Служба доставки: </td> <td>{6}</td> </tr> <tr> <td>Адрес/отделение/почтовый индекс: </td> <td>{7}</td> </tr> <tr> <td>Дополнительная информация: </td> <td style=""max-width: 400px;"">{8}</td> </tr> </table> </td> </tr> </table>" , cartLine, total.ToString("0.00"), model.Name, model.Number, model.Mail, model.City, model.Addres, model.Post, model.Note); return(result); }