public async static void SeedNomina(ApecDbContext dbContext)
{
if (!dbContext.Nominas.Any())
{
var nominas = new List <Nomina>
{
new Nomina {
TipoRegistro = "D", ClaveNomina = "N01", TipoDocumento = "C", NoDocumento = "40223157997",
MontoPagar = 25000,
Cuenta = "2547896321"
},
new Nomina {
TipoRegistro = "D", ClaveNomina = "N01", TipoDocumento = "C", NoDocumento = "22315239797",
MontoPagar = 30000,
Cuenta = "4047895326"
},
new Nomina {
TipoRegistro = "D", ClaveNomina = "N01", TipoDocumento = "C", NoDocumento = "22314057998",
MontoPagar = 33000,
Cuenta = "9949906830"
},
new Nomina {
TipoRegistro = "D", ClaveNomina = "N01", TipoDocumento = "C", NoDocumento = "40225208890",
MontoPagar = 45000,
Cuenta = "6557796531"
}
};
await dbContext.AddRangeAsync(nominas);
await dbContext.SaveChangesAsync();
}
}
public async static void Generate()
{
try
{
var path = Directory.CreateDirectory(folderName);
if (!path.Exists)
{
Directory.CreateDirectory(folderName);
}
var query = "SELECT Id, TipoRegistro, ClaveNomina, TipoDocumento, NoDocumento, MontoPagar, Cuenta FROM Nominas";
using (var _dbContext = new ApecDbContext())
{
var nomina = await _dbContext.Nominas.FromSqlRaw(query).ToListAsync();
foreach (var item in nomina)
{
writeFileLine($"{item.TipoRegistro}|{item.ClaveNomina}|{item.TipoDocumento}|{item.NoDocumento}|{item.MontoPagar}|{item.Cuenta}");
}
_dbContext.Dispose();
Console.WriteLine("Archivo generado");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
static void Main(string[] args)
{
using (var dbContext = new ApecDbContext())
{
DataSeeder.SeedNomina(dbContext);
dbContext.Dispose();
};
GenerarNomina.Generate();
Console.ReadLine();
}
