Example #1
0
 public int SaveItem(ExercisesTimeTable item)
 {
     if (item.ID != 0)
     {
         database.Update(item);
         return(item.ID);
     }
     else
     {
         count++;
         return(database.Insert(item));
     }
 }
Example #2
0
        private StackLayout AddStatisticByExercise(MainTable mainTable)
        {
            int    progress = 0;
            double percent  = 0.0;

            if (mainTable.Type == (byte)App.TypeExercises.Count)
            {
                ExercisesCountTableRepository exercisesCountTableRepository = new ExercisesCountTableRepository(Path.Combine(DBSaverLoader.documentsPath, mainTable.StringID + ".db"));
                int exercisesTableLength = exercisesCountTableRepository.Count;
                if (exercisesTableLength == 0)
                {
                    return(AddStatisticFromScreen(mainTable.Name, mainTable.ID, 0, 0.0, "count.jpg"));
                }
                ExercisesCountTable lastItem = exercisesCountTableRepository.GetItem(exercisesCountTableRepository.StartPosition + exercisesTableLength - 1);
                double purpose = double.Parse(mainTable.Purpose);
                if (exercisesTableLength >= 2)
                {
                    ExercisesCountTable penultItem = exercisesCountTableRepository.GetItem(exercisesCountTableRepository.StartPosition + exercisesTableLength - 2);
                    progress = lastItem.Count - penultItem.Count;
                    percent  = (double)lastItem.Count / purpose * 100.0;
                }
                if (exercisesTableLength == 1)
                {
                    percent = (double)lastItem.Count / purpose * 100.0;
                }
            }
            else if (mainTable.Type == (byte)App.TypeExercises.Approach)
            {
                ExercisesApproachTableRepository exercisesApproachTableRepository = new ExercisesApproachTableRepository(Path.Combine(DBSaverLoader.documentsPath, mainTable.StringID + ".db"));
                int exercisesTableLength = exercisesApproachTableRepository.Count;
                if (exercisesTableLength == 0)
                {
                    return(AddStatisticFromScreen(mainTable.Name, mainTable.ID, 0, 0.0, "approach.jpg"));
                }
                int lastItem = (from item in exercisesApproachTableRepository.GetItem(exercisesApproachTableRepository.StartPosition + exercisesTableLength - 1).Count.Split('/')
                                select int.Parse(item)).Sum();
                double purpose = (from item in mainTable.Purpose.Split('/') select double.Parse(item)).Sum();
                if (exercisesTableLength >= 2)
                {
                    int penultItem = (from item in exercisesApproachTableRepository.GetItem(exercisesApproachTableRepository.StartPosition + exercisesTableLength - 2).Count.Split('/')
                                      select int.Parse(item)).Sum();
                    progress = lastItem - penultItem;
                    percent  = (double)lastItem / purpose * 100.0;
                }
                if (exercisesTableLength == 1)
                {
                    percent = (double)lastItem / purpose * 100.0;
                }
            }
            else if (mainTable.Type == (byte)App.TypeExercises.Time)
            {
                ExercisesTimeTableRepository exercisesTimeTableRepository = new ExercisesTimeTableRepository(Path.Combine(DBSaverLoader.documentsPath, mainTable.StringID + ".db"));
                int      exercisesTableLength = exercisesTimeTableRepository.Count;
                TimeSpan progressTime         = new TimeSpan(0, 0, 0);
                if (exercisesTableLength == 0)
                {
                    return(AddStatisticFromScreen(mainTable.Name, mainTable.ID, 0, 0.0, "timer.jpg"));
                }
                ExercisesTimeTable lastItem = exercisesTimeTableRepository.GetItem(exercisesTimeTableRepository.StartPosition + exercisesTableLength - 1);
                double             purpose  = double.Parse(mainTable.Purpose);
                if (exercisesTableLength >= 2)
                {
                    ExercisesTimeTable penultItem = exercisesTimeTableRepository.GetItem(exercisesTimeTableRepository.StartPosition + exercisesTableLength - 2);
                    progressTime = lastItem.Count - penultItem.Count;
                    percent      = (double)lastItem.Count.TotalSeconds / purpose * 100.0;
                }
                if (exercisesTableLength == 1)
                {
                    percent = (double)lastItem.Count.TotalSeconds / purpose * 100.0;
                }
                return(AddStatisticFromScreen(mainTable.Name, mainTable.ID, (int)progressTime.TotalSeconds, percent, "timer.jpg", true));
            }
            string photo = "";

            if (mainTable.Type == (byte)App.TypeExercises.Time)
            {
                photo = "timer.jpg";
            }
            if (mainTable.Type == (byte)App.TypeExercises.Approach)
            {
                photo = "approach.jpg";
            }
            if (mainTable.Type == (byte)App.TypeExercises.Count)
            {
                photo = "count.jpg";
            }
            return(AddStatisticFromScreen(mainTable.Name, mainTable.ID, progress, percent, photo));
        }