public static async void UseSeed(this IApplicationBuilder app)
{
IServiceScope scope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope();
PgsqlContext context = scope.ServiceProvider.GetService <PgsqlContext>();
IRepository repository = scope.ServiceProvider.GetService <IRepository>();
IConfiguration configuration = scope.ServiceProvider.GetService <IConfiguration>();
using (context)
{
// Crea la BD si no existe
context.Database.Migrate();
// ejecuta los seeds necesarios en la BD
// se deben agregar
bool runSeed = bool.Parse(configuration.GetValue <string>("Seed"));
if (runSeed)
{
if (!context.Student.Any())
{
StudentSeed studentSeed = new StudentSeed(repository);
await studentSeed.Run();
}
}
}
}
private void pgsqlExport_Click(object sender, RoutedEventArgs e)
{
var db = PgsqlContext.CreateConnection();
db.Database.EnsureCreated();
Scene psqlScene = db.Scene.FirstOrDefault(s => s.SceneId == Scene.Instance.SceneId);
if (psqlScene != null)
{
System.Windows.Forms.DialogResult dialogResult =
System.Windows.Forms.MessageBox.Show(
"May be this scene already exists in PostgreSQL database."
+ " Psql scene name: " + psqlScene.Name
+ " This scene name: " + Scene.Instance.Name
+ " Are you sure you want insert it?",
"Think about it!",
System.Windows.Forms.MessageBoxButtons.YesNo);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
Console.WriteLine("testing1");
Scene.Instance.SceneId = db.Scene.Last().SceneId + 1;
Console.WriteLine("testing2");
}
else if (dialogResult == System.Windows.Forms.DialogResult.No)
{
return;
}
}
List <Scene> list = db.Scene.ToList();
Console.WriteLine("algo");
db.Scene.Add(Scene.Instance);
list = db.Scene.ToList();
Console.WriteLine("algo");
db.SaveChanges();
}
public StudentsController(PgsqlContext context, ILogger iLogger, IMapper mapper, IRepository repository)
{
Repository = repository;
Logger = iLogger;
Mapper = mapper;
}
