public void AddDetailOrder() { DetailOrder detail = new DetailOrder(); detail.ListProduct = listOrder; detail.Add(); }
public void AddToListbox(string Size, string Amount, int index)//Productname, Priceproduct, Size, Amount { Product product = new Product(); ItemOrder itemorder = new ItemOrder(); DetailOrder detail = new DetailOrder(); product.Find((index + 1).ToString()); //thành tiền sản phẩm int totalprice = int.Parse(product.Price) * int.Parse(Amount); itemorder.PriceTotal = totalprice.ToString(); itemorder.Quantity = Amount; itemorder.Image = product.Image; itemorder.ProductName = product.ProductName; itemorder.IdProduct = (index + 1).ToString(); itemorder.Size = Size; detail.ListProduct.Add(itemorder); sum += totalprice; //binding OrderedList.Insert(0, detail.ListProduct); listOrder.Add(itemorder); //binding tổng tiền TotalPriceProductsTextblock = sum.ToString(); //gán để binding xóa item trong listbox DetailListbox.ListProduct.Insert(0, itemorder); }
public object Save([FromBody] DetailOrder detailOrder) { string sql = ""; if (detailOrder.Weight == 0) { detailOrder.Weight = 1; } detailOrder.ShouldPrice = detailOrder.SinglePrice * detailOrder.Weight; if (detailOrder.Id > 0) { sql = $@"UPDATE DetailOrder SET MenuId=@MenuId, SinglePrice=@SinglePrice, Weight=@Weight, ShouldPrice=@ShouldPrice WHERE Id = @Id"; } else { sql = $@"INSERT INTO DetailOrder(MenuId, SinglePrice, Weight, ShouldPrice, OrderId) VALUES(@MenuId, @SinglePrice, @Weight, @ShouldPrice, @OrderId)"; } var xresult = new XResult(); if (!XDataHelper.ExcuteNonQuery(sql, detailOrder)) { xresult.code = 10000; xresult.message = "操作失败!"; } ; return(xresult); }
public ActionResult SaveOrder(Customer model) { List <CartItem> sp = GetCart(); int id = model.Id; //Tạo đơn hàng Order order = new Order(); order.CustomerId = id; order.DateTime = DateTime.Now; _dbContext.Orders.Add(order); _dbContext.SaveChanges(); //Chi tiết đơn hàng foreach (var item in sp) { DetailOrder detailOrder = new DetailOrder(); detailOrder.OrderId = order.Id; detailOrder.ProductId = item.Product.Id; detailOrder.Amount = item.Amount; _dbContext.DetailOrders.Add(detailOrder); } _dbContext.SaveChanges(); Session["ShoppingCart"] = null; //return Content("<script>alert('Đơn hàng đặt thành công, chúng tôi sẽ liên hệ lại sau')</script>"); return(RedirectToAction("Index", "Home")); }
//[Authorize(Roles = "AddUser")] //[Permission(Action = "Create", Function = "USER")] public HttpResponseMessage Create(HttpRequestMessage request, OrderViewModel orderVm) { if (ModelState.IsValid) { var newOrder = new DetailOrder(); newOrder.UpdateOrder(orderVm); try { var listOrderDetails = new List <OrderDetail>(); foreach (var item in orderVm.OrderDetails) { listOrderDetails.Add(new OrderDetail() { ProductID = item.ProductID, Quantity = item.Quantity, Price = item.Price, }); } newOrder.OrderDetails = listOrderDetails; var result = _orderService.Create(newOrder); var model = Mapper.Map <DetailOrder, OrderViewModel>(result); return(request.CreateResponse(HttpStatusCode.OK, model)); } catch (Exception ex) { return(request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } } else { return(request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
public bool InsertDetailOrder(List <DetailOrdersDTO> dto, int orderId) { var temp = db.OrderTbls.Find(orderId); if (temp != null) { if (dto != null) { foreach (var i in dto) { DetailOrder dtop = new DetailOrder(); dtop.orderID = orderId; dtop.bookID = i.BookId; dtop.quantityBorrowed = i.QuantityBorrowed; db.DetailOrders.Add(dtop); Book b = db.Books.Find(i.BookId); b.quantity -= i.QuantityBorrowed; db.Entry(b).State = EntityState.Modified; } db.SaveChanges(); } return(true); } else { return(false); } }
public async Task <ActionResult> DeleteConfirmed(decimal id) { DetailOrder detailOrder = await db.DetailOrders.FindAsync(id); db.DetailOrders.Remove(detailOrder); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <IActionResult> DeleteConfirmed(int id) { var order = await _context.Orders .Include(o => o.User) .Include(o => o.Customer) .Include(o => o.DetailOrders) .ThenInclude(i => i.Product) .FirstOrDefaultAsync(o => o.ID == id); try { foreach (var i in order.DetailOrders) { i.Product.SoLuong += i.SoLuong; _context.Products.Update(i.Product); } _context.Orders.Remove(order); var user = await _userManager.GetUserAsync(User); var orderChange = new OrderChange { ThoiGian = DateTime.Now, UserName = user.UserName, HanhDong = "Xóa", OrderID = order.ID }; _context.OrderChanges.Add(orderChange); await _context.SaveChangesAsync(); TempData["messageSuccess"] = $"Đơn hàng \"{order.ID}\" đã xóa"; return(RedirectToAction("Index")); } catch { var model = new OrderViewModel { ID = order.ID, ThoiGianTao = order.ThoiGianTao, UserName = order.User.Ten, CustomerName = order.Customer.Ten }; foreach (var item in order.DetailOrders) { var itemVM = new DetailOrder { Gia = item.Gia, SoLuong = item.SoLuong, Product = item.Product }; model.DetailOrders.Add(itemVM); } ModelState.AddModelError(string.Empty, "Đã xảy ra lỗi trong quá trình xóa đơn hàng, vui lòng thử lại vào thời gian khác!"); return(View(model)); } }
public async Task <ActionResult> storeDetail(DetailOrder model) { var status = await _Order.postDetail(model); if (status == true) { return(Ok()); } return(BadRequest()); }
public static void UpdateOrder(this DetailOrder order, OrderViewModel orderVm) { order.CustomerMessage = orderVm.CustomerMessage; order.PaymentMethod = orderVm.PaymentMethod; order.CreatedDate = DateTime.Now; order.CreatedBy = orderVm.CreatedBy; order.PaymentStatus = orderVm.PaymentStatus; order.Status = orderVm.Status; order.CustomerId = orderVm.CustomerId; }
public async Task CreateDetailOrderAsync(int productId, int orderId, int amount, double total) { DetailOrder detailOrder = new DetailOrder { ProductId = productId, Amount = amount, OrderId = orderId, Total = total }; await _repository.CreateDetailOrderAsync(detailOrder); }
public async Task <ActionResult> Edit([Bind(Include = "ID,IdOrder,Teeth,BuccalMargin,LingualMargin,BuccalTissue,Compression,AbutmentsParallel,Note,IdProduct,Contact,Oclussion,Material,Shade,DesignRequirements,ModelServices,ArticulatorType,ModelImplantConnection")] DetailOrder detailOrder) { if (ModelState.IsValid) { db.Entry(detailOrder).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.IdOrder = new SelectList(db.Orders, "ID", "Name", detailOrder.IdOrder); return(View(detailOrder)); }
public DetailOrderViewModel(DetailOrder d) { this.OrderID = d.OrderID; this.BookName = d.Book.Title; this.Quantity = d.Quantity; this.Price = (float)d.Book.Price; this.RecipientName = d.Order.RecipientName; this.RecipientPhone = d.Order.RecipientPhone; this.RecipientAddress = d.Order.RecipientAddress; this.Status = d.Order.StatusObject.Name; this.OrderNote = d.Order.OrderNote; }
public DetailOrder Create(DetailOrder order) { try { _orderRepository.Add(order); _unitOfWork.Commit(); return(order); } catch (Exception ex) { throw; } }
public bool Insert(DetailOrder detail) { try { data.DetailOrders.Add(detail); data.SaveChanges(); return(true); } catch { return(false); } }
// GET: DetailOrders/Details/5 public async Task <ActionResult> Details(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DetailOrder detailOrder = await db.DetailOrders.FindAsync(id); if (detailOrder == null) { return(HttpNotFound()); } return(View(detailOrder)); }
public async Task <bool> postDetail(DetailOrder model) { _context.DetailOrders.Add(model); _context.SaveChanges(); var Product = _context.Products.FirstOrDefault(m => m.ProductId == model.ProductId); Product.Quantity = Product.Quantity - model.Quantity; var status = await _context.SaveChangesAsync(); if (status > 0) { return(true); } return(false); }
// GET: DetailOrders/Edit/5 public async Task <ActionResult> Edit(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DetailOrder detailOrder = await db.DetailOrders.FindAsync(id); if (detailOrder == null) { return(HttpNotFound()); } ViewBag.IdOrder = new SelectList(db.Orders, "ID", "Name", detailOrder.IdOrder); return(View(detailOrder)); }
public DataRespond update(DetailOrder detailOrder) { DataRespond data = new DataRespond(); try { data.success = true; m_detailOrder.update(detailOrder); data.messger = "Insert success"; } catch (Exception e) { data.success = false; data.error = e; data.messger = e.Message; } return(data); }
public void ThemDonHang() { Order or = new Order(); or.DateSet = DateTime.Now; or.DateDelivery = DateTime.Now.Date.AddDays(5); or.UserName = Session["UserName"].ToString(); or.Address = txtDCNN.Text; or.Phone = txtSDTNN.Text; or.Email = txtEmailNN.Text; or.RecipientName = txtTenNN.Text; if (rdTTTT.Checked == true) { or.PaymentID = "PT1"; } if (rdTTQuaThe.Checked == true) { or.PaymentID = "PT2"; } or.State = 0; db.Orders.InsertOnSubmit(or); db.SubmitChanges(); var c = from p in db.Orders select p.OrderID; ShoppingCart gio = (ShoppingCart)Session["GioHang"]; for (int i = 0; i < gio.Data.Rows.Count; i++) { DetailOrder dto = new DetailOrder(); int mahd = 0; foreach (var con in c) { mahd = con; } dto.OrderID = mahd; dto.ProductID = gio.Data.Rows[i][0].ToString(); dto.Number = int.Parse(gio.Data.Rows[i][2].ToString()); db.DetailOrders.InsertOnSubmit(dto); db.SubmitChanges(); } }
public ActionResult Checkout(string Name, string Address, string Phone, string Email) { var order = new Order(); //User user = (User)Session["Account"]; //order.IDUser = user.IDUser; order.Name = Name; order.Email = Email; order.Address = Address; order.Phone = Phone; order.DateOrder = DateTime.Now; order.DateDelivery = DateTime.Now.AddDays(3); var id = new OrderDAO().Insert(order); var cart = (List <CartModel>)Session[CartSession]; var detailDao = new DetailOrderDAO(); decimal total = 0; foreach (var item in cart) { var orderDetail = new DetailOrder(); orderDetail.IDProduct = item.Product.IDProduct; orderDetail.IDOrder = id; orderDetail.UnitPrice = item.Product.Price; orderDetail.Quantity = item.Quantity; detailDao.Insert(orderDetail); total += (item.Product.Price.GetValueOrDefault(0) * item.Quantity); ViewBag.ToTal = total; } string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/client/template/neworder.html")); content = content.Replace("{{CustomerName}}", Name); content = content.Replace("{{Phone}}", Phone); content = content.Replace("{{Email}}", Email); content = content.Replace("{{Address}}", Address); content = content.Replace("{{Total}}", ViewBag.ToTal.ToString("N0")); //var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString(); //new MailHelper().SendMail(order.Email, "new order", content); //new MailHelper().SendMail(toEmail, "new order", content); return(Redirect("InformationOrder")); }
/// <summary> /// Adds the detail order. /// </summary> /// <param name="item">detail order item</param> /// <returns>Add Detail Order</returns> public bool AddDetailOrder(DetailOrder item) { using (var data = new Entities()) { bool rt; try { data.DetailOrders.Add(item); data.SaveChanges(); rt = true; } catch (Exception) { rt = false; } return(rt); } }
public bool insert(Order entity, DetailOrder[] items) { try { entity.CreatedAt = DateTime.Now; entity.Status = false; db.Orders.Add(entity); db.SaveChanges(); foreach (DetailOrder item in items) item.OrderId = entity.id; db.DetailOrders.AddRange(items); db.SaveChanges(); return true; } catch { return false; } }
public async Task <IActionResult> Delete(int?id) { if (id == 0) { return(NotFound()); } var order = await _context.Orders .Include(o => o.User) .Include(o => o.Customer) .Include(o => o.DetailOrders) .ThenInclude(i => i.Product) .AsNoTracking() .FirstOrDefaultAsync(o => o.ID == id); if (order == null) { return(NotFound()); } var model = new OrderViewModel { ID = order.ID, ThoiGianTao = order.ThoiGianTao, UserName = order.User.Ten, CustomerName = order.Customer.Ten }; foreach (var item in order.DetailOrders) { var itemVM = new DetailOrder { Gia = item.Gia, SoLuong = item.SoLuong, Product = item.Product }; model.DetailOrders.Add(itemVM); } return(View(model)); }
public int CreateOrder(Order order, string id) { decimal orderTotal = 0; var cartItem = GetCartItems(id); foreach (var item in cartItem) { var orderDetail = new DetailOrder { ItemId = item.ItemId, OrderId = order.OrderId, UnitPrice = item.Item.Price, Quantity = item.Count }; orderTotal += (item.Count * item.Item.Price); context.DetailOrders.Add(orderDetail); } order.Total = orderTotal; EmtyCart(id); context.SaveChanges(); return(order.OrderId); }
public async Task <string> Handle(CreateOrderCommand request, CancellationToken cancellationToken) { var idOrder = Guid.NewGuid(); var entityOrder = new Order { EmailUser = request.EmailUser, StatusOrder = 0, IdOrder = idOrder, TanggalOrder = DateTime.Now, }; Context.Orders.Add(entityOrder); List <DetailOrder> records = new List <DetailOrder> (); foreach (var data in request.IdProducts) { var newRecord = new DetailOrder { IdDetailOrder = Guid.NewGuid(), IdOrder = idOrder, IdProducts = data.IdProducts, TotalProducts = data.TotalProducts }; var entity = Context.Products.Where(x => x.IdProduct == data.IdProducts).FirstOrDefault(); entity.Stock = entity.Stock - data.TotalProducts; records.Add(newRecord); } await Context.DetailOrders.AddRangeAsync(records, cancellationToken); await Context.SaveChangesAsync(true, cancellationToken); return("Sukses"); }
public void Update(DetailOrder detailOrder) { _orderRepository.Update(detailOrder); }
/// <summary> /// Removes the specified it. /// </summary> /// <param name="detailOder">detail order</param> public void Remove(DetailOrder detailOder) { this.listOrderDetail.Remove(detailOder); }
public async Task CreateDetailOrderAsync(DetailOrder detailOrder) { _context.DetailOrders.Add(detailOrder); await _context.SaveChangesAsync(); }
/// <summary> /// Adds the specified detail order. /// </summary> /// <param name="detailOrder">detail order.</param> public void Add(DetailOrder detailOrder) { this.listOrderDetail.Add(detailOrder); }
/// <summary> /// 得到一个店铺的订单 /// </summary> /// <param name="accid"></param> /// <returns></returns> public static DetailOrder GetAccountOrder(int accid) { List <dynamic> orderList = T_OrderInfoBLL.GetListByAccId(accid); string str = ""; OrderItemProp propModel = new OrderItemProp(); DetailOrder orderModel = new DetailOrder(); foreach (dynamic item in orderList) { str = item.orderPayType.ToString(); switch (str) { case "0": item.orderPayType = "平台订单"; break; case "1": item.orderPayType = "线下订单"; break; case "2": item.orderPayType = "支付宝"; break; case "3": item.orderPayType = "财付通"; break; case "4": item.orderPayType = "快钱"; break; case "5": item.orderPayType = "微信支付"; break; case "6": item.orderPayType = "IOS支付"; break; case "7": item.orderPayType = "安卓支付"; break; } if (item.orderTypeId != 2) { OrderItemProp tempModel = T_Order_businessBLL.GetListItemProps(Convert.ToInt32(item.busId), accid); if (propModel.isFreeSms == 1 && tempModel.isFreeSms == 1) { propModel.Profit += Convert.ToDouble(item.RealPayMoney); propModel.SumMoney += Convert.ToDouble(item.RealPayMoney); } else { propModel.Cost += tempModel.Cost; propModel.Profit += Convert.ToDouble(item.RealPayMoney); propModel.SumMoney += Convert.ToDouble(item.RealPayMoney) - tempModel.Cost; propModel.isFreeSms = tempModel.isFreeSms; } } else { propModel.Cost += Convert.ToDouble(item.busSumMoney); propModel.Profit += Convert.ToDouble(item.RealPayMoney); propModel.SumMoney += Convert.ToDouble(item.RealPayMoney) - Convert.ToDouble(item.busSumMoney); } } propModel.Cost = Math.Round(propModel.Cost, 2); propModel.Profit = Math.Round(propModel.Profit, 2); propModel.SumMoney = Math.Round(propModel.SumMoney, 2); orderModel.DataList = orderList; orderModel.SumInfo = propModel; return(orderModel); }