public static void SeedData(PlaneBookingDbContext context)
{
try
{
if (!context.Cities.Any())
{
context.Cities.AddRange(SampleData.GetCities());
context.SaveChanges();
}
if (!context.Airports.Any())
{
context.Airports.AddRange(SampleData.GetAirports());
context.SaveChanges();
}
if (!context.Planes.Any())
{
context.Planes.AddRange(SampleData.GetPlanes());
context.SaveChanges();
}
if (!context.Tutors.Any())
{
context.Tutors.AddRange(SampleData.GetTutors());
context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public static void ResetIdentity(PlaneBookingDbContext context, string tableName)
{
try
{
context.Database.ExecuteSqlCommand($"DBCC CHECKIDENT (\"PlaneBooking.{tableName}\", RESEED, 0);");
}
catch { }
}
public static void ExecuteDeleteSQL(PlaneBookingDbContext context, string tableName)
{
try
{
context.Database.ExecuteSqlCommand($"Delete from PlaneBooking.{tableName}");
}
catch { }
}
public static void ClearData(PlaneBookingDbContext context)
{
foreach (var itm in _Tables)
{
ExecuteDeleteSQL(context, itm);
ResetIdentity(context, itm);
}
}
public static void InitializeData(PlaneBookingDbContext context)
{
ClearData(context);
SeedData(context);
}
protected RepoBase(DbContextOptions <PlaneBookingDbContext> options)
{
_Context = new PlaneBookingDbContext(options);
_Table = _Context.Set <T>();
}
protected RepoBase()
{
_Context = new PlaneBookingDbContext();
_Table = _Context.Set <T>();
}
