/// <summary> /// 顯示會員的方案購買紀錄 /// </summary> /// <param name="MemberNo">會員Id</param> /// <returns></returns> public ActionResult MyPurchaseSeries(int MemberId) { try { //驗證授權:一般會員 var pass = roleAuth.UserAuth(); if (pass == true) { ViewBag.UserName = roleAuth.UserName(); ViewBag.RoleName = "User"; } else { TempData["Msg"] = "無權限瀏覽該網頁,請登入會員瀏覽,謝謝!"; return(RedirectToAction("Logout", "Home")); } //取得會員購買方案資料 PurchaseRecordOperation pr = new PurchaseRecordOperation(); var LstRec = pr.Get(MemberId); List <MyPurchaseSeriesViewModel> LstVm = new List <MyPurchaseSeriesViewModel>(); foreach (var item in LstRec) { //取得購買方案相關資訊 CourseSeriesOperation cs = new CourseSeriesOperation(); var csRec = cs.Get(item.CourseSeries_No); var name = csRec.Name; var info = csRec.CourseInfo; var price = Convert.ToInt16(csRec.Price); var payStatus = ""; if (item.PayStatus == true) { payStatus = "已付款"; } else { payStatus = "未付款"; } //顯示會員購買方案 MyPurchaseSeriesViewModel vm = new MyPurchaseSeriesViewModel() { Id = item.CourseSeries_No, Name = name, CourseInfo = info, Price = price, Count = item.Count, Date = item.Date.ToString(), PayStatus = payStatus, }; LstVm.Add(vm); } return(View(LstVm)); } catch (Exception ex) { TempData["Msg"] = ex.ToString(); return(RedirectToAction("Logout", "Home")); } }
public ActionResult SeriesDetail(SeriesDetailViewModel model) { try { //驗證授權:一般會員 var pass = roleAuth.UserAuth(); if (pass == true) { ViewBag.UserName = roleAuth.UserName(); ViewBag.RoleName = "User"; } else { TempData["Msg"] = "無權限瀏覽該網頁,請登入會員瀏覽,謝謝!"; return(RedirectToAction("Logout", "Home")); } var UserEmail = User.Identity.Name; MemberOperation member = new MemberOperation(); //取得會員Id var MemberId = member.GetNo(UserEmail); //取得會員資料 var memberData = member.Get(UserEmail); //購買方案數量 var BuyCnt = Convert.ToInt16(model.Count); //新增方案購買紀錄 PurchaseRecord purchaseRecord = new PurchaseRecord(); purchaseRecord.Date = DateTime.Now; //購買日期 purchaseRecord.Count = BuyCnt; //購買數量 purchaseRecord.PayStatus = true; //付款狀態 purchaseRecord.CourseSeries_No = model.SeriesId; //方案代號 purchaseRecord.Member_No = MemberId; //會員id PurchaseRecordOperation pr = new PurchaseRecordOperation(); pr.Add(purchaseRecord); //找出課程方案內容 CourseSeriesDetailOperation csd = new CourseSeriesDetailOperation(); var seriesDetails = csd.Get(model.SeriesId); //找出會員課程table筆數 MemberCourseOperation mco = new MemberCourseOperation(); int dataCnt = mco.GetCount(); //將課程方案內容新增至會員課程 List <MemberCourse> LstCourses = new List <MemberCourse>(); foreach (var item in seriesDetails) { MemberCourse memberCourse = new MemberCourse(); CourseTypeOperation cto = new CourseTypeOperation(); memberCourse.MemberCourseNo = dataCnt + 1; memberCourse.CourseType_no = item.CourseType_No; //課程類型代號 memberCourse.Member_No = MemberId; //會員id memberCourse.Num = item.Num * BuyCnt; //課程堂數=原方案內容課程數*購買數量 LstCourses.Add(memberCourse); } mco.Add(LstCourses); return(RedirectToAction("MyPurchaseSeries", new { MemberId })); } catch (Exception ex) { TempData["Msg"] = ex.ToString(); return(RedirectToAction("Logout", "Home")); } }