public ActionResult CoachLogin() { if (Session[CDictionary.user_using_id] == null) { return(RedirectToAction("Index", "Fitness")); } Ctdatatable ct = new Ctdatatable(); int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); var q = (from items in db.tCoach where items.fCoachID == a select items).First(); ViewBag.CoachID = a; return(View(q)); }
public ActionResult Login() { if (Session[CDictionary.user_using_id] == null) { return(RedirectToAction("Index", "Fitness")); } int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); Ctdatatable ct = new Ctdatatable(); var q = (from itemsmember in db.tMember where itemsmember.fMemberId == a select itemsmember).First(); var q1 = from itemsorder in db.tOrder where itemsorder.fMemberId == a select itemsorder; //q2 =======這段不要啟用,會影響到飲食紀錄時間 //var q2 = from membertime in db.tTime // join memberrecord in db.tRecord // on membertime.fTimeId equals memberrecord.fTimeId // where memberrecord.fMemberId == a // select membertime; var q3 = from membertime in db.tTime join memberrecord in db.tRecord on membertime.fTimeId equals memberrecord.fTimeId where memberrecord.fMemberId == a select memberrecord; var q4 = from aa in db.tTime select aa; var q5 = (from itemsorder in db.tOrder join itemscoach in db.tCoach on itemsorder.fCoachID equals itemscoach.fCoachID where itemsorder.fMemberId == a && itemsorder.fEndTime < q.fMember_time && itemsorder.fOrderlike == -1 select itemscoach).FirstOrDefault(); ct.Cmember = q; ct.Corder = q1; ct.Ctime = q4; ct.Crecord = q3; ct.Ccoach = q5; return(View(ct)); }
public ActionResult Editmember(Ctdatatable member) { //string photoName = Guid.NewGuid().ToString(); //photoName += Path.GetExtension(member.Cmember.image.FileName); //member.Cmember.image.SaveAs(Server.MapPath("../Images/" + photoName)); //member.Cmember.fMemberPicture = "../Images/" + photoName; FitnessEntities db = new FitnessEntities(); var q = from items in db.tMember where items.fMemberId == member.Cmember.fMemberId select items; q.First().fMemberName = member.Cmember.fMemberName; q.First().fMemberGender = member.Cmember.fMemberGender; q.First().fMemberPhone = member.Cmember.fMemberPhone; q.First().MemberAddress = member.Cmember.MemberAddress; q.First().fMemberEmail = member.Cmember.fMemberEmail; q.First().fMemberPassword = member.Cmember.fMemberPassword; q.First().fMemberPicture = member.Cmember.fMemberPicture; db.SaveChanges(); return(RedirectToAction("Login")); }
// GET: Canlendar行事曆首頁 public ActionResult Booking(string coachid = "7") { if (Session[CDictionary.user_using_id] == null) { return(RedirectToAction("ViewCoach", "Coach")); } int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); Ctdatatable ct = new Ctdatatable(); var q = (from itemsmember in db.tMember where itemsmember.fMemberId == a select itemsmember).First(); var q1 = from itemsorder in db.tOrder where itemsorder.fMemberId == a select itemsorder; var q2 = from membertime in db.tTime join memberrecord in db.tRecord on membertime.fTimeId equals memberrecord.fTimeId where memberrecord.fMemberId == a select membertime; var q3 = from membertime in db.tTime join memberrecord in db.tRecord on membertime.fTimeId equals memberrecord.fTimeId where memberrecord.fMemberId == a select memberrecord; //var q4 = from aa in db.tTime // select aa; ct.Cmember = q; ct.Corder = q1; ct.Ctime = q2; ct.Crecord = q3; ViewBag.CoachID = coachid; ViewBag.MemberID = Session[CDictionary.user_using_id].ToString(); return(View(ct)); }