static void Main()
{
using (var db = new EntitiesModel())
{
var vendors = db.Vendors;
var products = db.Products;
var measures = db.Measures;
using (var dbSql = new SupermarketEntities())
{
foreach (var vendor in vendors)
{
Supermarket_EF.Data.Vendor vendorObj = new Supermarket_EF.Data.Vendor();
vendorObj.ID = vendor.IdvendorsID;
vendorObj.VendorName = vendor.VendorName;
dbSql.Vendors.Add(vendorObj);
}
foreach (var measure in measures)
{
Supermarket_EF.Data.Measure measureObj = new Supermarket_EF.Data.Measure()
{
ID = measure.ID,
MeasureName = measure.MeasureName
};
dbSql.Measures.Add(measureObj);
}
foreach (var product in products)
{
Supermarket_EF.Data.Product productObj = new Supermarket_EF.Data.Product()
{
ID = product.ID,
VendorID = product.VendorID,
ProductName = product.ProductName,
MeasureID = product.MeasureID,
BasePrice = (decimal)product.BasePrice
};
dbSql.Products.Add(productObj);
}
dbSql.SaveChanges();
MyExtract();
string dirPath = "../../../Extracted Files";
var dir = Directory.GetDirectories(dirPath);
Traverse(dir);
PdfReportCreator.CreatePDFs();
XmlReportCreator.CreateReport();
ExportReportInMongoDB.CreateReport();
VendorExpenses.LoadVendorExpenses();
VendorsReports.CreateExcel();
}
}
}
static void Main()
{
using (var db = new EntitiesModel())
{
var vendors = db.Vendors;
var products = db.Products;
var measures = db.Measures;
using (var dbSql = new SupermarketEntities())
{
foreach (var vendor in vendors)
{
Supermarket_EF.Data.Vendor vendorObj = new Supermarket_EF.Data.Vendor();
vendorObj.ID = vendor.IdvendorsID;
vendorObj.VendorName = vendor.VendorName;
dbSql.Vendors.Add(vendorObj);
}
foreach (var measure in measures)
{
Supermarket_EF.Data.Measure measureObj = new Supermarket_EF.Data.Measure()
{
ID = measure.ID,
MeasureName = measure.MeasureName
};
dbSql.Measures.Add(measureObj);
}
foreach (var product in products)
{
Supermarket_EF.Data.Product productObj = new Supermarket_EF.Data.Product()
{
ID = product.ID,
VendorID = product.VendorID,
ProductName = product.ProductName,
MeasureID = product.MeasureID,
BasePrice = (decimal)product.BasePrice
};
dbSql.Products.Add(productObj);
}
dbSql.SaveChanges();
MyExtract();
string dirPath = "../../../Extracted Files";
var dir = Directory.GetDirectories(dirPath);
Traverse(dir);
PdfReportCreator.CreatePDFs();
XmlReportCreator.CreateReport();
ExportReportInMongoDB.CreateReport();
VendorExpenses.LoadVendorExpenses();
VendorsReports.CreateExcel();
}
}
}