static public void SaveSystemErrorLog(int memberId, int?memberPlanId, PrizeConstants.SystemErrorLevel level, string sWebPage, string sEvent, Exception ex) { using (DIYPTEntities db = new DIYPTEntities()) { var log = new PrizeErrorLog(); log.MemberId = memberId; log.MemberExercisePlanId = memberPlanId; log.Page = sWebPage; //HttpContext.Current.Request.Url.AbsolutePath;' log.ErrorLevel = (int)level; log.LogDate = PrizeCommonUtils.GetSystemDate(); log.Event = sEvent; // Get stack trace for the exception with source file information var st = new StackTrace(ex, true); // Get the top stack frame var frame = st.GetFrame(st.FrameCount - 1); // Get the line number from the stack frame var line = frame.GetFileLineNumber(); string sError = ex.Message + " Line_" + frame.GetFileLineNumber() + "\r\n" + ex.StackTrace; log.Error = sError; log.InnerError = ""; if (ex.InnerException != null) { log.InnerError = ex.InnerException.Message + "\r\n" + ex.InnerException.StackTrace; } db.PrizeErrorLogs.Add(log); db.SaveChanges(); } }
public void PayMemberManualPayment(int weeklyPaymentId, int currentOrderId, int memberPlanId, string paymentConfirmation, string comment = "") { DIYPTEntities db = new DIYPTEntities(); try { db.Database.Connection.Open(); PrizeOrder myCurrentOrder; MemberExercisePlan myPlan; MemberManualPayment myManualPayment; DateTime currentEndDate = PrizeCommonUtils.GetSystemDate(); if (currentOrderId >= 0) { // Get Weekly payment. myManualPayment = db.MemberManualPayments.Single(o => o.Id == weeklyPaymentId); myManualPayment.PaidDate = currentEndDate; myManualPayment.Comment = comment; myManualPayment.Status = PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_APPROVED + myManualPayment.Status[1]; // Get the order based on order id. myCurrentOrder = db.PrizeOrders.Single(o => o.OrderId == currentOrderId); // Update the order to reflect payment has been completed. myCurrentOrder.PaymentTransactionId = paymentConfirmation; myPlan = db.MemberExercisePlans.Single(o => o.Id == myCurrentOrder.MemberPlanId); myPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAID; if (myPlan.StartDate < currentEndDate) { DateTime startDate = PrizeCommonUtils.GetNextWeekStart(currentEndDate); DateTime endDate = PrizeCommonUtils.GetWeekEnd(startDate); myPlan.StartDate = startDate; IList <MemberExercisePlanWeek> myPlanWeeks = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == myPlan.Id orderby c.StartDate select c).ToList(); foreach (MemberExercisePlanWeek myPlanWeek in myPlanWeeks) { myPlanWeek.StartDate = startDate; myPlanWeek.EndDate = endDate; myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED; myPlan.EndDate = endDate; db.SaveChanges(); startDate = startDate.AddDays(7); endDate = endDate.AddDays(7); } } // Save to DB. db.SaveChanges(); } } finally { db.Dispose(); } }
public int ManualPaymentMemberPlanSetup(PrizeMember member, int memberPlanId, int exercisePlanId, string sManualPaymentMode) { DIYPTEntities db = new DIYPTEntities(); try { db.Database.Connection.Open(); var oldOrders = db.PrizeOrders.Where(o => (o.MemberPlanId == memberPlanId && o.PaymentTransactionId == null)); db.PrizeOrders.RemoveRange(oldOrders); PrizeOrder myOrder = new PrizeOrder(); myOrder.OrderDate = PrizeCommonUtils.GetSystemDate(); myOrder.Username = member.Email; myOrder.FirstName = member.Firstname; myOrder.LastName = member.Surname; myOrder.Email = member.Email; myOrder.Total = 0; myOrder.MemberPlanId = memberPlanId; myOrder.ExercisePlanId = exercisePlanId; db.PrizeOrders.Add(myOrder); MemberExercisePlan myPlan; if (myOrder.OrderId >= 0) { myPlan = db.MemberExercisePlans.Single(o => o.Id == myOrder.MemberPlanId); myPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT; MemberManualPayment manualPayment = null; string manualPaymentStatus = PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_NOT_APPROVED + sManualPaymentMode; List <MemberManualPayment> manualPayments = (from c in db.MemberManualPayments where c.MemberId == member.UmbracoId && c.Status.StartsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_NOT_APPROVED) select c).ToList(); foreach (var notPaidRecord in manualPayments) { db.MemberManualPayments.Remove(notPaidRecord); db.SaveChanges(); } manualPayment = new MemberManualPayment(); manualPayment.MemberId = myPlan.MemberId; manualPayment.MemberExercisePlanId = myPlan.Id; manualPayment.CreatedDate = PrizeCommonUtils.GetSystemDate(); manualPayment.Status = manualPaymentStatus; db.MemberManualPayments.Add(manualPayment); } db.SaveChanges(); return(myOrder.OrderId); } finally { db.Dispose(); } }
static public void SaveMemberLoginLog(int memberId, int?memberPlanId, string sWebPage, string sEvent, string sError = null) { using (DIYPTEntities db = new DIYPTEntities()) { PrizeMember member = (from table in db.PrizeMembers where table.UmbracoId == memberId select table).FirstOrDefault(); var log = new PrizeMemberLog(); log.MemberId = memberId; log.MemberExercisePlanId = memberPlanId; log.Page = sWebPage; //HttpContext.Current.Request.Url.AbsolutePath; log.LogDate = PrizeCommonUtils.GetSystemDate(); log.Event = sEvent; log.Error = sError; db.PrizeMemberLogs.Add(log); //No longer needed here. /* * DateTime dtYesterdayStart = PrizeCommonUtils.GetDayStart(log.LogDate.AddDays(-1)); * DateTime dtYesterdayEnd = PrizeCommonUtils.GetDayEnd(log.LogDate.AddDays(-1)); * DateTime dtTodayStart = PrizeCommonUtils.GetDayStart(log.LogDate); * DateTime dtTodayterdayEnd = PrizeCommonUtils.GetDayEnd(log.LogDate); * * PrizeMemberLog todayLogin = (from table in db.PrizeMemberLogs * where table.MemberId == memberId && table.LogDate >= dtTodayStart && table.LogDate <= dtTodayterdayEnd * select table).FirstOrDefault(); * if (todayLogin != null) * return; * * PrizeMemberLog yesterdayLogin = (from table in db.PrizeMemberLogs * where table.MemberId == memberId && table.LogDate >= dtYesterdayStart && table.LogDate <= dtYesterdayEnd * select table).FirstOrDefault(); * if (yesterdayLogin != null && member.ContinuousLogin < PrizeConstants.MAX_CONTINUOUS_LOGIN) * member.ContinuousLogin++; * else * member.ContinuousLogin = 1; * * if (member.ContinuousLogin >= PrizeConstants.MAX_CONTINUOUS_LOGIN) * { * PrizeEmailWrapper.SendMemberConintuousLoginEmail(member); * } */ db.SaveChanges(); } }
private static void DailyTasks() { DIYPTEntities db = new DIYPTEntities(); try { PrizeEmailWrapper.ExercisePlan2DaysPriorToStartEmailTask(); db.Database.Connection.Open(); DateTime today = PrizeCommonUtils.GetDayStart(PrizeCommonUtils.GetSystemDate()); PrizePollingTask task = (from c in db.PrizePollingTasks where c.TaskDate >= today && c.TaskType == (int)PrizeConstants.TasksType.DailyRedoAble select c).FirstOrDefault(); if (task == null || task.Count < 2) { PrizeMemberPlanManager.UpdateMemberPlans(); PrizeEmailWrapper.DailyEmailTask(); if (task == null) { task = new PrizePollingTask(); task.Status = "1"; task.TaskDate = PrizeCommonUtils.GetSystemDate(); task.TaskType = (int)PrizeConstants.TasksType.DailyRedoAble; task.Count = 1; db.PrizePollingTasks.Add(task); } else { task.Count++; } db.SaveChanges(); } } catch (Exception e) { PrizeLogs.SaveSystemErrorLog(0, 0, PrizeConstants.SystemErrorLevel.LevelSerious, typeof(RegisteredEvents).ToString(), "DailyTasks", e.Message, e.InnerException == null ? "" : e.InnerException.Message); return; } finally { db.Database.Connection.Close(); } }
static public void SaveSystemErrorLog(int memberId, int?memberPlanId, PrizeConstants.SystemErrorLevel level, string sWebPage, string sEvent, string sError, string sInnerError) { using (DIYPTEntities db = new DIYPTEntities()) { var log = new PrizeErrorLog(); log.MemberExercisePlanId = memberId; log.MemberExercisePlanId = memberPlanId; log.Page = sWebPage; //HttpContext.Current.Request.Url.AbsolutePath;' log.ErrorLevel = (int)level; log.LogDate = PrizeCommonUtils.GetSystemDate(); log.Event = sEvent; log.Error = sError; log.InnerError = sInnerError; db.PrizeErrorLogs.Add(log); db.SaveChanges(); } }
private void FillDate() { //DateTime tempdate = new DateTime(2017, 1, 10); //var nextSunday = tempdate.Next(DayOfWeek.Sunday); PrizeDataAccess db = new PrizeDataAccess(); var exercisePlan = db.GetCurrentMemberPlanOrStartingPlan(PrizeMemberAuthUtils.GetMemberID()); //var nextSunday = exercisePlan.StartDate.NextDay(DayOfWeek.Monday); if (exercisePlan == null) { return; } //var nextSunday = exercisePlan.StartDate.NextDay(DayOfWeek.Sunday); var nextSunday = exercisePlan.StartDate; int counter = 0; for (int i = 0; i < 14; i++) { Label dateLabel = this.FindControl(string.Format("week{0}Date", i)) as Label; if (dateLabel != null) { dateLabel.Text = nextSunday.AddDays((i - 1) * 7).Date.ToString("dd/MM") + "-" + nextSunday.AddDays((i * 7) - 1).Date.ToString("dd/MM"); } for (int d = 1; d <= 7; d++) { if (nextSunday.AddDays(counter).Date == PrizeCommonUtils.GetSystemDate().Date) { HtmlTableCell tempLabel = this.FindControl(string.Format("w{0}d{1}", i, d)) as HtmlTableCell; if (tempLabel != null) { tempLabel.Attributes.Add("class", tempLabel.Attributes["class"] + " active"); } } //Label tempLabel = this.FindControl(string.Format("week{0}_{1}", i, d)) as Label; //if (tempLabel != null) // tempLabel.Text = nextSunday.AddDays(counter).ToString("dd/M"); counter++; } } }
private void doNoPaymentPlan() { PrizeOrder myOrder = new PrizeOrder(); myOrder.OrderDate = PrizeCommonUtils.GetSystemDate(); myOrder.Username = PrizeMemberAuthUtils.GetMemberName(); myOrder.FirstName = ""; myOrder.LastName = ""; myOrder.Email = PrizeMemberAuthUtils.GetMemberEmail(); myOrder.Total = 0; myOrder.MemberPlanId = Int32.Parse(Session["buying_my_plan_id"].ToString()); myOrder.ExercisePlanId = Int32.Parse(Session["buying_plan_id"].ToString()); // Get DB context. DIYPTEntities _db = new DIYPTEntities(); try { // Add order to DB. _db.Database.Connection.Open(); _db.PrizeOrders.Add(myOrder); _db.SaveChanges(); Session["currentOrderId"] = myOrder.OrderId; } finally { _db.Database.Connection.Close(); } int currentOrderId = -1; if (Session["currentOrderId"] != string.Empty) { currentOrderId = Convert.ToInt32(Session["currentOrderID"]); } PrizeMemberPlanManager planManager = new PrizeMemberPlanManager(); planManager.PayMemberPlans(currentOrderId, ""); Response.Redirect(PrizeConstants.URL_MEMBER_LANDING); }
private static void DoSendShceduledEmail() { DIYPTEntities db = new DIYPTEntities(); try { db.Database.Connection.Open(); IQueryable <MemberEmail> emails = (from c in db.MemberEmails where c.Status == (int)PrizeConstants.EmailStatus.Shceduled || c.Status == (int)PrizeConstants.EmailStatus.Failed select c); bool bSent = false; foreach (MemberEmail email in emails.ToList()) { string sError; List <string> additionalContents = new List <string>(); additionalContents.Add(email.Content1); additionalContents.Add(email.Content2); additionalContents.Add(email.Content3); additionalContents.Add(email.Content4); additionalContents.Add(email.Content5); bSent = PrizeEmailServiceThread.SendEmailHandler(email, (PrizeConstants.EmailType)email.EmailType, email.Title, additionalContents); if (bSent) { email.Status = (int)PrizeConstants.EmailStatus.Succeeded; email.SendDate = PrizeCommonUtils.GetSystemDate(); db.SaveChanges(); } else { email.SendDate = PrizeCommonUtils.GetSystemDate(); email.Status = (int)PrizeConstants.EmailStatus.Failed; db.SaveChanges(); } } } finally { db.Database.Connection.Close(); } }
protected void WeekChanged(object sender, EventArgs e) { DropDownList ddlWeekList = (DropDownList)sender; int weekNum = int.Parse(ddlWeekList.SelectedValue); MemberExercisePlan myPlan; if (Session["MPID"] != null) { int mPlanId = Convert.ToInt32(Session["MPID"]); myPlan = dbAccess.GetMemberExercisePlan(mPlanId); } else { myPlan = dbAccess.GetCurrentMemberPlanOrStartingPlan(memberId); } 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); }
public void TerminateMemberManualPaymentPlan(int weeklyPaymentId, int memberPlanId, string comment = "") { DIYPTEntities db = new DIYPTEntities(); try { db.Database.Connection.Open(); MemberExercisePlan myPlan; MemberManualPayment myManualPayment; DateTime currentEndDate = PrizeCommonUtils.GetSystemDate(); // Get Weekly payment. myManualPayment = db.MemberManualPayments.Single(o => o.Id == weeklyPaymentId); myManualPayment.TerminatedDate = currentEndDate; myManualPayment.Comment = comment; myManualPayment.Status = PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_TERMINATED + myManualPayment.Status[1]; myPlan = db.MemberExercisePlans.Single(o => o.Id == memberPlanId); myPlan.Status = PrizeConstants.STATUS_PLAN_TERMINATED + myPlan.Status[1]; IList <MemberExercisePlanWeek> myPlanWeeks = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == myPlan.Id && !c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_FINISHED) orderby c.StartDate select c).ToList(); foreach (MemberExercisePlanWeek myPlanWeek in myPlanWeeks) { myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_TERMINATED; db.SaveChanges(); } // Save to DB. db.SaveChanges(); } finally { db.Dispose(); } }
// Log an Exception public static void LogException(Exception exc, string source) { // Include logic for logging exceptions // Get the absolute path to the log file string logFile = "/App_Data/ErrorLog.txt"; logFile = HttpContext.Current.Server.MapPath(logFile); // Open the log file for append and write the log StreamWriter sw = new StreamWriter(logFile, true); sw.WriteLine("********** {0} **********", PrizeCommonUtils.GetSystemDate()); if (exc.InnerException != null) { sw.Write("Inner Exception Type: "); sw.WriteLine(exc.InnerException.GetType().ToString()); sw.Write("Inner Exception: "); sw.WriteLine(exc.InnerException.Message); sw.Write("Inner Source: "); sw.WriteLine(exc.InnerException.Source); if (exc.InnerException.StackTrace != null) { sw.WriteLine("Inner Stack Trace: "); sw.WriteLine(exc.InnerException.StackTrace); } } sw.Write("Exception Type: "); sw.WriteLine(exc.GetType().ToString()); sw.WriteLine("Exception: " + exc.Message); sw.WriteLine("Source: " + source); sw.WriteLine("Stack Trace: "); if (exc.StackTrace != null) { sw.WriteLine(exc.StackTrace); sw.WriteLine(); } sw.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) { /* * //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 LoadWeeklyResult(List <MemberPlanWeekResult> weekResults) { if (_MemberPlanWeek == null) { return; } MemberPlanWeekResult weekResult = weekResults[iWeekNum]; MemberPlanWeekResult prevWeekResult = null; int iWeek = this.GetLatestMeasurementWeekNum(iWeekNum - 1); if (iWeek >= 0) { prevWeekResult = weekResults[iWeek]; } if (weekResult == null) { throw new Exception(); } decimal iDiff = 0; if (weekResult.EndWeight.HasValue) { lblWeight.Text = weekResult.EndWeight.Value.ToString("0,0.00"); if (prevWeekResult != null && prevWeekResult.EndWeight.HasValue) { iDiff = weekResult.EndWeight.Value - prevWeekResult.EndWeight.Value; lblWeightDiff.Text = iDiff.ToString("0,0.00"); } else { lblWeightDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } } else if (weekResult.StartWeight.HasValue) { lblWeight.Text = weekResult.StartWeight.Value.ToString("0,0.00"); } else { lblWeight.Text = PrizeCommonUtils.FormatExerciseNumber(0); lblWeightDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } if (weekResult.EndWaist.HasValue) { lblWaist.Text = weekResult.EndWaist.Value.ToString("0,0.00"); if (prevWeekResult != null && prevWeekResult.EndWaist.HasValue) { iDiff = weekResult.EndWaist.Value - prevWeekResult.EndWaist.Value; lblWaistDiff.Text = iDiff.ToString("0,0.00"); } else { lblWaistDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } } else if (weekResult.StartWaist.HasValue) { lblWaist.Text = weekResult.StartWaist.Value.ToString("0,0.00"); } else { lblWaist.Text = PrizeCommonUtils.FormatExerciseNumber(0); lblWaistDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } if (weekResult.EndHip.HasValue) { lblHip.Text = weekResult.EndHip.Value.ToString("0,0.00"); if (prevWeekResult != null && prevWeekResult.EndHip.HasValue) { iDiff = weekResult.EndHip.Value - prevWeekResult.EndHip.Value; lblHipDiff.Text = iDiff.ToString("0,0.00"); } else { lblHipDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } } else if (weekResult.StartHip.HasValue) { lblHip.Text = weekResult.StartHip.Value.ToString("0,0.00"); } else { lblHip.Text = PrizeCommonUtils.FormatExerciseNumber(0); lblHipDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } if (weekResult.EndChest.HasValue) { lblChest.Text = weekResult.EndChest.Value.ToString("0,0.00"); if (prevWeekResult != null && prevWeekResult.EndChest.HasValue) { iDiff = weekResult.EndChest.Value - prevWeekResult.EndChest.Value; lblChestDiff.Text = iDiff.ToString("0,0.00"); } else { lblChestDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } } else if (weekResult.StartChest.HasValue) { lblChest.Text = weekResult.StartChest.Value.ToString("0,0.00"); } else { lblChest.Text = PrizeCommonUtils.FormatExerciseNumber(0); lblChestDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } if (weekResult.EndHeartRate.HasValue) { lblHeartRate.Text = weekResult.EndHeartRate.Value.ToString("0,0.00"); if (prevWeekResult != null && prevWeekResult.EndHeartRate.HasValue) { iDiff = weekResult.EndHeartRate.Value - prevWeekResult.EndHeartRate.Value; lblHeartRateDiff.Text = iDiff.ToString("0,0.00"); } else { lblHeartRateDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } } else if (weekResult.StartHeartRate.HasValue) { lblHeartRate.Text = PrizeCommonUtils.FormatExerciseNumber(weekResult.StartHeartRate.Value); } else { lblHeartRate.Text = PrizeCommonUtils.FormatExerciseNumber(0); lblHeartRateDiff.Text = PrizeCommonUtils.FormatExerciseNumber(0); } }
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(); } } }
private void AddNewUserDetails(int newUserId) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); try { PrizeMember member = new PrizeMember(); member.Firstname = txtFirstName.Text; member.Surname = tbLastName.Text; member.Email = txtEmail.Text; member.StreetAddress = tbStreetAddress.Text; member.Suburb = tbSuburb.Text; member.State = tbState.Text; member.Country = ddCountry.Text; member.Postcode = tbPostCode.Text; member.Mobile = tbMobile.Text; member.Phone = tbPhone.Text; StringBuilder sb = new StringBuilder(); sb.Append(Q3.InnerText); sb.Append("\r\n"); sb.Append(ddlQ3.Text); sb.Append("\r\n"); sb.Append(Q4.InnerText); sb.Append("\r\n"); sb.Append(ddlQ4.Text); sb.Append("\r\n"); sb.Append(regQ4.InnerText); sb.Append("\r\n"); sb.Append(Q5.InnerText); sb.Append("\r\n"); sb.Append(regQ5.InnerText); sb.Append("\r\n"); sb.Append(ddlQ6.Text); sb.Append("\r\n"); sb.Append(regQ6.InnerText); sb.Append("\r\n"); sb.Append(ddlQ7.Text); sb.Append("\r\n"); sb.Append(regQ7.InnerText); sb.Append("\r\n"); member.Questions = sb.ToString(); member.UmbracoId = newUserId; member.RegisterDateTime = PrizeCommonUtils.GetSystemDate(); char c = '1'; if (!cbPromotionalPhoto.Checked) { c = '0'; } member.UserSettings = PrizeConstants.DEFAULT_MEMBER_SETTINGS; string s = string.Copy(member.UserSettings); PrizeMemberAuthUtils.SetMemberSetting(ref s, PrizeConstants.MemberSettings.PromotionalPhoto, c); member.UserSettings = s; db.PrizeMembers.Add(member); db.SaveChanges(); } 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); }
public bool ResumeMemberPlan(int myPlanId) { bool ret = false; DIYPTEntities db = new DIYPTEntities(); try { db.Database.Connection.Open(); MemberExercisePlan myPlan = (from c in db.MemberExercisePlans where c.Id == myPlanId select c).FirstOrDefault(); if (myPlan == null) { return(ret); } IList <MemberExercisePlanWeek> myPlanWeeks = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == myPlan.Id && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_SUSPENDED) orderby c.Week select c).ToList(); int idx = 1; DateTime currentEndDate = PrizeCommonUtils.GetSystemDate(); DateTime startDate = PrizeCommonUtils.GetWeekStart(currentEndDate); DateTime endDate = PrizeCommonUtils.GetWeekEnd(startDate); foreach (var myPlanWeek in myPlanWeeks) { if (idx == 1) { if (myPlanWeek.StartDate <= startDate) { myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_STARTED; myPlanWeek.StartDate = startDate; myPlanWeek.EndDate = endDate; } else { myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED; startDate = myPlanWeek.StartDate; endDate = myPlanWeek.EndDate; } } else { myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED; myPlanWeek.StartDate = startDate; myPlanWeek.EndDate = endDate; } myPlan.EndDate = endDate; startDate = startDate.AddDays(7); endDate = endDate.AddDays(7); idx++; } myPlan.Status = PrizeConstants.STATUS_PLAN_STARTED + myPlan.Status[1]; db.SaveChanges(); return(true); } catch { return(false); } finally { db.Dispose(); } }
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 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 btnSubmitProfile_Click(object sender, EventArgs e) { try { using (DIYPTEntities db = new DIYPTEntities()) { try { PrizeMember memberUpdating = (from c in db.PrizeMembers where c.UmbracoId == member.UmbracoId select c).FirstOrDefault(); memberUpdating.Firstname = tbFirstName.Text; memberUpdating.Surname = tbLastName.Text; memberUpdating.WhyDIYPT = tbWhyDiypt.Text; memberUpdating.Facebook = tbFacebook.Text; memberUpdating.Instagram = tbInstagram.Text; memberUpdating.Twiter = tbTwitter.Text; /* * string s = null; * if (memberUpdating.UserSettings != null) * s = string.Copy(memberUpdating.UserSettings); * if (cbShowProgram.Checked == true) * PrizeMemberAuthUtils.SetMemberSetting(ref s, PrizeConstants.MemberSettings.ShowProgram, '1'); * else * PrizeMemberAuthUtils.SetMemberSetting(ref s, PrizeConstants.MemberSettings.ShowProgram, '0'); * * if (cbShowLevel.Checked == true) * PrizeMemberAuthUtils.SetMemberSetting(ref s, PrizeConstants.MemberSettings.ShowLevel, '1'); * else * PrizeMemberAuthUtils.SetMemberSetting(ref s, PrizeConstants.MemberSettings.ShowLevel, '0'); * memberUpdating.UserSettings = s; */ // db.PrizeMembers(member); //photoUpload if (photoUpload != null && !string.IsNullOrEmpty(photoUpload.FileName)) { string attachmentServerPath = ""; string sSuffix = photoUpload.FileName.Substring(photoUpload.FileName.Length - 4); string sServerFileName = memberUpdating.UmbracoId + "_" + PrizeCommonUtils.ParseDateTimeSimple(DateTime.Now) + "_" + sSuffix; string uploadPath = HttpContext.Current.Server.MapPath("~/member_images"); //@"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(photoUpload.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; photoUpload.SaveAs(fullFilePath); memberUpdating.Photo = attachmentServerPath; } } char cc = '1'; if (!cbPromotionalPhoto.Checked) { cc = '0'; } string s = string.Copy(memberUpdating.UserSettings); PrizeMemberAuthUtils.SetMemberSetting(ref s, PrizeConstants.MemberSettings.PromotionalPhoto, cc); memberUpdating.UserSettings = s; db.SaveChanges(); } finally { db.Database.Connection.Close(); divViewProfile.Visible = true; divEditProfile.Visible = false; DisableValidatorsControls(); member = PrizeMemberAuthUtils.GetMemberData(); LoadMemberDetails(); } } } catch (MembershipCreateUserException me) { lblMsg.Text = GetErrorMessage(me.StatusCode); lblMsgTop.Text = lblMsg.Text; } catch (HttpException httpe) { lblMsg.Text = httpe.Message; lblMsgTop.Text = lblMsg.Text; } }
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 refresh(object sender, EventArgs e) { tbfistname.Text = string.Empty; clWeeklyPaymentStart1.SelectedDate = PrizeCommonUtils.GetSystemDate(); clWeeklyPaymentStart2.SelectedDate = PrizeCommonUtils.GetSystemDate(); }
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#?"; }
protected void refresh2(object sender, EventArgs e) { tbFirstName2.Text = string.Empty; clWeeklyPaymentStop1.SelectedDate = PrizeCommonUtils.GetSystemDate(); clWeeklyPaymentStop2.SelectedDate = PrizeCommonUtils.GetSystemDate(); }