public ActionResult 修改消息(int id) { MotaiDataEntities dbContext = new MotaiDataEntities(); tPromotion promotion = dbContext.tPromotions.FirstOrDefault(p => p.PromotionId == id); if (promotion == null) { return(RedirectToAction("員工看產品頁面")); } DetailPromotionViewModel Promo = new DetailPromotionViewModel(); Promo.pADimage = promotion.pADimage; Promo.pCondition = promotion.pCondition; Promo.pDiscount = promotion.pDiscount; Promo.pPromotionDeadline = promotion.pPromotionDeadline; Promo.pPromotionPostDate = promotion.pPromotionPostDate; Promo.pPromotionStartDate = promotion.pPromotionStartDate; Promo.pPromotionWeb = promotion.pPromotionWeb; Promo.PromotionDescription = promotion.PromotionDescription; Promo.sPromotinoCategory = promotion.tPromotionCategory.PromtionCategory; Promo.PromotionName = promotion.PromotionName; Promo.pDiscountCode = promotion.pDiscountCode; Promo.PromotionId = promotion.PromotionId; Promo.sPromotinoCategory = promotion.tPromotionCategory.PromtionCategory; Promo.pCategory = promotion.PromotinoCategory; var categories = new PromotionRespoitory().GetPromoCategoryAll(); List <SelectListItem> Cateitems = commodityRespoitory.GetSelectList(categories);//???? 黑人問號 Promo.Categories = Cateitems; return(View(Promo)); }
public ActionResult 修改消息(DetailPromotionViewModel promotion) { if (CSession關鍵字.SK_LOGINED_EMPLOYEE == null) { return(RedirectToAction("員工登入")); } MotaiDataEntities dbContext = new MotaiDataEntities(); tPromotion Promo = dbContext.tPromotions.FirstOrDefault(p => p.PromotionId == promotion.PromotionId); if (Promo != null) { Promo.pCondition = promotion.pCondition; Promo.pDiscount = promotion.pDiscount; Promo.pPromotionDeadline = promotion.pPromotionDeadline; Promo.pPromotionPostDate = promotion.pPromotionPostDate; Promo.pPromotionStartDate = promotion.pPromotionStartDate; Promo.pPromotionWeb = promotion.pPromotionWeb; Promo.PromotionDescription = promotion.PromotionDescription; Promo.PromotinoCategory = promotion.pCategory; Promo.PromotionName = promotion.PromotionName; Promo.pDiscountCode = promotion.pDiscountCode; Promo.PromotionId = promotion.PromotionId; Promo.pPromotionPostDate = DateTime.Now; var uploagFile = promotion.upLoadimage; if (uploagFile != null) { FileInfo file = new FileInfo(uploagFile.FileName); string photoName = Guid.NewGuid().ToString() + file.Extension; uploagFile.SaveAs(Server.MapPath("~/images/" + photoName)); Promo.pADimage = "../../images/" + Url.Content(photoName); } dbContext.SaveChanges(); } return(RedirectToAction("員工看消息")); }
public ActionResult 購物車清單() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; List <tStatu> StateList = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList(); List <StatusCartViewModel> cartList = new List <StatusCartViewModel>(); foreach (var items in StateList) { tPromotion discount = dbContext.tPromotions.Where(p => p.PromotionId == items.sProductId).FirstOrDefault(); tProduct cartProd = dbContext.tProducts.Where(p => p.ProductId == items.sProductId).FirstOrDefault(); StatusCartViewModel cartC = new StatusCartViewModel(); cartC.StatusId = items.StatusId; cartC.pName = cartProd.pName; cartC.pPrice = cartProd.pPrice; cartC.sProductQty = items.sProductQty; cartC.pDiscountCode = discount.pDiscountCode; cartList.Add(cartC); } return(View(cartList)); } else { return(RedirectToAction("首頁")); } }
public ActionResult 修改消息(DetailPromotionViewModel promotion) { if (CSession關鍵字.SK_LOGINED_EMPLOYEE == null) { return(RedirectToAction("員工登入")); } MotaiDataEntities dbContext = new MotaiDataEntities(); tPromotion Promo = dbContext.tPromotions.FirstOrDefault(p => p.PromotionId == promotion.PromotionId); if (Promo != null) { Promo.pADimage = promotion.pADimage; Promo.pCondition = promotion.pCondition; Promo.pDiscount = promotion.pDiscount; Promo.pPromotionDeadline = promotion.pPromotionDeadline; Promo.pPromotionPostDate = promotion.pPromotionPostDate; Promo.pPromotionStartDate = promotion.pPromotionStartDate; Promo.pPromotionWeb = promotion.pPromotionWeb; Promo.PromotionDescription = promotion.PromotionDescription; Promo.PromotinoCategory = promotion.pCategory; Promo.PromotionName = promotion.PromotionName; Promo.pDiscountCode = promotion.pDiscountCode; Promo.PromotionId = promotion.PromotionId; dbContext.SaveChanges(); } return(RedirectToAction("員工看消息")); }
public OrderPayStatus GetPayStatus(int orderId) { tOrder order = dbContext.tOrders.Where(o => o.OrderId == orderId).FirstOrDefault(); List <tOrderDetail> detaillist = dbContext.tOrderDetails.Where(od => od.oOrderId == orderId).ToList(); List <tOrderPay> paylist = dbContext.tOrderPays.Where(op => op.oOrderId == orderId).ToList(); OrderPayStatus payStatus = new OrderPayStatus(); foreach (var detail in detaillist) { int price = Convert.ToInt32(dbContext.tProducts.Where(p => p.ProductId == detail.oProductId).FirstOrDefault().pPrice); payStatus.TotalAmount += detail.oProductQty * price; } tPromotion promotion = dbContext.tPromotions.Where(pm => pm.PromotionId == order.oPromotionId).FirstOrDefault(); if (promotion != null) { payStatus.TotalAmount -= Convert.ToInt32(promotion.pDiscount); } if (paylist.Count() == 0) { payStatus.AlreadyPay = 0; } else { foreach (var payitem in paylist) { payStatus.AlreadyPay += Convert.ToInt32(payitem.oPayment); } } payStatus.Unpaid = payStatus.TotalAmount - payStatus.AlreadyPay; return(payStatus); }
public ActionResult 新增消息(DetailPromotionViewModel create消息) { MotaiDataEntities dbContext = new MotaiDataEntities(); tPromotion n消息 = new tPromotion(); n消息.PromotionName = create消息.PromotionName; n消息.PromotinoCategory = create消息.pCategory; n消息.PromotionDescription = create消息.PromotionDescription; n消息.pPromotionStartDate = create消息.pPromotionStartDate; n消息.pPromotionDeadline = create消息.pPromotionDeadline; //n消息.pADimage = create消息.pADimage; n消息.pDiscountCode = create消息.pDiscountCode; n消息.pDiscount = create消息.pDiscount; n消息.pCondition = create消息.pCondition; var date = DateTime.Now; n消息.pPromotionPostDate = date; int PromotionId = dbContext.tPromotions.OrderByDescending(o => o.PromotionId).First().PromotionId; PromotionId = PromotionId + 1; //if (create消息.upLoadimage.Count() > 0) //{ // foreach (var uploagFile in create消息.upLoadimage) // { // if (uploagFile.ContentLength > 0) // { // FileInfo file = new FileInfo(uploagFile.FileName); // string photoName = Guid.NewGuid().ToString() + file.Extension; // uploagFile.SaveAs(Server.MapPath("~/images/" + photoName)); // n消息.pADimage = "~" + Url.Content("~/images/" + photoName); // dbContext.tPromotions.Add(n消息); // dbContext.SaveChanges(); // } // } //} dbContext.SaveChanges(); return(RedirectToAction("員工看消息")); //if (n新增產品.pImage.Count() > 0) //{ // foreach (var uploagFile in n新增產品.pImage) // { // if (uploagFile.ContentLength > 0) // { // tProductImage image = new tProductImage(); // FileInfo file = new FileInfo(uploagFile.FileName); // string photoName = Guid.NewGuid().ToString() + file.Extension; // uploagFile.SaveAs(Server.MapPath("~/images/" + photoName)); // image.ProductId = ProductId; // image.pImage = "~" + Url.Content("~/images/" + photoName); // db.tProductImages.Add(image); // } // } //} }
//客戶看訂單 public ActionResult 過往訂單() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; MotaiDataEntities db = new MotaiDataEntities(); List <tOrder> orders = db.tOrders.Where(o => o.oCustomerId == cust.CustomerId).ToList(); List <CustomerOrderViewModel> OrderList = new List <CustomerOrderViewModel>(); foreach (var items in orders) { CustomerOrderViewModel order = new CustomerOrderViewModel(); order.oDate = items.oDate; order.WarehouseName = db.tWarehouseNames.Where(w => w.WarehouseNameId.Equals(items.oWarehouseName)).FirstOrDefault().WarehouseName; tEmployee employee = db.tEmployees.Where(e => e.EmployeeId == items.oEmployeeId).FirstOrDefault(); if (employee != null) { order.EmployeeName = employee.eName; } order.cNote = items.cNote; List <tOrderDetail> orderdetails = db.tOrderDetails.Where(od => od.oOrderId == items.OrderId).ToList(); List <CustomerOrderDetailViewModel> OrderDetailList = new List <CustomerOrderDetailViewModel>(); int originPrice = 0; foreach (var itemDetail in orderdetails) { CustomerOrderDetailViewModel orderdetail = new CustomerOrderDetailViewModel(); tProduct product = db.tProducts.Where(p => p.ProductId == itemDetail.oProductId).FirstOrDefault(); orderdetail.ProductNum = product.pNumber; orderdetail.ProductName = product.pName; orderdetail.ProductPrice = product.pPrice; orderdetail.oProductQty = itemDetail.oProductQty; orderdetail.oNote = itemDetail.oNote; OrderDetailList.Add(orderdetail); originPrice += Convert.ToInt32(product.pPrice) * itemDetail.oProductQty; } if (items.oPromotionId != null) { tPromotion promotion = db.tPromotions.Where(p => p.PromotionId == items.oPromotionId).FirstOrDefault(); order.TotalAmount = originPrice - Convert.ToInt32(promotion.pDiscount); } else { order.TotalAmount = originPrice; } List <tOrderPay> paylists = db.tOrderPays.Where(op => op.oOrderId == items.OrderId).ToList(); foreach (var itemPay in paylists) { order.AlreadyPay += Convert.ToInt32(itemPay.oPayment); } order.Unpaid = order.TotalAmount - order.AlreadyPay; order.CustomerOrderDetails = OrderDetailList; OrderList.Add(order); } return(View(OrderList)); } return(RedirectToAction("首頁")); }
public JsonResult 修改消息讀圖(int PromotionId) { MotaiDataEntities dbContext = new MotaiDataEntities(); tPromotion Promo = dbContext.tPromotions.FirstOrDefault(p => p.PromotionId == PromotionId); if (Promo.pADimage != null) { string image = Url.Content(Promo.pADimage); return(Json(new { images = image })); } else { return(Json(new { images = "" })); } }
public DetailPromotionViewModel GetPromotionById(int PromotionId) { tPromotion promotion = dbContext.tPromotions.FirstOrDefault(p => p.PromotionId == PromotionId); DetailPromotionViewModel Promo = new DetailPromotionViewModel(); Promo.pADimage = promotion.pADimage; Promo.pCondition = promotion.pCondition; Promo.pDiscount = promotion.pDiscount; Promo.pPromotionDeadline = promotion.pPromotionDeadline; Promo.pPromotionPostDate = promotion.pPromotionPostDate; Promo.pPromotionStartDate = promotion.pPromotionStartDate; Promo.pPromotionWeb = promotion.pPromotionWeb; Promo.PromotionDescription = promotion.PromotionDescription; Promo.sPromotinoCategory = promotion.tPromotionCategory.PromtionCategory; Promo.PromotionName = promotion.PromotionName; Promo.pDiscountCode = promotion.pDiscountCode; Promo.PromotionId = promotion.PromotionId; return(Promo); }
public ActionResult 新增消息(DetailPromotionViewModel create消息) { MotaiDataEntities dbContext = new MotaiDataEntities(); tPromotion n消息 = new tPromotion(); n消息.PromotionName = create消息.PromotionName; n消息.PromotinoCategory = create消息.pCategory; n消息.PromotionDescription = create消息.PromotionDescription; n消息.pPromotionStartDate = create消息.pPromotionStartDate; n消息.pPromotionDeadline = create消息.pPromotionDeadline; n消息.pPromotionWeb = create消息.pPromotionWeb; n消息.pDiscountCode = create消息.pDiscountCode; n消息.pDiscount = create消息.pDiscount; n消息.pCondition = create消息.pCondition; var date = DateTime.Now; n消息.pPromotionPostDate = date; int PromotionId = dbContext.tPromotions.OrderByDescending(o => o.PromotionId).First().PromotionId; PromotionId = PromotionId + 1; var uploagFile = create消息.upLoadimage; if (uploagFile == null) { } if (uploagFile.ContentLength > 0) { FileInfo file = new FileInfo(uploagFile.FileName); string photoName = Guid.NewGuid().ToString() + file.Extension; uploagFile.SaveAs(Server.MapPath("~/images/" + photoName)); n消息.pADimage = "../../images/" + Url.Content(photoName); dbContext.tPromotions.Add(n消息); } dbContext.SaveChanges(); return(RedirectToAction("員工看消息")); }
//實體結帳畫面 public ActionResult realCheckView(int OrderId) { MotaiDataEntities dbContext = new MotaiDataEntities(); EmployeeCheckoutViewModel model = new EmployeeCheckoutViewModel(); EmployeeOrderViewModel Order = new EmployeeOrderViewModel(); tOrder order = dbContext.tOrders.Where(o => o.OrderId.Equals(OrderId)).FirstOrDefault(); Order.CustomerName = dbContext.tCustomers.Where(c => c.CustomerId == order.oCustomerId).FirstOrDefault().cName; Order.oAddress = order.oAddress; Order.oDate = order.oDate; if (order.cNote != null) { Order.cNote = order.cNote; } else { Order.cNote = "無"; } List <tOrderDetail> orderDetails = dbContext.tOrderDetails.Where(od => od.oOrderId.Equals(OrderId)).ToList(); List <EmployeeOrderDetailViewModel> Orderdetails = new List <EmployeeOrderDetailViewModel>(); foreach (var itemdetails in orderDetails) { tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(itemdetails.oProductId)).FirstOrDefault(); EmployeeOrderDetailViewModel Orderdetail = new EmployeeOrderDetailViewModel(); Orderdetail.oOrderId = OrderId; Orderdetail.ProductName = product.pName; Orderdetail.ProductNum = product.pNumber; Orderdetail.ProductPrice = product.pPrice; Orderdetail.oProductQty = itemdetails.oProductQty; model.originalPrice += itemdetails.oProductQty * Convert.ToInt32(product.pPrice); Orderdetails.Add(Orderdetail); } if (order.oPromotionId != null) { tPromotion promotion = dbContext.tPromotions.Where(p => p.PromotionId == order.oPromotionId).FirstOrDefault(); Order.PromotionName = promotion.PromotionName; Order.PromotionDiscount = promotion.pDiscount; Order.PromotionCondition = promotion.pCondition; model.TotalAmount = model.originalPrice - Convert.ToInt32(promotion.pDiscount); } else { Order.PromotionName = "不適用任何優惠活動"; Order.PromotionDiscount = "0"; Order.PromotionCondition = "無"; model.TotalAmount = model.originalPrice; } model.AlreadyPay = 0; model.Unpaid = model.TotalAmount; if (dbContext.tOrderPays.Where(op => op.oOrderId.Equals(OrderId)).ToList() != null) { List <tOrderPay> pays = dbContext.tOrderPays.Where(op => op.oOrderId.Equals(OrderId)).ToList(); foreach (var item in pays) { model.AlreadyPay += Convert.ToInt32(item.oPayment); } model.Unpaid = model.TotalAmount - model.AlreadyPay; } model.Order = Order; model.orderDetails = Orderdetails; return(View(model)); }
public List <OrderViewModel> GetOrderAllByEmp(int EmployeeId) { List <tOrder> order = dbContext.tOrders.OrderByDescending(o => o.oDate).Where(o => o.oEmployeeId == EmployeeId).ToList(); List <OrderViewModel> orderlist = new List <OrderViewModel>(); foreach (tOrder item in order) { OrderViewModel Order = new OrderViewModel(); Order.oAddress = item.oAddress; Order.oCheck = item.oCheck; if (item.oCheckDate != null) { Order.oCheckDate = item.oCheckDate.Value.Date; } Order.oDate = item.oDate.Date; //if(item.oDeliverDate) //Order.oDeliverDate = item.oDeliverDate.Value.Date; Order.OrderId = item.OrderId; Order.sWarehouseName = item.tWarehouseName.WarehouseName; Order.seName = item.tEmployee.eName; Order.scName = item.tCustomer.cName; var note = item.cNote; if (note != null) { if (note.Length > 10) { Order.cNote = note.Substring(0, 10) + "..."; } else { Order.cNote = note; } } //變數 - 觀察付了多少錢 var receivedMoney = from tP in dbContext.tOrderPays where tP.oOrderId == item.OrderId select tP.oPayment; //已收到 int receivedTotal = 0; foreach (var receivedM in receivedMoney) { receivedTotal = (int)receivedM + receivedTotal; } Order.received = receivedTotal; //應收款 var receivableMoney = from tp in dbContext.tOrderDetails where tp.oOrderId == item.OrderId select tp.oProductQty * tp.tProduct.pPrice; //全額 int receivableTotal = 0; foreach (var receivableM in receivableMoney) { receivableTotal += (int)receivableM; } //折扣 if (item.oPromotionId != null) { tPromotion promotion = dbContext.tPromotions.Where(p => p.PromotionId == item.oPromotionId).FirstOrDefault(); if (promotion.PromotionName.Length > 7) { Order.PromotionName = promotion.PromotionName.Substring(0, 6) + "."; } else { Order.PromotionName = promotion.PromotionName; } //Order.PromotionName = promotion.PromotionName; Order.pDiscount = Convert.ToInt32(item.tPromotion.pDiscount); receivableTotal -= Convert.ToInt32(item.tPromotion.pDiscount); } Order.receivable = receivableTotal; //應付款額-收款 var surplus = receivableTotal - receivedTotal; Order.surplus = surplus; if (item.oCheck != null) { Order.htmlName = "tr_hidden1"; } else if (surplus <= 0) { Order.htmlName = "tr_hidden2"; } else { Order.htmlName = "tr_hidden3"; } List <AccountOrderDetailViewModel> detailViewModels = new List <AccountOrderDetailViewModel>(); List <tOrderDetail> detailLists = dbContext.tOrderDetails.Where(od => od.oOrderId == item.OrderId).ToList(); foreach (tOrderDetail itemdetail in detailLists) { AccountOrderDetailViewModel detail = new AccountOrderDetailViewModel(); tProduct product = dbContext.tProducts.Where(p => p.ProductId == itemdetail.oProductId).FirstOrDefault(); detail.ProductNum = product.pNumber; detail.ProductName = product.pName; detail.ProductPrice = product.pPrice; detail.oProductQty = itemdetail.oProductQty; detail.oNote = itemdetail.oNote; detailViewModels.Add(detail); } Order.orderDetailViews = detailViewModels; orderlist.Add(Order); } return(orderlist); }