public ActionResult ViewOrderDetail(long OrderId = 0) { ViewOrderModel model = new ViewOrderModel(); CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel; if (currentUser == null || currentUser.IsAdmin == false) { return(RedirectToAction("Login", "Login")); } CommonService comService = new CommonService(); CommonDa da = new CommonDa(); AdminOrderDa dataAccess = new AdminOrderDa(); if (OrderId > 0) { ViewOrderModel infor = new ViewOrderModel(); infor = dataAccess.getInforOrder(OrderId); model = infor != null ? infor : model; string CompanyCd = "00000"; var inforCompany = da.getInfoCompany(CompanyCd); if (inforCompany != null) { model.CompanyName = inforCompany.COMPANY_NAME; model.CompanyAddress = inforCompany.COMPANY_ADDRESS; model.CompanyEmail = inforCompany.COMPANY_EMAIL; model.CompanyPhone = inforCompany.COMPANY_PHONE; } model.AddressCustomer = model.DistrictName + ", " + model.Receive_Address; model.ORDER_STATUS_TEXT = OrderStatus.Items[model.Status].ToString(); var getOrderDetail = dataAccess.getOrderDetail(model.ID).Take(3); ViewBag.listOrderDetail = getOrderDetail.ToList(); foreach (var data in getOrderDetail) { model.ProductDetailTotal += data.ProductName + " (Số lượng: " + data.Quantity.ToString() + "), "; } if (String.IsNullOrEmpty(model.LINK_QRCODE)) { model.LINK_QRCODE = QRCodeServices.creatQR(model.Code); dataAccess.UpdateQRLink(OrderId, model.LINK_QRCODE); } if (!String.IsNullOrEmpty(model.LINK_QRCODE)) { model.LINK_QRCODE = model.LINK_QRCODE.Replace("~", ""); } } return(this.PartialView("ViewOrderDetail", model)); }
public long InsertOrder(OrderModel model, List <ItemGioHang> lstGioHang) { long res = 0; // Declare new DataAccess object OrderCartDa dataAccess = new OrderCartDa(); using (var transaction = new TransactionScope()) { try { Order order = new Order(); order.UserID = model.UserID; int maxOrder = dataAccess.getMaxOrder() + 1; order.Code = "VB" + DateTime.Now.ToString("ddMM") + maxOrder.ToString("D6"); order.LINK_QRCODE = QRCodeServices.creatQR(order.Code); order.TongTienHang = model.TongTienHang; order.PriceTotal = model.PriceTotal; order.PriceShip = model.PriceShip; order.PriceDiscountTotal = model.PriceDiscountTotal; order.PaymentMethod = model.METHOD_TYPE; order.Paid = PayStatus.None; order.Note = model.Note; order.Receive_District = model.Receive_District; order.Receive_Address = model.Receive_Address; order.Receive_Phone = model.Receive_Phone; order.Receive_Address = model.Receive_Address; order.Status = OrderStatus.Create; order.del_flg = Constant.DeleteFlag.NON_DELETE; res = dataAccess.InsertOrder(order); if (res <= 0) { transaction.Dispose(); } if (res > 0) { long res1 = 0; foreach (var data in lstGioHang) { OrderDetail detail = new OrderDetail(); detail.OrderID = res; detail.ProductID = data.IdSanPham; detail.ProductName = data.TenSanPham; detail.Quantity = data.SoLuong; detail.Price = data.TienHang; detail.del_flg = Constant.DeleteFlag.NON_DELETE; res1 = dataAccess.InsertOrderDetail(detail); if (res1 <= 0) { transaction.Dispose(); } res1 = dataAccess.UpdateQuantityProduct(detail.ProductID, detail.Quantity.Value); if (res1 <= 0) { transaction.Dispose(); } } } transaction.Complete(); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { transaction.Dispose(); } } return(res); }
public ActionResult PrintOrderCustom(string ORDER_ID_STRING) { CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel; if (currentUser == null || currentUser.IsAdmin == false) { return(RedirectToAction("Login", "Login")); } CommonService comService = new CommonService(); CommonDa da = new CommonDa(); AdminOrderDa dataAccess = new AdminOrderDa(); List <ViewOrderModel> listOrderDetail = new List <ViewOrderModel>(); ViewOrderModel model = new ViewOrderModel(); if (!string.IsNullOrEmpty(ORDER_ID_STRING)) { List <long> ORDER_ID_LIST = ORDER_ID_STRING.Split(',').Select(long.Parse).ToList(); if (ORDER_ID_LIST.Count > 0) { for (int i = 0; i < ORDER_ID_LIST.Count(); i++) { if (ORDER_ID_LIST[i] > 0) { ViewOrderModel infor = new ViewOrderModel(); infor = dataAccess.getInforOrder(ORDER_ID_LIST[i]); model = infor != null ? infor : model; string CompanyCd = "00000"; var inforCompany = da.getInfoCompany(CompanyCd); if (inforCompany != null) { model.CompanyName = inforCompany.COMPANY_NAME; model.CompanyAddress = inforCompany.COMPANY_ADDRESS; model.CompanyEmail = inforCompany.COMPANY_EMAIL; model.CompanyPhone = inforCompany.COMPANY_PHONE; } model.AddressCustomer = model.DistrictName + ", " + model.Receive_Address; model.ORDER_STATUS_TEXT = OrderStatus.Items[model.Status].ToString(); var getOrderDetail = dataAccess.getOrderDetail(model.ID).Take(3); ViewBag.listOrderDetail = getOrderDetail.ToList(); foreach (var data in getOrderDetail) { model.ProductDetailTotal += data.ProductName + " (Số lượng: " + data.Quantity.ToString() + "), "; } if (String.IsNullOrEmpty(model.LINK_QRCODE)) { model.LINK_QRCODE = QRCodeServices.creatQR(model.Code); dataAccess.UpdateQRLink(ORDER_ID_LIST[i], model.LINK_QRCODE); } if (!String.IsNullOrEmpty(model.LINK_QRCODE)) { model.LINK_QRCODE = model.LINK_QRCODE.Replace("~", ""); } listOrderDetail.Add(model); } } } //return new ViewAsPdf("ViewOrderDetailPDF", listOrderDetail); return(PartialView("ViewOrderDetailPDF", listOrderDetail)); } return(new EmptyResult()); }