public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new AIMDbContext(
serviceProvider.GetRequiredService <
DbContextOptions <AIMDbContext> >()))
{
// Look for any entries.
//if (context.DodicLibrary.Any())
//{
// return; // DB has been seeded
//}
TextFieldParser parser = new TextFieldParser(@"C:\Users\adam\Documents\Adam\MSSA\Project\AIM\AIM\Models\SeedData\DodicLibrary.csv");
parser.HasFieldsEnclosedInQuotes = true; //Account for commas in quotes
parser.SetDelimiters(","); //DODIC/nomenclature pairs are split by comma
string[] parsedData; //Array to hold data read from csv
while (!parser.EndOfData)
{
parsedData = parser.ReadFields(); //Input each string into array, split at the commas, and don't ignore blank entries
context.DodicLibrary.AddRange( //Add new db entry
new DodicLibrary
{
Dodic = parsedData[0],
Nomenclature = parsedData[1]
});
context.SaveChanges();
}
}
}
public UserInfoController(AIMDbContext context)
{
_context = context;
}
public CustomerInfoController(AIMDbContext context)
{
_context = context;
}
public SingleInventoryController(AIMDbContext context)
{
_context = context;
}
public SingleTransactionDetailsController(AIMDbContext context)
{
_context = context;
}
public LocalTransactionController(AIMDbContext context)
{
_context = context;
}
public DodicLibraryController(AIMDbContext context)
{
_context = context;
}
public LocalInventoryController(AIMDbContext context)
{
_context = context;
}