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();
}
}
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();
}
}
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 MemberExercisePlan GetNextMemberPlanNeedToPay(int iMemberId)
{
DIYPTEntities db = new DIYPTEntities();
try
{
db.Database.Connection.Open();
string statusNotPaid = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_NOT_PAID;
string statusWeekly = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT;
MemberExercisePlan myPlan = (from c in db.MemberExercisePlans
where c.MemberId == iMemberId && (c.Status.Equals(statusNotPaid) || c.Status.Equals(statusWeekly))
orderby c.Id descending
select c).FirstOrDefault();
return(myPlan);
}
finally
{
db.Dispose();
}
}
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();
}
}
public bool ResumeMemberPlan(int myPlanId)
{
bool ret = false;
DIYPTEntities db = new DIYPTEntities();
try
{
db.Database.Connection.Open();
MemberExercisePlan myPlan = (from c in db.MemberExercisePlans
where c.Id == myPlanId
select c).FirstOrDefault();
if (myPlan == null)
{
return(ret);
}
IList <MemberExercisePlanWeek> myPlanWeeks = (from c in db.MemberExercisePlanWeeks
where c.MemberExercisePlanId == myPlan.Id && c.Status.Equals(PrizeConstants.STATUS_PLAN_WEEK_SUSPENDED)
orderby c.Week
select c).ToList();
int idx = 1;
DateTime currentEndDate = PrizeCommonUtils.GetSystemDate();
DateTime startDate = PrizeCommonUtils.GetWeekStart(currentEndDate);
DateTime endDate = PrizeCommonUtils.GetWeekEnd(startDate);
foreach (var myPlanWeek in myPlanWeeks)
{
if (idx == 1)
{
if (myPlanWeek.StartDate <= startDate)
{
myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_STARTED;
myPlanWeek.StartDate = startDate;
myPlanWeek.EndDate = endDate;
}
else
{
myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED;
startDate = myPlanWeek.StartDate;
endDate = myPlanWeek.EndDate;
}
}
else
{
myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED;
myPlanWeek.StartDate = startDate;
myPlanWeek.EndDate = endDate;
}
myPlan.EndDate = endDate;
startDate = startDate.AddDays(7);
endDate = endDate.AddDays(7);
idx++;
}
myPlan.Status = PrizeConstants.STATUS_PLAN_STARTED + myPlan.Status[1];
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
finally
{
db.Dispose();
}
}
public int BuyNewPlan(int newPlanId, ref PrizeExercisePlan prizePlan, ref MemberExercisePlan newMemberPlan)
{
DIYPTEntities db = new DIYPTEntities();
try
{
if (PrizeMemberAuthUtils.CurrentUserLogin() != true)
{
return(PrizeErrorCode.ERROR_NOT_LOGGED_IN);
}
int memberId = PrizeMemberAuthUtils.GetMemberID();
db.Database.Connection.Open();
PrizeExercisePlan plan = (from c in db.PrizeExercisePlans
where c.Id == newPlanId
select c).FirstOrDefault();
if (plan == null)
{
return(-1);
}
//using (TransactionScope transaction = new TransactionScope())
//{
if (plan == null)
{
return(PrizeErrorCode.ERROR_PLAN_NOT_EXIST);
}
MemberExercisePlan myExistingPaidPlan = (from c in db.MemberExercisePlans
where c.MemberId == memberId &&
(c.Status.Equals(PrizeConstants.STATUS_PLAN_STARTED + PrizeConstants.STATUS_PLAN_PAID) ||
c.Status.Equals(PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAID))
orderby c.EndDate descending
select c).FirstOrDefault();
DateTime currentEndDate;
if (myExistingPaidPlan != null)
{
currentEndDate = myExistingPaidPlan.EndDate.Value;
}
else
{
currentEndDate = PrizeCommonUtils.GetSystemDate();
}
List <MemberExercisePlan> myNotPaidPlans = (from c in db.MemberExercisePlans
where c.MemberId == memberId && (c.Status.EndsWith(PrizeConstants.STATUS_PLAN_NOT_PAID) || c.Status.EndsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT))
select c).ToList();
foreach (MemberExercisePlan notPaidPlan in myNotPaidPlans)
{
IQueryable <MemberExercisePlanWeek> notPaidPlanWeeks = (from c in db.MemberExercisePlanWeeks
where c.MemberExercisePlanId == notPaidPlan.Id
select c);
foreach (var week in notPaidPlanWeeks)
{
MemberPlanWeekResult weekResult = (from c in db.MemberPlanWeekResults
where c.MemberExercisePlanWeekId == week.Id
select c).SingleOrDefault();
db.MemberExercisePlanWeeks.Remove(week);
db.MemberPlanWeekResults.Remove(weekResult);
}
notPaidPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_PAYMENT_CANCELLED;
List <MemberManualPayment> manualPayments = (from c in db.MemberManualPayments
where c.MemberExercisePlanId == notPaidPlan.Id && c.Status.StartsWith(PrizeConstants.STATUS_PLAN_MANUAL_PAYMENT_NOT_APPROVED)
select c).ToList();
foreach (var notPaidRecord in manualPayments)
{
db.MemberManualPayments.Remove(notPaidRecord);
db.SaveChanges();
}
}
db.SaveChanges();
DateTime startDate = PrizeCommonUtils.GetNextWeekStart(currentEndDate);
DateTime endDate = PrizeCommonUtils.GetWeekEnd(startDate);
MemberExercisePlan myPlan = new MemberExercisePlan();
myPlan.MemberId = memberId;
myPlan.ExercisePlanId = plan.Id;
myPlan.StartDate = startDate;
myPlan.Status = PrizeConstants.STATUS_PLAN_NOT_STARTED + PrizeConstants.STATUS_PLAN_NOT_PAID; //Not paid
db.MemberExercisePlans.Add(myPlan);
db.SaveChanges();
MemberPlanWeekResult myWeekResult;
if (plan.IsTrialPlan != 1)
{
MemberExercisePlanWeek myPlanWeekOrientation = new MemberExercisePlanWeek();
myPlanWeekOrientation.MemberExercisePlanId = myPlan.Id;
myPlanWeekOrientation.ExercisePlanWeekId = 0;
myPlanWeekOrientation.MemberId = memberId;
myPlanWeekOrientation.StartDate = startDate;
myPlanWeekOrientation.EndDate = endDate;
myPlanWeekOrientation.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED;
myPlanWeekOrientation.Week = 0;
db.MemberExercisePlanWeeks.Add(myPlanWeekOrientation);
db.SaveChanges();
myWeekResult = new MemberPlanWeekResult();
myWeekResult.MemberId = memberId;
myWeekResult.MemberExercisePlanWeekId = myPlanWeekOrientation.Id;
InitialiseWeekResult(ref myWeekResult);
db.MemberPlanWeekResults.Add(myWeekResult);
db.SaveChanges();
myPlan.EndDate = endDate;
startDate = startDate.AddDays(7);
endDate = endDate.AddDays(7);
}
IList <PrizeExercisePlanWeek> planWeeks = plan.PrizeExercisePlanWeeks.OrderBy(s => s.StartWeek).ToList();
foreach (PrizeExercisePlanWeek planWeek in planWeeks)
{
for (int i = planWeek.StartWeek; i <= planWeek.EndWeek; i++)
{
MemberExercisePlanWeek myPlanWeek = new MemberExercisePlanWeek();
myPlanWeek.MemberExercisePlanId = myPlan.Id;
myPlanWeek.ExercisePlanWeekId = planWeek.Id;
myPlanWeek.MemberId = memberId;
myPlanWeek.StartDate = startDate;
myPlanWeek.EndDate = endDate;
myPlanWeek.Status = PrizeConstants.STATUS_PLAN_WEEK_NOT_STARTED;
myPlanWeek.Week = i;
db.MemberExercisePlanWeeks.Add(myPlanWeek);
db.SaveChanges();
myWeekResult = new MemberPlanWeekResult();
myWeekResult.MemberId = memberId;
myWeekResult.MemberExercisePlanWeekId = myPlanWeek.Id;
InitialiseWeekResult(ref myWeekResult);
db.MemberPlanWeekResults.Add(myWeekResult);
myPlan.EndDate = endDate;
db.SaveChanges();
startDate = startDate.AddDays(7);
endDate = endDate.AddDays(7);
}
}
//transaction.Complete();
newMemberPlan = myPlan;
prizePlan = plan;
return(newPlanId);
//}
}
finally
{
db.Dispose();
}
}
public bool ChangeMemberPlan(int myPlanId, int targetPlanId)
{
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);
}
PrizeExercisePlan plan = (from c in db.PrizeExercisePlans
where c.Id == myPlan.ExercisePlanId
select c).FirstOrDefault();
if (plan == null)
{
return(ret);
}
PrizeExercisePlan targetPlan;
if (plan.IsTrialPlan == 1)
{
targetPlan = (from c in db.PrizeExercisePlans
where c.Id == targetPlanId && c.IsTrialPlan == 1
select c).FirstOrDefault();
}
else
{
targetPlan = (from c in db.PrizeExercisePlans
where c.Id == targetPlanId && c.IsTrialPlan == 0
select c).FirstOrDefault();
}
if (targetPlan == null)
{
return(ret);
}
IQueryable <PrizeExercisePlanWeek> targetPlanWeeks = (from c in db.PrizeExercisePlanWeeks
where c.ExercisePlanId == targetPlan.Id
orderby c.StartWeek
select c);
foreach (var targetPlanWeek in targetPlanWeeks)
{
IQueryable <MemberExercisePlanWeek> myPlanWeeks = (from c in db.MemberExercisePlanWeeks
join d in db.PrizeExercisePlanWeeks on c.ExercisePlanWeekId equals d.Id
where c.MemberExercisePlanId == myPlan.Id && c.Week >= targetPlanWeek.StartWeek && c.Week <= targetPlanWeek.EndWeek
select c);
foreach (var myPlanWeek in myPlanWeeks)
{
myPlanWeek.ExercisePlanWeekId = targetPlanWeek.Id;
}
}
myPlan.ExercisePlanId = targetPlan.Id;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
finally
{
db.Dispose();
}
}
public int FindNewPlan(string sProgram, string sLocation, string sLevel, string sExp, bool bIsTrial = false)
{
int newPlanId = -1;
DIYPTEntities db = new DIYPTEntities();
try
{
db.Database.Connection.Open();
PrizePlanProgram program = (from c in db.PrizePlanPrograms
where c.Name == sProgram
select c).FirstOrDefault();
if (program == null)
{
return(PrizeErrorCode.ERROR_WRONG_PROGRAM);
}
PrizePlanLocation location = (from c in db.PrizePlanLocations
where c.Name == sLocation
select c).FirstOrDefault();
if (location == null)
{
return(PrizeErrorCode.ERROR_WRONG_LOCATION);
}
PrizePlanLevel level = (from c in db.PrizePlanLevels
where c.Name == sLevel
select c).FirstOrDefault();
if (level == null)
{
return(PrizeErrorCode.ERROR_WRONG_LEVEL);
}
PrizePlanExperience exp = (from c in db.PrizePlanExperiences
where c.Name == sExp
select c).FirstOrDefault();
if (exp == null)
{
return(PrizeErrorCode.ERROR_WRONG_LEVEL);
}
PrizeExercisePlan plan;
if (bIsTrial == false)
{
plan = (from c in db.PrizeExercisePlans
where c.ProgramId == program.Id && c.LocationId == location.Id &&
c.LevelId == level.Id && c.ExperienceId == exp.Id && c.IsTrialPlan == 0
select c).FirstOrDefault();
}
else
{
plan = (from c in db.PrizeExercisePlans
where c.ProgramId == program.Id && c.LocationId == location.Id &&
c.LevelId == level.Id && c.ExperienceId == exp.Id && c.IsTrialPlan == 1
select c).FirstOrDefault();
}
if (plan != null)
{
newPlanId = plan.Id;
}
return(newPlanId);
}
finally
{
db.Dispose();
}
}