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 void orderCancel(int?id) { if (id != null) { TOrder l_order被修改 = db.TOrders.FirstOrDefault(n => n.COrderId == id); TMember l_member被修改 = db.TMembers.FirstOrDefault(n => n.CMemberId == l_order被修改.CMemberId); TCupon l_cupon被修改 = db.TCupons.FirstOrDefault(n => n.CCuponId == l_order被修改.CCuponId); TCuponCategory p折扣金額 = db.TCuponCategories.FirstOrDefault(n => n.CCuponCategoryId == l_cupon被修改.CCuponCategoryId); IEnumerable <TOrderDetail> table = null; table = db.TOrderDetails.Where(n => n.COrderId == id); List <TOrderDetail> list = new List <TOrderDetail>(); foreach (var item in table) { list.Add(item); } decimal p總價 = 0; decimal p價格 = 0; int p數量 = 0; int pID = 0; for (int i = 0; i < list.Count(); i++) { //消費金額 p價格 = list[i].CPriceAtTheTime.Value; p數量 = list[i].CQuantity.Value; p總價 += (p價格 * p數量); //產品庫存 pID = list[i].CProductId; TProduct l_product被修改 = db.TProducts.FirstOrDefault(n => n.CProductId == pID); l_product被修改.CQuantity += p數量; } if (l_order被修改.CPayTypeId.Value == 1) { //無折扣 if (l_order被修改.CCuponId.Value == 1) { l_order被修改.COrderStatusId = 3; l_member被修改.CDeposit += p總價; } //有折扣 else { l_order被修改.COrderStatusId = 3; l_member被修改.CDeposit += (p總價 - p折扣金額.CCutPrice.Value); l_cupon被修改.CBeUsed = 0; } } else { l_order被修改.COrderStatusId = 3; } db.SaveChanges(); } }
public IActionResult CreateCategory(CCategoryViewModel p_產品類別新增) { if (!string.IsNullOrEmpty(p_產品類別新增.CCategoryName)) { db.TProductCategories.Add(p_產品類別新增.allTProductCategory); db.SaveChanges(); } return(RedirectToAction("CategoryList")); }
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 getDetailValue(int StarValue, string ReviewInput, int orderdetailID) { string test = $"{StarValue}分,{ReviewInput},編號{orderdetailID}號"; var UpdateScore = db.TOrderDetails.Where(n => n.COrderDetailId == orderdetailID).FirstOrDefault(); UpdateScore.CScores = StarValue; UpdateScore.CReview = ReviewInput; UpdateScore.CFeedBackStatus = 1; db.SaveChanges(); return(Json(UpdateScore)); }
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 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 IActionResult Create(MemberManagementViewModel newMember) { string photoName = Guid.NewGuid().ToString() + ".jpg"; if (newMember.image != null) { using (var photo = new FileStream(iv_host.WebRootPath + @"\MemberPhoto\" + photoName, FileMode.Create)) { newMember.image.CopyTo(photo); } } newMember.CPicture = @"/MemberPhoto/" + photoName; db.TMembers.Add(newMember.member); db.SaveChanges(); return(RedirectToAction("List")); }
//[HttpPost] //public IActionResult List(string pkeyword ,string pkeyword2) //{ // IEnumerable<TProduct> table = null; // string a = pkeyword2; // if (string.IsNullOrEmpty(pkeyword)) // { // table = from p in (new 擺腹BuyFoodContext()).TProducts // select p; // } // else // { // table = from p in (new 擺腹BuyFoodContext()).TProducts // where((p.CProductName).ToLower()).Contains(pkeyword.ToLower()) // select p; // } // if(pkeyword2 != null) // { // table = from p in (new 擺腹BuyFoodContext()).TProducts // where p.CCategoryId == int.Parse(pkeyword2) // select p; // } // List<CProductViewModel> list = new List<CProductViewModel>(); // foreach (TProduct t in table) // { // list.Add(new CProductViewModel(t)); // } // return View(list); //} #region 產品販售狀況 public JsonResult changeSaleonoff(int?PrId, int PrTimeId) { if (PrId != null) { TProduct l_p販售狀態 = db.TProducts.FirstOrDefault(n => n.CProductId == PrId); if (PrTimeId == 1) { PrTimeId = 2; l_p販售狀態.CIsOnSaleId = PrTimeId; } else if (PrTimeId == 2) { PrTimeId = 3; l_p販售狀態.CIsOnSaleId = PrTimeId; } else { PrTimeId = 1; l_p販售狀態.CIsOnSaleId = PrTimeId; } db.SaveChanges(); } return(Json(PrTimeId)); }
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 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 void ActionUpRank(int?id) { if (id != null) { TActivity table = db.TActivities.FirstOrDefault(n => n.CActivityId == id); if (table != null) { if (table.CRank == 99) { var newnum = (from x in db.TActivities where x.CRank != 99 && x.CStatus != 0 select x).Count(); table.CRank = newnum + 1; } else { table.CRank = 99; } } db.SaveChanges(); } }
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 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(); } }
public void saveTheNewOrders(string userName, string OrderMessage) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); DateTime dn = DateTime.Now; TMessageOrder messageOrder = new TMessageOrder { CMessageOrder = OrderMessage, CUserName = userName, CIsRead = 0, CSaveTime = dn }; db.Add(messageOrder); db.SaveChanges(); }
public IActionResult ActivityCreat(yuActivityViewModel p) { 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; p.CTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); db.TActivities.Add(p.Activity); db.SaveChanges(); return(RedirectToAction("ActivityList")); }
public string usecoupon() { Random r = new Random(); 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); var orders = db.TOrders.Select(n => new { n.COrderId, sum = n.TOrderDetails.Sum(m => m.CPriceAtTheTime * m.CQuantity) }).Where(n => n.sum > 400).ToList(); foreach (var order in orders) { var target = db.TOrders.First(n => n.COrderId == order.COrderId); target.CCuponId = r.Next(1, 5); } db.SaveChanges(); return("done"); }
public string savePassword([FromBody] changePassword data) { 擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext(); TMember reviseTarget = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(data.memberID)); ShareFunction sf = new ShareFunction(); SHA1 sha1 = SHA1.Create(); string SHAoPassword = sf.GetHash(sha1, data.oPassword); //string SHAoPassword = data.oPassword; string SHAnPassword = sf.GetHash(sha1, data.nPassword); if (SHAoPassword != reviseTarget.CPassword) { return("1"); } reviseTarget.CPassword = SHAnPassword; dbcontext.SaveChanges(); return("0"); }
public IActionResult memberConfirm() { string memberOpenID = HttpContext.Request.Query["ID"]; 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); TMember openMember = (from n in db.TMembers where n.CMemberId == int.Parse(memberOpenID) select n).FirstOrDefault(); openMember.COpenMember = 1; db.SaveChanges(); HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERNAME, openMember.CName); HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERPHOTO, openMember.CPicture); HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERID, openMember.CMemberId.ToString()); return(Redirect("~/HomePage/Home")); }
public bool gotoblack(int?id) { TOrderDetail table = db.TOrderDetails.FirstOrDefault(n => n.COrderDetailId == id); bool x = true; if (table != null) { if (table.CFeedBackStatus == 1) { table.CFeedBackStatus = 0; } else { table.CFeedBackStatus = 1; x = false; } } db.SaveChanges(); return(x); }
public IActionResult ActionUpDelete(int?id) { if (id != null) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); TActivity table = db.TActivities.FirstOrDefault(n => n.CActivityId == id); if (table != null) { if (table.CStatus == 1) { table.CStatus = 0; table.CRank = 99; } else { table.CStatus = 1; } } db.SaveChanges(); } return(RedirectToAction("ActivityList")); }
public JsonResult UploadOneFile(IFormFile photo) { string memberID = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID); if (!string.IsNullOrEmpty(memberID) && photo.Length > 0) { string photoName = Guid.NewGuid().ToString() + ".jpg"; string photoPath = iv_host.WebRootPath + @"\MemberPhoto\" + photoName; using ( var addphoto = new FileStream(photoPath, FileMode.Create)) { photo.CopyTo(addphoto); } 擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext(); TMember target = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(memberID)); target.CPicture = @"/MemberPhoto/" + photoName; dbcontext.SaveChanges(); HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERPHOTO, target.CPicture); return(Json(new { result = "1", msg = "上傳成功", src = target.CPicture })); } return(Json(new { result = "0", msg = "上傳失敗" })); }
public void DetailBoardDelete([FromBody] List <yupushstrViewModel> Array) { if (Array != null) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); for (int i = 0; i < Array.Count; i++) { TOrderDetail table = db.TOrderDetails.FirstOrDefault(a => a.COrderDetailId.ToString() == Array[i].strmember); if (table != null) { if (table.CFeedBackStatus == 1) { table.CFeedBackStatus = 0; } else { table.CFeedBackStatus = 1; } } db.SaveChanges(); } } }
public void saveContext(string MemberName, string Content, string MessageTime, string foto, int userID, int difChatRoomID) { if (userID != 16 || difChatRoomID == 16) { return; } DateTime theSaveTime = DateTime.Now; TChatRoom cr = new TChatRoom() { CContent = Content, CMessageTime = MessageTime, CSaveTime = theSaveTime, CMemberId = userID, CPhoto = foto, CDifRoomId = difChatRoomID, CReview = 1 }; db.TChatRooms.Add(cr); db.SaveChanges(); }
public JsonResult forgetMemberCheck([FromBody] CForgetPasswordViewModel forgetPwdMember) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); var check信箱 = from n in db.TMembers select n.CEmail; if (check信箱.Any(n => n == forgetPwdMember.CEmail) == true) { TMember checkPhone = (from n in db.TMembers where n.CEmail == forgetPwdMember.CEmail select n).FirstOrDefault(); if (checkPhone.CPhone == forgetPwdMember.CPhone) { SHA1 sha1 = SHA1.Create(); string RandomPwd = shareFun.產生亂數(16); string ReplacementPwd = shareFun.GetHash(sha1, RandomPwd); checkPhone.CPassword = ReplacementPwd; db.SaveChanges(); string val信件內容 = "您的密碼已被修改成 : " + RandomPwd + " , 請登入後自行修改密碼"; shareFun.sendGrid(checkPhone.CEmail, checkPhone.CName, "BuyFood帳號開通認證信", val信件內容); return(Json("EditSuccess")); } else { return(Json("wrongPhone")); } } else { return(Json("noEmail")); } }
public void ActionDelete([FromBody] List <yupushstrViewModel> Array) { if (Array != null) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); for (int i = 0; i < Array.Count; i++) { TActivity table = db.TActivities.FirstOrDefault(a => a.CActivityId.ToString() == Array[i].strmember); if (table != null) { if (table.CPicture != null) { FileInfo file = new FileInfo(table.CPicture); if (file.Exists) { file.Delete(); } } db.Remove(table); db.SaveChanges(); } } } }
public void getMessage(string MemberName, string Content, string MessageTime, string foto, int userID) { if (userID == 16) { return; } 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); DateTime theSaveTime = DateTime.Now; TChatRoom cr = new TChatRoom() { CContent = Content, CMessageTime = MessageTime, CSaveTime = theSaveTime, CMemberId = userID, CPhoto = foto, CDifRoomId = userID, CReview = 0 }; db.TChatRooms.Add(cr); db.SaveChanges(); }
public void saveDepositResult(ViewModelForOPay returnData) { DateTime now = DateTime.Now; 擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext(); TMember changeTarget = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(returnData.StoreID)); if (returnData.RtnCode == 1) { TDeposit result = new TDeposit { CMemberId = int.Parse(returnData.StoreID), CDepositTime = now, CDepositAmount = returnData.TradeAmt, CDepositRecordNo = returnData.MerchantTradeNo }; dbcontext.TDeposits.Add(result); changeTarget.CDeposit += returnData.TradeAmt; int couponCategory = 0; switch (returnData.TradeAmt) { case 1000: couponCategory = 2; break; case 2000: couponCategory = 4; break; case 5000: couponCategory = 7; break; default: break; } if (couponCategory != 0) { string dsCode = ""; while (dsCode == "") { bool check = false; string newCode = (new ShareFunction()).產生亂數(6); var data = dbcontext.TCupons; foreach (var item in data) { if (item.CDiscountCode == newCode) { check = true; break; } } if (!check) { dsCode = newCode; } } TCupon newCoupon = new TCupon { CCuponCategoryId = couponCategory, CMenberId = int.Parse(returnData.StoreID), CDiscountCode = dsCode, CValidDate = now.AddDays(60), CReceivedTime = now }; dbcontext.TCupons.Add(newCoupon); } dbcontext.SaveChanges(); } string EmailContent = returnData.RtnCode == 1 ? $"已成功於{now.ToString("yyyy/MM/dd")}加值共{returnData.TradeAmt}擺腹幣" : $"加值失敗,請重新加值並確認付款內容。"; (new ShareFunction()).sendGrid(changeTarget.CEmail, changeTarget.CName, "通知-加值結果", EmailContent); }
public JsonResult newOrder() { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); int[] memberBox = new int[] { 11, 17, 21, 30, 31 }; string[] addressBox = new string[] { "106台北市大安區復興南路一段303號9樓", "106台北市大安區信義路三段147巷11弄1號1樓", "106台北市大安區瑞安街31巷1號", "106台北市大安區通安街115號", "106台北市大安區新生南路二段50號", "105台北市松山區敦化北路199號", "106台北市大安區忠孝東路四段77巷28號", "104台北市中山區市民大道三段143號", "106台北市大安區安和路二段92號B1F", "106台北市大安區復興南路二段102號", "106台北市大安區仁愛路三段26-5號", "106台北市大安區建國南路二段231號", "106台北市大安區通安街115號", "106台北市大安區新生南路二段50號", "105台北市松山區敦化北路199號", "110台北市信義區信義路五段1號", "106台北市大安區光復南路180巷11號", }; string[] dateBox = new string[] { "2021/01/01 10:10:10", "2021/02/01 10:10:10", "2021/03/01 10:10:10", "2021/04/01 10:10:10", "2020/01/01 10:10:10", "2020/02/01 10:10:10", "2020/03/01 10:10:10", "2020/04/01 10:10:10", "2020/05/01 10:10:10", "2020/06/01 10:10:10", "2020/07/01 10:10:10", "2020/08/01 10:10:10", "2020/09/01 10:10:10", "2020/10/01 10:10:10", "2020/11/01 10:10:10", "2020/12/01 10:10:10", }; Random random = new Random(); var productBox = db.TProducts.ToList(); for (int i = 0; i < 2000; i++) { TOrder order = new TOrder() { CMemberId = memberBox[random.Next(0, 3)], COrderStatusId = 2, CCuponId = 1, CArrivedAddress = addressBox[random.Next(0, 8)], CPayTypeId = 1, COrderDate = dateBox[random.Next(0, dateBox.Count())], CTransportMinute = random.Next(5, 30) }; db.TOrders.Add(order); db.SaveChanges(); var orderdetailCount = random.Next(1, 6); for (int p = 0; p < orderdetailCount; p++) { var productID = productBox[random.Next(0, productBox.Count())].CProductId; TOrderDetail od = new TOrderDetail() { CProductId = productID, COrderId = order.COrderId, CQuantity = random.Next(1, 4), CPriceAtTheTime = productBox.First(n => n.CProductId == productID).CPrice, }; db.TOrderDetails.Add(od); } } db.SaveChanges(); return(Json("done")); }