public static List <Products> GetAllProductsFilterByType(int type, string filter)
        {
            var dal        = new ProductsDAL();
            var collection = new List <Products>();

            foreach (DataRow row in dal.GetAllProductsFilterByType(type, filter).Rows)
            {
                var instance = new Products();
                instance.Bind(row);
                collection.Add(instance);
            }

            return(collection);
        }
        public static List <Products> GetAllAccessories()
        {
            var dal        = new ProductsDAL();
            var collection = new List <Products>();

            foreach (DataRow row in dal.GetAllAccessories().Rows)
            {
                var instance = new Products();
                instance.Bind(row);
                collection.Add(instance);
            }

            return(collection);
        }
        public static List<Products> GetAllTablets()
        {
            var dal = new ProductsDAL();
            var collection = new List<Products>();

            foreach(DataRow row in dal.GetAllTablets().Rows){
                var instance = new Products();
                instance.Bind(row);
                collection.Add(instance);
            }

            return collection;
        }
        public static List<Products> GetAllProductsFilterByType(int type, string filter)
        {
            var dal = new ProductsDAL();
            var collection = new List<Products>();

            foreach (DataRow row in dal.GetAllProductsFilterByType(type, filter).Rows)
            {
                var instance = new Products();
                instance.Bind(row);
                collection.Add(instance);
            }

            return collection;
        }