private void CreatePlayTimes(IMsSqlDbContext context)
{
if (!context.PlayTimes.Any())
{
context.PlayTimes.Add(new PlayTime(TimeOfDay.morning, DateTime.Now));
context.PlayTimes.Add(new PlayTime(TimeOfDay.lunch, DateTime.Now));
context.PlayTimes.Add(new PlayTime(TimeOfDay.afternoon, DateTime.Now));
context.PlayTimes.Add(new PlayTime(TimeOfDay.evening, DateTime.Now));
context.PlayTimes.Add(new PlayTime(TimeOfDay.night, DateTime.Now));
}
context.SaveChanges();
}
private void SampleCity(IMsSqlDbContext context, string CityName)
{
if (!context.Cities.Any())
{
var city = new City()
{
Name = CityName,
CreatedOn = DateTime.Now
};
context.Cities.Add(city);
context.SaveChanges();
}
}
private void SampleClub(IMsSqlDbContext context, string ClubName)
{
if (!context.Clubs.Any())
{
var club = new Club()
{
Name = ClubName,
SurfaceType = Surface.Clay,
City_Id = context.Cities.First().Id,
CreatedOn = DateTime.Now
};
context.Clubs.Add(club);
context.SaveChanges();
}
}
private void SampleMessage(IMsSqlDbContext context)
{
if (!context.Messages.Any())
{
var message = new Message()
{
Title = "Test message",
Content = "This is just a test!",
Author = "Gosho",
Recipient = "Admin",
CreatedOn = DateTime.Now
};
context.Messages.Add(message);
context.SaveChanges();
}
}
private void SampleDetails(IMsSqlDbContext context)
{
if (!context.Details.Any())
{
var details = new Details()
{
City_Id = context.Cities.First().Id,
Club_Id = context.Clubs.First().Id,
PlayTime_Id = context.PlayTimes.First().Id,
Age = 35,
Gender = Gender.Male,
Skill = 2.5,
Info = "Tennis Links app administrator. If you have any troubles or requests do not hesitate to contact me!",
CreatedOn = DateTime.Now
};
context.Details.Add(details);
context.SaveChanges();
}
}
public FootballSystemData(IMsSqlDbContext context)
{
this._context = context;
}
public EfRepository(IMsSqlDbContext context)
{
this.Context = context;
this.DbSet = this.Context.Set <T>();
}
