/*public ActionResult Index(Models.OrderModel.Ship postback)
{
return View();
}*/
public ActionResult Index(Models.OrderModel.Ship postback)
{
if(this.ModelState.IsValid)
{
//取得目前的購物車
var currentcart = Models.Cart.Operation.GetCurrentCart();
//取得目前登入使用Id
var userId = HttpContext.User.Identity.GetUserId();
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
//建立Order物件
var order = new Models.Cart.Order()
{
UserId = userId,
RecieverName = postback.RecieverName,
RecieverPhone = postback.RecieverPhone,
RecieverAddress = postback.RecieverAddress
};
//加入Orders資料表後，儲存變更
db.Orders.Add(order);
db.SaveChanges();
//取得購物車中OrderDetail物件
var orderDetails = currentcart.ToOrderDetailList(order.Id);
//將其加入OrderDetails資料表後，儲存變更
db.OrderDetails.AddRange(orderDetails);
db.SaveChanges();
}
return RedirectToAction("OrderSuccess");
}
return View();
}
public ActionResult Edit(Models.Cart.Product postback)
{
if(this.ModelState.IsValid) //判斷使用者輸入資料是否正確
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.Products where s.Id == postback.Id select s).FirstOrDefault();
//儲存使用者變更資料
result.Name = postback.Name; result.Price = postback.Price;
result.PublishDate = postback.PublishDate; result.Quantity = postback.Quantity;
result.Status = postback.Status; result.CategoryId = postback.CategoryId;
result.DefaultImageId = postback.DefaultImageId; result.Description = postback.Description;
result.DefaultImageURL = postback.DefaultImageURL;
//存入資料庫
db.SaveChanges();
//成功後回index頁面
TempData["ResultMessage"] = String.Format("商品[{0}]成功編輯", postback.Name);
return RedirectToAction("Index");
}
}
else //如果資料不正確則回到自己的頁面(Edit)
{
return View(postback);
}
}
public ActionResult Vegetable()
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.Products where s.CategoryId == 2 select s).ToList();
return View(result);
}
}
public ActionResult Index()
{
using(Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.Products select s).ToList();
return View(result);
}
}
public ActionResult Index()
{//取得Order中所有資料
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.Orders
select s).ToList();
return View(result);
}
}
public ActionResult MyOrder()
{
var userId = HttpContext.User.Identity.GetUserId();
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.Orders
where s.UserId == userId
select s).ToList();
return View(result);
}
}
public ActionResult Index()
{
//宣告<Product>result，等等要接db撈出來的資料
List<Models.Cart.Product> result = new List<Models.Cart.Product>();
//接收訊息
ViewBag.ResultMessage = TempData["ResultMessage"];
//DB把資料取出
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
result = (from s in db.Products select s).ToList();
return View(result);
}
}
//編輯商品頁面(從資料庫中取出此資料資訊)
public ActionResult Edit(int id)
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
//抓取Product.Id 輸入id的資料
var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
if(result != default(Models.Cart.Product))//判斷此id是否有資料
{
return View(result);
}
else
{
TempData["ResultMessage"] = "資料有誤，請重新操作";
return RedirectToAction("Index");
}
}
}
public ActionResult Details(int id)
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
//取得OrderId為傳入id的所有商品列表
var result = (from s in db.OrderDetails
where s.OrderId == id
select s).ToList();
if (result.Count == 0)
{//如果商品數目為零，代表該訂當異常
return RedirectToAction("Index");
}
else
{
return View(result);
}
}
}
public ActionResult Detail(int id)
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.Products
where s.Id == id
select s).FirstOrDefault();
if (result == default(Models.Cart.Product))
{
return RedirectToAction("Index");
}
else
{
return View(result);
}
}
}
public ActionResult MyOrderDetail(int id)
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
var result = (from s in db.OrderDetails
where s.OrderId == id
select s).ToList();
if(result.Count ==0 )
{
return RedirectToAction("Index");
}
else
{
return View(result);
}
}
}
public ActionResult Create(Models.Cart.Product postback)
{
if (this.ModelState.IsValid)//資料驗證成功
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
//回傳資料postback加入Products
db.Products.Add(postback);
//存取異動資料
db.SaveChanges();
//設定成功訊息
TempData["ResultMessage"] = String.Format("商品[{0}]成功建立", postback.Name);
return RedirectToAction("Index");
}
}
//失敗訊息
ViewBag.ResultMessage = "資料有誤請檢查";
return View(postback);
}
public ActionResult Delete(int id)
{
using (Models.Cart.CartDBContext db = new Models.Cart.CartDBContext())
{
//抓取product id
var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
if(result != default(Models.Cart.Product))//判斷id是否有資料
{
db.Products.Remove(result);
db.SaveChanges();
//設定成功訊息並導回index頁面
TempData["ResultMessage"] = String.Format("商品[{0}]成功刪除", result.Name);
return RedirectToAction("Index");
}
else
{ //如果沒有資料則顯示錯誤，並回index頁面
TempData["ResultMessage"] = "指定資料不存在，無法刪除，請重新操作";
return RedirectToAction("Index");
}
}
}
