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