public static void Entry(Category category)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Entry(category).State = EntityState.Modified;
}
}
public static List <OrderDTO> GetOrderById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(OrderConverter.DALListToDTO(db.Orders.Where(order => order.shopCode == id).ToList()));
}
}
public static CategoryDTO GetCategoryById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(CategoryConverter.DALToDTO(db.Categories.Find(id)));
}
}
public static bool CategoryExists(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(db.Categories.Count(e => e.code == id) > 0);
}
}
public static void Add(Order order)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Orders.Add(order);
}
}
public static ShopDTO GetShopById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ShopConverter.DALToDTO(db.Shops.Find(id)));
}
}
public static List <UsersDTO> GetUsers()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(UsersConverter.DALListToDTO(db.Users.ToList()));
}
}
public static OrderDTO GetOrderById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(OrderConverter.DALToDTO(db.Orders.Find(id)));
}
}
public static bool ShopProductsExists(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(db.Shop_sProduct.Count(e => e.shopCode == id) > 0);
}
}
public static void Entry(Shop_sProduct shopProducts)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Entry(shopProducts).State = EntityState.Modified;
}
}
public static List <ShopProductsDTO> GetShopProductsById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ShopProductsConverter.DALsToDTOs(db.Shop_sProduct.Where(Shop => Shop.shopCode == id).ToList()));
}
}
public static List <ShopProductsDTO> GetAllShopProducts()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ShopProductsConverter.DALListToDTO(db.Shop_sProduct.ToList()));
}
}
public static void Add(Shop shop)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Shops.Add(shop);
}
}
public static void Add(Shop_sProduct shopProducts)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Shop_sProduct.Add(shopProducts);
}
}
public static UsersDTO GetUsersById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(UsersConverter.DALToDTO(db.Users.Find(id)));
}
}
public static List <OrderDTO> GetOrders()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(OrderConverter.DALListToDTO(db.Orders.ToList()));
}
}
public static void Add(Category category)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Categories.Add(category);
}
}
public static void Entry(Order order)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Entry(order).State = EntityState.Modified;
}
}
public static List <CategoryDTO> GetCategories()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(CategoryConverter.DALListToDTO(db.Categories.ToList()));
}
}
public static List <ShopDTO> GetShops()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ShopConverter.DALListToDTO(db.Shops.ToList()));
}
}
public static void Add(Product product)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Products.Add(product);
}
}
public static ShopProductsDTO GetShopProductsById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ShopProductsConverter.DALToDTO(db.Shop_sProduct.Find(id)));
}
}
public static bool ProductExists(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(db.Products.Count(e => e.code == id) > 0);
}
}
public static void Entry(Product product)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Entry(product).State = EntityState.Modified;
}
}
public static ProductDTO GetProductById(long id)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ProductConverter.DALToDTO(db.Products.Find(id)));
}
}
public static List <ProductDTO> GetProducts()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
return(ProductConverter.DALListToDTO(db.Products.ToList()));
}
}
public static void SaveChanges()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.SaveChanges();
}
}
public static void Dispose()
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Dispose();
}
}
public static void updateOrder(OrderDTO order)
{
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
Order o = OrderConverter.DTOToDAL(order);
db.Entry(o).State = EntityState.Modified;
db.SaveChanges();
}
}
public static ShopDTO Add(ShopDTO shop)
{
Shop s = ShopConverter.DTOToDAL(shop);
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.Shops.Add(s);
db.SaveChanges();
}
return(ShopConverter.DALToDTO(s));
}
