public JsonResult SubmitManaualCourse(int sqno, int[] selected)
{
try
{
Member targetMember = db.Member.Where(x => x.sqno == sqno).FirstOrDefault();
if (targetMember == null)
{
return(Json(new { result = "member not found" }));
}
MemberCourse temp;
foreach (int courseid in selected)
{
temp = new MemberCourse()
{
CourseSqno = courseid, mrSqno = sqno, mrNumber = targetMember.mrNumber, IsAttend = "Y", CreateDate = DateTime.Now
};
db.MemberCourse.Add(temp);
db.SaveChanges();
}
return(Json(new { result = "success" }));
}
catch
{
return(Json(new { result = "error" }));
}
}
public ActionResult EditCourseStudentAttend(int sqno, string IsAttend)
{
MemberCourse model = db.MemberCourse.Where(x => x.sqno == sqno).FirstOrDefault();
if (model == null)
{
ViewBag.ErrorMessage = "找不到資料";
return(RedirectToAction("Index"));
}
else
{
model.IsAttend = IsAttend;
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
var result = new { success = true };
return(Json(result));
}
}
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"));
}
}
public void Update(MemberCourse item)
{
}
