public static void FillSQLITEProducts()
{
List<FullIProductInformation> info = MongoWorker.getData();
using (VendorsDB dbLite = new VendorsDB())
{
foreach (var item in info)
{
dbLite.Products.Add(new Product()
{
productName = item.ProductName,
ProductID = item.ProductId,
vendorName = item.VendorName,
totalIncomes = item.TotalIncomes,
totalQuantitySold = item.TotalQuantitySold
});
}
dbLite.SaveChanges();
}
}
public static void FillSQLITEProducts()
{
List <FullIProductInformation> info = MongoWorker.getData();
using (VendorsDB dbLite = new VendorsDB())
{
foreach (var item in info)
{
dbLite.Products.Add(new Product()
{
productName = item.ProductName,
ProductID = item.ProductId,
vendorName = item.VendorName,
totalIncomes = item.TotalIncomes,
totalQuantitySold = item.TotalQuantitySold
});
}
dbLite.SaveChanges();
}
}
public static void GenerateTaxes()
{
using (SqlServerEntities db = new SqlServerEntities())
{
var names = from p in db.Products
select new
{
Product = p.ProductName,
Id = p.ProductId
};
using (VendorsDB dbLite = new VendorsDB())
{
Random rnd = new Random();
foreach (var item in names)
{
dbLite.Taxes.Add(new Tax()
{
Id = item.Id, ProductName = item.Product, Tax1 = rnd.Next(1, 40)
});
}
dbLite.SaveChanges();
}
}
}
public static void GenerateTaxes()
{
using (SqlServerEntities db = new SqlServerEntities())
{
var names = from p in db.Products
select new
{
Product = p.ProductName,
Id = p.ProductId
};
using (VendorsDB dbLite = new VendorsDB())
{
Random rnd = new Random();
foreach (var item in names)
{
dbLite.Taxes.Add(new Tax() { Id = item.Id, ProductName = item.Product, Tax1 = rnd.Next(1, 40) });
}
dbLite.SaveChanges();
}
}
}
