//客戶購物車清單 ==> 訂單
public ActionResult OrderPayment()
{
if (String.IsNullOrEmpty((string)Session["logState"])) //如未登入，則重導到登入頁面
{
Session["lastPage"] = "/Order/OrderPayment"; //儲存最後頁面
return(RedirectToAction("Login", "Member")); //重導到登入頁面
}
//將存在session中的 電話取出
string phonString = Session["userPhone"].ToString();
//將存在session中的 桌號取出
int tableNum = Convert.ToInt32(Session["TableId"]);
//int tableNum = 1;
//現在時間字串
string dateString = DateTime.Now.ToString();
if (this.ModelState.IsValid)
{
//取得購物車
var currentCart = Models.Cart.Operation.GetCurrentCart();
using (FoodCourtDBEntities db = new FoodCourtDBEntities()) {
//新增訂單，存入database
Models.Order newOrder = new Order()
{
orderDate = dateString,
phoneNum = phonString,
tableId = tableNum,
orderState = 1, //訂單狀態：1-未結單 2-結單
};
db.Orders.Add(newOrder);
db.SaveChanges();
//傳入訂單編號，取得訂單明細，存入database
var newOrderDetail = currentCart.ToOrderDetail(newOrder.orderId);
db.OrderDetials.AddRange(newOrderDetail);
db.SaveChanges();
//signalR
var querySignalr = from o in newOrderDetail
join p in db.Products on o.productID equals p.productID into r
from p in r.DefaultIfEmpty()
join q in task03_0606.Hubs.StoreHub.signalrsList on p.storeId equals q.StoreId into s
from q in s.DefaultIfEmpty()
group p by new { p.storeId, q.ContextID } into g
select g.Key.ContextID;
var context = GlobalHost.ConnectionManager.GetHubContext <StoreHub>();
foreach (var item in querySignalr)
{
context.Clients.Client(item).addNewMessageToPage("新訂單");
}
} //return Content("訂購成功");
return(RedirectToAction("ClearFromCart", "Cart"));
}
return(View());
}
public ActionResult DeleteConfirmed(int productID)
{
Product product = db.Products.Find(productID);
db.Products.Remove(product);
db.SaveChanges();
return(RedirectToAction("ManagerIndex"));
}
public ActionResult Order_list_bussiness(int orderId_ok)
{
using (Models.FoodCourtDBEntities db = new FoodCourtDBEntities()) {
var order = (from o in db.Orders
where o.orderId == orderId_ok
select o).FirstOrDefault();
order.orderState = 2;
db.SaveChanges();
return(Json(true));
}
}
//廠商未出餐點明細清單 ==> 準備完成
public ActionResult Order_list_chickToDatabase_bussiness(int productId_ok, int orderId_ok)
{
int test = productId_ok;
using (Models.FoodCourtDBEntities db = new FoodCourtDBEntities()) {
var result = (from o in db.OrderDetials
where o.productID == productId_ok && o.orderId == orderId_ok
orderby o.orderId
select o).FirstOrDefault();
if (result.productionStatus == 1)
{
result.productionStatus = 2;
}
else
{
result.productionStatus = 1;
}
db.SaveChanges();
return(Json(true));
}
}
public ActionResult EasyRegister(string LastName, string FirstName, string Password1, string ConfirmPassword, string cellPhone) //只需手機號碼的註冊
//post時，回傳已填入值
{
int checkNum = 0; //用於檢查必填欄位是否填寫
if (!string.IsNullOrEmpty(LastName)) //傳姓氏值
{
ViewBag.LastName = LastName;
checkNum += 1;
}
if (!string.IsNullOrEmpty(FirstName)) //傳名稱值
{
ViewBag.FirstName = FirstName;
checkNum += 1;
}
if (!string.IsNullOrEmpty(cellPhone)) //傳cellPhone值
{
ViewBag.cellPhone = cellPhone;
checkNum += 1;
}
//檢查電話是否註冊----------------------------------
var queryCheckPhone = from o in db.UserInfoes
where o.phoneNum == cellPhone
select cellPhone;
ViewBag.phoneCheck = "";
if (queryCheckPhone.Count() > 0)
{
ViewBag.phoneCheck = "號碼已註冊";
ViewBag.html = "<i class='fa fa-times' style='color: red; '></i> 此號碼已註冊";
}
if (ViewBag.phoneCheck == "信箱已註冊")
{
return(View());
}
else
{
if (Password1 == ConfirmPassword && checkNum == 3)
{
UserInfo addMember = new UserInfo()
{
lastName = LastName,
firstName = FirstName,
pwd = Password1,
phoneNum = cellPhone,
userRank = "normalUser",
userState = 1
};
db.UserInfoes.Add(addMember);
db.SaveChanges();
//try {
// db.SaveChanges();
//} catch (Exception ex) {
// throw;
//}
return(RedirectToAction("Login", "Member"));
}
}
return(View());
}