private List<Model.article_groups> getArticleGroupInformation() { List<Model.article_groups> articleGroups = new List<Model.article_groups>(); using (Model.MTDBEntities context = new Model.MTDBEntities()) { articleGroups = context.article_groups.ToList(); } return articleGroups; }
private List<Model.addresses> getSupplierInformation() { List<Model.addresses> results = new List<Model.addresses>(); List<Model.addresses> addresses = new List<Model.addresses>(); using (Model.MTDBEntities context = new Model.MTDBEntities()) { addresses = context.addresses.ToList(); foreach (Model.addresses address in addresses) { if(address.adr_type == 6) { results.Add(address); } } } return results; }
private List<Model.inventory_positions> getInventoryPositionsInformation() { List<Model.inventory_positions> inventoryPositions = new List<Model.inventory_positions>(); using (Model.MTDBEntities context = new Model.MTDBEntities()) { inventoryPositions = context.inventory_positions.ToList(); } return inventoryPositions; }