public bool addArticle(BEArticle art) { bool res = false; bdshoesEntities dc; articles nuevo = new articles { id = art.id, name = art.name, description = art.description, price = art.price, store_id = art.store_id, total_in_shelf = art.total_in_shelf, total_in_vault = art.total_in_vault, }; using (dc = new bdshoesEntities()) { dc.articles.Add(nuevo); dc.SaveChanges(); art.id = nuevo.id; res = art.id > 0; } return(res); }
public List <BEStore> getStores() { List <BEStore> lista = null; bdshoesEntities dc; using (dc = new bdshoesEntities()) { lista = dc.stores.Select(a => new BEStore { id = a.id, name = a.name, address = a.address, }).OrderBy(b => b.name).ToList(); } return(lista); }
private List <BEArticle> getArticlesByStoreId(short?storeId) { List <BEArticle> lista = new List <BEArticle>(); bdshoesEntities dc; using (dc = new bdshoesEntities()) { lista = dc.articles.Where(b => (storeId == null || b.store_id == storeId)).Select(a => new BEArticle { id = a.id, name = a.name, description = a.description, store_id = a.store_id, price = a.price, total_in_shelf = a.total_in_shelf, total_in_vault = a.total_in_vault, store_name = a.stores.name, }).OrderBy(a => a.name).ToList(); } return(lista); }