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