// ---------------------------------------------------------
// COACHMAIN: Method adds WOD to athlete to certain date
// ---------------------------------------------------------
public static void AddWodToAthlete(int WodId, int athleteId, DateTime dateTime, string movement, int reps, int rounds, string comment, int level)
{
using (var ctx = new WODCoachEntities())
{
// if value sent in property wodId is 0 it means nothing was selected from datagrid
if (WodId == 0) // insert
{
Wod wod = new Wod();
wod.movementName = movement;
wod.date = dateTime;
wod.idAthlete = athleteId;
wod.repsCount = reps;
wod.roundCount = rounds;
wod.comment = comment;
wod.level = level;
wod.done = false;
ctx.Wod.Add(wod);
}
else // if value sent with wodId is not 0 then search for Wod with Id
{
Wod wod = ctx.Wod.First(i => i.idWod == WodId);
wod.movementName = movement;
wod.date = dateTime;
wod.idAthlete = athleteId;
wod.repsCount = reps;
wod.roundCount = rounds;
wod.comment = comment;
wod.level = level;
}
ctx.SaveChanges();
}
}
// ---------------------------------------------------------
// ATHLETEMAIN: Saves the state of wod (movement), done (true) or not done (false).
// ---------------------------------------------------------
public static void SaveDoneWod(Wod selectedWod)
{
using (var ctx = new WODCoachEntities())
{
Wod wod = ctx.Wod.First(i => i.idWod == selectedWod.idWod);
wod.done = selectedWod.done;
ctx.SaveChanges();
}
}
// ---------------------------------------------------------
// ADMIN: DELETE Athlete
// ---------------------------------------------------------
public static void DeleteAthlete(Athlete selectedAthlete)
{
using (var ctx = new WODCoachEntities())
{
Athlete athlete1 = ctx.Athlete.First(i => i.idAthlete == selectedAthlete.idAthlete);
ctx.Athlete.Remove(athlete1);
ctx.SaveChanges();
}
}
// ---------------------------------------------------------
// COACHMAIN: Removes connection from between a wod (movement) and athlete. Nothing is deleted. Used in CoachMain.
// ---------------------------------------------------------
public static void RemoveWodFromAthlete(int wodId, int athlete_id)
{
using (var ctx = new WODCoachEntities())
{
Wod wod = ctx.Wod.First(i => i.idWod == wodId);
wod.idAthlete = null;
wod.repsCount = 0;
wod.roundCount = 0;
ctx.SaveChanges();
}
}
// ---------------------------------------------------------
// ATHLETEMAIN: Adds new or updates Rate for wod (movement)
// ---------------------------------------------------------
public static void SaveRating(int number, int wodId, int athleteId, float rating, string comment)
{
using (var ctx = new WODCoachEntities())
{
if (number == 0)
{
Rate rate = new Rate();
rate.athlete_id = athleteId;
rate.wod_id = wodId;
rate.rating = rating;
rate.comment = comment;
ctx.Rate.Add(rate);
ctx.SaveChanges();
}
else
{
Rate rate = ctx.Rate.First(i => i.wod_id == wodId);
rate.rating = rating;
rate.comment = comment;
ctx.SaveChanges();
}
}
}
// ---------------------------------------------------------
// MOVEMENTMAIN: Delete Wod (Movement) identified by wodId
// ---------------------------------------------------------
public static void DeleteWod(int wodId)
{
using (var ctx = new WODCoachEntities())
{
Wod wod = ctx.Wod.First(i => i.idWod == wodId);
if (wod.Rate.Count > 0)
{
Rate rate = ctx.Rate.First(i => i.wod_id == wodId);
ctx.Rate.Remove(rate);
}
ctx.Wod.Remove(wod);
ctx.SaveChanges();
}
}
// ---------------------------------------------------------
// MOVEMENTMAIN: Add or update Wods (movements)
// ---------------------------------------------------------
public static void SaveWod(int number, Wod selectedWod)
{
using (var ctx = new WODCoachEntities())
{
if (number == 0)
{
Wod wod = new Wod();
wod.movementName = selectedWod.movementName;
wod.level = selectedWod.level;
wod.done = false;
ctx.Wod.Add(wod);
ctx.SaveChanges();
}
else
{
Wod wod = ctx.Wod.First(i => i.idWod == number);
wod.movementName = selectedWod.movementName;
wod.level = selectedWod.level;
wod.done = selectedWod.done;
ctx.SaveChanges();
}
}
}
// ---------------------------------------------------------
// ADMIN: Add or update athlete information
// ---------------------------------------------------------
public static void SaveAthlete(int number, Athlete selectedAthlete)
{
using (var ctx = new WODCoachEntities())
{
if (number == 0)
{
Athlete athlete1 = new Athlete();
athlete1.fullname = selectedAthlete.fullname;
athlete1.telNumber = selectedAthlete.telNumber;
athlete1.Coach_idCoach = selectedAthlete.Coach_idCoach;
ctx.Athlete.Add(athlete1);
ctx.SaveChanges();
}
else
{
Athlete athlete1 = ctx.Athlete.First(i => i.idAthlete == number);
athlete1.fullname = selectedAthlete.fullname;
athlete1.telNumber = selectedAthlete.telNumber;
athlete1.Coach_idCoach = selectedAthlete.Coach_idCoach;
ctx.SaveChanges();
}
}
}
