public override void OnBindViewHolder(RecyclerView.ViewHolder holder, int position)
{
ExerciseSetsViewHolder viewHolder = holder as ExerciseSetsViewHolder;
ExerciseSets set = exerciseSets.ElementAt(position);
viewHolder.tvExerciseTitle.Text = set.Name;
viewHolder.tvNSets.Text = set.Count.ToString() + (set.Count > 1 ? " sets" : " set");
viewHolder.llExercise.SetOnClickListener(this);
}
public ActionResult DeleteSet([FromBody] WorkoutViewModel data)
{
TrainingProgram tp = _context.Workouts.FirstOrDefault(W => W.id == data.ProgramID);
var exer = _context.PExercises.FromSql("SELECT * FROM PExercises").ToList(); // Need to do this to access the data ???
var sets = _context.ESets.FromSql("SELECT * FROM ESets").ToList(); // Need to do this to access the data ???
ExerciseSets toDelete = sets.FirstOrDefault(x => x.id == data.SetID);
_context.ESets.Remove(toDelete);
_context.SaveChanges();
return(Json("Success."));
}
void onclick_delete(object sender, System.EventArgs e)
{
var delete = sender as Image;
ExerciseSets item = delete.BindingContext as ExerciseSets;
//var vm = BindingContext as ExerciseSetsViewModel;
//vm.RemoveCommand.Execute(item);
//OnPropertyChanged(nameof(list_exerciseSet));
var index = (list_exerciseSet.ItemsSource as ObservableCollection <ExerciseSets>).IndexOf(item);
Console.WriteLine("---Delete Index-->" + index);
em.GetExerciseSets.RemoveAt(index);
}
void onclick_edit(object sender, System.EventArgs e)
{
var edit = sender as Image;
ExerciseSets item = edit.BindingContext as ExerciseSets;
// get and set data
item.SetNumber = edit.TabIndex;
lbl_val1.Text = "" + item.Value_1;
lbl_val2.Text = "" + item.Value_2;
Isedit = true;
Console.WriteLine("---Edit Click----" + edit.TabIndex);
Console.WriteLine("--->" + item.SetNumber + "-->" + item.Value_1 + "-->" + item.Value_2);
}
public ActionResult AddSets([FromBody] WorkoutViewModel data)
{
TrainingProgram tp = _context.Workouts.FirstOrDefault(W => W.id == data.ProgramID);
int?weight = 0;
if (!(data.Weight == null))
{
weight = data.Weight;
}
var exer = _context.PExercises.FromSql("SELECT * FROM PExercises").ToList(); // Need to do this to access the data ???
var sets = _context.ESets.FromSql("SELECT * FROM ESets").ToList(); // Need to do this to access the data ???
ProgramExercises p_ex = tp.Exercices.FirstOrDefault(E => E.id == data.ExerciseID);
List <ExerciseSets> e_set = p_ex.SetInfo;
ExerciseSets newSet = new ExerciseSets
{
amount = data.Amount,
aunit = data.Aunit,
weight = (int)weight,
wunit = (int)data.Wunit
};
p_ex.SetInfo.Add(newSet);
tp.Exercices.Add(p_ex);
var result = _context.Workouts.Update(tp);
_context.SaveChanges();
var setResult = result.Entity.Exercices.FirstOrDefault(x => x.id == data.ExerciseID).SetInfo.Last();
setResult = _context.ESets.FirstOrDefault(x => x.id == setResult.id);
return(Json(JsonConvert.SerializeObject(setResult)));
}
public void onSaveClick(object sender, System.EventArgs e)
{
String val1 = lbl_val1.Text;
String val2 = lbl_val2.Text;
int sets = 0;
ExerciseSets ex = new ExerciseSets();
ex.Value_1 = Int32.Parse(val1);
ex.Value_2 = Int32.Parse(val2);
ex.SetNumber = sets;
if (Isedit)
{
Update(index, ex);
}
else
{
em.GetExerciseSets.Add(ex);
}
//list_exerciseSet.ItemsSource = em.GetExerciseSets;
Isedit = false;
}
public List <ExerciseSets> GetExercisesNSetsWorkout(int workoutId)
{
var query = conn.Query <Exercise>("SELECT Exercises.Name, Exercises.Id from Exercises JOIN Workouts_Exercises ON Exercises.Id = Workouts_Exercises.ExerciseId"
+ " JOIN Target_Sets ON Workouts_Exercises.Id = Target_Sets.Workout_ExerciseId WHERE Workouts_Exercises.WorkoutId = " + workoutId.ToString());
List <ExerciseSets> exercisesSets = new List <ExerciseSets>();
foreach (var exercise in query)
{
//If not exists, add new ExerciseSets
if (!exercisesSets.Any(ex => ex.Id == exercise.Id))
{
ExerciseSets newExercise = new ExerciseSets();
newExercise.Name = exercise.Name;
newExercise.Count = 1;
newExercise.Id = exercise.Id;
exercisesSets.Add(newExercise);
} //Else, add count
else
{
exercisesSets.Find(ex => ex.Id == exercise.Id).Count++;
}
}
return(exercisesSets);
}
public async Task <IActionResult> AddExerciseToDay(WorkoutViewModel model, string returnUrl = null)
{
List <Exercise> ExercisesList = getExercisesFromAPI();
ModelState.Remove("WorkoutName");
ModelState.Remove("WorkoutDescription");
ModelState.Remove("StartDate");
ModelState.Remove("EndDate");
ModelState.Remove("CustomName");
ModelState.Remove("CustomDescription");
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
string userID = _userManager.GetUserId(User);
int programID = model.ProgramID;
int exerciseID = model.ExerciseID;
int day = model.Day;
int amount = model.Amount;
int aunit = model.Aunit;
int? weight = model.Weight;
int? wunit = model.Wunit;
if (weight != null && wunit < 1)
{
TempData["ErrorMessage"] = "If you enter a weight, you need to enter the weight unit as well.";
ViewBag.Exercises = ExercisesList;
ViewBag.Workouts = getWorkoutsForUser();
return(View("Program", model));
}
TrainingProgram tp = await _context.Workouts.FirstOrDefaultAsync(W => W.id == model.ProgramID && W.uid == _userManager.GetUserId(User));
ExerciseSets e_set = new ExerciseSets
{
amount = amount,
aunit = aunit,
weight = (weight == null ? 0 : (int)weight),
wunit = (wunit == null ? 0 : (int)wunit)
};
ProgramExercises p_ex = new ProgramExercises
{
ExerciseID = exerciseID,
day = day
};
p_ex.SetInfo.Add(e_set);
tp.Exercices.Add(p_ex);
_context.Workouts.Update(tp);
await _context.SaveChangesAsync();
Dictionary <int, string> exerciseNames = new Dictionary <int, string>();
var exer = _context.PExercises.FromSql("SELECT * FROM PExercises").ToList(); // Need to do this to access the data ???
var sets = _context.ESets.FromSql("SELECT * FROM ESets").ToList(); // Need to do this to access the data ???
List <Exercise> exercisesFromAPI = ExercisesList;
foreach (var ex in tp.Exercices)
{
foreach (var real_ex in exercisesFromAPI)
{
if (ex.ExerciseID == real_ex.id && (exerciseNames.GetValueOrDefault(ex.ExerciseID) == null))
{
exerciseNames.Add(ex.ExerciseID, real_ex.name);
}
}
}
TempData["SuccessMessage"] = "Your Exercise has been added successfully!";
ViewBag.Program = tp;
ViewBag.Names = exerciseNames;
ViewBag.Exercises = ExercisesList;
return(View("ProgramInfo", new WorkoutViewModel()));
}
ViewBag.Exercises = ExercisesList;
ViewBag.Workouts = getWorkoutsForUser();
TempData["ErrorMessage"] = "Oops... Something hapenned...";
return(View("Program", model));
}
public async Task <IActionResult> AddExerciseToWorkout(WorkoutViewModel model, string returnUrl = null)
{
List <Exercise> ExercisesList = getExercisesFromAPI();
ModelState.Remove("WorkoutName");
ModelState.Remove("WorkoutDescription");
ModelState.Remove("StartDate");
ModelState.Remove("EndDate");
ModelState.Remove("CustomName");
ModelState.Remove("CustomDescription");
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
string userID = _userManager.GetUserId(User);
int programID = model.ProgramID;
int exerciseID = model.ExerciseID;
int day = model.Day;
int amount = model.Amount;
int aunit = model.Aunit;
int? weight = model.Weight;
int? wunit = model.Wunit;
if (weight != null && wunit < 1)
{
TempData["ErrorMessage"] = "If you enter a weight, you need to enter the weight unit as well.";
ViewBag.Exercises = ExercisesList;
ViewBag.Workouts = getWorkoutsForUser();
return(View("Program", model));
}
TrainingProgram tp = await _context.Workouts.FirstOrDefaultAsync(X => X.id == programID);
ExerciseSets e_set = new ExerciseSets
{
amount = amount,
aunit = aunit,
weight = (weight == null ? 0 : (int)weight),
wunit = (wunit == null ? 0 : (int)wunit)
};
ProgramExercises p_ex = new ProgramExercises
{
ExerciseID = exerciseID,
day = day
};
p_ex.SetInfo.Add(e_set);
tp.Exercices.Add(p_ex);
_context.Workouts.Update(tp);
await _context.SaveChangesAsync();
ViewBag.Exercises = ExercisesList;
ViewBag.Workouts = getWorkoutsForUser();
TempData["SuccessMessage"] = "Congrats! Your Exercise has been added successfully.";
return(View("Program", new WorkoutViewModel()));
}
ViewBag.Exercises = ExercisesList;
ViewBag.Workouts = getWorkoutsForUser();
TempData["ErrorMessage"] = "Oops... Something hapenned...";
return(View("Program", model));
}
public void Update(int index, ExerciseSets ex)
{
em.GetExerciseSets.Insert(index, ex);
}
public async Task <IActionResult> AddExerciseToWorkout(ExercisesViewModel model, string returnUrl = null)
{
AddToWorkoutData dataModel = model.AddData;
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
string userID = _userManager.GetUserId(User);
int programID = dataModel.ProgramID;
int exerciseID = dataModel.ExerciseID;
int day = dataModel.Day;
int amount = dataModel.Amount;
int aunit = dataModel.Aunit;
int? weight = dataModel.Weight;
int? wunit = dataModel.Wunit;
if (weight != null && wunit < 1)
{
TempData["ErrorMessage"] = "If you enter a weight, you need to enter the weight unit as well.";
ViewBag.Workouts = getWorkoutsForUser();
return(View("Exercises", model));
}
TrainingProgram tp = await _context.Workouts.FirstOrDefaultAsync(X => X.id == programID);
ExerciseSets e_set = new ExerciseSets
{
amount = amount,
aunit = aunit,
weight = (weight == null ? 0 : (int)weight),
wunit = (wunit == null ? 0: (int)wunit)
};
ProgramExercises p_ex = new ProgramExercises
{
ExerciseID = exerciseID,
day = day
};
p_ex.SetInfo.Add(e_set);
tp.Exercices.Add(p_ex);
_context.Workouts.Update(tp);
await _context.SaveChangesAsync();
ViewBag.Workouts = getWorkoutsForUser();
TempData["SuccessMessage"] = "Congrats! Your exercise has been added successfully.";
if (model.Search == null)
{
return(RedirectToAction("Exercises"));
}
else
{
return(RedirectToAction("Exercises"));
}
}
ViewBag.Workouts = getWorkoutsForUser();
TempData["ErrorMessage"] = "Oops... Something hapenned...";
return(View("Exercises", model));
}
