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 PrizeDataAccess()
{
//
// TODO: Add constructor logic here
//
db = new DIYPTEntities();
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string sImageUrl = "";
if (!string.IsNullOrEmpty(frontUpload.FileName))
{
sImageUrl = this.UpdateMemberPlanWeekPhoto(_MemberPlanWeek, frontUpload, 0);
Image1.ImageUrl = sImageUrl;
}
if (!string.IsNullOrEmpty(sideUpload.FileName))
{
sImageUrl = this.UpdateMemberPlanWeekPhoto(_MemberPlanWeek, sideUpload, 1);
Image2.ImageUrl = sImageUrl;
}
if (!string.IsNullOrEmpty(backUpload.FileName))
{
sImageUrl = this.UpdateMemberPlanWeekPhoto(_MemberPlanWeek, backUpload, 2);
Image3.ImageUrl = sImageUrl;
}
using (DIYPTEntities db = new DIYPTEntities())
{
LoadMemberPhotos(iWeekNum, WeekResults);
LoadWeeklyResult(WeekResults);
DrawProgressGraph((int)_MemberPlanWeek.MemberExercisePlanId, WeekResults);
}
}
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();
}
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();
}
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);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (DIYPTEntities db = new DIYPTEntities())
{
var tempStage = int.Parse(ddlStage.SelectedValue);
var tempLevel = int.Parse(ddlLevel.SelectedValue);
var tempWeek = decimal.Parse(ddlWeek.SelectedValue);
/* var dbStage = (from c in db.PrizeExercisePlans
* where c.PlanStage == tempStage
* && c.PlanLevel == tempLevel
* select c).FirstOrDefault();
* if (dbStage != null)
* {
* var dbWeek = (from c in db.PrizeExercisePlanWeeks
* where c.Week == tempWeek
* && c.PrizeExercisePlan.Id == dbStage.Id
* select c).FirstOrDefault();
*
* dbStage.Description = txtDescription.Text;
*
* if (dbWeek != null)
* {
* dbWeek.Week = tempWeek;
* dbWeek.ExerciseDay1 = txtDay1.Text;
* dbWeek.ExerciseDay2 = txtDay2.Text;
* dbWeek.ExerciseDay3 = txtDay3.Text;
* dbWeek.ExerciseDay4 = txtDay4.Text;
* dbWeek.ExerciseDay5 = txtDay5.Text;
* dbWeek.ExerciseDay6 = txtDay6.Text;
* dbWeek.ExerciseDay7 = txtDay7.Text;
*
* dbWeek.PrizeFoodPlanId = tempWeek;
* dbWeek.PrizeExercisePlanId = dbStage.Id;
* }
* else
* {
* dbWeek = new PrizeExercisePlanWeek();
* dbWeek.Week = tempWeek;
* dbWeek.ExerciseDay1 = txtDay1.Text;
* dbWeek.ExerciseDay2 = txtDay2.Text;
* dbWeek.ExerciseDay3 = txtDay3.Text;
* dbWeek.ExerciseDay4 = txtDay4.Text;
* dbWeek.ExerciseDay5 = txtDay5.Text;
* dbWeek.ExerciseDay6 = txtDay6.Text;
* dbWeek.ExerciseDay7 = txtDay7.Text;
*
* dbWeek.PrizeFoodPlanId = tempWeek;
* dbWeek.PrizeExercisePlanId = dbStage.Id;
*
* db.PrizeExercisePlanWeeks.Add(dbWeek);
* }
*
*
*
* db.SaveChanges();
* lblError.Text = "Saved!";
* }*/
}
}
private void BindGrid()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
if (ViewState["Filter"].ToString() == "ALL")
{
var excerciseplan = from ExercisePlan in db.PrizeExercisePlans
join Program in db.PrizePlanPrograms on ExercisePlan.ProgramId equals Program.Id
join Location in db.PrizePlanLocations on ExercisePlan.LocationId equals Location.Id
join Experience in db.PrizePlanExperiences on ExercisePlan.ExperienceId equals Experience.Id
join Level in db.PrizePlanLevels on ExercisePlan.LevelId equals Level.Id
orderby Program.Sequence, Location.Sequence, Level.Sequence, Experience.Sequence
select new
{
Id = ExercisePlan.Id,
programename = Program.Name,
locationname = Location.Name,
levelname = Level.Name,
experiencename = Experience.Name,
Price = ExercisePlan.Price,
IsTrialPlan = ExercisePlan.IsTrialPlan,
PlanName = Program.Name + "_" + Location.Name + "_" + Level.Name + "_" + Experience.Name,
};
GridView1.DataSource = excerciseplan.ToList();
}
else
{
int filtervalue = Convert.ToInt32(ViewState["Filter"]);
var excerciseplan = from ExercisePlan in db.PrizeExercisePlans
join Program in db.PrizePlanPrograms on ExercisePlan.ProgramId equals Program.Id
join Location in db.PrizePlanLocations on ExercisePlan.LocationId equals Location.Id
join Experience in db.PrizePlanExperiences on ExercisePlan.ExperienceId equals Experience.Id
join Level in db.PrizePlanLevels on ExercisePlan.LevelId equals Level.Id
where Program.Id == filtervalue
select new
{
Id = ExercisePlan.Id,
programename = Program.Name,
locationname = Location.Name,
levelname = Level.Name,
experiencename = Experience.Name,
Price = ExercisePlan.Price,
IsTrialPlan = ExercisePlan.IsTrialPlan,
PlanName = Program.Name + "_" + Location.Name + "_" + Level.Name + "_" + Experience.Name,
};
GridView1.DataSource = excerciseplan.ToList();
}
GridView1.DataBind();
DropDownList ddlhdprg =
(DropDownList)GridView1.HeaderRow.FindControl("ddlhdprg");
this.BindProgramList(ddlhdprg);
}
db.Database.Connection.Close();
}
}
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 Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
PrizeSysConfig conf = (from a in db.PrizeSysConfigs
select a).FirstOrDefault();
string s = "";
if (conf != null && conf.SystemDate.HasValue)
{
currentTime = conf.SystemDate.Value;
}
else
{
currentTime = DateTime.Now;
}
s = currentTime.ToString("yyyy-MM-dd");
txtDate.Text = s;
}
}
lblError.Text = "";
}
}
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();
}
}
private void BindGrid()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
int weekid = Convert.ToInt32(Session["PWID"]);
int day = Convert.ToInt32(Session["DAY"]);
string sName = Session["PLANNAME"].ToString();
lblPlanName.Text = sName;
string sWeek = Session["PLANWEEKNUM"].ToString();
lblWeekNum.Text = sWeek;
string sDay = Session["DAY"].ToString();
lblWeekDay.Text = sDay;
var DayGroups = from a in db.PrizeExerciseUnitSetForDays
join b in db.PrizeExerciseDayGroupNames on a.DayGroupNameId equals b.Id
where a.ExercisePlanWeekId == weekid && a.ExerciseDay == day
select new
{
DayGruopName = b.DayGroupName,
ExerciseUnitSetId = a.ExerciseUnitSetId,
Id = a.Id,
DayGroupNameId = a.DayGroupNameId,
};
GridView1.DataSource = DayGroups.ToList();
GridView1.DataBind();
}
db.Database.Connection.Close();
}
}
private void BindGrid()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
string sid = Session["PLANWEEKID"].ToString();
Int32 ID = Convert.ToInt32(sid);
string sName = Session["PLANNAME"].ToString();
lblPlanName.Text = sName;
string sWeek = Session["PLANWEEKNUM"].ToString();
lblWeekNum.Text = sWeek;
var DayTypes = from a in db.PrizeExercisePlanWeekDays
join b in db.PrizeExerciseDayTypes on a.DayTypeId equals b.Id
where a.ExercisePlanWeekId == ID
orderby a.Day
select new
{
Id = a.Id,
Day = a.Day,
DayTypeName = b.DayTypeName,
ExercisePlanWeekId = a.ExercisePlanWeekId
};
GridView1.DataSource = DayTypes.ToList();
GridView1.DataBind();
}
db.Database.Connection.Close();
}
}
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();
}
}
private void BindGridWeeklyPayStart()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
DateTime st = DateTime.MinValue;
DateTime ed = DateTime.MaxValue;
if (tbFrom.Text != "" && tbFrom.Text != null)
{
st = DateTime.ParseExact(tbFrom.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
if (tbTo.Text != "" && tbTo.Text != null)
{
ed = DateTime.ParseExact(tbTo.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
var weeklyPayments = from w in db.MemberManualPayments
join a in db.MemberExercisePlans on w.MemberExercisePlanId equals a.Id
join dic in db.PrizeMembers on a.MemberId equals dic.UmbracoId
join b in db.PrizeExercisePlans on a.ExercisePlanId equals b.Id
join Program in db.PrizePlanPrograms on b.ProgramId equals Program.Id
join Location in db.PrizePlanLocations on b.LocationId equals Location.Id
join Experience in db.PrizePlanExperiences on b.ExperienceId equals Experience.Id
join Level in db.PrizePlanLevels on b.LevelId equals Level.Id
join c in db.PrizeOrders on a.Id equals c.MemberPlanId
orderby a.StartDate descending
where w.CreatedDate > st && w.CreatedDate < ed && w.Status.StartsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_NOT_APPROVED) &&
(a.Status.EndsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT))
select new
{
ManualPaymentId = w.Id,
MemberPlanId = a.Id,
Id = dic.UmbracoId,
Firstname = dic.Firstname,
Surname = dic.Surname,
Email = dic.Email,
IsTrialPlan = b.IsTrialPlan,
PlanName = Program.Name + "_" + Location.Name + "_" + Level.Name + "_" + Experience.Name,
CreatedDate = w.CreatedDate,
StartDate = a.StartDate,
Status = w.Status,
OrderId = c.OrderId.ToString(),
Transaction = c.PaymentTransactionId,
Comment = w.Comment,
};
if (tbfistname.Text != "")
{
weeklyPayments = weeklyPayments.Where(m => m.Firstname.Contains(tbfistname.Text));
}
GridView1.DataSource = weeklyPayments.ToList();
GridView1.DataBind();
}
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();
}
}
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 void BindDropDownList()
{
PrizeExercisePlan plan = dbAccess.GetCurrentOrStartingExercisePlanInfo(memberId);
if (plan == null)
{
return;
}
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
var ProgramQuery = from c in db.PrizePlanPrograms
select new { c.Name, c.Id };
ddlProgram.DataValueField = "Id";
ddlProgram.DataTextField = "Name";
ddlProgram.DataSource = ProgramQuery.ToList();
ddlProgram.DataBind();
ddlProgram.Items.FindByValue("" + plan.ProgramId).Selected = true;
var LevelQuery = from e in db.PrizePlanLevels
select new { e.Name, e.Id };
ddlLevel.DataValueField = "Id";
ddlLevel.DataTextField = "Name";
ddlLevel.DataSource = LevelQuery.ToList();
ddlLevel.DataBind();
ddlLevel.Items.FindByValue("" + plan.LevelId).Selected = true;
var planQuery = from a in db.PrizeExercisePlans
join Program in db.PrizePlanPrograms on a.ProgramId equals Program.Id
join Location in db.PrizePlanLocations on a.LocationId equals Location.Id
join Level in db.PrizePlanLevels on a.LevelId equals Level.Id
join Experience in db.PrizePlanExperiences on a.ExperienceId equals Experience.Id
where a.IsTrialPlan == plan.IsTrialPlan
orderby Program.Name, Location.Name, Level.Name, Experience.Name
select new
{
PlanId = a.Id,
PlanName = Program.Name + "_" + Location.Name + "_" + Level.Name + "_" + Experience.Name
};
ddlPlan.DataValueField = "PlanId";
ddlPlan.DataTextField = "PlanName";
ddlPlan.DataSource = planQuery.ToList();
ddlPlan.DataBind();
ddlPlan.Items.FindByValue("" + plan.Id).Selected = true;
db.Database.Connection.Close();
}
}
}
protected void OnFilter(object sender, EventArgs e)
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
if (txtFilter.Text.Equals(""))
{
var languages2 = from dic in db.PrizeExerciseUnits
select new
{
Id = dic.Id,
Exercise = dic.Exercise,
AlternateExercise = dic.AlternateExercise,
Reps = dic.Reps,
Rest = dic.Rest,
Weight = dic.Weight,
Comments = dic.Comments,
UnitOrder = dic.UnitOrder,
Tempo = dic.Tempo,
Trainning_Set = dic.Trainning_Set,
Video = dic.Video,
Image = dic.Image,
TimeDuration = dic.TimeDuration,
};
GridView1.DataSource = languages2.ToList();
GridView1.DataBind();
}
else
{
var languages2 = from dic in db.PrizeExerciseUnits
where dic.Exercise.ToUpper().Contains(txtFilter.Text.ToUpper())
select new
{
Id = dic.Id,
Exercise = dic.Exercise,
AlternateExercise = dic.AlternateExercise,
Reps = dic.Reps,
Rest = dic.Rest,
Weight = dic.Weight,
Comments = dic.Comments,
UnitOrder = dic.UnitOrder,
Tempo = dic.Tempo,
Trainning_Set = dic.Trainning_Set,
Video = dic.Video,
Image = dic.Image,
TimeDuration = dic.TimeDuration,
};
GridView1.DataSource = languages2.ToList();
GridView1.DataBind();
}
}
db.Database.Connection.Close();
}
}
static public PrizeMember GetMemberData(int memberId)
{
using (DIYPTEntities db = new DIYPTEntities())
{
//db.Database.Connection.Open();
PrizeMember member = (from c in db.PrizeMembers
where c.UmbracoId == memberId
select c).FirstOrDefault();
return(member);
//db.Database.Connection.Close();
}
}
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();
}
}
private void BindGrid()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
var languages = from dic in db.PrizeMembers orderby dic.Surname
select new
{
Id = dic.UmbracoId,
Firstname = dic.Firstname,
Surname = dic.Surname,
DoB = dic.DoB,
Gender = dic.Gender,
Country = dic.Country,
Email = dic.Email,
StreetAddress = dic.StreetAddress,
Suburb = dic.Suburb,
City = dic.City,
Postcode = dic.Postcode,
State = dic.State,
Height = dic.Height,
Weight = dic.Weight,
Password = dic.Password,
Waist = dic.Waist,
BodyFat = dic.BodyFat,
GoalDescription = dic.GoalDescription,
GoalWeight = dic.GoalWeight,
GoalWaist = dic.GoalWaist,
GoalBodyFat = dic.GoalBodyFat,
UserSettings = dic.UserSettings,
};
if (tbfistname.Text != "")
{
languages = languages.Where(m => m.Firstname.Contains(tbfistname.Text));
}
if (tbemail.Text != "")
{
languages = languages.Where(m => m.Email.Contains(tbemail.Text));
}
GridView1.DataSource = languages.ToList();
GridView1.DataBind();
}
db.Database.Connection.Close();
}
}
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;
}
}
private void UpdateForm()
{
using (DIYPTEntities db = new DIYPTEntities())
{
var tempStage = int.Parse(ddlStage.SelectedValue);
var tempLevel = int.Parse(ddlLevel.SelectedValue);
var tempWeek = int.Parse(ddlWeek.SelectedValue);
/*var dbStage = (from c in db.PrizeExercisePlans
* where c.PlanStage == tempStage
* && c.PlanLevel == tempLevel
* select c).FirstOrDefault();
* if (dbStage != null)
* {
* var dbWeek = (from c in db.PrizeExercisePlanWeeks
* where c.Week == tempWeek
* && c.PrizeExercisePlan.Id == dbStage.Id
* select c).FirstOrDefault();
*
* txtDescription.Text = dbStage.Description;
*
* txtDay1.Text = "";
* txtDay2.Text = "";
* txtDay3.Text = "";
* txtDay4.Text = "";
* txtDay5.Text = "";
* txtDay6.Text = "";
* txtDay7.Text = "";
*
* if (dbWeek != null)
* {
* txtDay1.Text = dbWeek.ExerciseDay1;
* txtDay2.Text = dbWeek.ExerciseDay2;
* txtDay3.Text = dbWeek.ExerciseDay3;
* txtDay4.Text = dbWeek.ExerciseDay4;
* txtDay5.Text = dbWeek.ExerciseDay5;
* txtDay6.Text = dbWeek.ExerciseDay6;
* txtDay7.Text = dbWeek.ExerciseDay7;
* }
* }
*
* var dbFood = (from c in db.PrizeFoodPlans
* select c).ToList();
* ddlFoodPlan.DataSource = dbFood;
* ddlFoodPlan.DataTextField = "PlanName";
* ddlFoodPlan.DataValueField = "Id";
* ddlFoodPlan.DataBind();*/
}
}
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();
}
}
private void BindGrid()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
var memberPlans = from a in db.MemberExercisePlans
join dic in db.PrizeMembers on a.MemberId equals dic.UmbracoId
join b in db.PrizeExercisePlans on a.ExercisePlanId equals b.Id
join Program in db.PrizePlanPrograms on b.ProgramId equals Program.Id
join Location in db.PrizePlanLocations on b.LocationId equals Location.Id
join Experience in db.PrizePlanExperiences on b.ExperienceId equals Experience.Id
join Level in db.PrizePlanLevels on b.LevelId equals Level.Id
join c in db.PrizeOrders on a.Id equals c.MemberPlanId into gj from subOrder in gj.DefaultIfEmpty()
orderby a.StartDate descending
where !a.Status.EndsWith("C")
select new
{
Id = dic.UmbracoId,
Firstname = dic.Firstname,
Surname = dic.Surname,
Email = dic.Email,
IsTrialPlan = b.IsTrialPlan,
PlanName = Program.Name + "_" + Location.Name + "_" + Level.Name + "_" + Experience.Name,
StartDate = a.StartDate,
EndDate = a.EndDate,
Status = a.Status,
MemberPlanId = a.Id,
PaidDate = subOrder != null?subOrder.OrderDate.ToString() : "",
};
if (tbfistname.Text != "")
{
memberPlans = memberPlans.Where(m => m.Firstname.Contains(tbfistname.Text));
}
if (tbemail.Text != "")
{
memberPlans = memberPlans.Where(m => m.Email.Contains(tbemail.Text));
}
GridView1.DataSource = memberPlans.ToList();
GridView1.DataBind();
}
db.Database.Connection.Close();
}
}
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;
}
}
private void BindDropDownList()
{
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
{
var ProgramQuery = from c in db.PrizeExerciseDayGroupNames
select new { c.DayGroupName, c.Id };
ddldaygroup.DataValueField = "Id";
ddldaygroup.DataTextField = "DayGroupName";
ddldaygroup.DataSource = ProgramQuery.ToList();
ddldaygroup.DataBind();
db.Database.Connection.Close();
}
}
}
