public ActionResult CancelDailyChicCutOrder(int OrderId) { Daily_ChicCut_OrderModel model = _context.Daily_ChicCut_OrderModel .Where(p => p.OrderId == OrderId) .FirstOrDefault(); var Resuilt = ""; if (model == null) { Resuilt = "Không tìm thấy đơn hàng yêu cầu !"; } else if (model.OrderStatusId == EnumDaily_ChicCut_OrderStatus.DaTinhTien) { using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand()) { cmd.CommandText = "usp_Daily_ChicCut_Order_Canceled"; cmd.Parameters.AddWithValue("@OrderId", model.OrderId); cmd.Parameters.AddWithValue("@CanceledDate", DateTime.Now); cmd.Parameters.AddWithValue("@CanceledUserId", CurrentUser.UserId); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } Resuilt = "success"; } return(Json(Resuilt, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(int OrderId, int PaymentMethodId) { Daily_ChicCut_OrderModel orderModel = _context.Daily_ChicCut_OrderModel.Where(p => p.OrderId == OrderId).FirstOrDefault(); if (orderModel != null) { orderModel.PaymentMethodId = PaymentMethodId; _context.Entry(orderModel).State = System.Data.Entity.EntityState.Modified; _context.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } else { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public ActionResult ConfirmToPreOrder(int PreOrderId, int HairTypeId, int OrderStatusId) { try { using (TransactionScope ts = new TransactionScope()) { #region #B1. Tạo OrderMaster và OrderDetail var PreOrderMaster = _context.Daily_ChicCut_Pre_OrderModel.Find(PreOrderId); List <Daily_ChicCut_OrderDetailViewModel> LstOrderDetail = GetListOrderDetail(HairTypeId, PreOrderId); Daily_ChicCut_OrderModel modelOrder = GetOrderMaster(PreOrderMaster, LstOrderDetail, HairTypeId, OrderStatusId); _context.Entry(modelOrder).State = System.Data.Entity.EntityState.Added; _context.SaveChanges(); //Duyệt danh sách LstOrderDetail để Add vào OrderDetail: Tính SumCOGSOfOrderDetail (CashierUserId, CashierDate, Tip, Commission khi Thanh toán sẽ tính) decimal SumCOGSOfOrderDetail = 0; if (LstOrderDetail != null && LstOrderDetail.Count > 0) { DuyetDanhSachChiTietDonHang(ref SumCOGSOfOrderDetail, LstOrderDetail, modelOrder.OrderId); } #endregion #region #B2.Cập nhật PreOder: OrderId, OrderStatusId. Cập nhật OrderMaster: SumCOGSOfOrderDetail // PreOder PreOrderMaster.OrderId = modelOrder.OrderId; PreOrderMaster.OrderStatusId = OrderStatusId; // 1.Đang chờ || 2.Đang phục vụ _context.Entry(PreOrderMaster).State = System.Data.Entity.EntityState.Modified; //OrderMaster modelOrder.SumCOGSOfOrderDetail = SumCOGSOfOrderDetail; _context.Entry(modelOrder).State = System.Data.Entity.EntityState.Modified; _context.SaveChanges(); #endregion ts.Complete(); return(Content("success")); //Gửi tin nhắn } } catch { return(Content("Xảy ra lỗi trong quá trình xác nhận đơn hàng!")); } }
private Daily_ChicCut_OrderModel GetOrderMaster(Daily_ChicCut_Pre_OrderModel PreOrderMaster, List <Daily_ChicCut_OrderDetailViewModel> LstOrderDetail, int HairTypeId, int OrderStatusId) { // Tạo Order Master var currentTime = DateTime.Now; var modelOrder = new Daily_ChicCut_OrderModel() { CustomerId = PreOrderMaster.CustomerId, FullName = PreOrderMaster.FullName, IdentityCard = PreOrderMaster.IdentityCard, HairTypeId = HairTypeId, Gender = PreOrderMaster.Gender, Phone = PreOrderMaster.Phone, BillDiscountTypeId = 1, OrderStatusId = OrderStatusId, CreatedDate = currentTime, CreatedUserId = CurrentUser.UserId, Note = PreOrderMaster.Note, SumPriceOfOrderDetail = (LstOrderDetail.Sum(p => p.UnitPrice) ?? 0), Total = (LstOrderDetail.Sum(p => p.UnitPrice) ?? 0) }; return(modelOrder); }