public bool GetNextAndPrevPlanWeek(MemberExercisePlanWeek currentMemberPlanWeek, ref int prevMemberPlanWeekId, ref int nextMemberPlanWeekId) { prevMemberPlanWeekId = -1; nextMemberPlanWeekId = -1; string statusFinished = PrizeConstants.STATUS_PLAN_FINISHED; //+ PrizeConstants.STATUS_PLAN_PAID; MemberExercisePlanWeek aMemberPlanWeek = (from c in db.MemberExercisePlanWeeks where c.MemberId == currentMemberPlanWeek.MemberId && c.StartDate < currentMemberPlanWeek.StartDate && c.Status.Equals(statusFinished) orderby c.StartDate descending select c).FirstOrDefault(); if (aMemberPlanWeek != null) { prevMemberPlanWeekId = aMemberPlanWeek.Id; } //statusFinished = PrizeConstants.STATUS_PLAN_FINISHED + PrizeConstants.STATUS_PLAN_PAID; string statusCurrent = PrizeConstants.STATUS_PLAN_STARTED; //+ PrizeConstants.STATUS_PLAN_PAID; aMemberPlanWeek = (from c in db.MemberExercisePlanWeeks where c.MemberId == currentMemberPlanWeek.MemberId && c.StartDate > currentMemberPlanWeek.StartDate && (c.Status.Equals(statusFinished) || c.Status.Equals(statusCurrent)) orderby c.StartDate ascending select c).FirstOrDefault(); if (aMemberPlanWeek != null) { nextMemberPlanWeekId = aMemberPlanWeek.Id; } return(true); }
public bool MemberInOrientation(int memberId) { try { db.Database.Connection.Open(); string status1 = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAID; string status2 = PrizeConstants.STATUS_PLAN_STARTED + PrizeConstants.STATUS_PLAN_PAID; MemberExercisePlanWeek memberPlanWeek = (from c in db.MemberExercisePlanWeeks join d in db.MemberExercisePlans on c.MemberExercisePlanId equals d.Id where c.MemberId == memberId && (d.Status.Equals(status1) || d.Status.Equals(status2)) && (c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_STARTED) || c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED)) orderby c.StartDate select c).FirstOrDefault(); if (memberPlanWeek == null) { return(false); } else if (memberPlanWeek.ExercisePlanWeekId != 0) { return(false); } return(true); } finally { db.Database.Connection.Close(); } }
protected void LoadPreNextLinks() { int iWeek = this.GetLatestMeasurementWeekNum(iWeekNum - 1); MemberExercisePlanWeek prevWeek = null; if (iWeek != iWeekNum && iWeek >= 0) { prevWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(_MemberPlanWeek.MemberExercisePlanId, iWeek); dayPre.NavigateUrl = "/my-account/progress-status?MemberPlanWeekID=" + prevWeek.Id; dayPre.Text = "Week " + (iWeek); } else { dayPre.Attributes.Add("class", "no-arrow"); } iWeek = this.GetNextMeasurementWeekNum(iWeekNum); if (iWeek != iWeekNum) { var nextWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(_MemberPlanWeek.MemberExercisePlanId, iWeek); if (nextWeek != null && !nextWeek.Status.Equals(PrizeConstants.STATUS_PLAN_NOT_STARTED)) { dayNext.NavigateUrl = "/my-account/progress-status?MemberPlanWeekID=" + nextWeek.Id; dayNext.Text = "Week " + (iWeek); } else { dayNext.Attributes.Add("class", "no-arrow"); } } else { dayNext.Attributes.Add("class", "no-arrow"); } }
public MemberExercisePlanWeek GetMemberPlanWeekById(int memberPlanWeekId) { try { db.Database.Connection.Open(); MemberExercisePlanWeek memberPlanWeek = (from c in db.MemberExercisePlanWeeks where c.Id == memberPlanWeekId select c).FirstOrDefault(); return(memberPlanWeek); } finally { db.Database.Connection.Close(); } }
public MemberExercisePlanWeek GetMemberPlanWeekByMemberPlanAndWeek(int memberPlanId, int week) { try { db.Database.Connection.Open(); MemberExercisePlanWeek memberPlanWeek = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == memberPlanId && c.Week == week select c).FirstOrDefault(); return(memberPlanWeek); } finally { db.Database.Connection.Close(); } }
public MemberExercisePlanWeek GetCurrentMemberPlanWeek(int memberId) { try { db.Database.Connection.Open(); MemberExercisePlanWeek memberPlanWeek = (from c in db.MemberExercisePlanWeeks where c.MemberId == memberId && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_STARTED) select c).FirstOrDefault(); return(memberPlanWeek); } 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); }
private void BindGrid() { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { var languages = from a in db.MemberPlanWeekResults join b in db.PrizeMembers on a.MemberId equals b.UmbracoId join c in db.MemberExercisePlanWeeks on a.MemberExercisePlanWeekId equals c.Id join d in db.MemberExercisePlans on c.MemberExercisePlanId equals d.Id join e in db.PrizeExercisePlans on d.ExercisePlanId equals e.Id where a.MemberId == memberId && d.Status.EndsWith("P") orderby d.StartDate descending, c.StartDate select new { Memberid = a.MemberId, Firstname = b.Firstname, Surname = b.Surname, Week = c.Week, Status = c.Status, StartDate = c.StartDate, EndDate = c.EndDate, PlanName = e.PlanName, EndWeight = a.EndWeight, EndWaist = a.EndWaist, EndBodyFat = a.EndBodyFat, EndChest = a.EndChest, EndHip = a.EndHip, EndHeartRate = a.EndHeartRate, FrontPhoto = a.FrontPhoto, BackPhoto = a.BackPhoto, SidePhoto = a.SidePhoto, Tasks = a.Tasks, }; GridView1.DataSource = languages.ToList(); GridView1.DataBind(); MemberExercisePlan myPlan = null; MemberExercisePlanWeek myPlanWeek = null; if (Session["MPID"] != null) { int mPlanId = Convert.ToInt32(Session["MPID"]); myPlan = dbAccess.GetMemberExercisePlan(mPlanId); } else { myPlan = dbAccess.GetCurrentMemberPlanOrStartingPlan(memberId); myPlanWeek = dbAccess.GetCurrentMemberPlanWeek(memberId); } this.btnSave.Enabled = false; if (myPlan != null) { this.btnSave.Enabled = true; var memberPlanWeeks = from a in db.MemberExercisePlanWeeks where a.MemberExercisePlanId == myPlan.Id orderby a.Week select new { WeekText = a.Week, WeekNum = a.Week }; ddlWeek.DataValueField = "WeekNum"; ddlWeek.DataTextField = "WeekText"; ddlWeek.DataSource = memberPlanWeeks.ToList(); ddlWeek.DataBind(); int weekNum = -1; if (myPlanWeek != null) { weekNum = myPlanWeek.Week; } PrizeExercisePlan plan = dbAccess.GetExercisePlan(myPlan.ExercisePlanId); lblPlanInfo.Text = "Plan " + plan.PlanName + " from " + PrizeCommonUtils.ParseDateToEnglish(myPlan.StartDate) + " to " + PrizeCommonUtils.ParseDateToEnglish(myPlan.EndDate.Value); LoadFoodPlanWeek(memberId, myPlan, weekNum); } } db.Database.Connection.Close(); } }
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 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)); } MemberExercisePlanWeek memberPlanWeek; if (Request["MemberPlanWeekID"] != null) { int memberPlanWeekId; int.TryParse(Request["MemberPlanWeekID"], out memberPlanWeekId); memberPlanWeek = dbAccess.GetMemberPlanWeekById(memberPlanWeekId); } else { memberPlanWeek = dbAccess.GetCurrentMemberPlanWeek(memberId); } if (memberPlanWeek == null) { divMealPlanContent.Visible = false; divNotStarted.Visible = true; return; } int iWeekNum = memberPlanWeek.Week; lblWeekNum.Text = "Week " + iWeekNum; divMainMealPlan.Attributes.Add("class", "tab-inner-content nodisplay wk" + iWeekNum); lblDateDuration.Text = PrizeCommonUtils.ParseDateToEnglish(memberPlanWeek.StartDate) + " - " + PrizeCommonUtils.ParseDateToEnglish(memberPlanWeek.EndDate); MemberExercisePlan memberPlan = dbAccess.GetCurrentMemberPlan(memberId); if (memberPlan == null) { return; } PrizeExercisePlan plan = dbAccess.GetExercisePlan(memberPlan.ExercisePlanId); if (plan == null) { return; } lblPlanProgram.Text = plan.PrizePlanProgram.Name; MemberExercisePlanWeek prevWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(memberPlan.Id, memberPlanWeek.Week - 1); if (prevWeek != null) { int prevWeekNum = iWeekNum - 1; weekPre.NavigateUrl = "/my-account/meal-plan?MemberPlanWeekID=" + prevWeek.Id; weekPre.Text = "Week " + (memberPlanWeek.Week - 1); } else { weekPre.Attributes.Add("class", "no-arrow"); } MemberExercisePlanWeek nextWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(memberPlan.Id, memberPlanWeek.Week + 1); if (nextWeek != null) { weekNext.NavigateUrl = "/my-account/meal-plan?MemberPlanWeekID=" + nextWeek.Id; weekNext.Text = "Week " + (memberPlanWeek.Week + 1); } else { weekNext.Attributes.Add("class", "no-arrow"); } MemberFoodPlanWeek foodWeek = dbAccess.GetMemberFoodPlanWeek(memberId, memberPlanWeek.MemberExercisePlanId, memberPlanWeek.Week); if (foodWeek == null) { return; } if (foodWeek.Food1 == null || foodWeek.Food1.Equals("")) { this.colories.Visible = false; } else { lblFood1.Text = foodWeek.Food1; } if (foodWeek.Food2 == null || foodWeek.Food2.Equals("")) { this.protein.Visible = false; } else { lblFood2.Text = foodWeek.Food2; } if (foodWeek.Food3 == null || foodWeek.Food3.Equals("")) { this.carbo.Visible = false; } else { lblFood3.Text = foodWeek.Food3; } if (foodWeek.Food4 == null || foodWeek.Food4.Equals("")) { this.fats.Visible = false; } else { lblFood4.Text = foodWeek.Food4; } if (foodWeek.Food5 != null) { string[] sPersentage = foodWeek.Food5.Split(';'); if (sPersentage.Length > 0) { lblFood5.Text = sPersentage[0]; if (sPersentage.Length > 1) { lblFood6.Text = sPersentage[1]; if (sPersentage.Length > 2) { lblFood7.Text = sPersentage[2]; } } } } }
protected void Page_Load(object sender, EventArgs e) { int.TryParse(Request["PlanWeekId"], out iPlanWeekId); int.TryParse(Request["PlanDayNumber"], out iDay); int.TryParse(Request["MemberPlanWeekId"], out memberPlanWeekId); MemberExercisePlanWeek memberPlanWeek = dbAccess.GetMemberPlanWeekById(memberPlanWeekId); if (memberPlanWeek != null) { lblDate.Text = PrizeCommonUtils.ParseDateToEnglish(memberPlanWeek.StartDate.AddDays(iDay - 1)); } lblDayNum.Text = "" + iDay; lblDayTypeName.Text = PrizeConstants.STR_NO_TRAINNING; DataSet ds = dbAccess.GetMemberWeeklyInfo(iPlanWeekId); foreach (DataRow row in ds.Tables[0].Rows) { int iWeekDay = (int)row[0]; if (iWeekDay == iDay) { lblDayTypeName.Text = (String)row[2]; } } if (lblDayTypeName.Text.ToLower() == PrizeConstants.STR_NO_TRAINNING.ToLower()) { divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divRest.Visible = true; } lblDay.Text = PrizeCommonUtils.ParseWeekDayToEnglish(iDay); MemberExercisePlan myPlan = dbAccess.GetMemberExercisePlan(memberPlanWeek.MemberExercisePlanId); if (iDay > 1) { preDay.NavigateUrl = (String.Format("{0}?PlanWeekId={1}&MemberPlanWeekId={2}&PlanDayNumber={3}", PrizeConstants.URL_MEMBER_DAY_VIEW, iPlanWeekId, memberPlanWeekId, iDay - 1)); preDay.Text = "Previous Day"; } else { MemberExercisePlanWeek prevWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(myPlan.Id, memberPlanWeek.Week - 1); if (prevWeek != null) { preDay.NavigateUrl = (String.Format("{0}?PlanWeekId={1}&MemberPlanWeekId={2}&PlanDayNumber={3}", PrizeConstants.URL_MEMBER_DAY_VIEW, iPlanWeekId, prevWeek.Id, 7)); preDay.Text = "Previous Day"; } else { preDay.Attributes.Add("class", "no-arrow"); } } if (iDay < 7) { nextDay.NavigateUrl = (String.Format("{0}?PlanWeekId={1}&MemberPlanWeekId={2}&PlanDayNumber={3}", PrizeConstants.URL_MEMBER_DAY_VIEW, iPlanWeekId, memberPlanWeekId, iDay + 1)); nextDay.Text = "Next Day"; } else { MemberExercisePlanWeek nextWeek = dbAccess.GetMemberPlanWeekByMemberPlanAndWeek(myPlan.Id, memberPlanWeek.Week + 1); if (nextWeek != null) { nextDay.NavigateUrl = (String.Format("{0}?PlanWeekId={1}&MemberPlanWeekId={2}&PlanDayNumber={3}", PrizeConstants.URL_MEMBER_DAY_VIEW, iPlanWeekId, nextWeek.Id, 1)); nextDay.Text = "Next Day"; } else { nextDay.Attributes.Add("class", "no-arrow"); } } InitPageControls(); DivAdvanceEquipment.Visible = false; PrizeDataAccess db = new PrizeDataAccess(); var memberExercisePlan = db.GetCurrentMemberPlanOrStartingPlan(PrizeMemberAuthUtils.GetMemberID()); if (memberExercisePlan != null) { var exercisePlan = db.GetExercisePlan(memberExercisePlan.ExercisePlanId); if (exercisePlan != null) { if (exercisePlan.PlanName.ToLower().Contains("home") && (exercisePlan.PlanName.ToLower().Contains("intermediate") || exercisePlan.PlanName.ToLower().Contains("advanced")) ) { DivAdvanceEquipment.Visible = true; } } } switch (lblDayTypeName.Text.Trim()) { case "Time to celebrate": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divRest.Visible = true; DivAdvanceEquipment.Visible = false; break; case "30min brisk walk": case "Brisk walk": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divWalk.Visible = true; DivAdvanceEquipment.Visible = false; break; case "30-60min weekend physical activity": case "Weekend physical activity": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divWeekend.Visible = true; DivAdvanceEquipment.Visible = false; break; case "Own 1hr cardio": case "Own training": case "Own cardio": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divCardio.Visible = true; DivAdvanceEquipment.Visible = false; break; case "Milestone workout = 20x pushups, squats, situps": case "Milestone workout 2": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divSquat.Visible = true; DivAdvanceEquipment.Visible = false; break; case "Milestone workout = 20 pushups & make your bed": case "Milestone workout 1": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divPushup.Visible = true; DivAdvanceEquipment.Visible = false; break; case "Measurement day and rest": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; divMeasurement.Visible = true; DivAdvanceEquipment.Visible = false; break; case "Milestone workout = 20 star jumps & make your bed": divWarmup.Visible = divCooldown.Visible = divLegend.Visible = false; DivAdvanceEquipment.Visible = false; //divMeasurement.Visible = true; break; default: break; } LoadDailyInfo(iPlanWeekId, iDay); // nextDay.Text = "Next day tuesday"; // nextDay.NavigateUrl = "/tuesday#?"; }
public int BuyNewPlan(int newPlanId, ref PrizeExercisePlan prizePlan, ref MemberExercisePlan newMemberPlan) { DIYPTEntities db = new DIYPTEntities(); try { if (PrizeMemberAuthUtils.CurrentUserLogin() != true) { return(PrizeErrorCode.ERROR_NOT_LOGGED_IN); } int memberId = PrizeMemberAuthUtils.GetMemberID(); db.Database.Connection.Open(); PrizeExercisePlan plan = (from c in db.PrizeExercisePlans where c.Id == newPlanId select c).FirstOrDefault(); if (plan == null) { return(-1); } //using (TransactionScope transaction = new TransactionScope()) //{ if (plan == null) { return(PrizeErrorCode.ERROR_PLAN_NOT_EXIST); } MemberExercisePlan myExistingPaidPlan = (from c in db.MemberExercisePlans where c.MemberId == memberId && (c.Status.Equals(PrizeConstants.STATUS_PLAN_STARTED + PrizeConstants.STATUS_PLAN_PAID) || c.Status.Equals(PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAID)) orderby c.EndDate descending select c).FirstOrDefault(); DateTime currentEndDate; if (myExistingPaidPlan != null) { currentEndDate = myExistingPaidPlan.EndDate.Value; } else { currentEndDate = PrizeCommonUtils.GetSystemDate(); } List <MemberExercisePlan> myNotPaidPlans = (from c in db.MemberExercisePlans where c.MemberId == memberId && (c.Status.EndsWith(PrizeConstants.STATUS_PLAN_NOT_PAID) || c.Status.EndsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT)) select c).ToList(); foreach (MemberExercisePlan notPaidPlan in myNotPaidPlans) { IQueryable <MemberExercisePlanWeek> notPaidPlanWeeks = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == notPaidPlan.Id select c); foreach (var week in notPaidPlanWeeks) { MemberPlanWeekResult weekResult = (from c in db.MemberPlanWeekResults where c.MemberExercisePlanWeekId == week.Id select c).SingleOrDefault(); db.MemberExercisePlanWeeks.Remove(week); db.MemberPlanWeekResults.Remove(weekResult); } notPaidPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAYMENT_CANCELLED; List <MemberManualPayment> manualPayments = (from c in db.MemberManualPayments where c.MemberExercisePlanId == notPaidPlan.Id && c.Status.StartsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_NOT_APPROVED) select c).ToList(); foreach (var notPaidRecord in manualPayments) { db.MemberManualPayments.Remove(notPaidRecord); db.SaveChanges(); } } db.SaveChanges(); DateTime startDate = PrizeCommonUtils.GetNextWeekStart(currentEndDate); DateTime endDate = PrizeCommonUtils.GetWeekEnd(startDate); MemberExercisePlan myPlan = new MemberExercisePlan(); myPlan.MemberId = memberId; myPlan.ExercisePlanId = plan.Id; myPlan.StartDate = startDate; myPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_NOT_PAID; //Not paid db.MemberExercisePlans.Add(myPlan); db.SaveChanges(); MemberPlanWeekResult myWeekResult; if (plan.IsTrialPlan != 1) { MemberExercisePlanWeek myPlanWeekOrientation = new MemberExercisePlanWeek(); myPlanWeekOrientation.MemberExercisePlanId = myPlan.Id; myPlanWeekOrientation.ExercisePlanWeekId = 0; myPlanWeekOrientation.MemberId = memberId; myPlanWeekOrientation.StartDate = startDate; myPlanWeekOrientation.EndDate = endDate; myPlanWeekOrientation.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED; myPlanWeekOrientation.Week = 0; db.MemberExercisePlanWeeks.Add(myPlanWeekOrientation); db.SaveChanges(); myWeekResult = new MemberPlanWeekResult(); myWeekResult.MemberId = memberId; myWeekResult.MemberExercisePlanWeekId = myPlanWeekOrientation.Id; InitialiseWeekResult(ref myWeekResult); db.MemberPlanWeekResults.Add(myWeekResult); db.SaveChanges(); myPlan.EndDate = endDate; startDate = startDate.AddDays(7); endDate = endDate.AddDays(7); } IList <PrizeExercisePlanWeek> planWeeks = plan.PrizeExercisePlanWeeks.OrderBy(s => s.StartWeek).ToList(); foreach (PrizeExercisePlanWeek planWeek in planWeeks) { for (int i = planWeek.StartWeek; i <= planWeek.EndWeek; i++) { MemberExercisePlanWeek myPlanWeek = new MemberExercisePlanWeek(); myPlanWeek.MemberExercisePlanId = myPlan.Id; myPlanWeek.ExercisePlanWeekId = planWeek.Id; myPlanWeek.MemberId = memberId; myPlanWeek.StartDate = startDate; myPlanWeek.EndDate = endDate; myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED; myPlanWeek.Week = i; db.MemberExercisePlanWeeks.Add(myPlanWeek); db.SaveChanges(); myWeekResult = new MemberPlanWeekResult(); myWeekResult.MemberId = memberId; myWeekResult.MemberExercisePlanWeekId = myPlanWeek.Id; InitialiseWeekResult(ref myWeekResult); db.MemberPlanWeekResults.Add(myWeekResult); myPlan.EndDate = endDate; db.SaveChanges(); startDate = startDate.AddDays(7); endDate = endDate.AddDays(7); } } //transaction.Complete(); newMemberPlan = myPlan; prizePlan = plan; return(newPlanId); //} } finally { db.Dispose(); } }
public static bool UpdateMemberPlans() { using (DIYPTEntities db = new DIYPTEntities()) { try { db.Database.Connection.Open(); DateTime today = PrizeCommonUtils.GetDayStart(PrizeCommonUtils.GetSystemDate()); MemberExercisePlanWeek startingPlanWeek; String availableStatus = PrizeConstants.STATUS_PLAN_STARTED + PrizeConstants.STATUS_PLAN_PAID; IQueryable <MemberExercisePlan> plans = (from c in db.MemberExercisePlans where c.Status.Equals(availableStatus) orderby c.MemberId, c.Id select c); foreach (MemberExercisePlan plan in plans) { MemberExercisePlanWeek finishingPlanWeek = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == plan.Id && c.EndDate <= today && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_STARTED) orderby c.ExercisePlanWeekId select c).FirstOrDefault(); if (finishingPlanWeek != null) { finishingPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_FINISHED; startingPlanWeek = (from c in db.MemberExercisePlanWeeks where c.StartDate >= finishingPlanWeek.EndDate && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED) && c.MemberExercisePlanId == plan.Id orderby c.StartDate select c).FirstOrDefault(); if (startingPlanWeek != null) { MemberPlanWeekResult finishingResult = (from c in db.MemberPlanWeekResults where c.MemberExercisePlanWeekId == finishingPlanWeek.Id select c).FirstOrDefault(); MemberPlanWeekResult startingResult = (from c in db.MemberPlanWeekResults where c.MemberExercisePlanWeekId == startingPlanWeek.Id select c).FirstOrDefault(); CopyWeekResult(ref startingResult, ref finishingResult); startingPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_STARTED; } else { plan.Status = PrizeConstants.STATUS_PLAN_FINISHED + PrizeConstants.STATUS_PLAN_PAID; } } } availableStatus = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAID; plans = (from c in db.MemberExercisePlans where c.Status.Equals(availableStatus) orderby c.MemberId select c); foreach (MemberExercisePlan plan in plans) { startingPlanWeek = (from c in db.MemberExercisePlanWeeks where c.StartDate <= today && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED) && c.MemberExercisePlanId == plan.Id orderby c.StartDate select c).FirstOrDefault(); if (startingPlanWeek != null) { MemberPlanWeekResult startingResult = (from c in db.MemberPlanWeekResults where c.MemberExercisePlanWeekId == startingPlanWeek.Id select c).FirstOrDefault(); MemberExercisePlanWeek finishedWeek = (from c in db.MemberExercisePlanWeeks where c.EndDate < startingPlanWeek.StartDate && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_FINISHED) select c).FirstOrDefault(); if (finishedWeek != null) { MemberPlanWeekResult finishingResult = (from c in db.MemberPlanWeekResults where c.MemberExercisePlanWeekId == finishedWeek.Id select c).FirstOrDefault(); CopyWeekResult(ref startingResult, ref finishingResult); } startingPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_STARTED; plan.Status = PrizeConstants.STATUS_PLAN_STARTED + PrizeConstants.STATUS_PLAN_PAID; } } db.SaveChanges(); return(true); } catch (Exception e) { PrizeLogs.SaveSystemErrorLog(0, 0, PrizeConstants.SystemErrorLevel.LevelSerious, typeof(PrizeMemberPlanManager).ToString(), "UpdateMemberPlans", e.Message, e.InnerException == null ? "" : e.InnerException.Message); return(false); } finally { db.Database.Connection.Close(); } } }
protected string UpdateMemberPlanWeekPhoto(MemberExercisePlanWeek memberPlanWeek, FileUpload loader, int iType = 0) { FileUpload tempFileupload = loader; string sPhotoTypeName = ""; string attachmentServerPath = ""; if (iType == 0) { sPhotoTypeName = "front"; } if (iType == 1) { sPhotoTypeName = "side"; } if (iType == 2) { sPhotoTypeName = "back"; } string sSuffix = Path.GetExtension(tempFileupload.FileName); string sServerFileName = memberPlanWeek.MemberId + "_" + PrizeCommonUtils.ParseDateTimeSimple(memberPlanWeek.StartDate) + "_" + sPhotoTypeName + sSuffix; if (tempFileupload != null && !string.IsNullOrEmpty(tempFileupload.FileName)) { string uploadPath = @"d:\sites\jrguico\diypt.com.au\home\member_images"; //string uploadPath = @"C:\workspace\asp_project\diypt.club\home\member_images"; attachmentServerPath = String.Format(@"http://{0}/member_images/{1}", HttpContext.Current.Request.Url.Authority, sServerFileName); decimal attachmentFileSize = Math.Round(Convert.ToDecimal(tempFileupload.PostedFile.ContentLength / 1024), 2); //if (attachmentFileSize + Helper.GetTrialTotalAttachmentSize(TrialId) < Convert.ToDecimal(ConfigurationManager.AppSettings["TotalAttachmentSizeLimit"])) if (attachmentFileSize < 15000) { string[] dirs = Directory.GetFiles(uploadPath); string folderPath = String.Format(@"\{0}", sServerFileName); string fullFilePath = uploadPath + folderPath; tempFileupload.SaveAs(fullFilePath); ImageHelper.RotateImageByExifOrientationData(fullFilePath, fullFilePath, System.Drawing.Imaging.ImageFormat.Jpeg, true); using (DIYPTEntities db = new DIYPTEntities()) { MemberPlanWeekResult weekResult = (from c in db.MemberPlanWeekResults where c.MemberExercisePlanWeekId == memberPlanWeek.Id select c).FirstOrDefault(); if (weekResult != null) { switch (iType) { case 0: weekResult.FrontPhoto = attachmentServerPath; break; case 1: weekResult.SidePhoto = attachmentServerPath; break; case 2: weekResult.BackPhoto = attachmentServerPath; break; default: break; } db.SaveChanges(); } } } else { Response.Write("<script>alert('You cannot attach this file. The maximum file size limit is 15mb.');</script>"); return(""); } } else { Response.Write("<script>alert('Please choose a file to attach.');</script>"); } WeekResults = dbAccess.GetMemberPlanResults(_MemberPlanWeek.MemberExercisePlanId); return(attachmentServerPath); }
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)"; } } } }