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"));
}
}
