Esempio n. 1
0
        public static void AddCars(Slot_Car_TournamentContext context)
        {
            var car1 = new Car {
                Name = "The Car", DriverName = "Marston", CarId = 1
            };

            context.Add(car1);

            var car2 = new Car {
                Name = "ProX", DriverName = "The Stig", CarId = 2
            };

            context.Add(car2);

            var car3 = new Car {
                Name = "The Best Car", DriverName = "Jeremy", CarId = 3
            };

            context.Add(car3);

            var car4 = new Car {
                Name = "The Car That Ran Out Of Names", DriverName = "Chris", CarId = 4
            };

            context.Add(car4);
        }
Esempio n. 2
0
        public static TrackInfo GetTrackInfo(int trackId)
        {
            using (Slot_Car_TournamentContext context = new Slot_Car_TournamentContext())
            {
                var track = context.Track.Find(trackId);

                var races = (from r in context.Race
                             where r.TrackId == track.TrackId
                             select r).ToList();

                var driver = (from d in context.CarInRace
                              where d.Race.Track == track && d.BestLap == track.BestTime
                              select d.Car).FirstOrDefault();

                var trackInfo = new TrackInfo();

                trackInfo.Id             = track.TrackId;
                trackInfo.Name           = track.Name;
                trackInfo.FastestLap     = TimeSpan.FromMilliseconds(track.BestTime);
                trackInfo.FastestsCar    = driver.Name;
                trackInfo.FastestsDriver = driver.DriverName;
                trackInfo.NumberOfRaces  = (int)races.Count();



                return(trackInfo);
            }
        }
Esempio n. 3
0
 public static void Main(string[] args)
 {
     using (var context = new Slot_Car_TournamentContext())
     {
         Seed(context);
         context.SaveChanges();
     }
 }
Esempio n. 4
0
        public static RaceInfo GetRaceInfo(int raceId)
        {
            using (Slot_Car_TournamentContext context = new Slot_Car_TournamentContext())
            {
                var race = context.Race.Find(raceId);

                var track = (from t in context.Track
                             where t.TrackId == race.TrackId
                             select t).FirstOrDefault();

                var cars = (from c in context.CarInRace
                            where c.RaceId == race.RaceId
                            select c).ToList();

                var carInfos = new List <CarInfo>();

                foreach (CarInRace cir in cars)
                {
                    var car = (from c in context.Car
                               where c.CarId == cir.CarId
                               select c).FirstOrDefault();

                    var carinfo = new CarInfo()
                    {
                        CarId                = cir.CarId,
                        CarName              = car.Name,
                        DriverName           = car.DriverName,
                        StartPosition        = cir.StartPosition,
                        EndPosition          = cir.EndPosition,
                        BestLapInTicks       = (long)cir.BestLap * 10000,
                        TotalRaceTimeInTicks = (long)cir.TotalRaceTime * 10000
                    };

                    carInfos.Add(carinfo);
                }

                var raceInfo = new RaceInfo();

                raceInfo.RaceId       = race.RaceId;
                raceInfo.TrackName    = track.Name;
                raceInfo.TrackId      = race.TrackId;
                raceInfo.PlannedStart = race.PlannedStartTime;
                raceInfo.PlannedEnd   = race.PlannedEndTime;
                raceInfo.NumberOfLaps = race.NumberOfLaps;
                raceInfo.ActualStart  = race.ActualStartTime;
                raceInfo.ActualEnd    = race.ActualEndTime;
                raceInfo.Cars         = carInfos;



                return(raceInfo);
            }
        }
Esempio n. 5
0
        public static void Seed(Slot_Car_TournamentContext context)
        {
            var cs = from c in context.Car
                     select c;

            if (cs.ToList().Count <= 0)     //Hack/cheat to check if things from Seed are already added to the database.
            {                               //This should be implemented better given more time...
                AddTracks(context);         //Maybe import libraries to implement "SetUp" and "TearDown" for testing
                AddRaces(context);          //So the everything is added before all tests, and then removed after.
                AddCars(context);
                AddCarsToRace(context);
            }
        }
Esempio n. 6
0
        public static void Clear(Slot_Car_TournamentContext context)
        {
            context.Database.ExecuteSqlCommand("DELETE * FROM CarInRace");
            context.SaveChanges();

            context.Database.ExecuteSqlCommand("DELETE * FROM Race");
            context.SaveChanges();

            context.Database.ExecuteSqlCommand("DELETE * FROM Cars");
            context.SaveChanges();

            context.Database.ExecuteSqlCommand("DELETE * FROM Track");
            context.SaveChanges();
        }
