public ActionResult Edit(Models.Product postback)
{
if (this.ModelState.IsValid)
{
using (main.Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.Products where s.Id == postback.Id select s).FirstOrDefault();
//Revise Data
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;
//save data which changed
db.SaveChanges();
//retuen message
TempData["ResultMessage"] = String.Format("成功編輯");
return(RedirectToAction("Index"));
}
}
else
{
return(View(postback));
}
}
public ActionResult Index(Models.OrderModel.Ship postback)
{
if (this.ModelState.IsValid)
{
var currentcart = Models.Cart.Operation.GetCurrentCart();
var UserId = HttpContext.User.Identity.GetUserId();
using (Models.mainEntities db = new Models.mainEntities())
{
//Order object
var order = new Models.Order()
{
UserId = UserId,
RecieverName = postback.ReceiverName,
RecieverPhone = postback.ReceiverPhone,
RecieverAddress = postback.ReceiverAddress
};
//Add data table
db.OrderSet.Add(order);
db.SaveChanges();
//Get OrderDetail Object
var orderDetails = currentcart.ToOrderDetailList(order.Id);
// insert to order datatable
db.OrderDetailSet.AddRange(orderDetails);
db.SaveChanges();
}
return(Content("訂購成功!"));
}
return(View());
}
// GET: ManageOrder
public ActionResult Index()
{
//取得Models
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.OrderSet select s).ToList();
return(View(result));
}
}
public ActionResult MyOrder()
{
var userId = HttpContext.User.Identity.GetUserId();
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.OrderSet where s.UserId == userId select s).ToList();
return(View(result));
}
}
public ActionResult Index()
{
//修正為抓取商品
//return View();
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.Products select s).ToList();
return(View(result));
}
}
// GET: Product
public ActionResult Index()
{
List <Models.Product> result = new List <Models.Product>();
// Get Success Message
ViewBag.ResultMessage = TempData["ResultMessage"];
using (Models.mainEntities db = new Models.mainEntities())
{
//LinQ
result = (from s in db.Products select s).ToList();
return(View(result));
}
}
public ActionResult MyOrderDetail(int Id)
{
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.OrderDetailSet where s.OrderId == Id select s).ToList();
if (result.Count == 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(result));
}
}
}
//細項
public ActionResult Details(int Id)
{
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.Products where s.Id == Id select s).FirstOrDefault();
if (result == default(Models.Product))
{
return(RedirectToAction("Index"));
}
else
{
return(View(result));
}
}
}
public ActionResult Edit(int id)
{
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
if (result != default(Models.Product))
{
return(View(result));
}
else
{
TempData["resultMessage"] = "資料有誤，請重新操作";
return(RedirectToAction("Index"));
}
}
}
public ActionResult Create(Models.Product postback)
{
if (this.ModelState.IsValid)
{
using (Models.mainEntities db = new Models.mainEntities())
{
db.Products.Add(postback);
db.SaveChanges();
//Success Message
TempData["ResultMessage"] = String.Format("商品[{0}]建立成功", postback.Name);
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.ResultMessage = "資料有誤";
return(View());
}
}
public ActionResult Delete(int id)
{
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
if (result != default(Models.Product))
{
db.Products.Remove(result);
db.SaveChanges();
TempData["resultMessage"] = String.Format("商品[{0}]已刪除", result.Name);
return(RedirectToAction("Index"));
}
else
{
TempData["resultMessage"] = String.Format("沒有找到指定商品，無法刪除");
return(RedirectToAction("Index"));
}
}
}
public ActionResult SearchByUserName(string UserName)
{
string searchId = null;
using (Models.UserEntities db = new Models.UserEntities())
{
searchId = (from s in db.AspNetUsers where s.UserName == UserName select s.Id).FirstOrDefault();
}
if (!String.IsNullOrEmpty(searchId))
{
using (Models.mainEntities db = new Models.mainEntities())
{
var result = (from s in db.OrderSet where s.UserId == searchId select s).ToList();
return(View("Index", result));
}
}
else
{
return(View("Index", new List <Models.Order>()));
}
}
