internal static int InsertUserExercisePlanSelection(UserExercisePlanSelection userExercisePlanSelection)
{
try
{
using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes())
{
dbContext.UserExercisePlanSelections.Add(userExercisePlanSelection);
dbContext.SaveChanges();
return(userExercisePlanSelection.Id);
}
}
catch (Exception ex)
{
throw ex;
}
}
internal static UserExercisePlanSelection GetUserExercisePlanSelection(int userExercisePlanSelectionId, string userId)
{
try
{
using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes())
{
UserExercisePlanSelection userExercisePlanSelection = dbContext.UserExercisePlanSelections.Include(e => e.UserExerciseTypeSelections).SingleOrDefault(u => u.Id.Equals(userExercisePlanSelectionId) && u.UserId.Equals(userId));
//List<UserExerciseTypeSelection> lst = new List<UserExerciseTypeSelection>();
//lst.AddRange(userExercisePlanSelection.UserExerciseTypeSelections.Where(u => u.WeightRequired == true));
//userExercisePlanSelection.UserExerciseTypeSelections = lst;
return(userExercisePlanSelection);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Payment(string planId)
{
planId = Convert.ToString(Session["PLAN_ID"]);
APIContext apiContext = Configuration.GetAPIContext();
UserExercisePlanSelection userExercisePlanSelection = new UserExercisePlanSelection();
if (!string.IsNullOrEmpty(planId))
{
userExercisePlanSelection = DataService.GetUserExercisePlanSelection(Convert.ToInt32(planId), User.Identity.Name);
}
else
{
throw new Exception("Exercise Plan Selection is empty.");
}
try
{
string payerId = Request.Params["PayerID"];
if (string.IsNullOrEmpty(payerId))
{
string baseURI = Request.Url.Scheme + "://" + Request.Url.Authority + "/User/Payment?planId=" + planId + "&";
var guid = Convert.ToString((new Random()).Next(100000));
var createdPayment = this.CreatePayment(apiContext, baseURI + "guid=" + guid, userExercisePlanSelection.ExercisePlanId);
var links = createdPayment.links.GetEnumerator();
string paypalRedirectUrl = null;
while (links.MoveNext())
{
Links lnk = links.Current;
if (lnk.rel.ToLower().Trim().Equals("approval_url"))
{
paypalRedirectUrl = lnk.href;
}
}
Session.Add(guid, createdPayment.id);
return(Redirect(paypalRedirectUrl));
}
else
{
var guid = Request.Params["guid"];
var paymentId = Request.Params["paymentId"];
var executedPayment = ExecutePayment(apiContext, payerId, paymentId);
if (executedPayment.state.ToLower() != "approved")
{
return(View("FailureView"));
}
else
{
string finalExcel = ExcelGenerator.GenerateExcel(User.Identity.Name, Convert.ToInt32(planId));
DataService.InsertPurchases(new Purchase
{
Id = executedPayment.id,
UserId = User.Identity.Name,
UserExercisePlanSelectionId = userExercisePlanSelection.Id,
ExercisePlanId = userExercisePlanSelection.ExercisePlanId,
CartId = executedPayment.cart,
CreateTime = DateTime.Parse(executedPayment.create_time),
Intent = executedPayment.intent,
State = executedPayment.state,
Currency = executedPayment.transactions[0].amount.currency,
Amount = Convert.ToDouble(executedPayment.transactions[0].amount.total),
GenerateExcel = @"~/UserExcels/" + finalExcel
});
return(View(viewName: "~/Views/User/PurchaseSuccess.cshtml", model: finalExcel));
}
}
}
catch (Exception ex)
{
}
string fileName = Services.ExcelGenerator.GenerateExcel(User.Identity.Name, 104);
return(View(viewName: "~/Views/User/PurchaseSuccess.cshtml", model: fileName));
}
public static string GenerateExcel(string UserId, int PlanId)
{
// Taking existing file: Here 'ClinicalAthlete.xlsx' is treated as template file
FileInfo templateFile = new FileInfo(HttpContext.Current.Server.MapPath(@"~/OutputTemplate/ClinicalAthlete Template.xlsx"));
// Making a new file for user
FileInfo newFile = new FileInfo(HttpContext.Current.Server.MapPath(@"~/UserExcels/" + PlanId + "_" + UserId + ".xlsx"));
// If there is any file having same name as 'Sample2.xlsx', then delete it first
if (newFile.Exists)
{
newFile.Delete();
newFile = new FileInfo(HttpContext.Current.Server.MapPath(@"~/UserExcels/" + PlanId + "_" + UserId + ".xlsx"));
}
// DataService.GetUserExerciseWeightSelections("331,332,333", "2", "2");
using (ExcelPackage package = new ExcelPackage(newFile, templateFile))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
if (worksheet == null)
{
Exception exp = new Exception("Could not load worksheet.");
return(exp.Message);
}
UserExercisePlanSelection userExercisePlanSelection = DataService.GetUserExercisePlanSelection(PlanId, HttpContext.Current.User.Identity.Name);
if (null == userExercisePlanSelection)
{
Exception exp = new Exception("Could not load exercise plan selection.");
return(exp.Message);
}
int dayOneStart = 6;
int dayTwoStart = 14;
int dayThreeStart = 22;
int dayFourStart = 30;
int dayFiveStart = 38;
int daySixStart = 46;
var ListExTypes = userExercisePlanSelection.UserExerciseTypeSelections.OrderByDescending(x => x.WeightRequired).ToList();
foreach (UserExerciseTypeSelection userExerciseTypeSelection in ListExTypes)
{
worksheet.Cells["A" + dayOneStart.ToString()].Value = userExerciseTypeSelection.ExerciseTypeName;
worksheet.Cells["B" + dayOneStart.ToString()].Value = userExerciseTypeSelection.ExerciseName;
dayOneStart++;
worksheet.Cells["A" + dayTwoStart.ToString()].Value = userExerciseTypeSelection.ExerciseTypeName;
worksheet.Cells["B" + dayTwoStart.ToString()].Value = userExerciseTypeSelection.ExerciseName;
dayTwoStart++;
worksheet.Cells["A" + dayThreeStart.ToString()].Value = userExerciseTypeSelection.ExerciseTypeName;
worksheet.Cells["B" + dayThreeStart.ToString()].Value = userExerciseTypeSelection.ExerciseName;
dayThreeStart++;
worksheet.Cells["A" + dayFourStart.ToString()].Value = userExerciseTypeSelection.ExerciseTypeName;
worksheet.Cells["B" + dayFourStart.ToString()].Value = userExerciseTypeSelection.ExerciseName;
dayFourStart++;
worksheet.Cells["A" + dayFiveStart.ToString()].Value = userExerciseTypeSelection.ExerciseTypeName;
worksheet.Cells["B" + dayFiveStart.ToString()].Value = userExerciseTypeSelection.ExerciseName;
dayFiveStart++;
worksheet.Cells["A" + daySixStart.ToString()].Value = userExerciseTypeSelection.ExerciseTypeName;
worksheet.Cells["B" + daySixStart.ToString()].Value = userExerciseTypeSelection.ExerciseName;
daySixStart++;
}
#region Cell Addresses...
int Week1DayOneStart = 6;
int Week1DayTwoStart = 14;
int Week1DayThreeStart = 22;
int Week2DayOneStart = 6;
int Week2DayTwoStart = 14;
int Week2DayThreeStart = 22;
int Week3DayOneStart = 6;
int Week3DayTwoStart = 14;
int Week3DayThreeStart = 22;
int Week4DayOneStart = 6;
int Week4DayTwoStart = 14;
int Week4DayThreeStart = 22;
int Week5DayOneStart = 6;
int Week5DayTwoStart = 14;
int Week5DayThreeStart = 22;
int Week6DayOneStart = 30;
int Week6DayTwoStart = 38;
int Week6DayThreeStart = 46;
int Week7DayOneStart = 30;
int Week7DayTwoStart = 38;
int Week7DayThreeStart = 46;
int Week8DayOneStart = 30;
int Week8DayTwoStart = 38;
int Week8DayThreeStart = 46;
int Week9DayOneStart = 30;
int Week9DayTwoStart = 38;
int Week9DayThreeStart = 46;
int Week10DayOneStart = 30;
int Week10DayTwoStart = 38;
int Week10DayThreeStart = 46;
int Week11DayOneStart = 30;
int Week11DayTwoStart = 38;
int Week11DayThreeStart = 46;
int Week12DayOneStart = 30;
int Week12DayTwoStart = 38;
int Week12DayThreeStart = 46;
#endregion Cell Addresses...
#region Weekly Table...
foreach (UserExerciseTypeSelection userExerciseTypeSelection in userExercisePlanSelection.UserExerciseTypeSelections)
{
#region Week One...
List <UserExerciseWeightSelection> lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "1");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(1) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["E" + Week1DayOneStart].Value = userExerciseWeightSelection.Weight;
Week1DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(1) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["E" + Week1DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week1DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(1) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["E" + Week1DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week1DayThreeStart++;
}
}
#endregion Week One...
#region Week Two...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "2");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(2) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["H" + Week2DayOneStart].Value = userExerciseWeightSelection.Weight;
Week2DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(2) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["H" + Week2DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week2DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(2) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["H" + Week2DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week2DayThreeStart++;
}
}
#endregion Week Two...
#region Week Three...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "3");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(3) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["K" + Week3DayOneStart].Value = userExerciseWeightSelection.Weight;
Week3DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(3) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["K" + Week3DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week3DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(3) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["K" + Week3DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week3DayThreeStart++;
}
}
#endregion Week Three...
#region Week Four...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "4");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(4) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["N" + Week4DayOneStart].Value = userExerciseWeightSelection.Weight;
Week4DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(4) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["N" + Week4DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week4DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(4) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["N" + Week4DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week4DayThreeStart++;
}
}
#endregion Week Four...
#region Week Five...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "5");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(5) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["Q" + Week5DayOneStart].Value = userExerciseWeightSelection.Weight;
Week5DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(5) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["Q" + Week5DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week5DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(5) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["Q" + Week5DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week5DayThreeStart++;
}
}
#endregion Week Five...
#region Week Six...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "6");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(6) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["E" + Week6DayOneStart].Value = userExerciseWeightSelection.Weight;
Week6DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(6) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["E" + Week6DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week6DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(6) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["E" + Week6DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week6DayThreeStart++;
}
}
#endregion Week Six...
#region Week Seven...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "7");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(7) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["H" + Week7DayOneStart].Value = userExerciseWeightSelection.Weight;
Week7DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(7) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["H" + Week7DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week7DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(7) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["H" + Week7DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week7DayThreeStart++;
}
}
#endregion Week Seven...
#region Week Eight...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "8");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(8) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["K" + Week8DayOneStart].Value = userExerciseWeightSelection.Weight;
Week8DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(8) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["K" + Week8DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week8DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(8) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["K" + Week8DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week8DayThreeStart++;
}
}
#endregion Week Eight...
#region Week Nine...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "9");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(9) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["N" + Week9DayOneStart].Value = userExerciseWeightSelection.Weight;
Week9DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(9) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["N" + Week9DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week9DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(9) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["N" + Week9DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week9DayThreeStart++;
}
}
#endregion Week Nine...
#region Week Ten...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "10");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(10) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["Q" + Week10DayOneStart].Value = userExerciseWeightSelection.Weight;
Week10DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(10) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["Q" + Week10DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week10DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(10) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["Q" + Week10DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week10DayThreeStart++;
}
}
#endregion Week Ten...
#region Week Eleven...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "11");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(11) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["T" + Week11DayOneStart].Value = userExerciseWeightSelection.Weight;
Week11DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(11) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["T" + Week11DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week11DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(11) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["T" + Week11DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week11DayThreeStart++;
}
}
#endregion Week Eleven...
#region Week Twelve...
lst = DataService.GetUserExerciseWeightSelectionsWeekly(userExerciseTypeSelection.Id.ToString(), "12");
foreach (UserExerciseWeightSelection userExerciseWeightSelection in lst)
{
userExerciseWeightSelection.UserExerciseTypeSelection = DataService.GetUserExerciseTypeSelectionById(userExerciseWeightSelection.UserExerciseTypeSelectionId);
if (userExerciseWeightSelection.WeekNumber.Equals(12) && userExerciseWeightSelection.DayNumber.Equals(1) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["W" + Week12DayOneStart].Value = userExerciseWeightSelection.Weight;
Week12DayOneStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(12) && userExerciseWeightSelection.DayNumber.Equals(2) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["W" + Week12DayTwoStart].Value = userExerciseWeightSelection.Weight;
Week12DayTwoStart++;
}
if (userExerciseWeightSelection.WeekNumber.Equals(12) && userExerciseWeightSelection.DayNumber.Equals(3) && userExerciseWeightSelection.UserExerciseTypeSelection.WeightRequired)
{
worksheet.Cells["W" + Week12DayThreeStart].Value = userExerciseWeightSelection.Weight;
Week12DayThreeStart++;
}
}
#endregion Week Twelve...
}
#endregion Weekly Table...
package.Save();
}
return(newFile.Name);
}
public int SaveUserExercisePlanSelections(UserExercisePlanSelection userExercisePlanSelection)
{
userExercisePlanSelection.UserId = User.Identity.Name;
return(DataService.InsertUserExercisePlanSelection(userExercisePlanSelection));
}