public JsonResult getDrinks()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var getDrinks = db.TProducts.Where(n => n.CProductId == 5 || n.CProductId == 26 || n.CProductId == 24).Select(n => n).ToList();
return(Json(getDrinks));
}
public IActionResult ProductData(int?id) //在商品頁面所選擇的產品顯示出來
{
//var product = db.TProducts.Where(x => x.CProductId == id).FirstOrDefault();
if (!string.IsNullOrEmpty(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERNAME)))
{
ViewBag.USERNAME = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERNAME);
ViewBag.USERPHOTO = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERPHOTO);
ViewBag.USERUSERID = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID);
}
var product = new 擺腹BuyFoodContext().TProducts.Where(x => x.CProductId == id).FirstOrDefault();
return(View(product));
//int? A = db.TOrderDetails.Where(n => n.CProductId == id && n.CFeedBackStatus == 1).Count();
//int? B = db.TOrderDetails.Where(n => n.CProductId == id && n.CFeedBackStatus == 1).Sum(n => n.CScores);
//ViewBag.Bcount = A;
//try
//{
// ViewBag.Bagv = B / A;
//}
//catch
//{
// ViewBag.Bagv = 0;
//}
//return View(product);
}
public JsonResult getOrderTime()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var OrderIDs = db.TOrders.Select(n => n.COrderId).ToList();
foreach (var ID in OrderIDs)
{
var getOrderTime = db.TOrders.Where(n => n.COrderId == ID).Select(n => n.COrderDate).FirstOrDefault();
DateTime OrderTime = DateTime.ParseExact(getOrderTime, "yyyy/MM/dd HH:mm:ss", null);
var getPrepTime = db.TOrderDetails.Where(n => n.COrderId == ID).OrderByDescending(n => n.CProduct.CFinishedTime).Select(n => n.CProduct.CFinishedTime).FirstOrDefault().GetValueOrDefault();
var TransportTIme = db.TOrders.Where(n => n.COrderId == ID).Select(n => n.CTransportMinute).FirstOrDefault().GetValueOrDefault();
DateTime TimeOfArrival = OrderTime.AddMinutes((getPrepTime + TransportTIme));
if (DateTime.Now >= TimeOfArrival)
{
var StatusID = db.TOrders.FirstOrDefault(n => n.COrderId == ID);
if (StatusID.COrderStatusId == 1)
{
StatusID.COrderStatusId = 4;
db.SaveChanges();
}
}
}
return(Json(null));
}
public IActionResult MemberCenter()
{
ViewBag.LOCALWEBSITES = CDictionary.LOCAL_WEBSITES;
if (!string.IsNullOrEmpty(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERNAME)))
{
ViewBag.userName = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERNAME);
ViewBag.userPhoto = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERPHOTO);
ViewBag.memberID = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID);
ViewBag.facebook = string.IsNullOrEmpty(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_FACEBOOK)) ? "0" : "1";
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember data = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID)));
if (TempData[CDictionary.REDIRECT_FROM_WHERE] != null)
{
// 1:儲值, 2:套餐
string goWhere = TempData[CDictionary.REDIRECT_FROM_WHERE].ToString();
return(View(new MemberCenterViewModel(data, goWhere)));
}
return(View(new MemberCenterViewModel(data, "0")));
}
else
{
return(RedirectToAction("登入", "HomePage"));
}
}
public JsonResult ActivityPageView()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var table = db.TActivities.Where(n => n.CStatus == 1).OrderByDescending(n => n.CActivityId).Select(n => n);
return(Json(table.ToList()));
}
public JsonResult getActivity()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var getActivity = db.TActivities.Select(n => n).OrderByDescending(n => n).Where(n => n.CStatus == 1).Take(3).ToList();
return(Json(getActivity));
}
public JsonResult ListMessages(int ChannelID)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
//在一開始就從資料庫抓資料至畫面顯示
//判斷會員是否是自己
var MessagesBefore = from mes in db.TChatRooms
where mes.CDifRoomId == ChannelID
join member in db.TMembers on mes.CMemberId equals member.CMemberId
orderby mes.CSaveTime
select new
{
CChatRoomId = mes.CChatRoomId,
CMemberId = mes.CMemberId,
CMemberName = member.CName,
CContent = mes.CContent,
CMessageTime = mes.CMessageTime,
CSaveTime = mes.CSaveTime,
mes.CPhoto,
mes.CDifRoomId
};
//把ID換成名稱
return(Json(MessagesBefore.ToList()));
}
public JsonResult getFried()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var getFried = db.TProducts.Where(n => n.CProductId == 14 || n.CProductId == 30).Select(n => n).ToList();
return(Json(getFried));
}
public JsonResult getNoodels()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var getNoodels = db.TProducts.Where(n => n.CProductId == 10 || n.CProductId == 17 || n.CProductId == 58).Select(n => n).ToList();
return(Json(getNoodels));
}
public JsonResult getArroz()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var getArroz = db.TProducts.Where(n => n.CProductId == 19 || n.CProductId == 20).Select(n => n).ToList();
return(Json(getArroz));
}
public bool facebookLogin(string id, string name)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
//檢查是否用此帳號登入過
var checkID = from n in db.TMembers
select n.CFacebookId;
if (checkID.Any(n => n == id) == true)
{
var loginFacebookMember = (from n in db.TMembers
where n.CFacebookId == id
select n).FirstOrDefault();
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERNAME, loginFacebookMember.CName);
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERPHOTO, loginFacebookMember.CPicture);
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERID, loginFacebookMember.CMemberId.ToString());
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_FACEBOOK, "FacebookMember");
return(true);
}
else
{
return(false);
}
}
public JsonResult UploadImage(IFormFile photo, string CPhone)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TMember mem新增圖片 = (from n in db.TMembers
where n.CPhone == CPhone
select n).FirstOrDefault();
if (photo != null)
{
string photoname = Guid.NewGuid().ToString() + ".jpg";
using (var MemberPhoto = new FileStream(iv_host.WebRootPath + @"\MemberPhoto\" + photoname, FileMode.Create))
{
photo.CopyTo(MemberPhoto);
}
mem新增圖片.CPicture = @"/MemberPhoto/" + photoname;
db.SaveChanges();
return(Json(new { result = true }));
}
else
{
mem新增圖片.CPicture = @"/MemberPhoto/無人頭.jpg";
db.SaveChanges();
}
return(Json(new { result = false }));
}
public JsonResult GetMemberFavoriteItem([FromBody] int MemberID)
{
DateTime TimeNow = DateTime.Now;
擺腹BuyFoodContext BuyFoodDB = new 擺腹BuyFoodContext();
var result = from i in BuyFoodDB.TOrderDetails
join x in BuyFoodDB.TProducts
on i.CProductId equals x.CProductId
where i.COrder.CMemberId == MemberID
select new
{
i.CProductId,
x.CProductTagId
};
//依產品風格統計曾經購買最多次的商品
var GroupResult = (from u in result
group u by u.CProductTagId into g
orderby g.Count() descending
select new
{
g.Key,
OrderCount = g.Count(),
}).Take(1).FirstOrDefault();
if (GroupResult == null)
{
var HotItemList = HttpContext.Session.GetObject <List <TProduct> >("TopItem");
return(Json(HotItemList.Take(5)));
}
//將該會員購買最多次的商品風格作為選擇條件、隨機選取出來
var FavorItem = BuyFoodDB.TProducts.Where(x => x.CProductTagId == GroupResult.Key && x.CIsOnSaleId == 1 && x.CIsBreakFast == 1 && x.CIsLunch == 1).
OrderBy(x => Guid.NewGuid()).Select(x => x).ToList().Take(5);
return(Json(FavorItem));
}
public IActionResult ActionEdit(yuActivityViewModel p)
{
if (p != null)
{
if (p.img != null)
{
string pohotoname = Guid.NewGuid().ToString() + ".jpg";
using (var photo = new FileStream(iv_host.WebRootPath + @"\imgs\" + pohotoname, FileMode.Create))
{
p.img.CopyTo(photo);
}
p.CPicture = @"../imgs/" + pohotoname;
}
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TActivity table = db.TActivities.FirstOrDefault(a => a.CActivityId == p.CActivityId);
if (table != null)
{
table.CActivityName = p.CActivityName;
table.CDescription = p.CDescription;
table.CLink = p.CLink;
table.CStatus = p.CStatus;
if (p.CPicture != null)
{
table.CPicture = p.CPicture;
}
db.SaveChanges();
}
}
return(RedirectToAction("ActivityList"));
}
public JsonResult getOrderAdress(int OrderID)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var Orders = db.TOrders.Where(n => n.COrderId == OrderID).Select(n => n);
return(Json(Orders.ToList()));
}
public JsonResult saveProfile([FromBody] TMember member)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember data = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == member.CMemberId);
data.CName = member.CName;
dbcontext.SaveChanges();
return(Json(data));
}
public void saveCombo([FromBody] List <jComboDetail> list)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
if (list.First().cID != 0)
{
TCombo reviseTarget = dbcontext.TCombos.FirstOrDefault(n => n.CComboId == list.First().cID);
reviseTarget.CComboName = list.First().cName;
var removetarget = dbcontext.TComboDetails.Where(n => n.CComboId == list[0].cID);
dbcontext.TComboDetails.RemoveRange(removetarget);
foreach (var item in list)
{
for (int i = 0; i < item.q; i++)
{
TComboDetail detail = new TComboDetail
{
CComboId = item.cID,
CProductId = item.pID,
};
dbcontext.TComboDetails.Add(detail);
}
;
}
;
dbcontext.SaveChanges();
}
else
{
TCombo newcombo = new TCombo
{
CComboName = list.First().cName,
CMemberId = list.First().mID,
};
dbcontext.TCombos.Add(newcombo);
dbcontext.SaveChanges();
int newcomboID = dbcontext.TCombos.Where(n => n.CMemberId == list.First().mID).OrderByDescending(n => n.CComboId).First().CComboId;
foreach (var item in list)
{
for (int i = 0; i < item.q; i++)
{
TComboDetail detail = new TComboDetail
{
CComboId = newcomboID,
CProductId = item.pID,
};
dbcontext.TComboDetails.Add(detail);
}
;
}
;
dbcontext.SaveChanges();
}
//return "done";
}
public JsonResult DidLogingetBottomList(int MemberID)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
#region 最新商品
var lastProducts = db.TProducts.OrderByDescending(n => n.CProductId).Select(n => n).Take(6);
#endregion
#region //好評商品
var gettopProducts = (from tp in db.TOrderDetails
group tp by tp.CProductId into g
select new
{
g.Key,
AvgScore = g.Sum(n => n.CScores) / g.Count()
}).OrderByDescending(n => n.AvgScore).Select(n => n.Key).ToList().Take(6);
List <TProduct> topProducts = new List <TProduct>();
foreach (var p in gettopProducts)
{
topProducts.Add(db.TProducts.Where(n => n.CProductId == p).Select(n => n).FirstOrDefault());
}
#endregion
HttpContext.Session.SetObject <List <TProduct> >("TopItem", topProducts);
#region //最常購買
var ReviewProducts = db.TOrderDetails.OrderByDescending(n => n.COrder.COrderDate).Select(n => new
{
n.CProductId,
product = n.CProduct
}).Take(100)
.GroupBy(n => n.CProductId).Select(n => new
{
n.Key,
product = new List <TProduct>(),
count = n.Count()
}).OrderByDescending(n => n.count).Take(6).ToList();
foreach (var item in ReviewProducts)
{
TProduct product = db.TProducts.FirstOrDefault(n => n.CProductId == item.Key);
item.product.Add(product);
}
#endregion
var table = new { lastProducts = lastProducts, topProducts = topProducts, ReviewProducts = ReviewProducts };
return(Json(table));
}
public JsonResult getMember(int OrderID)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var MemberID = db.TOrders.Where(n => n.COrderId == OrderID).Select(n => n.CMemberId).FirstOrDefault();
var Member = db.TMembers.Where(n => n.CMemberId == MemberID).Select(n => n);
return(Json(Member.ToList()));
}
public JsonResult OrderStatusDateOnGoing(int memberID)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var OrderStatusDate = from o in db.TOrders
where o.CMemberId == memberID && o.COrderStatus.COrderStatusId == 1
select new { cOrderStatus = o.COrderStatus.COrderStatusName, cOrderDate = o.COrderDate, cCutPrice = o.CCupon.CCuponCategory.CCutPrice };
return(Json(OrderStatusDate.ToList()));
}
public JsonResult OrderStatusDateFinished(int memberID)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var OrderStatusDate = (from o in db.TOrders
where o.CMemberId == memberID && o.COrderStatus.COrderStatusId == 2
select new { cOrderStatus = o.COrderStatus.COrderStatusName, cOrderDate = o.COrderDate, cCutPrice = o.CCupon.CCuponCategory.CCutPrice, cOID = o.COrderId }).OrderByDescending(n => n.cOID).Take(10);
return(Json(OrderStatusDate.ToList()));
}
public void do_all_review_0()
{
擺腹BuyFoodContext db = (new 擺腹BuyFoodContext());
var table = db.TChatRooms.Where(n => n.CReview == 0).Select(n => n).ToList();
foreach (var item in table)
{
item.CReview = 1;
db.SaveChanges();
}
}
public IActionResult CreateCategory(CCategoryViewModel p_產品類別新增)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
if (!string.IsNullOrEmpty(p_產品類別新增.CCategoryName))
{
db.TProductCategories.Add(p_產品類別新增.allTProductCategory);
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public void clearAllnewOrderMessage()
{
擺腹BuyFoodContext db = (new 擺腹BuyFoodContext());
var mesR = db.TMessageOrders.Select(n => n).OrderByDescending(n => n.CSaveTime).Take(20).ToList();
foreach (var n in mesR)
{
n.CIsRead = 1;
db.SaveChanges();
}
}
//public JsonResult addCombo(string id)
//{
// 擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
// var combos = dbcontext.TCombos.Where(n => n.CMemberId == int.Parse(id)).Count() +1;
// TCombo newCombo = new TCombo
// {
// CComboName = "套餐" + combos,
// CMemberId = int.Parse(id)
// };
// dbcontext.TCombos.Add(newCombo);
// dbcontext.SaveChanges();
// TCombo data = dbcontext.TCombos.Where(n => n.CMemberId == int.Parse(id)).OrderByDescending(n => n.CComboId).FirstOrDefault();
// return Json(data);
//}
public void deleteCombo(string id)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
var comboDetails = dbcontext.TComboDetails.Where(n => n.CComboId == int.Parse(id));
dbcontext.TComboDetails.RemoveRange(comboDetails);
var combo = dbcontext.TCombos.FirstOrDefault(n => n.CComboId == int.Parse(id));
dbcontext.TCombos.Remove(combo);
dbcontext.SaveChanges();
}
public JsonResult ProductFinishTime([FromBody] List <int> IdList)
{
List <int> pdtTimeList = new List <int>();
foreach (var i in IdList)
{
var result = new 擺腹BuyFoodContext().TProducts.Where(x => x.CProductId == i)
.Select(x => x.CFinishedTime).FirstOrDefault();
pdtTimeList.Add((int)result);
}
return(Json(pdtTimeList));
}
public JsonResult QRcode(string id)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember targetMember = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(id));
string head = $"<h1>推薦碼 : {targetMember.CReferrerCode}</h1>";
string contenxt = CDictionary.LOCAL_WEBSITES + $"/Customer/Create?id={targetMember.CReferrerCode}";
List <string> data = new List <string>();
data.Add(head);
data.Add(contenxt);
return(Json(data));
}
public IActionResult ActionEdit(int?id)
{
if (id != null)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TActivity table = db.TActivities.FirstOrDefault(n => n.CActivityId == id);
if (table != null)
{
return(View(new yuActivityViewModel(table)));
}
}
return(RedirectToAction("ActivityList"));
}
public JsonResult ActivityupdateTOP()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
int All = db.TActivities.Select(n => n).Count();
int Going = db.TActivities.Where(n => n.CStatus == 1).Select(n => n).Count();
int close = db.TActivities.Where(n => n.CStatus == 0).Select(n => n).Count();
int mouth = db.TActivities.Where(n => n.CTime.Contains(DateTime.Now.Year.ToString()) && n.CTime.Contains(DateTime.Now.Month.ToString())).Select(n => n).Count();
int year = db.TActivities.Where(n => n.CTime.Contains(DateTime.Now.Year.ToString())).Select(n => n).Count();
var my_num = new { All = All, Going = Going, close = close, mouth = mouth, year = year };
return(Json(my_num));
}
public void ActionDeletealone(int?id)
{
if (id != null)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var table = db.TActivities.FirstOrDefault(n => n.CActivityId == id);
if (table != null)
{
db.Remove(table);
}
db.SaveChanges();
}
}
