public PrizeExercisePlanWeek GetExercisePlanWeek(int planWeekId) { try { db.Database.Connection.Open(); PrizeExercisePlanWeek planWeek = (from c in db.PrizeExercisePlanWeeks where c.Id == planWeekId select c).FirstOrDefault(); return(planWeek); } finally { db.Database.Connection.Close(); } }
public string GetCurrentDailyViewURL(int memberId) { string result = ""; MemberExercisePlanWeek memberPlanWeek = GetCurrentMemberPlanWeek(memberId); if (memberPlanWeek == null) { return(result); } PrizeExercisePlanWeek planWeek = GetExercisePlanWeek(memberPlanWeek.ExercisePlanWeekId); if (planWeek == null) { return(result); } result = String.Format("{0}?PlanWeekId={1}&MemberPlanWeekId={2}&PlanDayNumber={3}", PrizeConstants.URL_MEMBER_DAY_VIEW, planWeek.Id, memberPlanWeek.Id, PrizeCommonUtils.GetSystemDate().GetDayOfWeek()); return(result); }
protected void Insert(object sender, EventArgs e) { int iStart = Convert.ToInt32(txtStartWeek.Text); int iEnd; if (!int.TryParse(txtEndWeek.Text, out iEnd)) { iEnd = iStart; } if (iStart > iEnd) { Response.Write("<script>alert('Start week can not larger than end week.');</script>"); return; } using (DIYPTEntities db = new DIYPTEntities()) { PrizeExercisePlanWeek planWeek = (from c in db.PrizeExercisePlanWeeks where c.ExercisePlanId == planId && (c.StartWeek >= iStart && c.StartWeek <= iEnd || c.EndWeek >= iStart && c.EndWeek <= iEnd) select c).FirstOrDefault(); if (planWeek != null) { Response.Write("<script>alert('There is a start week or end week already in this plan.');</script>"); return; } db.Database.Connection.Open(); { PrizeExercisePlanWeek CD = new PrizeExercisePlanWeek(); CD.ExercisePlanId = planId; CD.StartWeek = iStart; CD.EndWeek = iEnd; CD.Description = txtDescription.Text; db.PrizeExercisePlanWeeks.Add(CD); db.SaveChanges(); } txtStartWeek.Text = ""; txtEndWeek.Text = ""; txtDescription.Text = ""; db.Database.Connection.Close(); this.BindGrid(); } }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string startWeek = (row.FindControl("txtStartWeek") as TextBox).Text; string endWeek = (row.FindControl("txtEndWeek") as TextBox).Text; string Description = (row.FindControl("txtDescription") as TextBox).Text; using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExercisePlanWeek item = (from c in db.PrizeExercisePlanWeeks where c.Id == Id select c).FirstOrDefault(); item.Description = Description; item.StartWeek = Convert.ToInt32(startWeek); item.EndWeek = Convert.ToInt32(endWeek); db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
protected void Page_Load(object sender, EventArgs e) { /* * //Handled in BaseOrientation// * if (PrizeMemberAuthUtils.CurrentUserLogin() != true) * return; */ int memberId = PrizeMemberAuthUtils.GetMemberID(); var exercisePlan = dbAccess.GetCurrentMemberPlanOrStartingPlan(memberId); if (exercisePlan == null) { PrizeMember member = PrizeMemberAuthUtils.GetMemberData(memberId); PrizeMemberPlanManager planMan = new PrizeMemberPlanManager(); Response.Redirect(planMan.GetEmptyPlanJumpURL(member)); } InitLables(); //var member = PrizeMemberAuthUtils.GetMemberData(); //lblTest.Text = member.Questions; if (Request["MemberPlanWeekID"] != null) { int memberPlanWeekId; int.TryParse(Request["MemberPlanWeekID"], out memberPlanWeekId); memberPlanWeek = dbAccess.GetMemberPlanWeekById(memberPlanWeekId); planWeek = dbAccess.GetExercisePlanWeek(memberPlanWeek.ExercisePlanWeekId); } else { DateTime now = PrizeCommonUtils.GetSystemDate(); memberPlanWeek = dbAccess.GetCurrentMemberPlanWeek(memberId); //(MemberExercisePlanWeek)Session["MemberPlanWeek"]; if (memberPlanWeek == null && PrizeCommonUtils.LessThanDaysAhead(now, exercisePlan.StartDate, 1)) { memberPlanWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(exercisePlan.Id, 0); } if (memberPlanWeek == null) { HideLinks(); topInfo.Visible = false; dayPre.Visible = false; dayNext.Visible = false; dayView.Visible = false; printDay.Visible = false; timesaverDiv.Visible = false; timesaverDivMobile.Visible = false; divNotStarted.Visible = true; return; } divNotStarted.Visible = false; planWeek = dbAccess.GetExercisePlanWeek(memberPlanWeek.ExercisePlanWeekId); } currentPlanWeekId = (int)memberPlanWeek.ExercisePlanWeekId; // dayView.HRef = dbAccess.GetCurrentDailyViewURL(memberId); LoadWeeklyInfo(memberId, planWeek, memberPlanWeek); MemberExercisePlan myPlan = dbAccess.GetMemberExercisePlan(memberPlanWeek.MemberExercisePlanId); MemberExercisePlanWeek prevWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(myPlan.Id, memberPlanWeek.Week - 1); if (prevWeek != null) { dayPre.NavigateUrl = "/my-account/exercise-view?MemberPlanWeekID=" + prevWeek.Id; dayPre.Text = "Week " + (memberPlanWeek.Week - 1); } else { dayPre.Attributes.Add("class", "no-arrow"); } MemberExercisePlanWeek nextWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(myPlan.Id, memberPlanWeek.Week + 1); if (nextWeek != null) { dayNext.NavigateUrl = "/my-account/exercise-view?MemberPlanWeekID=" + nextWeek.Id; dayNext.Text = "Week " + (memberPlanWeek.Week + 1); } else { dayNext.Attributes.Add("class", "no-arrow"); } }
protected void LoadDailyInfo(int iMemberId, PrizeExercisePlanWeek planWeek) { //lblExercise.Text = dbWeek.Description; //lblWeek.Text = dbWeek.Week.ToString(); foreach (var lbl in labels) { lbl.Text = PrizeConstants.STR_NO_TRAINNING; } DataSet ds = dbAccess.GetMemberWeeklyInfo(planWeek.Id); int DayTimeTypeId1 = 0; //int DayTimeTypeId2 = 0; foreach (DataRow row in ds.Tables[0].Rows) { int iWeekDay = (int)row[0] - 1; int iDayTimeType = (int)row[1]; //(int)reader.GetInt32(3); if (iWeekDay < labels.Count) { int iIndex = iWeekDay; //if (iDayTimeType == DayTimeTypeId2) //iIndex += 7; labels[iIndex].Text = (String)row[2];//reader.GetString(1); } //if (iWeekDay == (int)(PrizeCommonUtils.GetSystemDate().DayOfWeek)) //exerciseUnitSets.Add((int)row[4]); //((int)reader.GetInt32(4)); } HtmlControl temp = (HtmlControl)FindControl("day" + (int)(PrizeCommonUtils.GetSystemDate().GetDayOfWeek())); HtmlControl tempe = (HtmlControl)FindControl("day" + (int)(PrizeCommonUtils.GetSystemDate().GetDayOfWeek()) + "e"); /*if (temp != null) * { * temp.Attributes.Add("style", "background-color: #eee"); * tempe.Attributes.Add("style", "background-color: #eee"); * } */ for (int i = 0; i < 7; i++) { DataSet dsDaily = dbAccess.GetExerciseUnitsSetDetail(planWeek.Id, i + 1); double dTimeDuration = 0; int iTimeDuration = 0; for (int j = 1; j < dsDaily.Tables.Count; j++) { foreach (DataRow row in dsDaily.Tables[j].Rows) { dTimeDuration += double.Parse(row["TimeDuration"].ToString()); iTimeDuration = (int)Math.Ceiling((double)dTimeDuration / 60); } } if (dsDaily.Tables.Count > 1) { iTimeDuration = iTimeDuration + 10 + 5; // +10 warm up; +5 cool down } lblTimeDuration[i].Text = "" + iTimeDuration; } for (int i = 0; i < 7; i++) { switch (labels[i].Text.Trim()) { case "Brisk walk": lblTimeDuration[i].Text = "30 mins"; break; case "Own 1hr cardio": case "Own training": case "Own cardio": lblTimeDuration[i].Text = "60 mins"; break; case "30-60min weekend physical activity": case "Weekend physical activity": lblTimeDuration[i].Text = "30-60 mins"; break; case "Rest Day": lblTimeDuration[i].Text = "All Day"; break; default: lblTimeDuration[i].Text += " mins"; break; } } }
protected void LoadWeeklyInfo(int memberID, PrizeExercisePlanWeek planWeek, MemberExercisePlanWeek memberPlanWeek) { dayNumber = PrizeCommonUtils.GetSystemDate().GetDayOfWeek(); int memberId = PrizeMemberAuthUtils.GetMemberID(); using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); lblDateDuration.Text = PrizeCommonUtils.ParseDateToEnglish(memberPlanWeek.StartDate) + " - " + PrizeCommonUtils.ParseDateToEnglish(memberPlanWeek.EndDate); for (int i = 0; i < lblDates.Count; i++) { lblDates[i].Text = PrizeCommonUtils.ParseShortDateToEnglish(memberPlanWeek.StartDate.AddDays(i)); HyperLink linkDay = FindControl("linkDay" + (i + 1)) as HyperLink; if (linkDay != null && planWeek != null) { linkDay.NavigateUrl = (String.Format("{0}?PlanWeekId={1}&MemberPlanWeekId={2}&PlanDayNumber={3}", PrizeConstants.URL_MEMBER_DAY_VIEW, planWeek.Id, memberPlanWeek.Id, i + 1)); } else if (planWeek == null) { //Orientation week linkDay.NavigateUrl = "/orientation/day-" + (i + 1); labels[i].Text = "Orientation day " + (i + 1); } } if (planWeek == null) { lblWeekNum.Text = "Week 0"; PrizeDataAccess dba = new PrizeDataAccess(); if (dba.MemberInOrientation(PrizeMemberAuthUtils.GetMemberID())) { topInfo.Visible = false; } db.Database.Connection.Close(); return; } int iWeekNum = memberPlanWeek.Week; lblWeekNum.Text = "Week " + iWeekNum; string[] planWeekDesc = planWeek.Description.Split('\n'); bool bEquipmentSession = false; if (strEquipments == null) { strEquipments = new List <string>(); } for (int i = 0; i < planWeekDesc.Length; i++) { string[] strKeyValue = planWeekDesc[i].Split(':'); if (strKeyValue != null && strKeyValue.Length > 1) { if ((i == 1) && (strKeyValue[0].IndexOf("phase", StringComparison.OrdinalIgnoreCase) >= 0)) { lblTrainingPhase.Text = strKeyValue[1]; continue; } if ((i == 2) && (strKeyValue[0].IndexOf("phase duration", StringComparison.OrdinalIgnoreCase) >= 0 || (strKeyValue[0].IndexOf("training duration", StringComparison.OrdinalIgnoreCase) >= 0))) { lblDuration.Text = strKeyValue[1]; continue; } if (strKeyValue[0].IndexOf("equipment", StringComparison.OrdinalIgnoreCase) >= 0) { bEquipmentSession = true; strEquipments.Clear(); continue; } } if (bEquipmentSession && Regex.Matches(planWeekDesc[i], @"[a-zA-Z]").Count > 0) { strEquipments.Add(planWeekDesc[i]); continue; } } if (strEquipments != null && strEquipments.Count > 0) { string tempLiteral = "<ul class='equipment-list'>"; foreach (var e in strEquipments) { if (e != " ") { tempLiteral += "<li>" + e + "</li>"; } } tempLiteral += "</ul>"; equipmentLiteral.Text = tempLiteral; equipmentLiteralMobile.Text = tempLiteral; equipmentDiv.Visible = true; } DataSet myPlan = dbAccess.GetExercisePlanInfo((int)planWeek.ExercisePlanId); if (myPlan.Tables[0].Rows.Count == 0) { db.Database.Connection.Close(); return; } this.lblGoal.Text = myPlan.Tables[0].Rows[0]["ProgramName"].ToString(); LoadDailyInfo(memberId, planWeek); //PrizePlanProgram myProgram = (from c in db.PrizePlanPrograms // where c.Id == planWeek.ExercisePlanId // select c).FirstOrDefault(); db.Database.Connection.Close(); } }
protected void Page_Load(object sender, EventArgs e) { int memberId = PrizeMemberAuthUtils.GetMemberID(); var exercisePlan = dbAccess.GetCurrentMemberPlanOrStartingPlan(memberId); if (exercisePlan == null) { PrizeMember member = PrizeMemberAuthUtils.GetMemberData(memberId); PrizeMemberPlanManager planMan = new PrizeMemberPlanManager(); Response.Redirect(planMan.GetEmptyPlanJumpURL(member)); } if (int.TryParse(Request["MemberPlanWeekId"], out memberPlanWeekId)) { _MemberPlanWeek = dbAccess.GetMemberPlanWeekById(memberPlanWeekId); } if (_MemberPlanWeek == null) { _MemberPlanWeek = dbAccess.GetCurrentMemberPlanWeek(memberId); } if (_MemberPlanWeek == null) { divMeasurement.Visible = false; btnUpdateProgress.Enabled = false; this.photoPanelUpload.Visible = false; return; } InitPageControls(); frontUpload.Attributes["onchange"] = "UploadFile(this)"; sideUpload.Attributes["onchange"] = "UploadFile(this)"; backUpload.Attributes["onchange"] = "UploadFile(this)"; _PlanWeek = dbAccess.GetExercisePlanWeek(_MemberPlanWeek.ExercisePlanWeekId); iWeekNum = this.GetLatestMeasurementWeekNum(_MemberPlanWeek.Week); if (iWeekNum != _MemberPlanWeek.Week) { _MemberPlanWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(_MemberPlanWeek.MemberExercisePlanId, iWeekNum); } if (_MemberPlanWeek == null) { divMeasurement.Visible = false; btnUpdateProgress.Enabled = false; this.photoPanelUpload.Visible = false; return; } if (!PrizeConstants.WEEKS_NEEDS_RESULT.Contains(iWeekNum)) { divMeasurement.Visible = false; } lblWeekNum.Text = iWeekNum.ToString(); //lblWeekNum2.Text = lblWeekNum.Text; lblWeekNum3.Text = iWeekNum.ToString(); if (!IsPostBack) { WeekResults = dbAccess.GetMemberPlanResults(_MemberPlanWeek.MemberExercisePlanId); LoadWeeklyResult(WeekResults); LoadMemberPhotos(iWeekNum, WeekResults); DrawProgressGraph((int)_MemberPlanWeek.MemberExercisePlanId, WeekResults); LoadPreNextLinks(); } MemberExercisePlan myPlan = dbAccess.GetCurrentMemberPlan(PrizeMemberAuthUtils.GetMemberID()); if (myPlan != null) { PrizeExercisePlan plan = dbAccess.GetExercisePlan(myPlan.ExercisePlanId); if (plan != null) { if (plan.PlanName.ToLower().Contains("muscle")) { lblMeasurement3.Text = "Right arm biceps (cm)"; lblMeasurementGraph3.Text = "Right arm biceps"; lblMeasurementMetricGraph3.Text = "(cm)"; lblMeasurement4.Text = "Chest (cm)"; lblMeasurementGraph4.Text = "Chest"; lblMeasurementMetricGraph4.Text = "(cm)"; lblMeasurement5.Text = "Right thigh (cm)"; lblMeasurementGraph5.Text = "Right thigh"; lblMeasurementMetricGraph5.Text = "(cm)"; } if (plan.PlanName.ToLower().Contains("tone")) { lblMeasurement3.Text = "Right arm biceps (cm)"; lblMeasurementGraph3.Text = "Right arm biceps"; lblMeasurementMetricGraph3.Text = "(cm)"; lblMeasurement4.Text = "Hips (cm)"; lblMeasurementGraph4.Text = "Hips"; lblMeasurementMetricGraph4.Text = "(cm)"; lblMeasurement5.Text = "Right thigh (cm)"; lblMeasurementGraph5.Text = "Right thigh"; lblMeasurementMetricGraph5.Text = "(cm)"; } if (plan.PlanName.ToLower().Contains("weight")) { lblMeasurement3.Text = "Chest (cm)"; lblMeasurementGraph3.Text = "Chest"; lblMeasurementMetricGraph3.Text = "(cm)"; lblMeasurement4.Text = "Hips (cm)"; lblMeasurementGraph4.Text = "Hips"; lblMeasurementMetricGraph4.Text = "(cm)"; lblMeasurement5.Text = "Heart rate (per min)"; lblMeasurementGraph5.Text = "Heart rate"; lblMeasurementMetricGraph5.Text = "(per min)"; } } } }