public static void AddUsers()
{
using (var context = new Models.Lab4Context())
{
Models.User user1 = new Models.User();
user1.Firstname = "Josefine";
user1.Lastname = "Anerland";
Models.User user2 = new Models.User();
user2.Firstname = "Lukas";
user2.Lastname = "Lindahl";
Models.User user3 = new Models.User();
user3.Firstname = "Malin";
user3.Lastname = "Alm";
Models.User user4 = new Models.User();
user4.Firstname = "Robert";
user4.Lastname = "Alm";
context.Add(user1);
context.Add(user2);
context.Add(user3);
context.Add(user4);
context.SaveChanges();
}
}
public static void AddEquipment()
{
using (var context = new Models.Lab4Context())
{
Models.Equipment eq1 = new Models.Equipment();
eq1.Name = "Cykel";
Models.Equipment eq2 = new Models.Equipment();
eq2.Name = "Löpband";
Models.Equipment eq3 = new Models.Equipment();
eq3.Name = "Roddmaskin";
Models.Equipment eq4 = new Models.Equipment();
eq4.Name = "Trappmaskin";
Models.Equipment eq5 = new Models.Equipment();
eq5.Name = "Crosstrainer";
Models.Equipment eq6 = new Models.Equipment();
eq6.Name = "Bänkpress";
context.Add(eq1);
context.Add(eq2);
context.Add(eq3);
context.Add(eq4);
context.Add(eq5);
context.Add(eq6);
context.SaveChanges();
}
}
public static void AddExercises()
{
using (var context = new Models.Lab4Context())
{
Models.Exercise ex1 = new Models.Exercise();
ex1.Name = "Cykling";
Models.Exercise ex2 = new Models.Exercise();
ex2.Name = "Löpning";
Models.Exercise ex3 = new Models.Exercise();
ex3.Name = "Rodd";
Models.Exercise ex4 = new Models.Exercise();
ex4.Name = "Trappa";
Models.Exercise ex5 = new Models.Exercise();
ex5.Name = "Crosstrainer";
Models.Exercise ex6 = new Models.Exercise();
ex6.Name = "Bänkpress";
context.Add(ex1);
context.Add(ex2);
context.Add(ex3);
context.Add(ex4);
context.Add(ex5);
context.Add(ex6);
context.SaveChanges();
}
}
public static void AddWorkouts()
{
using (var context = new Models.Lab4Context())
{
Models.Workout w1 = new Models.Workout();
w1.UserId = 1;
w1.Name = "Cykling 2019-10-10";
w1.Description = "5km cykling";
w1.Time = TimeSpan.FromMinutes(20);
w1.Type = "Kondition";
Models.Workout w2 = new Models.Workout();
w2.UserId = 2;
w2.Name = "Löpning 2019-10-12";
w2.Description = "Löpträning på löpband";
w2.Time = TimeSpan.FromMinutes(60);
w2.Type = "Kondition";
Models.Workout w3 = new Models.Workout();
w3.UserId = 3;
w3.Name = "Rodd och styrketräning 2019-10-14";
w3.Description = "Roddmaskin och styrketräning ben och rumpa";
w3.Time = TimeSpan.FromMinutes(100);
w3.Type = "Styrketräning";
Models.Workout w4 = new Models.Workout();
w4.UserId = 4;
w4.Name = "Trappmaskin, crosstrainer och styrketräning 2019-10-16";
w4.Description = "Trappmaskin, crosstraining och styrketräning armar";
w4.Time = TimeSpan.FromMinutes(15);
w4.Type = "Kondition";
Models.Workout w5 = new Models.Workout();
w5.UserId = 1;
w5.Name = "Crosstrainer 2019-10-16";
w5.Description = "Crosstraining";
w5.Time = TimeSpan.FromMinutes(40);
w5.Type = "Kondition";
Models.Workout w6 = new Models.Workout();
w6.UserId = 2;
w6.Name = "Styrketräning och rodd 2019-10-18";
w6.Description = "Armar och mage samt rodd";
w6.Time = TimeSpan.FromMinutes(90);
w6.Type = "Styrketräning";
Models.Workout w7 = new Models.Workout();
w7.UserId = 3;
w7.Name = "Löpning 2019-10-20";
w7.Description = "Löpning på band";
w7.Time = TimeSpan.FromMinutes(50);
w7.Type = "Kondition";
Models.Workout w8 = new Models.Workout();
w8.UserId = 4;
w8.Name = "Cykling 2019-10-22";
w8.Description = "Cyklade 10km";
w8.Time = TimeSpan.FromMinutes(50);
w8.Type = "Kondition";
Models.Workout w9 = new Models.Workout();
w9.UserId = 1;
w9.Name = "Löpning 2019-10-24";
w9.Description = "Löpning på löpband";
w9.Time = TimeSpan.FromMinutes(30);
w9.Type = "Kondition";
Models.Workout w10 = new Models.Workout();
w10.UserId = 2;
w10.Name = "Rodd 2019-11-01";
w10.Description = "Roddmaskin";
w10.Time = TimeSpan.FromMinutes(35);
w10.Type = "Kondition";
Models.Workout w11 = new Models.Workout();
w11.UserId = 3;
w11.Name = "Crosstrainer 2019-11-04";
w11.Description = "Crosstraining";
w11.Time = TimeSpan.FromMinutes(40);
w11.Type = "Kondition";
Models.Workout w12 = new Models.Workout();
w12.UserId = 4;
w12.Name = "Löpning och cykkling 2019-11-05";
w12.Description = "Sprang på löpband och cyklade";
w12.Time = TimeSpan.FromMinutes(60);
w12.Type = "Kondition";
context.Add(w1);
context.Add(w2);
context.Add(w3);
context.Add(w4);
context.Add(w5);
context.Add(w6);
context.Add(w7);
context.Add(w8);
context.Add(w9);
context.Add(w10);
context.Add(w11);
context.Add(w12);
context.SaveChanges();
}
}
public static void AddWorkoutExercise()
{
using (var context = new Models.Lab4Context())
{
Models.WorkoutExercise we1 = new Models.WorkoutExercise();
we1.WorkoutId = 1;
we1.ExerciseId = 1;
we1.Strain = 6;
Models.WorkoutExercise we2 = new Models.WorkoutExercise();
we2.WorkoutId = 2;
we2.ExerciseId = 2;
we2.Strain = 9;
Models.WorkoutExercise we3 = new Models.WorkoutExercise();
we3.WorkoutId = 3;
we3.ExerciseId = 3;
we3.Reps = 40;
Models.WorkoutExercise we4 = new Models.WorkoutExercise();
we4.WorkoutId = 4;
we4.ExerciseId = 3;
Models.WorkoutExercise we5 = new Models.WorkoutExercise();
we5.WorkoutId = 4;
we5.ExerciseId = 4;
we5.Reps = 30;
Models.WorkoutExercise we6 = new Models.WorkoutExercise();
we6.WorkoutId = 5;
we6.ExerciseId = 5;
we6.Strain = 8;
Models.WorkoutExercise we7 = new Models.WorkoutExercise();
we7.WorkoutId = 6;
we7.ExerciseId = 3;
we7.Strain = 4;
Models.WorkoutExercise we8 = new Models.WorkoutExercise();
we8.WorkoutId = 6;
we8.ExerciseId = 4;
we8.Reps = 40;
Models.WorkoutExercise we9 = new Models.WorkoutExercise();
we9.WorkoutId = 7;
we9.ExerciseId = 2;
we9.Strain = 9;
Models.WorkoutExercise we10 = new Models.WorkoutExercise();
we10.WorkoutId = 8;
we10.ExerciseId = 1;
Models.WorkoutExercise we11 = new Models.WorkoutExercise();
we11.WorkoutId = 9;
we11.ExerciseId = 2;
Models.WorkoutExercise we12 = new Models.WorkoutExercise();
we12.WorkoutId = 10;
we12.ExerciseId = 3;
we12.Reps = 30;
we12.Strain = 10;
Models.WorkoutExercise we13 = new Models.WorkoutExercise();
we13.WorkoutId = 11;
we13.ExerciseId = 5;
Models.WorkoutExercise we14 = new Models.WorkoutExercise();
we14.WorkoutId = 12;
we14.ExerciseId = 2;
Models.WorkoutExercise we15 = new Models.WorkoutExercise();
we15.WorkoutId = 12;
we15.ExerciseId = 5;
context.Add(we1);
context.Add(we2);
context.Add(we3);
context.Add(we4);
context.Add(we5);
context.Add(we6);
context.Add(we7);
context.Add(we8);
context.Add(we9);
context.Add(we10);
context.Add(we12);
context.Add(we12);
context.Add(we13);
context.Add(we14);
context.Add(we15);
context.SaveChanges();
}
}
public static void AddWorkoutEquipment()
{
using (var context = new Models.Lab4Context())
{
Models.WorkoutEquipment we1 = new Models.WorkoutEquipment();
we1.WorkoutId = 1;
we1.EquipmentId = 1;
Models.WorkoutEquipment we2 = new Models.WorkoutEquipment();
we2.WorkoutId = 2;
we2.EquipmentId = 2;
Models.WorkoutEquipment we3 = new Models.WorkoutEquipment();
we3.WorkoutId = 3;
we3.EquipmentId = 3;
Models.WorkoutEquipment we4 = new Models.WorkoutEquipment();
we4.WorkoutId = 4;
we4.EquipmentId = 3;
Models.WorkoutEquipment we5 = new Models.WorkoutEquipment();
we5.WorkoutId = 4;
we5.EquipmentId = 4;
Models.WorkoutEquipment we6 = new Models.WorkoutEquipment();
we6.WorkoutId = 5;
we6.EquipmentId = 5;
Models.WorkoutEquipment we7 = new Models.WorkoutEquipment();
we7.WorkoutId = 6;
we7.EquipmentId = 3;
Models.WorkoutEquipment we8 = new Models.WorkoutEquipment();
we8.WorkoutId = 7;
we8.EquipmentId = 2;
Models.WorkoutEquipment we9 = new Models.WorkoutEquipment();
we9.WorkoutId = 8;
we9.EquipmentId = 1;
Models.WorkoutEquipment we10 = new Models.WorkoutEquipment();
we10.WorkoutId = 9;
we10.EquipmentId = 2;
Models.WorkoutEquipment we11 = new Models.WorkoutEquipment();
we11.WorkoutId = 10;
we11.EquipmentId = 3;
Models.WorkoutEquipment we12 = new Models.WorkoutEquipment();
we12.WorkoutId = 11;
we12.EquipmentId = 5;
Models.WorkoutEquipment we13 = new Models.WorkoutEquipment();
we13.WorkoutId = 12;
we13.EquipmentId = 2;
Models.WorkoutEquipment we14 = new Models.WorkoutEquipment();
we14.WorkoutId = 12;
we14.EquipmentId = 1;
context.Add(we1);
context.Add(we2);
context.Add(we3);
context.Add(we4);
context.Add(we5);
context.Add(we6);
context.Add(we7);
context.Add(we8);
context.Add(we9);
context.Add(we10);
context.Add(we11);
context.Add(we12);
context.Add(we13);
context.Add(we14);
context.SaveChanges();
}
}
