public AkasaService(AkasaDBContext context
, IMapper mapperServiceToSet)
{
_mapperService = mapperServiceToSet;
_context = context;
_thisDbSet = context.Set <TDataEntity>();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, AkasaDBContext context)
{
app.ConfigureAkasaLogging(env, loggerFactory, Configuration.GetSection("Logging"));
app.UseStaticFiles();
app.UseMvc();
app.UseSwagger(c =>
{
c.PreSerializeFilters.Add((swagger, httpReq) => swagger.Host = httpReq.Host.Value);
});
var jsonFileUrlWithVirtualDirectory = Configuration["Swagger:VirtualDirectory"] + "/swagger/v1/swagger.json";
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint(jsonFileUrlWithVirtualDirectory, "V1 Docs");
});
DbInitializer.Initialize(context);
}
public PaymentModalityService(AkasaDBContext context
, IMapper mapper)
: base(context, mapper)
{
}
public LessonRecurrentService(AkasaDBContext context
, IMapper mapper)
: base(context, mapper)
{
}
static void Main(string[] args)
{
AddConfigurationSettings();
// Initialize db context provider
var connectionString = Configuration.GetConnectionString("DefaultConnection");
Console.WriteLine("Launching dangerous rockets!!");
Console.WriteLine($"Connection string: {connectionString}");
Console.WriteLine();
Console.WriteLine("Opciones:");
Console.WriteLine();
Console.WriteLine("a) Aplicar migraciones e insertar registros.");
Console.WriteLine("b) BORRAR y re-crear la BD.");
Console.WriteLine("c) Solo insertar registros.");
Console.WriteLine("d) Solo insertar TEST Data.");
Console.WriteLine("e) BORRAR y re-crear la BD con TEST Data.");
Console.WriteLine();
Console.WriteLine("O cualquier otra tecla para salir.");
var migrate = false;
var create = false;
var insert = false;
var insertTEST = false;
var key = Console.ReadKey();
switch (key.Key)
{
case ConsoleKey.A:
migrate = true;
insert = true;
break;
case ConsoleKey.B:
create = true;
//insert = true;
break;
case ConsoleKey.C:
insert = true;
break;
case ConsoleKey.D:
insertTEST = true;
break;
case ConsoleKey.E:
create = true;
insert = true;
insertTEST = true;
break;
default: return;
}
Console.WriteLine();
var optionsBuilder = new DbContextOptionsBuilder <AkasaDBContext>();
optionsBuilder.UseMySql(connectionString);
using (var context = new AkasaDBContext(optionsBuilder.Options))
{
if (migrate)
{
Console.WriteLine("Migrating...");
context.Database.Migrate();
}
if (create)
{
// Create database
Console.WriteLine("Wiping out old beliefs...");
context.Database.EnsureDeleted();
Console.WriteLine("Doing karma yoga...");
context.Database.EnsureCreated();
}
if (insert)
{
// Insertar datos
Console.WriteLine("Inserting base data (currently empty BTW)...");
DbInitializer.SeedData(context);
}
if (insertTEST)
{
// Insertar datos TESTING
throw new NotImplementedException();
}
}
Console.ReadKey();
}
public static void Initialize(AkasaDBContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (!context.User.Any())
{
context.User.Add(new User
{
Name = "Nano",
Phone = "88226649",
FacebookID = String.Empty,
Email = "*****@*****.**",
LstUserXRole = new List <UserXRole>()
{
new UserXRole
{
VKRole = 2
}
}
});
context.SaveChanges();
}
if (!context.Lesson.Any())
{
context.Lesson.Add(new Lesson
{
Name = "Yoga Martes",
Description = "Aca la descripcion de la clase",
LstLessonRecurrent = new List <LessonRecurrent>
{
new LessonRecurrent
{
Tuesday = true
}
}
});
context.SaveChanges();
}
if (!context.PaymentModality.Any())
{
context.PaymentModality.AddRange(
new PaymentModality
{
Cost = 6000,
LessonQuantityAvailable = 1,
LessonAvailabilityDays = 1
},
new PaymentModality
{
Cost = 16000,
LessonQuantityAvailable = 4,
LessonAvailabilityDays = 30
},
new PaymentModality
{
Cost = 28000,
LessonQuantityAvailable = 8,
LessonAvailabilityDays = 60
},
new PaymentModality
{
Cost = 48000,
LessonQuantityAvailable = 16,
LessonAvailabilityDays = 90
});
context.SaveChanges();
}
}
public UserPaymentService(AkasaDBContext context
, IMapper mapper)
: base(context, mapper)
{
}
public LessonDayService(AkasaDBContext context
, IMapper mapper)
: base(context, mapper)
{
}
