public List <User> GetAllUsers()
{
using (PriceCompareContext db = new PriceCompareContext())
{
return(db.Users.ToList());
}
}
public List <Store> GetStoresByChainStoreId(string chainStoresName)
{
using (PriceCompareContext db = new PriceCompareContext())
{
return(db.Stores.Where(store => store.ChainStoreName.Equals(chainStoresName)).ToList());
}
}
public List <Item> GetAllItems()
{
using (PriceCompareContext db = new PriceCompareContext())
{
return(db.Items.ToList());
}
}
public List <Store> GetAllStores()
{
using (PriceCompareContext db = new PriceCompareContext())
{
return(db.Stores.ToList());
}
}
public List <Item> GetItemsByStoreId(long id)
{
using (PriceCompareContext db = new PriceCompareContext())
{
return(db.Items.Where(item => item.StoreId == id).ToList());
}
}
public void AddItems(List <Item> items)
{
using (PriceCompareContext db = new PriceCompareContext())
{
db.Items.AddRange(items);
db.SaveChanges();
}
}
public void AddItem(Item item)
{
using (PriceCompareContext db = new PriceCompareContext())
{
db.Items.Add(item);
db.SaveChanges();
}
}
public void DeleteAll()
{
using (PriceCompareContext db = new PriceCompareContext())
{
db.Items.RemoveRange(db.Items);
db.Users.RemoveRange(db.Users);
db.Stores.RemoveRange(db.Stores);
db.SaveChanges();
}
}
public void AddStore(Store store)
{
using (PriceCompareContext db = new PriceCompareContext())
{
if (db.Stores.Where(dbStore => dbStore.Name.Equals(store.Name) && dbStore.ChainStoreName.Equals(store.ChainStoreName)).ToList().Count == 0)
{
db.Stores.Add(store);
db.SaveChanges();
}
}
}
public long GetStoreId(Store store)
{
using (PriceCompareContext db = new PriceCompareContext())
{
List <Store> stores = db.Stores.Where(currentStore => currentStore.Name.Equals(store.Name) && currentStore.ChainStoreName.Equals(store.ChainStoreName)).ToList();
if (stores.Count == 1)
{
return(stores[0].Id);
}
return(-1);
}
}
public void AddUser(User user)
{
using (PriceCompareContext db = new PriceCompareContext())
{
if (String.IsNullOrEmpty(user.Name) || String.IsNullOrEmpty(user.Password))
{
throw new ArgumentException("Please enter name and password!");
}
if (db.Users.Where(dbUser => dbUser.Name == user.Name).ToList().Count != 0)
{
throw new ArgumentException($"There is user with the name {user.Name}!");
}
db.Users.Add(user);
db.SaveChanges();
}
}
