public static void SeedStrumenti(/*"@" in front of string before passing it as argument */ string excelPath, LabContext context) { if (context.Strumento.Count() == 0) { var filePath = @"C:\Users\Alexa\Desktop\StrumentiProva.xlsx"; FileInfo file = new FileInfo(filePath); using (ExcelPackage package = new ExcelPackage(file)) { ExcelWorksheet worksheet = package.Workbook.Worksheets.FirstOrDefault(); int rowCount = worksheet.Dimension.Rows; for (int row = 2; row <= rowCount; row++) { var PDFPath = ""; var ImgPath = ""; Strumento s = new Strumento(); s.PartId = worksheet.Cells[row, 1].Value.ToString(); s.SerialId = worksheet.Cells[row, 2].Value.ToString(); s.Nome = worksheet.Cells[row, 3].Value.ToString(); s.Descrizione = worksheet.Cells[row, 4].Value.ToString(); s.Marca = worksheet.Cells[row, 5].Value.ToString(); s.Modello = worksheet.Cells[row, 6].Value.ToString(); s.Posizione = worksheet.Cells[row, 7].Value.ToString(); if (worksheet.Cells[row, 8].Value != null) { PDFPath = @worksheet.Cells[row, 8].Value.ToString(); s.PDFPath = DataSeeder.Upload(PDFPath); } if (worksheet.Cells[row, 9].Value != null) { ImgPath = @worksheet.Cells[row, 9].Value.ToString(); s.ImgPath = DataSeeder.Upload(ImgPath); } var Date = DateTime.FromOADate((double)worksheet.Cells[row, 11].Value); s.Nascita = Date; var ttl = DateTime.FromOADate((double)worksheet.Cells[row, 10].Value); s.TTL = ttl; var delicato = worksheet.Cells[row, 12].Value.ToString(); if (delicato == "true") { s.Delicato = true; } else { s.Delicato = false; } s.Status = 1; context.Strumento.Add(s); } context.SaveChanges(); } } }
public static void SeedData(UserManager <Utente> userManager, RoleManager <IdentityRole> roleManager, string excelPath, LabContext context, IEmailService emailService, string email) { SeedRoles(roleManager); SeedUsers(userManager); SeedStrumenti(excelPath, context); // TTLHelper.CheckTTL(context,email,emailService); }