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