protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { int ExerciseUnitSetId = 0; //int ExerciseUnitId = Convert.ToInt32(Session["UnitSetId"]); int ExerciseUnitId = Convert.ToInt32(txtExerciseUnitId.Text); var tt = (from c in db.PrizeExerciseUnits where c.Id == ExerciseUnitId select c).Count(); if (Convert.ToInt32(tt) == 0) { string errorText = "Unit Id doesnot exist!Please add new unit first."; Response.Write( @"<SCRIPT LANGUAGE=""JavaScript"">alert('" + errorText + "')</SCRIPT>"); } else { ExerciseUnitSetId = Convert.ToInt32(Session["UnitSetId"]); if (ExerciseUnitSetId == 0) { int units = (from c in db.PrizeExerciseUnitSets orderby c.UnitSetId select c.UnitSetId).DefaultIfEmpty(0).Max(); ExerciseUnitSetId = units + 1; //add to unitset for days table one recond. int pwid = Convert.ToInt32(Session["PWID"]); int day = Convert.ToInt32(Session["DAY"]); int DGNid = Convert.ToInt32(Session["DayGroupNameId"]); PrizeExerciseUnitSetForDay item = (from c in db.PrizeExerciseUnitSetForDays where c.ExercisePlanWeekId == pwid && c.ExerciseDay == day && c.DayGroupNameId == DGNid select c).FirstOrDefault(); item.ExerciseUnitSetId = ExerciseUnitSetId; db.SaveChanges(); Session["UnitSetId"] = ExerciseUnitSetId; } PrizeExerciseUnitSet addplan = new PrizeExerciseUnitSet(); addplan.Sequence = txtSequence.Text; addplan.ExerciseUnitId = Convert.ToInt32(txtExerciseUnitId.Text); addplan.UnitSetId = ExerciseUnitSetId; db.PrizeExerciseUnitSets.Add(addplan); db.SaveChanges(); } this.BindGrid(); } // transaction.Complete(); db.Database.Connection.Close(); } }
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 int AddMemberWeek1NotifiedTimes(PrizeMember member) { using (DIYPTEntities db = new DIYPTEntities()) { PrizeMember memberUpdating = (from table in db.PrizeMembers where table.UmbracoId == member.UmbracoId select table).FirstOrDefault(); char c = GetMemberSetting(memberUpdating.UserSettings, PrizeConstants.MemberSettings.ShowedWeek1NotificationTimes); StringBuilder sb = new StringBuilder(); sb.Append(c); int i = int.Parse(sb.ToString()); if (i < 9) { i++; } sb.Clear(); sb.Append(i.ToString()); string s = null; if (memberUpdating.UserSettings != null) { s = string.Copy(memberUpdating.UserSettings); } SetMemberSetting(ref s, PrizeConstants.MemberSettings.ShowedWeek1NotificationTimes, sb[0]); memberUpdating.UserSettings = s; db.SaveChanges(); return(i); } }
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(); } }
protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { string sid = Session["PLANWEEKID"].ToString(); Int32 ID = Convert.ToInt32(sid); string dtype = ddldaytype.SelectedItem.Text; PrizeExerciseDayType daytpes = (from c in db.PrizeExerciseDayTypes where c.DayTypeName == dtype select c).FirstOrDefault(); int dId = daytpes.Id; PrizeExercisePlanWeekDay CD = new PrizeExercisePlanWeekDay(); CD.ExercisePlanWeekId = ID; CD.Day = Convert.ToInt32(txtDay.Text); CD.DayTypeId = dId; db.PrizeExercisePlanWeekDays.Add(CD); db.SaveChanges(); } db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExercisePlanWeekDay item = (from c in db.PrizeExercisePlanWeekDays where c.Id == Id select c).FirstOrDefault(); IQueryable <PrizeExerciseUnitSetForDay> unitSets = (from c in db.PrizeExerciseUnitSetForDays where c.ExercisePlanWeekId == item.ExercisePlanWeekId && c.ExerciseDay == item.Day select c); foreach (var unitset in unitSets) { db.PrizeExerciseUnitSetForDays.Remove(unitset); } db.PrizeExercisePlanWeekDays.Remove(item); db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
public void PayMemberPlanCancel(int currentOrderId) { DIYPTEntities db = new DIYPTEntities(); try { db.Database.Connection.Open(); PrizeOrder myCurrentOrder; MemberExercisePlan myPlan; if (currentOrderId >= 0) { // Get the order based on order id. myCurrentOrder = db.PrizeOrders.Single(o => o.OrderId == currentOrderId); myPlan = db.MemberExercisePlans.Single(o => o.Id == myCurrentOrder.MemberPlanId); myPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAYMENT_CANCELLED; // Save to DB. db.SaveChanges(); } } finally { db.Dispose(); } }
protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { int weekid = Convert.ToInt32(Session["PWID"]); int day = Convert.ToInt32(Session["DAY"]); string dgroup = ddldaygroup.SelectedItem.Text; PrizeExerciseDayGroupName daygroups = (from c in db.PrizeExerciseDayGroupNames where c.DayGroupName == dgroup select c).FirstOrDefault(); int dId = daygroups.Id; PrizeExerciseUnitSetForDay CD = new PrizeExerciseUnitSetForDay(); CD.ExercisePlanWeekId = weekid; CD.ExerciseDay = day; CD.DayGroupNameId = dId; CD.ExerciseUnitSetId = 0; db.PrizeExerciseUnitSetForDays.Add(CD); db.SaveChanges(); } db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
protected void Save(object sender, EventArgs e) { try { memberId = Convert.ToInt32(Session["MID"]); } catch { return; } MemberExercisePlan myPlan; if (Session["MPID"] != null) { int mPlanId = Convert.ToInt32(Session["MPID"]); myPlan = dbAccess.GetMemberExercisePlan(mPlanId); } else { myPlan = dbAccess.GetCurrentMemberPlanOrStartingPlan(memberId); } int weekNum = int.Parse(ddlWeek.SelectedValue); int myPlanId = myPlan.Id; using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { int id = Convert.ToInt32(Session["MID"]); var foodplanweek = dbAccess.GetMemberFoodPlanWeek(memberId, myPlanId, weekNum, false); if (foodplanweek == null) { MemberFoodPlanWeek MemFoodPW = new MemberFoodPlanWeek(); MemFoodPW.MemberId = id; MemFoodPW.MemberExercisePlanId = myPlanId; MemFoodPW.Food1 = tbFood1.Text; MemFoodPW.Food2 = tbFood2.Text; MemFoodPW.Food3 = tbFood3.Text; MemFoodPW.Food4 = tbFood4.Text; MemFoodPW.Food5 = tbFood5.Text + ";" + tbFood6.Text + ";" + tbFood7.Text; MemFoodPW.StartWeek = weekNum; MemFoodPW.EndWeek = MemFoodPW.StartWeek; db.MemberFoodPlanWeeks.Add(MemFoodPW); } else { var updatePlan = (from c in db.MemberFoodPlanWeeks where c.Id == foodplanweek.Id select c).FirstOrDefault(); updatePlan.Food1 = tbFood1.Text; updatePlan.Food2 = tbFood2.Text; updatePlan.Food3 = tbFood3.Text; updatePlan.Food4 = tbFood4.Text; updatePlan.Food5 = tbFood5.Text + ";" + tbFood6.Text + ";" + tbFood7.Text; } db.SaveChanges(); } } }
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(); } }
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(); } }
protected void btnSubmitPersonal_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.Gender = RdoGender.Text; memberUpdating.StreetAddress = tbStreetAddress.Text; memberUpdating.Suburb = tbSuburb.Text; memberUpdating.State = tbState.Text; memberUpdating.Country = tbCountry.Text; memberUpdating.Postcode = tbPostCode.Text; memberUpdating.Mobile = tbMobile.Text; memberUpdating.Phone = tbPhone.Text; DateTime tempDoB; if (DateTime.TryParse(txtDob.Text, out tempDoB)) { memberUpdating.DoB = tempDoB; } db.SaveChanges(); } finally { db.Database.Connection.Close(); divViewPersonal.Visible = true; divEditPersonal.Visible = false; DisableValidatorsControls(); member = PrizeMemberAuthUtils.GetMemberData(); LoadMemberDetails(); Page.ClientScript.RegisterStartupScript(this.GetType(), "hash", "location.hash = '#personal';", true); } } } catch (MembershipCreateUserException me) { lblMsg.Text = GetErrorMessage(me.StatusCode); lblMsgTop.Text = lblMsg.Text; } catch (HttpException httpe) { lblMsg.Text = httpe.Message; lblMsgTop.Text = lblMsg.Text; } }
public void UpdateOrientationWeekDayResult(int memberPlanId, int day, int quest, bool done) { using (this.db) { MemberPlanWeekResult result = (from r in db.MemberPlanWeekResults join weeks in db.MemberExercisePlanWeeks on r.MemberExercisePlanWeekId equals weeks.Id where weeks.MemberExercisePlanId == memberPlanId && weeks.ExercisePlanWeekId == 0 select r).FirstOrDefault(); char[] arr; if (result.Questions == null || result.Questions.Length < PrizeConstants.MAX_ORIENTATION_QUESTION) { result.Questions = ""; arr = new char[PrizeConstants.MAX_ORIENTATION_QUESTION]; for (int i = 0; i < PrizeConstants.MAX_ORIENTATION_QUESTION; i++) { arr[i] = '0'; } } else { arr = result.Questions.ToArray(); } int idx = (day - 1) * 10 + (quest - 1); if (done) { arr[idx] = '1'; } else { arr[idx] = '0'; } result.Questions = new string(arr); 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 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(); } }
protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { PrizeExerciseDayType dayType = new PrizeExerciseDayType(); dayType.DayTypeName = txtDayTypeName.Text; db.PrizeExerciseDayTypes.Add(dayType); db.SaveChanges(); this.BindGrid(); } db.Database.Connection.Close(); } }
protected void btnSubmitAccount_Click(object sender, EventArgs e) { try { if (txtPassword.Text != txtConfirmPwd.Text) { lblMsg.Text = "Error: Passwords do not match."; lblMsgTop.Text = lblMsg.Text; return; } using (DIYPTEntities db = new DIYPTEntities()) { try { PrizeMember memberUpdating = (from c in db.PrizeMembers where c.UmbracoId == member.UmbracoId select c).FirstOrDefault(); var mem = ApplicationContext.Current.Services.MemberService.GetByEmail(memberUpdating.Email); memberUpdating.Email = txtEmail.Text; ApplicationContext.Current.Services.MemberService.SavePassword(mem, txtPassword.Text); db.SaveChanges(); } finally { db.Database.Connection.Close(); divViewAccount.Visible = true; divEditAccount.Visible = false; DisableValidatorsControls(); member = PrizeMemberAuthUtils.GetMemberData(); LoadMemberDetails(); Page.ClientScript.RegisterStartupScript(this.GetType(), "hash", "location.hash = '#account';", true); } } } catch (MembershipCreateUserException me) { lblMsg.Text = GetErrorMessage(me.StatusCode); lblMsgTop.Text = lblMsg.Text; } catch (HttpException httpe) { lblMsg.Text = httpe.Message; lblMsgTop.Text = lblMsg.Text; } }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExerciseUnit item = (from c in db.PrizeExerciseUnits where c.Id == Id select c).FirstOrDefault(); db.PrizeExerciseUnits.Remove(item); db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
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(); } }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string Exercise = (row.FindControl("ttExercise") as TextBox).Text; string AlterExercise = (row.FindControl("ttAlterExercise") as TextBox).Text; string Reps = (row.FindControl("ttReps") as TextBox).Text; string Rest = (row.FindControl("ttRest") as TextBox).Text; string Weight = (row.FindControl("ttWeight") as TextBox).Text; string Comments = (row.FindControl("ttComments") as TextBox).Text; //string UnitOrder = (row.FindControl("ttUnitOrder") as TextBox).Text; string Tempo = (row.FindControl("ttTempo") as TextBox).Text; string Trainning_Set = (row.FindControl("ttTrainning_Set") as TextBox).Text; string TimeDuration = (row.FindControl("ttTimeDuration") as TextBox).Text; string Image = (row.FindControl("ttImage") as TextBox).Text; using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExerciseUnit item = (from c in db.PrizeExerciseUnits where c.Id == Id select c).FirstOrDefault(); item.Exercise = Exercise; item.AlternateExercise = AlterExercise; item.Reps = Reps; item.Rest = Rest; item.Weight = Weight; //item.UnitOrder = Convert.ToInt32(UnitOrder); item.Comments = Comments; item.Tempo = Tempo; item.Trainning_Set = Trainning_Set; item.Comments = Comments; item.TimeDuration = Convert.ToInt32(TimeDuration); item.Image = Image; db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
public bool PauseMemberPlan(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); } IQueryable <MemberExercisePlanWeek> myPlanWeeks = (from c in db.MemberExercisePlanWeeks where c.MemberExercisePlanId == myPlan.Id orderby c.Week select c); foreach (var planWeek in myPlanWeeks) { if (planWeek.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_STARTED) || planWeek.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED)) { planWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_SUSPENDED; } } myPlan.Status = PrizeConstants.STATUS_PLAN_SUSPENDED + myPlan.Status[1]; db.SaveChanges(); return(true); } catch { return(false); } finally { db.Dispose(); } }
protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { string[] sTemp = txtExercise.Text.Split(new string[] { "or alternatively" }, 2, StringSplitOptions.None); string sExercise = sTemp[0]; string sAlterExercise = ""; sExercise = sExercise.Trim(new char[] { ' ' }); if (sTemp.Length > 1) { sAlterExercise = sTemp[1]; sAlterExercise = Regex.Replace(sAlterExercise, @",", ""); sAlterExercise = sAlterExercise.Trim(new char[] { ' ' }); } PrizeExerciseUnit addplan = new PrizeExerciseUnit(); addplan.Exercise = sExercise; addplan.AlternateExercise = sAlterExercise; addplan.Reps = txtReps.Text; addplan.Rest = txtRest.Text; addplan.Weight = txtWeight.Text; addplan.Comments = txtComments.Text; addplan.UnitOrder = 0;// Convert.ToInt32(txtUnitOrder.Text); addplan.Tempo = txtTempo.Text; addplan.Trainning_Set = txtTrainning_Set.Text; addplan.TimeDuration = Convert.ToInt32(txtTimeDuration.Text); addplan.Image = txtImage.Text; //addplan.Video = txtVideo.Text; db.PrizeExerciseUnits.Add(addplan); db.SaveChanges(); this.BindGrid(); } // transaction.Complete(); db.Database.Connection.Close(); } }
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(); } }
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); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string Sequence = (row.FindControl("ttSequence") as TextBox).Text; int ExerciseUnitId = Convert.ToInt32((row.FindControl("ttExerciseUnitId") as TextBox).Text); using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); var tt = (from c in db.PrizeExerciseUnits where c.Id == ExerciseUnitId select c).Count(); if (Convert.ToInt32(tt) == 0) { string errorText = "Unit Id doesnot exist!Please add new unit first."; Response.Write( @"<SCRIPT LANGUAGE=""JavaScript"">alert('" + errorText + "')</SCRIPT>"); } else { PrizeExerciseUnitSet item = (from c in db.PrizeExerciseUnitSets where c.Id == Id select c).FirstOrDefault(); item.Sequence = Sequence; item.ExerciseUnitId = ExerciseUnitId; db.SaveChanges(); } db.Database.Connection.Close(); } GridView1.EditIndex = -1; 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 DayTypeName = (row.FindControl("ttDayTypeName") as TextBox).Text; using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExerciseDayType item = (from c in db.PrizeExerciseDayTypes where c.Id == Id select c).FirstOrDefault(); item.DayTypeName = DayTypeName; db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; 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]); double price = Convert.ToDouble((row.FindControl("txtPrice") as TextBox).Text); int isTrial = Convert.ToInt16((row.FindControl("txtTrialOrNot") as CheckBox).Checked); using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExercisePlan plan = (from c in db.PrizeExercisePlans where c.Id == Id select c).FirstOrDefault(); plan.Price = price; plan.IsTrialPlan = isTrial; db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; 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(); }
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(); } } }