internal List <CallendarVM> GetMemberbookData(string memberid = "2") //會員檢視自己排的課 { int _memberid = int.Parse(memberid); var resultLst = (from q in db.tOrder join m in db.tMember on q.fMemberId equals m.fMemberId join c in db.tCoach on q.fCoachID equals c.fCoachID where (q.fMemberId == _memberid) select new tBookingVM { GymId = q.fGynId, OrderID = q.forderid, MemberId = q.fMemberId, MemberName = m.fMemberName, CoachName = c.fCoachName, CoachId = q.fCoachID, OrderStatus = q.fSuccessed.ToString(), StartTime = q.fStartTime, Endtime = q.fEndTime, TrainingName = q.fTrainingName, GymName = (from p in db.tStudio where p.fId == q.fGynId select p.fCorpName).FirstOrDefault() }).ToList(); List <CallendarVM> callendarLst = new List <CallendarVM>(); foreach (var p in resultLst) { CallendarVM c = new CallendarVM(); c.type = string.IsNullOrWhiteSpace(p.Type) ? "member" : "coach"; c.groupId = p.OrderID.ToString(); c.coachid = p.CoachId.ToString(); c.coachrestid = p.RestID; c.membername = p.MemberName; c.title = p.TrainingName; c.start = p.StartTime.ToString("yyyy-MM-dd HH:mm"); c.end = p.Endtime.ToString("yyyy-MM-dd HH:mm"); c.color = "steelblue"; c.GymName = p.GymName; c.GymId = p.GymId; c.TrainingName = p.TrainingName; c.OrderStatus = p.OrderStatus; c.CoachName = p.CoachName; callendarLst.Add(c); } return(callendarLst); }
internal List <CallendarVM> GetTbookDataByid(string id, string coachid, string memberid) //撈所有事件資料 { int _id = int.Parse(id); int _memberid = int.Parse(memberid); int _coachid = int.Parse(coachid); //會員預定 var memberLst = (from q in db.tOrder join m in db.tMember on q.fMemberId equals m.fMemberId where (q.fMemberId == _memberid) && q.fCoachID == _coachid && q.forderid == _id select new tBookingVM { GymId = q.fGynId, OrderID = q.fLessonId, MemberId = q.fMemberId, MemberName = m.fMemberName, CoachId = q.fCoachID, OrderStatus = q.fSuccessed.ToString(), StartTime = q.fStartTime, Endtime = q.fEndTime, TrainingName = q.fTrainingName, GymName = (from p in db.tStudio where p.fId == q.fGynId select p.fCorpName).FirstOrDefault() }).ToList(); List <CallendarVM> callendarLst = new List <CallendarVM>(); foreach (var p in memberLst) { CallendarVM c = new CallendarVM(); c.type = string.IsNullOrWhiteSpace(p.Type) ? "member" : "coach"; c.groupId = p.OrderID.ToString(); c.membername = p.MemberName; c.title = p.TrainingName; c.start = p.StartTime.ToString("yyyy-MM-dd HH:mm"); c.end = p.Endtime.ToString("yyyy-MM-dd HH:mm"); c.color = "steelblue"; c.GymName = p.GymName; c.GymId = p.GymId; c.TrainingName = p.TrainingName; callendarLst.Add(c); } return(callendarLst); }
internal List <CallendarVM> GetTbookData(string memberid, string coachid) //撈所有事件資料 { int _memberid = int.Parse(memberid); int _coachid = int.Parse(coachid); bool isCoach = false; if (memberid == "-1") { isCoach = true; } //會員預定 var memberLst = (from q in db.tOrder join m in db.tMember on q.fMemberId equals m.fMemberId join c in db.tCoach on q.fCoachID equals c.fCoachID where ((q.fMemberId == _memberid) || isCoach) && q.fCoachID == _coachid && q.fSuccessed.ToString() != "2" select new tBookingVM { GymId = q.fGynId, OrderID = q.forderid, MemberId = q.fMemberId, MemberName = m.fMemberName, CoachId = q.fCoachID, CoachName = c.fCoachName, OrderStatus = q.fSuccessed.ToString(), StartTime = q.fStartTime, Endtime = q.fEndTime, TrainingName = q.fTrainingName, GymName = (from p in db.tStudio where p.fId == q.fGynId select p.fCorpName).FirstOrDefault() }).ToList(); //教練畫休 var coachLst = (from q in db.tCoachRest where q.fCoachId == _coachid select new tBookingVM { OrderID = q.fRestId, RestID = q.fRestId, CoachId = q.fCoachId, StartTime = q.fStartTime, Endtime = q.fEndTime, GymName = q.Description, Type = "Coach" }).ToList(); //會員預定+教練畫休 var resultLst = memberLst.Union(coachLst).ToList(); List <CallendarVM> callendarLst = new List <CallendarVM>(); foreach (var p in resultLst) { CallendarVM c = new CallendarVM(); c.type = string.IsNullOrWhiteSpace(p.Type) ? "member" : "coach"; c.groupId = p.OrderID.ToString(); c.coachid = p.CoachId.ToString(); c.coachrestid = p.RestID; c.membername = p.MemberName; c.title = p.TrainingName; c.start = p.StartTime.ToString("yyyy-MM-dd HH:mm"); c.end = p.Endtime.ToString("yyyy-MM-dd HH:mm"); c.color = "steelblue"; c.GymName = p.GymName; c.GymId = p.GymId; c.TrainingName = p.TrainingName; c.OrderStatus = p.OrderStatus; c.CoachName = p.CoachName; callendarLst.Add(c); } return(callendarLst); }