private void btnManageFunds_Click(object sender, EventArgs e) { OrderDataAccess ordersDA = new OrderDataAccess(); OrderDetailDataAccess detailsDA = new OrderDetailDataAccess(); mlvOrders.Items.Clear(); decimal loss = 0, profit = 0; foreach (var order in ordersDA.GetList()) { ListViewItem item = new ListViewItem(order.OrderID.ToString()); item.SubItems.Add(order.CustomerID.ToString()); item.SubItems.Add(order.OrderDate.ToLongTimeString()); item.SubItems.Add(order.OrderState.ToString()); if (detailsDA.GetList().Where(d => d.OrderID == order.OrderID).ToList().Count > 0) { foreach (var orderDetails in detailsDA.GetList().Where(d => d.OrderID == order.OrderID).ToList()) { item.SubItems.Add(orderDetails.Loss + "$"); loss += orderDetails.Loss; item.SubItems.Add(orderDetails.Profit + "$"); profit += orderDetails.Profit; } } else { item.SubItems.Add("---- $"); item.SubItems.Add("---- $"); } mlvOrders.Items.Add(item); } lblLoss.Text = loss.ToString() + "$"; lblProfit.Text = profit.ToString() + "$"; if ((profit - loss) > 0) { lblBalance.ForeColor = Color.SeaGreen; lblBalance.Text = (profit - loss).ToString() + "$"; } else { lblBalance.ForeColor = Color.Red; lblBalance.Text = (loss - profit).ToString() + "$"; } pnlManageFunds.Visible = true; pnlManageFunds.BringToFront(); }
public int DeleteExistingOrder(int orderId) { int result = 0; try { var orderDetail = dataDetailAccess.GetOrderDetailListByOrderId(orderId); if (orderDetail.Count > 0) { dataDetailAccess = new OrderDetailDataAccess(); dataDetailAccess.DeleteOrderDetailByOrderId(orderId); } result = orderDataAccess.DeleteExistingOrder(orderId); } catch (Exception ex) { // } return(result); }
public OrderManager() { orderDataAccess = new OrderDataAccess(); customerDataAccess = new CustomerDataAccess(); dataDetailAccess = new OrderDetailDataAccess(); }
public ActionResult Payment(string shipName, string mobile, string address, string email) { //Lấy data, kiểu data là Order var order = new Order(); order.ShipName = shipName; order.ShipMobile = mobile; order.ShipAddress = address; order.ShipEmail = email; //Insert data vừa lấy vào bảng Order var id = new OrderDataAccess().Insert(order); //// var OrderDetail = new OrderDetailDataAccess(); //Lấy data từ session hiện tại var cart = Session[CartSession]; var list = new List <CartItem>(); //// if (cart != null) { list = (List <CartItem>)cart; } decimal total = 0; decimal totalAll = 0; var listProduct = new List <string>(); string product = ""; //Them data vào bảng OrderDetail foreach (var item in list) { var detail = new OrderDetail(); detail.ProductID = item.Product.ID; detail.OrderID = id; detail.Quantity = item.Quantity; detail.Price = item.Product.Price; OrderDetail.Insert(detail); total = item.Product.Price.GetValueOrDefault(0) * item.Quantity; product += "Sản phẩm:" + item.Product.Name + '\n' + "Số lượng:" + item.Quantity + Environment.NewLine + "Giá:" + item.Product.Price + Environment.NewLine + "Thành tiền:" + item.Product.Price * item.Quantity + Environment.NewLine; listProduct.Add(product); product = ""; totalAll += total; } //Tạo đơn hàng email string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Client/template/neworder.html")); content = content.Replace("{{CustomerName}}", shipName); content = content.Replace("{{Phone}}", mobile); content = content.Replace("{{Email}}", email); content = content.Replace("{{Address}}", address); string listProductEmail = ListProductEmail(listProduct); content = content.Replace("{{Product}}", listProductEmail); content = content.Replace("{{Total}}", totalAll.ToString()); //content = content.Replace("{{Product}}", listProduct[0]); //gửi đến Admin var toEmailAdmin = ConfigurationManager.AppSettings["ToEmailAddress"].ToString(); new MailHelper().SendMail(toEmailAdmin, "Đơn hàng mới từ BookShop", content); //gửi đến người mua var toEmailCustomer = email; new MailHelper().SendMail(toEmailCustomer, "Đơn hàng mới từ BookShop", content); /// return(Redirect("/hoan-thanh")); }