Esempio n. 7
0
        public static void AddRaces(Slot_Car_TournamentContext context)
        {
            var RaceIndianaOne = new Race
            {
                TrackId          = 1,
                RaceId           = 1,
                NumberOfLaps     = 100,
                PlannedStartTime = new DateTime(2017, 9, 21, 12, 0, 0),
                ActualStartTime  = new DateTime(2017, 9, 21, 12, 0, 0),
                PlannedEndTime   = new DateTime(2017, 9, 21, 13, 0, 0),
                ActualEndTime    = new DateTime(2017, 9, 21, 13, 30, 0)
            };

            context.Add(RaceIndianaOne);

            var RaceIndianaTwo = new Race
            {
                TrackId          = 1,
                RaceId           = 2,
                NumberOfLaps     = 150,
                PlannedStartTime = new DateTime(2017, 9, 22, 16, 0, 0),
                ActualStartTime  = new DateTime(2017, 9, 22, 16, 0, 0),
                PlannedEndTime   = new DateTime(2017, 9, 22, 17, 30, 0),
                ActualEndTime    = new DateTime(2017, 9, 22, 17, 30, 0)
            };

            context.Add(RaceIndianaTwo);

            var RaceMonacoOne = new Race
            {
                TrackId          = 2,
                RaceId           = 3,
                NumberOfLaps     = 80,
                PlannedStartTime = new DateTime(2017, 9, 22, 16, 0, 0),
                ActualStartTime  = new DateTime(2017, 9, 22, 16, 0, 0),
                PlannedEndTime   = new DateTime(2017, 9, 22, 18, 30, 0),
                ActualEndTime    = new DateTime(2017, 9, 22, 18, 34, 0)
            };

            context.Add(RaceMonacoOne);
        }
Esempio n. 8
0
        public static void AddTracks(Slot_Car_TournamentContext context)
        {
            var TrackIndiana = new Track
            {
                Name        = "Indianapolis Race Track",
                LengthMeter = 2782,
                BestTime    = 29871,
                MaxCars     = 40,
                TrackId     = 1
            };

            context.Add(TrackIndiana);

            var TrackMonaco = new Track
            {
                Name        = "Monaco Race Track",
                LengthMeter = 4929,
                BestTime    = 31928,
                MaxCars     = 26,
                TrackId     = 2
            };

            context.Add(TrackMonaco);
        }
Esempio n. 9
0
 public CarCRUD(Slot_Car_TournamentContext context)
 {
     _context = context;
 }
Esempio n. 10
0
        public static void AddCarsToRace(Slot_Car_TournamentContext context)
        {
            var carInRaceOne = new CarInRace
            {
                RaceId        = 1,
                CarId         = 1,
                BestLap       = 29867,
                EndPosition   = 2,
                StartPosition = 1,
                TotalRaceTime = 192835387
            };

            context.Add(carInRaceOne);

            var carInRaceTwo = new CarInRace
            {
                RaceId        = 1,
                CarId         = 2,
                BestLap       = 29871,
                EndPosition   = 1,
                StartPosition = 2,
                TotalRaceTime = 19255387
            };

            context.Add(carInRaceTwo);

            var carInRaceThree = new CarInRace
            {
                RaceId        = 2,
                CarId         = 2,
                BestLap       = 29999,
                EndPosition   = 2,
                StartPosition = 2,
                TotalRaceTime = 162435387
            };

            context.Add(carInRaceThree);

            var carInRaceFour = new CarInRace
            {
                RaceId        = 2,
                CarId         = 1,
                BestLap       = 26147,
                EndPosition   = 1,
                StartPosition = 1,
                TotalRaceTime = 192863524
            };

            context.Add(carInRaceFour);

            var carInRaceFive = new CarInRace
            {
                RaceId        = 3,
                CarId         = 3,
                BestLap       = 42315,
                EndPosition   = 2,
                StartPosition = 1,
                TotalRaceTime = 192888724
            };

            context.Add(carInRaceFive);

            var carInRaceSix = new CarInRace
            {
                RaceId        = 3,
                CarId         = 4,
                BestLap       = 31928,
                EndPosition   = 1,
                StartPosition = 2,
                TotalRaceTime = 192882924
            };

            context.Add(carInRaceSix);
        }