/// <summary> /// Get all stores /// </summary> public static List <StoreDTO> GetStores() { try { using (SuperZapatosContext db = new SuperZapatosContext()) { return((from s in db.Stores select new StoreDTO() { id = s.id, name = s.name, address = s.address }).ToList()); }; } catch (Exception ex) { string sMsg = string.Format("SuperZapatos.GetStores"); throw new Exception(sMsg, ex); } }
/// <summary> /// Get stores by id /// </summary> public static StoreDTO GetStoreById(int id) { try { using (SuperZapatosContext db = new SuperZapatosContext()) { return((from s in db.Stores where s.id == id select new StoreDTO() { id = s.id, name = s.name, address = s.address }).FirstOrDefault()); }; } catch (Exception ex) { throw ex; } }
/// <summary> /// Update Article /// </summary> public static void UpdateArticle(ArticleDTO articleDTO) { try { using (SuperZapatosContext db = new SuperZapatosContext()) { var articleDB = new Article(); articleDB.name = articleDTO.name; articleDB.description = articleDTO.description; articleDB.price = articleDTO.price; articleDB.total_in_shelf = articleDTO.total_in_shelf; articleDB.total_in_vault = articleDTO.total_in_vault; articleDB.store_id = articleDTO.store_id; db.Entry(articleDB).State = EntityState.Modified; db.SaveChanges(); }; } catch (Exception ex) { throw ex; } }