public void RemoveUser()
{
using (var db = new GymTrackerContext())
{
db.Users.Remove(SelectedUser);
db.SaveChanges();
SelectedUser = null;
SelectedSession = null;
SelectedExercise = null;
SelectedMuscleGroup = null;
SelectedSet = null;
}
}
public void AddExercise(string name)
{
using (var db = new GymTrackerContext())
{
var newExersice = new Exercise()
{
ExerciseName = name,
MuscleGroupId = SelectedMuscleGroup.MuscleGroupId
};
db.Exercises.Add(newExersice);
db.SaveChanges();
}
}
public void AddandSelectUser(string name)
{
using (var db = new GymTrackerContext())
{
var newUser = new User()
{
UserName = name
};
db.Users.Add(newUser);
db.SaveChanges();
SelectedUser = newUser;
}
}
public void RemoveSet()
{
using (var db = new GymTrackerContext())
{
db.Sets.Remove(SelectedSet);
db.SaveChanges();
var allinSession = ReadSessionSets();
foreach (var item in allinSession)
{
SelectedSet = item;
UpdateSets(item.NumberofReps, item.Weight);
}
}
}
public void AddSession(string date)
{
using (var db = new GymTrackerContext())
{
var newSession = new Session()
{
UserId = SelectedUser.UserId,
ExerciseId = SelectedExercise.ExerciseId,
SessionDate = date
};
db.Sessions.Add(newSession);
db.SaveChanges();
}
}
public void AddandSelectExerciseTest()
{
using (var db = new GymTrackerContext())
{
var selMusGro = db.MuscleGroups.Where(c => c.MuscleGroupId == 1).FirstOrDefault();
crudManager.SelectMuscleGroup(selMusGro);
var beforeNumberOfExercises = db.Exercises.ToList().Count();
crudManager.AddandSelectExercise("Jumping");
var afterNumberOfExercises = db.Exercises.ToList().Count();
Assert.AreEqual(crudManager.SelectedExercise.ExerciseName, "Jumping");
Assert.AreEqual(beforeNumberOfExercises + 1, afterNumberOfExercises);
}
}
public List <Session> ReadUserSessions()
{
using (var db = new GymTrackerContext())
{
var allsessions = db.Sessions.ToList();
List <Session> userSessions = new List <Session>();
foreach (var item in allsessions)
{
if (item.UserId == SelectedUser.UserId)
{
userSessions.Add(item);
}
}
return(userSessions);
}
}
public void TearDown()
{
using (var db = new GymTrackerContext())
{
var selectedCustomer =
from c in db.Users
where c.UserName == "Test-Vinay"
select c;
foreach (var c in selectedCustomer)
{
db.Users.Remove(c);
}
db.SaveChanges();
}
}
public List <Session> SWOverview(int userid, int fake)
{
using (var db = new GymTrackerContext())
{
List <Session> allSessions = new List <Session>();
List <Session> userSessions = new List <Session>();
allSessions = db.Sessions.ToList();
foreach (var item in allSessions)
{
if (item.UserId == userid)
{
userSessions.Add(item);
}
}
return(userSessions);
}
}
public List <Exercise> ReadExercise(int userid)
{
using (var db = new GymTrackerContext())
{
List <Session> allSessions = new List <Session>();
allSessions = db.Sessions.ToList();
List <Exercise> allExercise = new List <Exercise>();
allExercise = db.Exercises.ToList();
List <Exercise> userExercise = new List <Exercise>();
foreach (var session in allSessions)
{
bool addTo = true;
if (session.UserId == userid)
{
foreach (var exercise in allExercise)
{
if (exercise.ExerciseId == session.ExerciseId)
{
if (userExercise.Count() > 0) //minimse
{
foreach (var rep in userExercise)
{
if (rep == exercise)
{
addTo = false;
break;
}
}
}
if (addTo == true)
{
userExercise.Add(exercise);
}
}
}
}
}
return(userExercise);
}
}
public List <Set> ReadSessionSets()
{
using (var db = new GymTrackerContext())
{
List <Set> allSets = db.Sets.ToList();
List <Set> sessionSets = new List <Set>();
if (SelectedSession != null)
{
foreach (var item in allSets)
{
if (item.SessionId == SelectedSession.SessionId)
{
sessionSets.Add(item);
}
}
}
return(sessionSets);
}
}
public void ReadUserSessionsTest()
{
using (var db = new GymTrackerContext())
{
var allSessions = db.Users.ToList();
var numberOfUserSessions = 0;
foreach (var item in allSessions)
{
if (item.UserId == crudManager.SelectedUser.UserId)
{
numberOfUserSessions++;
}
}
var resultFromMethod = crudManager.ReadUserSessions().Count();
Assert.IsTrue(crudManager.SelectedSession != null);
Assert.AreEqual(numberOfUserSessions, resultFromMethod);
}
}
public void Setup()
{
using (var db = new GymTrackerContext())
{
var selectedCustomer =
from c in db.Users
where c.UserName == "Test-Vinay"
select c;
foreach (var c in selectedCustomer)
{
db.Users.Remove(c);
}
db.SaveChanges();
crudManager.AddandSelectUser("Test-Vinay");
var selEx = db.Exercises.Where(e => e.ExerciseId == 1).FirstOrDefault();
crudManager.SelectExercise(selEx);
crudManager.AddandSelectSession("12-12-12"); //autoremoved when user removed
}
}
public void UpdateSets(int numofreps, int weight)
{
using (var db = new GymTrackerContext())
{
var SetWhy = db.Sets.Where(c => c.SetId == SelectedSet.SetId).FirstOrDefault();
var allSessionSets = ReadSessionSets();
int renumber = 1;
foreach (var item in allSessionSets)
{
if (item.SetId == SetWhy.SetId)
{
break;
}
renumber++;
}
SetWhy.SetNumber = renumber;
SetWhy.NumberofReps = numofreps;
SetWhy.Weight = weight;
db.SaveChanges();
}
}
public void TearDown()
{
using (var db = new GymTrackerContext())
{
var selectedCustomer =
from c in db.Users
where c.UserName == "Test-Vinay"
select c;
foreach (var c in selectedCustomer)
{
db.Users.Remove(c);
}
db.SaveChanges();
//var exercise = db.Exercises.Where(e => e.ExerciseName == "Jumping");
//crudManager.SelectExercise(exercise);
//crudManager.RemoveExercise();
}
}
public DailyRoutineRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}
public TraineeRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}
public ExerciseRepository(GymTrackerContext context)
{
this.context = context;
}
//////////////////////////////////////////////////////////////////////////////////////
public (List <string>, List <int>, List <string>) SWOverview(int userid)
{
using (var db = new GymTrackerContext())
{
List <string> dates = new List <string>();
List <int> totalExersices = new List <int>();
List <string> ratios = new List <string>();
var allSessions =
from s in db.Sessions
join e in db.Exercises on s.ExerciseId equals e.ExerciseId
where s.UserId == userid
select new { s.SessionDate, e.MuscleGroupId };
//int countChest = 0;
//int countShoulders = 0;
//int countBack= 0;
//int countArms = 0;
//int countLegs = 0; //for future feature - hopefully not
foreach (var item in allSessions)
{
if (dates.Count() > 0)
{
if (item.SessionDate == dates[dates.Count() - 1])
{
totalExersices[totalExersices.Count() - 1]++;
//ratios[ratios.Count() - 1] = ("1:1:0:0:0"); // for future feature
}
}
else
{
dates.Add(item.SessionDate);
totalExersices.Add(1);
/////na....
if (item.MuscleGroupId == 1)
{
ratios.Add("1:0:0:0:0"); // for future feature
}
else if (item.MuscleGroupId == 2)
{
{
ratios.Add("0:1:0:0:0"); // for future feature
}
}
else if (item.MuscleGroupId == 3)
{
{
ratios.Add("0:0:1:0:0"); // for future feature
}
}
else if (item.MuscleGroupId == 4)
{
{
ratios.Add("0:0:0:1:0"); // for future feature
}
}
else if (item.MuscleGroupId == 5)
{
{
ratios.Add("0:0:0:0:1"); // for future feature
}
}
////na....
}
}
return(dates, totalExersices, ratios);
}
}
public EventRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}
public ExerciseRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}
public TraineeMeasurementsRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}
public UserProfileRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}
public UserDetailsRepository(GymTrackerContext context)
{
this.context = context;
}
public DailyProgressRepository(GymTrackerContext aspnet_GymTrackerContext)
{
_aspnetGymTrackerContext = aspnet_GymTrackerContext;
}