static void Main()
{
SupermarketEntitiesModel super = new SupermarketEntitiesModel();
foreach (var item in super.Products)
{
Console.WriteLine(item.Product_Name);
}
}
public static ICollection<SqlSupermarketModel.Mesure> GetMesures()
{
SupermarketEntitiesModel super = new SupermarketEntitiesModel();
var mySqlMesures = super.Measures.ToList();
ICollection<SqlSupermarketModel.Mesure> sqlMesures = new List<SqlSupermarketModel.Mesure>();
foreach (var item in mySqlMesures)
{
var mesure = new SqlSupermarketModel.Mesure()
{
ID = item.ID,
Mesure_Name = item.Measure_Name
};
sqlMesures.Add(mesure);
}
return sqlMesures;
}
public static ICollection<SqlSupermarketModel.Vendor> GetVendors()
{
SupermarketEntitiesModel super = new SupermarketEntitiesModel();
var mySqlVendors = super.Vendors.ToList();
ICollection<SqlSupermarketModel.Vendor> sqlVendors = new List<SqlSupermarketModel.Vendor>();
foreach (var item in mySqlVendors)
{
var vendor = new SqlSupermarketModel.Vendor()
{
ID = item.ID,
VendorName = item.Vendor_Name
};
sqlVendors.Add(vendor);
}
return sqlVendors;
}
public static ICollection<SqlSupermarketModel.Product> GetProducts()
{
SupermarketEntitiesModel super = new SupermarketEntitiesModel();
var mySqlProducts = super.Products.ToList();
ICollection<SqlSupermarketModel.Product> sqlProducts = new List<SqlSupermarketModel.Product>();
foreach (var item in mySqlProducts)
{
var product = new SqlSupermarketModel.Product()
{
ID = item.ID,
Product_Name = item.Product_Name,
Base_Price = item.Base_Price,
mesures_ID = item.Measures_ID,
vendors_ID = item.Vendors_ID
};
sqlProducts.Add(product);
}
return sqlProducts;
}
