public static void FillProductsTable()
{
var context = new ChainOfSupermarketsEntities();
var vendors = context.VENDORS.ToList();
var measures = context.MEASURES.ToList();
using (var productReader = new StreamReader(@"..\..\..\Products.txt"))
{
var line = productReader.ReadLine();
line = productReader.ReadLine();
while (!string.IsNullOrEmpty(line))
{
var data = line.Split('|');
int productId = int.Parse(data[0]);
int vendorId = int.Parse(data[1]);
var productName = data[2];
int measureId = int.Parse(data[3]);
decimal price = decimal.Parse(data[4]);
context.PRODUCTS.Add(new PRODUCT()
{
ID = productId,
VENDOR = vendors.Find(v => v.ID == vendorId),
PRODUCT_NAME = productName,
MEASURE = measures.Find(m => m.ID == measureId),
PRICE = price
});
line = productReader.ReadLine();
}
context.SaveChanges();
}
}
public static void FillMeasureTable()
{
var context = new ChainOfSupermarketsEntities();
using (var measureReader = new StreamReader(@"..\..\..\Measures.txt"))
{
var measureLine = measureReader.ReadLine();
measureLine = measureReader.ReadLine();
while (measureLine != null)
{
var measureData = measureLine.Split(' ');
var measure = new MEASURE() {ID = int.Parse(measureData[0]), MEASURE_NAME = measureData[1]};
context.MEASURES.Add(measure);
measureLine = measureReader.ReadLine();
}
}
context.SaveChanges();
}
public static void FillVendorTable()
{
var context = new ChainOfSupermarketsEntities();
using (var vendorReader = new StreamReader(@"..\..\..\Vendors.txt"))
{
var vendorLine = vendorReader.ReadLine();
vendorLine = vendorReader.ReadLine();
while (vendorLine != null)
{
var vendorData = vendorLine.Split(' ');
var vendor = new VENDOR() {ID = int.Parse(vendorData[0]), VENDOR_NAME = vendorData[1]};
context.VENDORS.Add(vendor);
vendorLine = vendorReader.ReadLine();
}
}
context.SaveChanges();
}
