public void Add_car(string ProductID) { string UserID = Session["Member"].ToString(); var currentCar = db.ShoppingCarList.Where(m => m.ProductID == ProductID && m.UserID == UserID).FirstOrDefault(); if (currentCar == null) { var product = db.Product.Where(m => m.ProductID == ProductID).FirstOrDefault(); if (product != null) { ShoppingCarList shoppingCarList = new ShoppingCarList(); shoppingCarList.UserID = UserID; shoppingCarList.ProductID = product.ProductID; shoppingCarList.ProductQty = 1; shoppingCarList.Order_Flag = true; shoppingCarList.Create_Date = DateTime.Now; db.ShoppingCarList.Add(shoppingCarList); } else { } } else { currentCar.ProductQty += 1; } }
public ActionResult AddCar(string ProductID) { string UserID = Session["Member"].ToString(); string message = ""; var currentCar = db.ShoppingCarList.Where(m => m.ProductID == ProductID && m.UserID == UserID).FirstOrDefault(); if (currentCar == null) { var product = db.Product.Where(m => m.ProductID == ProductID).FirstOrDefault(); ShoppingCarList shoppingCarList = new ShoppingCarList(); shoppingCarList.UserID = UserID; shoppingCarList.ProductID = product.ProductID; shoppingCarList.ProductQty = 1; shoppingCarList.Order_Flag = true; shoppingCarList.Create_Date = DateTime.Now; db.ShoppingCarList.Add(shoppingCarList); } else { currentCar.ProductQty += 1; } try { db.SaveChanges(); } catch (Exception ex) { throw; } return(RedirectToAction("Check_Car")); }
//[Filters.MemberFilter] public ActionResult ImportOrder(HttpPostedFileBase ImportOrder) { string UserID = Session["Member"].ToString(); FileUploadValidate fs = new FileUploadValidate(); fs.filesize = 2000; string message = ""; ExcelValidate ev = new ExcelValidate(); if (fs.UploadUserFile(ImportOrder)) { if (ev.CheckExcelData(ImportOrder)) { var currentWorkSheet = ev.workbook.Worksheets.First(); int col = 1; int row = 2; foreach (var item in currentWorkSheet.Cells) { if (currentWorkSheet.Cells[row, col].Value != null) { try { string ProductID = currentWorkSheet.Cells[row, col].Value.ToString(); var currentCar = db.ShoppingCarList.Where(m => m.ProductID == ProductID && m.UserID == UserID).FirstOrDefault(); if (currentCar == null) { var product = db.Product.Where(m => m.ProductID == ProductID).FirstOrDefault(); if (product != null) { ShoppingCarList shoppingCarList = new ShoppingCarList(); shoppingCarList.UserID = UserID; shoppingCarList.ProductID = product.ProductID; shoppingCarList.ProductQty = 1; shoppingCarList.Order_Flag = true; shoppingCarList.Create_Date = DateTime.Now; db.ShoppingCarList.Add(shoppingCarList); db.SaveChanges(); message += "<p>[" + row + "," + ProductID + "]新增成功</p>"; } else { message += "<p>[" + row + "]該產品不存在</p>"; } } else { currentCar.ProductQty += 1; message += "<p>[" + row + "," + ProductID + "]新增成功</p>"; } } catch (DbEntityValidationException ex) { TempData["ImportCarMessage"] = "請確認資料格式是否正確"; foreach (var err in ex.EntityValidationErrors) { foreach (var erro in err.ValidationErrors) { var ErrID = erro.PropertyName; if (ErrID == "ProductID") { ErrID = "產品編號"; } else if (ErrID == "ProductName") { ErrID = "產品名稱"; } else if (ErrID == "ProductExplain") { ErrID = "產品說明"; } else if (ErrID == "ProductPrice") { ErrID = "產品價錢"; } message += "<p>[第" + row + "列," + ErrID + "]" + erro.ErrorMessage + "<p/>"; } } } catch (InvalidCastException ex) { var ErrID = ""; if ((col - 1) == 1) { ErrID = "產品編號"; } else if ((col - 1) == 2) { ErrID = "產品名稱"; } else if ((col - 1) == 3) { ErrID = "產品說明"; } else if ((col - 1) == 4) { ErrID = "產品價錢"; } message += "<p>[" + row + "," + ErrID + "]資料型態輸入錯誤</p>"; } catch (Exception ex) { message += ex.Message; } row++; TempData["ExcelResultErrorMessage"] = message; } else { break; } } } return(RedirectToAction("Check_Car")); } else { //ViewBag.ExcelResultErrorMessage = fs.ErrorMessage; TempData["ExcelResultErrorMessage"] = fs.ErrorMessage; return(RedirectToAction("Index", "Home")); } }