public async Task AddSetToInternalDb(DateTime date, string pickerOne, string pickerTwo)
{ //guid later
var weight = System.Convert.ToDecimal(pickerOne);
var rep = System.Convert.ToInt16(pickerTwo);
//add set record
var set = new Models.Persistence.Set
{
ExerciseId = ExerciseId,
TimeOfSet = date,
Weight = weight,
Reps = rep
};
await _connection.InsertAsync(set);
var sets = await Set.GetSetsByDate(_connection, date);
if (sets.Count != 1)
{
await Navigation.PushAsync(new Views.Workout.ViewWorkoutsPage());
Navigation.RemovePage(this);
}
else
{
ExerciseList exerciseList = new ExerciseList()
{
Id = sets[0].ExerciseId
};
await Navigation.PushAsync(new Views.Workout.ViewSetsPage(exerciseList));
Navigation.RemovePage(this);
}
}
public async Task UpdateSetInternally(string pickerOne, string pickerTwo)
{ //guid later
var weight = System.Convert.ToDecimal(pickerOne);
var rep = System.Convert.ToInt16(pickerTwo);
//add set record
var set = new Models.Persistence.Set
{
Id = SetId,
ExerciseId = ExerciseId,
Weight = weight,
Reps = rep,
TimeOfSet = Date
};
await _connection.UpdateAsync(set);
ExerciseList exerciseList = new ExerciseList()
{
Id = ExerciseId
};
await Navigation.PushAsync(new Views.Workout.ViewSetsPage(exerciseList));
Navigation.RemovePage(this);
}
public ViewSetsPage(ExerciseList exerciseList)
{
ExerciseId = exerciseList.Id;
_connection = DependencyService.Get <ISQLiteDb>().GetConnection();
InitializeComponent();
}
public IHttpActionResult SaveExerciseList(ExerciseList entity)
{
return(ApiResult <bool>(() =>
{
return GynBusinessRules.SaveExerciseList(entity);
}));
}
void ReleaseDesignerOutlets()
{
if (AddExerciseButton != null)
{
AddExerciseButton.Dispose();
AddExerciseButton = null;
}
if (ExerciseList != null)
{
ExerciseList.Dispose();
ExerciseList = null;
}
if (MenuButton != null)
{
MenuButton.Dispose();
MenuButton = null;
}
if (NavBar != null)
{
NavBar.Dispose();
NavBar = null;
}
}
public EditExercisePage(ExerciseList exerciseList)
{
ExerciseId = exerciseList.Id;
WorkoutId = exerciseList.WorkoutId;
_connection = DependencyService.Get <ISQLiteDb>().GetConnection();
InitializeComponent();
}
public override int UpdateExerciseList(ExerciseList entity)
{
TccContext.Tcc.DB.Update <ExerciseList>("ExerciseList", entity)
.AutoMap(x => x.Id)
.Where(x => x.Id)
.Execute();
return(entity.Id);
}
private void LoadExerciseDay(ExerciseDay day)
{
ExerciseDayAdd = day;
OnPropertyChanged("ExerciseDayAdd");
ExerciseAdd = ExerciseList.FirstOrDefault(p => p.Id == day.ExerciseId);
OnPropertyChanged("ExerciseAdd");
}
void Handle_ItemTapped(object sender, Xamarin.Forms.ItemTappedEventArgs e)
{
ExerciseList item = (ExerciseList)((ListView)sender).SelectedItem;
((ListView)sender).SelectedItem = null;
Navigation.PushAsync(new ViewSetsPage(item));
//Navigation.RemovePage(this);
}
public IActionResult AddExercise(int SheetId, int ExerciseId, int StudentId)
{
ExerciseList obj = new ExerciseList()
{
ExerciseId = ExerciseId, SheetId = SheetId
};
return(View(obj));
}
void AddSet(object sender, System.EventArgs e)
{
ExerciseList exercise = new ExerciseList()
{
Id = ExerciseId
};
Navigation.PushAsync(new AddSetPage(exercise));
Navigation.RemovePage(this);
}
private void LoadWorkoutExercise(WorkoutExercise workoutExercise)
{
WorkoutExerciseAdd = workoutExercise;
OnPropertyChanged("WorkoutExerciseAdd");
WorkoutAdd = WorkoutList.FirstOrDefault(p => p.Id == workoutExercise.WorkoutId);
OnPropertyChanged("WorkoutAdd");
ExerciseAdd = ExerciseList.FirstOrDefault(p => p.Id == workoutExercise.ExerciseId);
OnPropertyChanged("ExerciseAdd");
}
/// <summary>
/// Prepare for valuation anything that is not dependent upon the scenario.
/// </summary>
public override void PreCloneInitialize(PriceFactorList factors, BaseTimeGrid baseTimes, RequiredResults ResultsRequired)
{
base.PreCloneInitialize(factors, baseTimes, ResultsRequired);
fItems.PreCloneInitialize(factors, baseTimes, ResultsRequired);
CallableStructuredDeal deal = (CallableStructuredDeal)fDeal;
// Create a list of sorted exercise items with exercise date >= baseDate and exercise date <= deal's end date.
fExercises = CreateExerciseList(factors.BaseDate, deal.EndDate(), deal.Exercise_Dates, deal.Principal);
AddDatesToValuationGrid(factors.BaseDate, ResultsRequired.CashRequired());
}
protected override async void OnAppearing()
{
List <ExerciseList> ListOfExercises = new List <ExerciseList>();
var exercises = await Exercise.GetAllExercise(_connection);
var exercisesForWorkout = new List <Exercise>();
foreach (var e in exercises)
{
if (e.WorkoutId == WorkoutId)
{
exercisesForWorkout.Add(e);
}
}
//var exerciseGroup3 = await _connection.Table<ExerciseGroup>().ToListAsync();
//var exerciseGroupCount = exerciseGroup3.Count;
var exerciseName2 = await ExerciseName.GetAllExerciseNameRecords(_connection);
var exerciseNameCount = exerciseName2.Count;
int exerciseNumber = 1;
foreach (var e in exercisesForWorkout)
{
var exerciseName = await ExerciseName.GetAllExerciseNameRecordsById(_connection, e.ExerciseNameId);
var sets = await _connection.Table <Models.Persistence.Set>()
.Where(w => w.ExerciseId == e.Id).ToListAsync();
ExerciseList exerciseFromSqLite = new ExerciseList();
exerciseFromSqLite.Id = e.Id;
exerciseFromSqLite.WorkoutId = e.WorkoutId;
exerciseFromSqLite.Exercise = exerciseName[0].ExerciseNameString;
exerciseFromSqLite.MuscleGroup = exerciseName[0].ExerciseMuscleGroup;
exerciseFromSqLite.Sets = sets.Count.ToString();
exerciseFromSqLite.FrontEndExerciseString = exerciseNumber.ToString() + "- " + exerciseName[0].ExerciseNameString;
ListOfExercises.Add(exerciseFromSqLite);
exerciseNumber++;
}
ListViewExercises.ItemsSource = ListOfExercises;
}
void exerciseTableDelegate_ExerciseDeleted(object sender, int exerciseIndex)
{
Data.DeleteExerciseBlock(_exercises[exerciseIndex].Id);
_exercises = Data.GetExerciseBlocks();
ServiceManager.RestartNotificationServiceIfNeeded();
InvokeOnMainThread(() =>
{
_source.EnabledDisabledSwitchSelected -= EnableDisableExercise;
_source = new ExerciseListTableSource(_exercises);
_source.EnabledDisabledSwitchSelected += EnableDisableExercise;
ExerciseList.Source = _source;
ExerciseList.ReloadData();
ExerciseList.Delegate = _exerciseTableDelegate;
});
}
private void SaveExercise()
{
if (ExerciseAdd.Id == 0)
{
new ExerciseRepository().Save(ExerciseAdd);
ExerciseList.Add(ExerciseAdd);
}
else
{
new ExerciseRepository().Update(ExerciseAdd);
ExerciseList = new ObservableCollection <Exercise>(new ExerciseRepository().GetAll());
OnPropertyChanged("ExerciseList");
}
ExerciseAdd = new Exercise();
OnPropertyChanged("ExerciseAdd");
}
public bool SaveExerciseList(ExerciseList entity)
{
entity.UpdateDate = DateTime.Now;
entity.UpdateByPersonId = 1;
entity.IsDeleted = false;
if (entity.Id > 0)
{
SqlGynProvider.DeleteExerciseList(entity.UniqueId);
foreach (var item in entity.Exercises)
{
item.ExerciseListId = entity.Id;
item.UpdateDate = entity.UpdateDate;
item.CreateDate = item.UpdateDate;
item.UpdateByPersonId = entity.UpdateByPersonId;
item.IsDeleted = entity.IsDeleted;
item.UniqueId = Guid.NewGuid();
item.CreateByPersonId = item.UpdateByPersonId;
SqlGynProvider.InsertExercise(item);
}
SqlGynProvider.UpdateExerciseList(entity);
}
else
{
entity.CreateDate = entity.UpdateDate;
entity.CreateByPersonId = entity.UpdateByPersonId;
entity.UniqueId = Guid.NewGuid();
entity.Id = SqlGynProvider.InsertExerciseList(entity);
foreach (var item in entity.Exercises)
{
item.UpdateDate = entity.UpdateDate;
item.CreateDate = item.UpdateDate;
item.UpdateByPersonId = entity.UpdateByPersonId;
item.IsDeleted = entity.IsDeleted;
item.UniqueId = Guid.NewGuid();
item.CreateByPersonId = item.UpdateByPersonId;
item.ExerciseListId = entity.Id;
SqlGynProvider.InsertExercise(item);
}
}
return(true);
}
public async Task <IActionResult> AddExercise(ExerciseList obj, int StudentId)
{
if (await _exerciseListService.HasExerciseList(obj.SheetId, obj.ExerciseId))
{
TempData["erro"] = "O exercício já consta na ficha.";
return(RedirectToAction("List", "Exercises", new { SheetId = obj.SheetId }));
}
if (ModelState.IsValid)
{
TempData["confirm"] = "Exercício adicionado com sucesso.";
await _exerciseListService.InsertAsync(obj);
return(RedirectToAction("List", "Exercises", new { SheetId = obj.SheetId }));
}
TempData["erro"] = "Erro ao cadastrar.";
return(RedirectToAction("List", "Exercises", new { SheetId = obj.SheetId }));
}
private async Task StopDelete(ExerciseList item)
{
int workoutId = item.WorkoutId;
var workouts = await Models.Persistence.Workout.GetAllWorkoutRecordsById(_connection, workoutId);
if (workouts[0].Completed == true)
{
await DisplayAlert("Delete Exercise?", "This workout has been set as 'completed'. Please re-open this workout to edit or delete your exercises.", "Close");
}
else
{
var result = await DisplayAlert("Delete Exercise?", "All related sets will also be removed, are you sure you want to delete?", "Yes", "No");
if (result)
{
var exercises = await Exercise.GetAllExerciseRecordsById(_connection, item.Id);
List <int> exerciseInt = new List <int>();
foreach (var exercise in exercises)
{
exerciseInt.Add(exercise.Id);
}
foreach (var i in exerciseInt)
{
var sets = await Set.GetAllSetsByExerciseId(_connection, i);
foreach (var s in sets)
{
await _connection.DeleteAsync(s);
}
}
foreach (var exercise in exercises)
{
await _connection.DeleteAsync(exercise);
}
}
OnAppearing();
}
}
private async Task StopEdit(ExerciseList item)
{
int workoutId = item.WorkoutId;
var workouts = await Models.Persistence.Workout.GetAllWorkoutRecordsById(_connection, workoutId);
if (workouts[0].Completed == true)
{
await DisplayAlert("Edit Exercise?", "This workout has been set as 'completed'. Please re-open this workout to edit or delete your exercises.", "Close");
}
else
{
ExerciseList exercise = new ExerciseList()
{
Id = item.Id
};
await Navigation.PushAsync(new Views.Workout.EditExercisePage(exercise));
Navigation.RemovePage(this);
}
}
static void Main(string[] args)
{
ExerciseList ExerciseList = new ExerciseList();
Exercise Exercise1 = ExerciseList.createExercise("Dictionaries", "C#");
Exercise Exercise2 = ExerciseList.createExercise("Lists", "C#");
Exercise Exercise3 = ExerciseList.createExercise("Classes", "C#");
Exercise Exercise4 = ExerciseList.createExercise("Student Exercises", "C#");
CohortsList CohortList = new CohortsList();
Cohort Cohort28 = CohortList.createCohort("Full Stack", "C28");
Cohort Cohort29 = CohortList.createCohort("Full Stack", "C29");
Cohort Cohort30 = CohortList.createCohort("Full Stack", "C30");
Cohort Cohort31 = CohortList.createCohort("Full Stack", "C31");
InstructorList InstructorList = new InstructorList();
Instructor Instructor1 = InstructorList.createInstructor("Jisie", "David");
Instructor Instructor2 = InstructorList.createInstructor("Andy", "Collins");
Instructor Instructor3 = InstructorList.createInstructor("Kristin", "Norris");
Instructor Instructor4 = InstructorList.createInstructor("Leah", "Hoefling");
Instructor1.setSpecialty("Being blunt.");
Instructor2.setSpecialty("Unknown.");
Instructor3.setSpecialty("Snacks.");
Instructor4.setSpecialty("Illustration.");
Instructor1.SlackHandle = "@jisie";
Instructor2.SlackHandle = "@andy";
Instructor3.SlackHandle = "@kristin";
Instructor4.SlackHandle = "@leah";
foreach (Instructor Instructor in InstructorList.getAll())
{
Cohort31.Assign(Instructor);
}
StudentList StudentList = new StudentList();
Student Student1 = StudentList.createStudent("Anne", "Vick");
Student Student2 = StudentList.createStudent("Jameka", "Echols");
Student Student3 = StudentList.createStudent("Chris", "Morgan");
Student Student4 = StudentList.createStudent("Meag", "Mueller");
Student1.SlackHandle = "@anne";
Student2.SlackHandle = "@jameka";
Student3.SlackHandle = "@chris";
Student4.SlackHandle = "@meag";
foreach (Student Student in StudentList.getAll())
{
Cohort31.Assign(Student);
}
foreach (Student Student in StudentList.getAll())
{
Instructor1.AssignExercise(Student, Exercise1);
Instructor2.AssignExercise(Student, Exercise2);
Instructor3.AssignExercise(Student, Exercise3);
Instructor4.AssignExercise(Student, Exercise4);
}
foreach (Cohort Cohort in CohortList.AllCohorts())
{
Console.WriteLine(Cohort.printInfo());
Console.WriteLine("-----------------");
}
Console.WriteLine("--------------------------");
Console.WriteLine("PART 2");
Console.WriteLine("--------------------------");
Cohort30.Assign(StudentList.createStudent("Larry", "Larryson"));
Cohort30.Assign(StudentList.createStudent("Kristen", "Kristinson"));
Cohort30.Assign(StudentList.createStudent("Loshanna", "Loshannason"));
Cohort30.Assign(StudentList.createStudent("Tre", "Treson"));
Cohort30.Assign(StudentList.createStudent("Overachieving", "Asshat"));
ExerciseList.createExercise("OverlyExcited", "Javascript");
ExerciseList.createExercise("SolarSystem", "Javascript");
ExerciseList.createExercise("CarLot", "Javascript");
ExerciseList.createExercise("DynamicCards", "Javascript");
Cohort30.Assign(InstructorList.createInstructor("Idont", "Remember"));
Cohort30.Assign(InstructorList.createInstructor("Who", "Taught"));
Cohort30.Assign(InstructorList.createInstructor("Cohort", "Thirty"));
//note to self: never do it like this again. Just wanted to see if I could keep it all straight in my head long enough to type out working code.
//for each student wher student cohort is cohort 30, iterate through a list of exercies that are of the javascript langauge and assign those to the student.
StudentList.getAll().Where(student => student.Cohort() == Cohort30.Name()).ToList().ForEach(student => ExerciseList.getAll().Where(exercise => exercise.Language() == "Javascript").ToList().ForEach(exercise => student.Assign(exercise)));
Student Overachiever = StudentList.getAll().First(Student => Student.Name() == "Overachieving Asshat");
ExerciseList.getAll().Where(exercise => exercise.Language() == "C#").ToList().ForEach(exercise => Overachiever.Assign(exercise));
Cohort30.Assign(StudentList.createStudent("Lazy", "Asshole"));
Console.WriteLine("All javascript exercises");
//For all exercises where javascript is the language, write out the name of the exercise and its langauge.
ExerciseList.getAll().Where(exercise => exercise.Language() == "Javascript").ToList().ForEach(exercise => Console.WriteLine($"{exercise.Name()} is in {exercise.Language()}"));
Console.WriteLine("----------------------");
Console.WriteLine("All students in Cohort 30");
StudentList.getAll().Where(student => student.Cohort() == Cohort30.Name()).ToList().ForEach(student => Console.WriteLine($"{student.Name()} is in {student.Cohort()}"));
Console.WriteLine("----------------------");
Console.WriteLine("All Instructors in Cohort 30");
InstructorList.getAll().Where(instructor => instructor.Cohort() == Cohort30.Name()).ToList().ForEach(instructor => Console.WriteLine($"{instructor.Name()} is in {instructor.Cohort()}"));
Console.WriteLine("----------------------");
Console.WriteLine("All students sorted by LastName");
StudentList.getAll().OrderBy(student => student.LastName()).ToList().ForEach(student => Console.WriteLine($"{student.LastName()}, {student.FirstName()}"));
Console.WriteLine("----------------------");
Console.WriteLine("All students working on 0 exercises:");
StudentList.getAll().Where(student => student.ExerciseList().Count == 0).ToList().ForEach(student => Console.WriteLine(student.Name()));
Console.WriteLine("----------------------");
Console.WriteLine("The student working on the most exercises:");
int MaxExercises = StudentList.getAll().Select(student => student.ExerciseList().Count).Max();
Console.WriteLine(StudentList.getAll().First(student => student.ExerciseList().Count == MaxExercises).Name());
Console.WriteLine("----------------------");
Console.WriteLine("The number of students in each cohort:");
IEnumerable <EnrollmentReport> enrollmentReports = CohortList.AllCohorts().Select(cohort => new EnrollmentReport {
CohortName = cohort.Name(),
StudentCount = StudentList.getAll().Where(student => student.Cohort() == cohort.Name()).ToList().Count
});
foreach (EnrollmentReport report in enrollmentReports)
{
Console.WriteLine($"{report.CohortName} has {report.StudentCount} students.");
}
}
public override int InsertExerciseList(ExerciseList entity)
{
return(TccContext.Tcc.DB.Insert <ExerciseList>("ExerciseList", entity)
.AutoMap(x => x.Id)
.ExecuteReturnLastId <int>());
}
private void Save()
{
var workbook = workbookHandler.getWorkbook(CurrentlySelectedTrainingDay.Year);
if (SelectedTrainingDay != TrainingDays[TrainingDays.Count() - 1])
{
MessageBoxResult result = MessageBox.Show("Do you want to update this training session?", "Update", MessageBoxButton.YesNo);
if (result == MessageBoxResult.No)
{
return;
}
TrainingDataMapper.UpdateTraining(new TrainingModel(CurrentlySelectedTrainingDay, ExerciseList.ToList()), SelectedTrainingYear, SelectedTrainingMonth, TrainingPositionInMonth + 1, folderPath, "kk");
MessageBox.Show("A training has been updated");
}
else
{
MessageBoxResult result = MessageBox.Show("Do you want to create new training session?", "Create", MessageBoxButton.YesNo);
if (result == MessageBoxResult.No)
{
return;
}
TrainingDataMapper.AddTraining(new TrainingModel(CurrentlySelectedTrainingDay, ExerciseList.ToList()), workbook);
TrainingYears = TrainingDataMapper.GetTrainingYears(folderPath, "kk");
MessageBox.Show("A new training has been saved");
workbook.Save();
}
}
//
// This method is invoked when the application has loaded and is ready to run. In this
// method you should instantiate the window, load the UI into it and then make the window
// visible.
//
// You have 17 seconds to return from this method, or iOS will terminate your application.
//
public override bool FinishedLaunching(UIApplication app, NSDictionary options)
{
// create a new window instance based on the screen size
window = new UIWindow (UIScreen.MainScreen.Bounds);
// If you have defined a view, add it here:
// window.AddSubview (navigationController.View);
rootElement = new RootElement ("1RM Log") { new Section () };
rootVC = new DialogViewController (rootElement);
navigation = new UINavigationController (rootVC);
exercises = new ExerciseList ();
// Test exercises;
Exercise bp = new Exercise ();
bp.Name = "bench press";
bp.LogRM(DateTime.Now, 150.3);
bp.LogRM(DateTime.Now, 120.1);
exercises.AddLast (bp);
Exercise sq = new Exercise ();
sq.Name = "squat";
exercises.AddLast (sq);
// add the existing list to the screen
foreach (Exercise exer in exercises) {
var localExer = exer;
StyledStringElement newExercise = new StyledStringElement (localExer.Name, () => {
ExerciseLog (localExer); });
newExercise.Accessory = UITableViewCellAccessory.DisclosureIndicator;
rootElement [0].Add (newExercise);
}
// Add new Exercises to the Log
addbutton = new UIBarButtonItem (UIBarButtonSystemItem.Add);
rootVC.NavigationItem.RightBarButtonItem = addbutton;
int i = 0;
addbutton.Clicked += (sender, e) => {
++i;
Exercise newExerciseToAdd = new Exercise ();
newExerciseToAdd.Name = "new exercise " + i.ToString();
// Add element
StyledStringElement newExercise = new StyledStringElement (newExerciseToAdd.Name, () => {
ExerciseLog (newExerciseToAdd); });
newExercise.Accessory = UITableViewCellAccessory.DisclosureIndicator;
rootElement [0].Add (newExercise);
exercises.AddLast (newExerciseToAdd);
};
// make the window visible
window.RootViewController = navigation;
window.MakeKeyAndVisible ();
return true;
}
private void DeleteExercise(Exercise exercise)
{
new ExerciseRepository().Delete(exercise);
ExerciseList.Remove(exercise);
}
public virtual int UpdateExerciseList(ExerciseList entity)
{
throw new NotImplementedException();
}
public void AddNewExercise(Exercise exercise)
{
ExerciseList.Add(exercise);
TotalWeight += exercise.TotalWeight;
}
