?using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using VinciDataAccess.Linq;
using VinciDataAccess.Entity;
using System.Collections;

namespace VinciDataAccess.DataAccess
{
    public class CategoriesStore
    {        
        private CategoriesDataContext _categoriesDataContext = null;
        public CategoriesStore()
        {
            _categoriesDataContext = new CategoriesDataContext();
        }
        /// <summary>
        /// Define Method  CategoriesObjectToEntity
        /// Return  CategoriesEntity
        /// </summary>
        /// <param name="category"></param>
        /// <returns></returns>
        private CategoriesEntity CategoriesObjectToEntity(Categories category)
        {
            CategoriesEntity categoriesEntity = new CategoriesEntity();
            categoriesEntity.CategoryID = category.CategoryID;
            categoriesEntity.CategoryName = category.CategoryName;
            categoriesEntity.Description = category.Description;
            return categoriesEntity;
        }

        /// <summary>
        /// Get List Of Categories
        /// </summary>
        /// <returns>CategoriesCollection</returns>
        public CategoriesCollection GetCategoriesList()
        {
            CategoriesCollection categoriesList = new CategoriesCollection();
            IEnumerable<Categories> categories = from category in this._categoriesDataContext.Categories
                                                           orderby category.CategoryID
                                                           select category;            
            foreach(Categories category in categories)
            {                
                categoriesList.Add(this.CategoriesObjectToEntity(category));
            }
            return categoriesList;
        }
        /// <summary>
        ///  Get Single Category Information
        ///  Select It By CategoryID
        /// </summary>
        /// <param name="categoryID"></param>
        /// <returns></returns>    
        public CategoriesEntity GetCategoryInfo(int categoryID)
        {
            IEnumerable<Categories> categories = from category in this._categoriesDataContext.Categories
                                                 where category.CategoryID == categoryID
                                                 select category;
            CategoriesEntity categoriesEntity = new CategoriesEntity();
            foreach (Categories category in categories)
            {
                categoriesEntity = this.CategoriesObjectToEntity(category);
            }
            return categoriesEntity;
        }  

    }
}