public yuOrderViewModel(TOrder p, TCupon pCupon, TMember pMember, TOrderStatus pOrderStatus) { iv_Order = p; CCupon = pCupon; CMember = pMember; COrderStatus = pOrderStatus; }
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 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 CreateNewMember([FromBody] CCustomerCreateViewModel newMember) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); var check信箱 = from n in db.TMembers select n.CEmail; var check手機 = from n in db.TMembers select n.CPhone; if (check信箱.Any(n => n == newMember.CEmail) == true) { return(Json("EmailRepeat")); } else if (check手機.Any(n => n == newMember.CPhone) == true) { return(Json("PhoneRepeat")); } else { string 邀請碼 = shareFun.產生亂數(6); newMember.CBlackList = 0; newMember.CFreezeCount = 0; newMember.CDeposit = 0; newMember.CRegisteredTime = DateTime.Now; newMember.COpenMember = 0; var check邀請碼 = from n in db.TMembers select n.CReferrerCode; //抓推薦人 if (!string.IsNullOrEmpty(newMember.code)) { var 抓推薦人 = from n in db.TMembers where n.CReferrerCode == newMember.code select n.CMemberId; int[] 推薦人ID = 抓推薦人.ToArray(); newMember.CReferrerID = 推薦人ID[0]; } else { newMember.CReferrerID = null; } //防止邀請碼重複 while (check邀請碼.Any(n => n == 邀請碼) == true) { 邀請碼 = shareFun.產生亂數(6); } newMember.CReferrerCode = 邀請碼; db.TMembers.Add(newMember.member); db.SaveChanges(); //註冊折價卷 var 新增註冊折價卷 = from n in db.TMembers where n.CMemberId == newMember.CMemberID select n.CReferrerId; int?[] 邀請人ID = 新增註冊折價卷.ToArray(); if (邀請人ID[0] != null) { TCupon 新增邀請人折價卷 = new TCupon { CCuponCategoryId = 2, CMenberId = (int)邀請人ID[0], CBeUsed = 0, CDiscountCode = shareFun.產生亂數(6), CReceivedTime = DateTime.Now, CValidDate = DateTime.Now.AddDays(60) }; TCupon 新增新會員折價卷 = new TCupon { CCuponCategoryId = 3, CMenberId = newMember.CMemberID, CBeUsed = 0, CDiscountCode = shareFun.產生亂數(6), CReceivedTime = DateTime.Now, CValidDate = DateTime.Now.AddDays(60) }; db.TCupons.Add(新增邀請人折價卷); db.TCupons.Add(新增新會員折價卷); db.SaveChanges(); } //密碼雜湊 TMember add密碼雜湊 = (from n in db.TMembers where n.CMemberId == newMember.CMemberID select n).FirstOrDefault(); SHA1 sha1 = SHA1.Create(); string 雜湊密碼 = shareFun.GetHash(sha1, add密碼雜湊.CPassword); add密碼雜湊.CPassword = 雜湊密碼; db.SaveChanges(); string val信件內容 = "歡迎加入BuyFood,請點擊以下連結以開通帳號 \n" + CDictionary.LOCAL_WEBSITES + "/Customer/memberConfirm?ID=" + add密碼雜湊.CMemberId; shareFun.sendGrid(add密碼雜湊.CEmail, add密碼雜湊.CName, "BuyFood帳號開通認證信", val信件內容); return(Json(true)); } }
public JsonResult CreateNewFacebookMember([FromBody] CCustomerCreateViewModel newMember) { 擺腹BuyFoodContext db = new 擺腹BuyFoodContext(); var check信箱 = from n in db.TMembers select n.CEmail; var check手機 = from n in db.TMembers select n.CPhone; if (check信箱.Any(n => n == newMember.CEmail) == true) { return(Json("EmailRepeat")); } else if (check手機.Any(n => n == newMember.CPhone) == true) { return(Json("PhoneRepeat")); } else { string 邀請碼 = shareFun.產生亂數(6); newMember.CBlackList = 0; newMember.CFreezeCount = 0; newMember.CDeposit = 0; newMember.CRegisteredTime = DateTime.Now; newMember.COpenMember = 1; var check邀請碼 = from n in db.TMembers select n.CReferrerCode; //抓推薦人 if (!string.IsNullOrEmpty(newMember.code)) { var 抓推薦人 = from n in db.TMembers where n.CReferrerCode == newMember.code select n.CMemberId; int[] 推薦人ID = 抓推薦人.ToArray(); newMember.CReferrerID = 推薦人ID[0]; } else { newMember.CReferrerID = null; } //防止邀請碼重複 while (check邀請碼.Any(n => n == 邀請碼) == true) { 邀請碼 = shareFun.產生亂數(6); } newMember.CReferrerCode = 邀請碼; db.TMembers.Add(newMember.member); db.SaveChanges(); //註冊折價卷 var 新增註冊折價卷 = from n in db.TMembers where n.CMemberId == newMember.CMemberID select n.CReferrerId; int?[] 邀請人ID = 新增註冊折價卷.ToArray(); if (邀請人ID[0] != null) { TCupon 新增邀請人折價卷 = new TCupon { CCuponCategoryId = 2, CMenberId = (int)邀請人ID[0], CBeUsed = 0, CReceivedTime = DateTime.Now, CValidDate = DateTime.Now.AddDays(60) }; TCupon 新增新會員折價卷 = new TCupon { CCuponCategoryId = 3, CMenberId = newMember.CMemberID, CBeUsed = 0, CReceivedTime = DateTime.Now, CValidDate = DateTime.Now.AddDays(60) }; db.TCupons.Add(新增邀請人折價卷); db.TCupons.Add(新增新會員折價卷); db.SaveChanges(); } return(Json(true)); } }