public JsonResult ChangePassword(int EmployeeId, string ePassword, string oldpass) {//要用到其他地方 if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; MotaiDataEntities dbContext = new MotaiDataEntities(); tEmployee changeemp = new tEmployee(); changeemp = emp; changeemp.EmployeeId = EmployeeId; dbContext.tEmployees.Add(changeemp); dbContext.SaveChanges(); if (emp.ePassword == oldpass) { emp.ePassword = ePassword; Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] = emp; tEmployee changePwd = dbContext.tEmployees.Where(e => e.EmployeeId.Equals(emp.EmployeeId)).FirstOrDefault(); changePwd.ePassword = ePassword; dbContext.SaveChanges(); return(Json(new { result = true, msg = "更新成功" })); } else { return(Json(new { result = false, msg = "舊密碼錯誤" })); } } else { return(Json(new { result = false, msg = "請先登入" })); } }
public ActionResult 人員檢視() { MotaiDataEntities dbContext = new MotaiDataEntities(); if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] == null) { return(RedirectToAction("員工登入", "Employee")); } tEmployee empse = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; var empall = dbContext.tEmployees.OrderBy(c => c.eBranch).ToList(); var empall2 = empall.OrderBy(c => c.ePosition).ToList(); var empall3 = empall2.OrderBy(c => c.eBranch).ToList(); List <EmployeeViewModels> employees = new List <EmployeeViewModels>(); foreach (var item in empall3) { EmployeeViewModels employeeModel = new EmployeeViewModels(); employeeModel.EmployeeId = item.EmployeeId; employeeModel.eAccount = item.eAccount; employeeModel.eName = item.eName; employeeModel.sPosition = item.tPosition.pPosition; employeeModel.sBranch = item.tBranch.bBranch; employees.Add(employeeModel); } return(View(employees)); }
public ActionResult 店鋪報表() { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] == null) { return(RedirectToAction("員工登入", "Employee")); } MotaiDataEntities dbContext = new MotaiDataEntities(); List <tOrderDetail> tOrderDetails = dbContext.tOrderDetails.ToList(); wareData ware = new wareData(); ware.waretem = new Dictionary <int, Dictionary <int, int> >(); List <int> load = new List <int>(); foreach (tOrderDetail item in tOrderDetails) { int wNAME = item.tOrder.tWarehouseName.WarehouseNameId; if (!load.Contains(wNAME))//抓店 { load.Add(wNAME); Dictionary <int, int> temD = new Dictionary <int, int>(); for (int i = 1; i < 13; i++) {//抓月份 var q = from search in tOrderDetails where search.tOrder.oDate.Month == i && search.tOrder.tWarehouseName.WarehouseNameId == wNAME && search.tOrder.oCheck == "checked" && search.tOrder.oDate.Year == DateTime.Now.Year select(search.oProductQty) * ((int)search.tProduct.pPrice); int V = q.Sum();//合併月份內營收 temD.Add(i, V); } ware.waretem.Add(wNAME, temD); } } return(View(ware)); }
public JsonResult 收藏排名() { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tFavorite> favordb = dbContext.tFavorites.ToList(); string func(int i) { tProduct p = new tProduct(); List <string> pimage = new List <string>(); p.ProductId = i; pimage = productRespotiory.GetProductShowImages(p); if (pimage.Count > 0) { return(Url.Content(pimage[0])); } else { return(""); } } var favorOrderby = (from i in favordb group i by i.fProductId into j select new { Pid = j.Key, Pimage = func(j.Key), Pcount = j.Count(), }).OrderByDescending(j => j.Pcount).Take(10).ToArray(); return(Json(new { favorOrderby })); }
public JsonResult 購買排名() { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tOrderDetail> orderdb = dbContext.tOrderDetails.ToList(); //這樣才能在linq內使用函式 string func(int i) { tProduct p = new tProduct(); List <string> pimage = new List <string>(); p.ProductId = i; pimage = productRespotiory.GetProductShowImages(p); if (pimage.Count > 0) { return(Url.Content(pimage[0])); } else { return(""); } } var buyOrderby = (from i in orderdb group i by i.oProductId into j select new { Pid = j.Key, Pimage = func(j.Key), Pcount = j.Sum(p => p.oProductQty), }).OrderByDescending(j => j.Pcount).Take(10).ToArray(); return(Json(new { buyOrderby })); }
public ActionResult 購物車清單() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; int count = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList().Count; ViewBag.Count = count + "項"; List <tStatu> StateList = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList(); List <StatusCartViewModel> cartList = new List <StatusCartViewModel>(); StatusCartGoToPayViewModel Cart = new StatusCartGoToPayViewModel(); foreach (var items in StateList) { tProduct cartProd = dbContext.tProducts.Where(p => p.ProductId == items.sProductId).FirstOrDefault(); StatusCartViewModel cartC = new StatusCartViewModel(); cartC.StatusId = items.StatusId; cartC.ProductId = items.sProductId; cartC.pName = cartProd.pName; cartC.pPrice = cartProd.pPrice; cartC.sProductQty = items.sProductQty; cartList.Add(cartC); } Cart.Carts = cartList; var warehouseNames = commodityRespoitory.GetWarehouseAll(); List <SelectListItem> warehouselist = commodityRespoitory.GetSelectList(warehouseNames); Cart.warehouses = warehouselist; return(View(Cart)); } else { return(RedirectToAction("首頁")); } }
public JsonResult 修改會員資料(MemberViewModel oldMember) { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { tCustomer customer = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer cust = dbContext.tCustomers.Find(customer.CustomerId); List <tCustomer> custList = dbContext.tCustomers.ToList(); foreach (var item in custList) { if (item.cCellPhone == oldMember.cCellPhone) { if (cust.cCellPhone != oldMember.cCellPhone) { return(Json(new { result = false, msg = "此手機號碼已被註冊" })); } } else if (item.cEmail == oldMember.cEmail) { if (cust.cEmail != oldMember.cEmail) { return(Json(new { result = false, msg = "此信箱已被註冊" })); } } } cust.cName = oldMember.cName; cust.cTelePhone = oldMember.cTelePhone; cust.cGUI = oldMember.cGUI; cust.cEmail = oldMember.cEmail; cust.cAddress = oldMember.cAddress; dbContext.SaveChanges(); return(Json(new { result = true, msg = "修改成功", url = Url.Action("會員中心", "Customer") })); } return(Json(new { result = true, msg = "請先登入", url = Url.Action("首頁", "Customer") })); }
public ActionResult 修改會員資料(int CustomerId) { MotaiDataEntities db = new MotaiDataEntities(); tCustomer cust = db.tCustomers.FirstOrDefault(c => c.CustomerId == CustomerId); if (cust == null) { return(RedirectToAction("會員中心")); } MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer custer = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; int count = dbContext.tStatus.Where(c => c.sCustomerId == custer.CustomerId).ToList().Count; ViewBag.Count = count; MemberViewModel customer = new MemberViewModel(); customer.cAccount = cust.cAccount; customer.cPassword = cust.cPassword; customer.cName = cust.cName; customer.cTelePhone = cust.cTelePhone; customer.cCellPhone = cust.cCellPhone; customer.cAddress = cust.cAddress; customer.cGUI = cust.cGUI; customer.cEmail = cust.cEmail; return(View(customer)); }
public JsonResult 員工登入(EmployeeLoginViewModel e登入資料) { MotaiDataEntities dbContext = new MotaiDataEntities(); tEmployee d資料確認 = dbContext.tEmployees.Where(e => e.eAccount == e登入資料.eAccount && e.ePassword.Equals(e登入資料.ePassword)).FirstOrDefault(); if (d資料確認 != null) { Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] = d資料確認; switch (d資料確認.eBranch) { case 1: return(Json(new { result = true, msg = "登入成功", url = Url.Action("Boss首頁", "Boss") })); case 2: return(Json(new { result = true, msg = "登入成功", url = Url.Action("Business首頁", "Business") })); case 3: return(Json(new { result = true, msg = "登入成功", url = Url.Action("Accountant首頁", "Accountant") })); case 4: return(Json(new { result = true, msg = "登入成功", url = Url.Action("People首頁", "People") })); case 5: return(Json(new { result = true, msg = "登入成功", url = Url.Action("Commodity首頁", "Commodity") })); default: return(Json(new { result = true, msg = "帳號或密碼有誤", url = Url.Action("員工首頁", "Employee") })); } } else { return(Json(new { result = false, msg = "帳號或密碼有誤" })); } }
//客戶訂單 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.Equals(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; order.EmployeeName = db.tEmployees.Where(e => e.EmployeeId.Equals(items.oEmployeeId)).FirstOrDefault().eName; order.cNote = items.cNote; List <tOrderDetail> orderdetails = db.tOrderDetails.Where(od => od.oOrderId.Equals(items.OrderId)).ToList(); List <CustomerOrderDetailViewModel> OrderDetailList = new List <CustomerOrderDetailViewModel>(); foreach (var itemDetail in orderdetails) { CustomerOrderDetailViewModel orderdetail = new CustomerOrderDetailViewModel(); orderdetail.ProductNum = db.tProducts.Where(p => p.ProductId.Equals(itemDetail.oProductId)).FirstOrDefault().pNumber; orderdetail.ProductName = db.tProducts.Where(p => p.ProductId.Equals(itemDetail.oProductId)).FirstOrDefault().pName; orderdetail.oProductQty = itemDetail.oProductQty; orderdetail.oNote = itemDetail.oNote; OrderDetailList.Add(orderdetail); } order.CustomerOrderDetails = OrderDetailList; OrderList.Add(order); } return(View(OrderList)); } return(RedirectToAction("首頁")); }
public ActionResult 工作日誌() { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { MotaiDataEntities dbContext = new MotaiDataEntities(); tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; var dlist = dbContext.tDiaries.Where(c => c.dEmployeeId == emp.EmployeeId).ToList(); var dlistnew = dlist.OrderByDescending(c => c.dDate).ToList(); List <DiaryViewModel> DSaw = new List <DiaryViewModel>(); foreach (var item in dlistnew) { DiaryViewModel show = new DiaryViewModel(); show.eName = item.tEmployee.eName; show.dDate = item.dDate; show.dWeather = item.dWeather; show.dDiaryNote = item.dDiaryNote; show.DiaryId = item.DiaryId; show.dWarehouseNameId = item.dWarehouseNameId; show.dWarehouseName = dbContext.tWarehouseNames.Where(w => w.WarehouseNameId == item.dWarehouseNameId).FirstOrDefault().WarehouseName; DSaw.Add(show); } return(View(DSaw)); } return(RedirectToAction("員工登入", "Employee")); }
public JsonResult OrderPay(int payType, int OrderId, int payMoney) { MotaiDataEntities dbContext = new MotaiDataEntities(); tOrderPay pay = dbContext.tOrderPays.OrderByDescending(op => op.oOrderInstallment).Where(op => op.oOrderId.Equals(OrderId)).FirstOrDefault(); if (pay == null) { tOrderPay orderPay = new tOrderPay(); orderPay.oOrderId = OrderId; orderPay.oOrderInstallment = 1; orderPay.oPayType = payType; orderPay.oPayment = payMoney; orderPay.oPayDate = DateTime.Now; dbContext.tOrderPays.Add(orderPay); dbContext.SaveChanges(); } else { tOrderPay orderPay = new tOrderPay(); orderPay.oOrderId = OrderId; orderPay.oOrderInstallment = pay.oOrderInstallment++; orderPay.oPayType = payType; orderPay.oPayment = payMoney; orderPay.oPayDate = DateTime.Now; dbContext.tOrderPays.Add(orderPay); dbContext.SaveChanges(); } return(Json(new { msg = "結帳完成", url = Url.Action("實體店新增訂單", "Order") })); }
public ActionResult 會員中心() { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; MotaiDataEntities db = new MotaiDataEntities(); tCustomer custor = db.tCustomers.Find(cust.CustomerId); MemberViewModel member = new MemberViewModel(); MotaiDataEntities dbContext = new MotaiDataEntities(); int count = dbContext.tStatus.Where(c => c.sCustomerId == cust.CustomerId).ToList().Count; ViewBag.Count = count + "項"; member.cName = custor.cName; member.cTelePhone = custor.cTelePhone; member.cCellPhone = custor.cCellPhone; member.cAddress = custor.cAddress; member.cGUI = custor.cGUI; member.cEmail = custor.cEmail; member.cAccount = custor.cAccount; member.cPassword = custor.cPassword; return(View(member)); } return(RedirectToAction("首頁")); }
//搜尋客戶訂單 public JsonResult SearchCustomerOrder(string CustomerCell) { MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer cust = dbContext.tCustomers.Where(c => c.cCellPhone.Equals(CustomerCell)).FirstOrDefault(); if (cust == null) { return(Json(new { result = false, msg = "查無此人" })); } else { int custId = cust.CustomerId; List <tOrder> orderlist = dbContext.tOrders.Where(o => o.oCustomerId == custId && o.oCheck == null).ToList(); List <SearchCustomerOrderModel> searchlist = new List <SearchCustomerOrderModel>(); foreach (var item in orderlist) { SearchCustomerOrderModel search = new SearchCustomerOrderModel(); search.orderId = item.OrderId; search.purchaseDate = item.oDate.ToString("yyyy/MM/dd"); search.WarehouseName = dbContext.tWarehouseNames.Where(wn => wn.WarehouseNameId == item.oWarehouseName).FirstOrDefault().WarehouseName; OrderPayStatus payStatus = orderRespoitory.GetPayStatus(item.OrderId); search.TotalAmount = payStatus.TotalAmount; search.AlreadyPay = payStatus.AlreadyPay; search.Unpaid = payStatus.Unpaid; searchlist.Add(search); } return(Json(new { result = true, list = searchlist })); } }
public JsonResult chooseShipWare(int OrderId) { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tOrderDetail> orderDetailSearchs = dbContext.tOrderDetails.Where(od => od.oOrderId.Equals(OrderId)).ToList(); List <WareShipChooseViewModel> ChooseList = new List <WareShipChooseViewModel>(); foreach (var item in orderDetailSearchs) { List <tWarehouse> wareList = dbContext.tWarehouses.Where(w => w.wProductId.Equals(item.oProductId)).ToList(); foreach (var itemware in wareList) { tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(item.oProductId)).FirstOrDefault(); WareShipChooseViewModel wareChoose = new WareShipChooseViewModel(); wareChoose.WareHouseName = dbContext.tWarehouseNames.Where(wn => wn.WarehouseNameId.Equals(itemware.WarehouseNameId)).FirstOrDefault().WarehouseName; wareChoose.WareHouseId = itemware.WarehouseNameId; wareChoose.OrderDetailId = item.oOrderDetailId; wareChoose.ProductId = product.ProductId; wareChoose.ProductNum = product.pNumber; wareChoose.ProductName = product.pName; wareChoose.ProductQty = itemware.wPQty; ChooseList.Add(wareChoose); } } return(Json(ChooseList)); }
public ActionResult 修改產品(int id) { MotaiDataEntities db = new MotaiDataEntities(); tProduct product = db.tProducts.FirstOrDefault(p => p.ProductId == id); if (product == null) { return(RedirectToAction("員工看產品頁面")); } EmpProductViewModel Prod = new EmpProductViewModel(); Prod.ProductId = id; Prod.pNumber = product.pNumber; Prod.pName = product.pName; Prod.psCategory = product.tProductCategory.Category; Prod.psMaterial = product.tProductMaterial.Material; Prod.psSize = product.tProductSize.Size; Prod.pLxWxH = product.pLxWxH; Prod.pWeight = product.pWeight; Prod.pIntroduction = product.pIntroduction; Prod.pPrice = product.pPrice; var categories = new ProductRespoitory().GetCategoryAll(); List <SelectListItem> Cateitems = new ProductRespoitory().GetSelectList(categories); Prod.Categories = Cateitems; var materials = new ProductRespoitory().GetMaterialAll(); List <SelectListItem> Mateitems = new ProductRespoitory().GetSelectList(materials); Prod.Materials = Mateitems; var sizes = new ProductRespoitory().GetSizeAll(); List <SelectListItem> Sizeitems = new ProductRespoitory().GetSelectList(sizes); Prod.Sizes = Sizeitems; return(View(Prod)); }
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 JsonResult AddToCart(int ProductId, int buyQty) { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { tCustomer cust = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; MotaiDataEntities db = new MotaiDataEntities(); var product = (new MotaiDataEntities()).tProducts.FirstOrDefault(p => p.ProductId == ProductId); if (product != null && product.pQty > buyQty) { tStatu cart = new tStatu(); cart.sCustomerId = cust.CustomerId; cart.sProductId = ProductId; cart.sProductQty = buyQty; db.tStatus.Add(cart); db.SaveChanges(); return(Json(new { result = true, msg = "加入成功" })); } else { return(Json(new { result = false, msg = "庫存不足" })); } } else { return(Json(new { result = false, msg = "請先登入" })); } }
public ActionResult 消息(int page = 1) { MotaiDataEntities db = new MotaiDataEntities(); int cpage = page < 1 ? 1 : page; //資料庫讀取 tPromotions 為資料庫名稱 var promotion = db.tPromotions.OrderByDescending(c => c.PromotionId).ToList(); //開新List 取值 List <news> reslsit = new List <news>(); foreach (var items in promotion) { //實體化 class news res = new news(); NewPromotionViewModel npv = new NewPromotionViewModel(); //Prom 讀取入get set npv.sPromotinoCategory = items.tPromotionCategory.PromtionCategory; npv.PromotionDescription = items.PromotionDescription; npv.pADimage = items.pADimage; npv.pPromotionWeb = items.pPromotionWeb; npv.pPromotionPostDate = items.pPromotionPostDate; res.newPrmotion = npv; reslsit.Add(res); } var result = reslsit.ToPagedList(cpage, pageSize); return(View(result)); }
public JsonResult 會員註冊(RegisterViewModel newMember) { MotaiDataEntities dbContext = new MotaiDataEntities(); List <tCustomer> custo = dbContext.tCustomers.ToList(); foreach (var item in custo) { if (item.cAccount == newMember.cAccount) { return(Json(new { msg = "帳號已被註冊" })); } else if (item.cEmail == newMember.cEmail) { return(Json(new { msg = "信箱已被使用" })); } } if (newMember.cPassword == newMember.cConfirmPassword) { tCustomer newmember = new tCustomer(); newmember.cAccount = newMember.cAccount; newmember.cPassword = newMember.cPassword; newmember.cName = newMember.cName; newmember.cTelePhone = newMember.cTelePhone; newmember.cCellPhone = newMember.cCellPhone; newmember.cAddress = newMember.cAddress; newmember.cGUI = newMember.cGUI; newmember.cEmail = newMember.cEmail; dbContext.tCustomers.Add(newmember); dbContext.SaveChanges(); return(Json(new { msg = "註冊成功" })); } return(Json(new { msg = "註冊失敗" })); }
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 JsonResult CustomerChangePassword(int CustomerId, string cPassword, string oldpass) { if (Session[CSession關鍵字.SK_LOGINED_CUSTOMER] != null) { tCustomer customer = Session[CSession關鍵字.SK_LOGINED_CUSTOMER] as tCustomer; MotaiDataEntities dbContext = new MotaiDataEntities(); if (customer.cPassword == oldpass) { customer.cPassword = cPassword; Session[CSession關鍵字.SK_LOGINED_CUSTOMER] = customer; tCustomer changePwd = dbContext.tCustomers.Where(c => c.CustomerId.Equals(customer.CustomerId)).FirstOrDefault(); changePwd.cPassword = cPassword; dbContext.SaveChanges(); return(Json(new { result = true, msg = "更新成功" })); } else { return(Json(new { result = false, msg = "舊密碼錯誤" })); } } else { return(Json(new { result = false, msg = "請先登入" })); } }
//出貨單 public ActionResult 出貨單建立() { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { MotaiDataEntities dbContext = new MotaiDataEntities(); ShipCreateShowViewModel model = new ShipCreateShowViewModel(); DateTime today = DateTime.Now.Date; var count = dbContext.tShipLists.Where(s => s.sShipDate == today).ToList().Count; count++; model.sShipSerialValue = Convert.ToInt32(DateTime.Now.ToString("yyMMdd") + count.ToString("0000")); model.sShipDate = DateTime.Now; List <tOrder> orderSearch = dbContext.tOrders.Where(o => o.oCheck != null && o.oDeliverDate == null).ToList(); List <OrderShipShowViewModel> orderShips = new List <OrderShipShowViewModel>(); foreach (var item in orderSearch) { OrderShipShowViewModel orderShip = new OrderShipShowViewModel(); orderShip.OrderId = item.OrderId; orderShip.oAddress = item.oAddress; orderShip.oCheck = item.oCheck; orderShip.oCheckDate = item.oCheckDate; orderShip.cNote = item.cNote; orderShip.oDate = item.oDate; orderShips.Add(orderShip); } model.ShipShows = orderShips; return(View(model)); } return(RedirectToAction("員工登入", "Employee")); }
//進貨單 public ActionResult 進貨單建立() { MotaiDataEntities dbContext = new MotaiDataEntities(); if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { StockCreateViewModel model = new StockCreateViewModel(); StockDetailViewModel detail = new StockDetailViewModel(); tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; model.sEmployeeId = emp.EmployeeId; var productNames = productRespoitory.GetNameAll(); List <SelectListItem> productlist = productRespoitory.GetPositionName(productNames); var warehouseNames = commodityRespoitory.GetWarehouseAll(); List <SelectListItem> warehouselist = commodityRespoitory.GetSelectList(warehouseNames); detail.WareHouseNames = warehouselist; detail.ProductNames = productlist; DateTime today = DateTime.Now.Date; var count = dbContext.tStockLists.Where(s => s.sStockDate == today).ToList().Count; count++; model.sStockSerialValue = Convert.ToInt32(DateTime.Now.ToString("yyMMdd") + count.ToString("0000")); model.StockDetail = detail; model.sStockDate = DateTime.Now; return(View(model)); } else { return(RedirectToAction("員工登入", "Employee")); } }
public JsonResult 實體店新增訂單(EmployeeOrderViewModel empOrder) { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; if (Session[CSession關鍵字.SK_ORDERDETAIL] == null) { return(Json(new { result = false, msg = "訂單尚未完成!", url = Url.Action("實體店新增訂單", "Order") })); } else { List <EmployeeOrderDetailViewModel> orders = Session[CSession關鍵字.SK_ORDERDETAIL] as List <EmployeeOrderDetailViewModel>; MotaiDataEntities dbContext = new MotaiDataEntities(); tCustomer customer = dbContext.tCustomers.Where(c => c.cCellPhone == empOrder.cCellphone).FirstOrDefault(); tOrder list = new tOrder(); list.oEmployeeId = emp.EmployeeId; list.oCustomerId = customer.CustomerId; if (empOrder.oAddress == null) { list.oAddress = customer.cAddress; } else { list.oAddress = empOrder.oAddress; } list.oDate = empOrder.oDate; list.cNote = empOrder.cNote; list.oWarehouseName = empOrder.oWarehouseName; dbContext.tOrders.Add(list); dbContext.SaveChanges(); int orderId = dbContext.tOrders.OrderByDescending(i => i.OrderId).First().OrderId; int originalPrice = 0; foreach (var items in orders) { tOrderDetail detail = new tOrderDetail(); detail.oOrderId = orderId; detail.oProductId = items.oProductId; detail.oProductQty = items.oProductQty; detail.oNote = items.oNote; dbContext.tOrderDetails.Add(detail); tProduct product = dbContext.tProducts.Where(p => p.ProductId.Equals(items.oProductId)).FirstOrDefault(); originalPrice += items.oProductQty * Convert.ToInt32(product.pPrice); } tOrder order = dbContext.tOrders.Where(o => o.OrderId == orderId).FirstOrDefault(); int promotionId = orderRespoitory.SelectPromotionId(originalPrice, empOrder.oDate); if (promotionId != 0) { order.oPromotionId = promotionId; } dbContext.SaveChanges(); Session[CSession關鍵字.SK_ORDERDETAIL] = null; return(Json(new { result = true, msg = "新增成功", url = Url.Action("realCheckView", "Order"), OrderId = orderId })); } } else { return(Json(new { result = false, msg = "尚未登入!", url = Url.Action("員工登入", "Employee") })); } }
public JsonResult WareOutInventory(int WarehouseIdOut, int ProductId) { MotaiDataEntities dbContext = new MotaiDataEntities(); tWarehouse warehouse = dbContext.tWarehouses.Where(w => w.wProductId.Equals(ProductId) && w.WarehouseNameId.Equals(WarehouseIdOut)).FirstOrDefault(); int MaxQty = warehouse.wPQty; return(Json(MaxQty)); }
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 JsonResult 進貨單建立(StockCreateViewModel stockList) { if (Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] != null) { tEmployee emp = Session[CSession關鍵字.SK_LOGINED_EMPLOYEE] as tEmployee; if (Session[CSession關鍵字.SK_STOCKDETAIL] == null) { return(Json(new { result = false, msg = "進貨單尚未完成!", url = "" })); } else { List <StockDetailViewModel> stocks = Session[CSession關鍵字.SK_STOCKDETAIL] as List <StockDetailViewModel>; MotaiDataEntities dbContext = new MotaiDataEntities(); tStockList list = new tStockList(); list.sEmployeeId = emp.EmployeeId; list.sStockSerialValue = stockList.sStockSerialValue; list.sVendor = stockList.sVendor; list.sVendorTel = stockList.sVendorTel; list.sStockDate = stockList.sStockDate; list.sStockNote = stockList.sStockNote; dbContext.tStockLists.Add(list); dbContext.SaveChanges(); foreach (var items in stocks) { tStockDetail detail = new tStockDetail(); detail.sStockId = dbContext.tStockLists.OrderByDescending(i => i.StockId).First().StockId; detail.sProductId = items.sProductId; detail.sCost = items.sCost; detail.sQuantity = items.sQuantity; detail.sWarehouseNameId = items.sWarehouseNameId; detail.sNote = items.sNote; dbContext.tStockDetails.Add(detail); //倉儲變動 tWarehouse Warehouse = dbContext.tWarehouses.Where(w => w.WarehouseNameId.Equals(items.sWarehouseNameId) && w.wProductId.Equals(items.sProductId)).FirstOrDefault(); if (Warehouse != null) { Warehouse.wPQty += items.sQuantity; } else { tWarehouse warehouse = new tWarehouse(); warehouse.WarehouseNameId = items.sWarehouseNameId; warehouse.wProductId = items.sProductId; warehouse.wPQty = items.sQuantity; dbContext.tWarehouses.Add(warehouse); } } dbContext.SaveChanges(); Session[CSession關鍵字.SK_STOCKDETAIL] = null; return(Json(new { result = true, msg = "新增成功", url = Url.Action("進貨單建立", "Commodity") })); } } else { return(Json(new { result = false, msg = "尚未登入!", url = Url.Action("員工登入", "Employee") })); } }