public static List<VendorEntity> GetVendors() { List<VendorEntity> vendors = new List<VendorEntity>(); MySqlSupermarketContext context = new MySqlSupermarketContext(); using (context) { foreach (var vendor in context.Vendors) { VendorEntity vendorEntity = new VendorEntity(); vendorEntity.VendorID = vendor.VendorID; vendorEntity.Name = vendor.VendorName; vendors.Add(vendorEntity); } } return vendors; }
public static List<MeasureEntity> GetMeasures() { List<MeasureEntity> measures = new List<MeasureEntity>(); MySqlSupermarketContext context = new MySqlSupermarketContext(); using (context) { foreach (var measure in context.Measures) { MeasureEntity measureEntity = new MeasureEntity(); measureEntity.MeasureID = measure.MeasureID; measureEntity.Name = measure.Name; measures.Add(measureEntity); } } return measures; }
public static List<ProductEntity> GetProducts() { List<ProductEntity> products = new List<ProductEntity>(); MySqlSupermarketContext context = new MySqlSupermarketContext(); using (context) { foreach (var product in context.Products) { ProductEntity productEntity = new ProductEntity(); productEntity.ProductID = product.ID; productEntity.Name = product.ProductName; productEntity.BasePrice = product.BasePrice; productEntity.VendorID = product.VendorID; productEntity.MeasureID = product.MeasureID; products.Add(productEntity); } } return products; }