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