/// <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"));
}
}
