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

namespace VinciDataAccess.DataAccess
{
    public class SuppliersStore
    {
        SuppliersDataContext _suppliersDataContext = new SuppliersDataContext();
        public SuppliersStore()
        {
            _suppliersDataContext = new SuppliersDataContext();
        }
        /// <summary>
        /// Define Method SuppliersObjectToEntity
        /// Retrun SuppliersEntity
        /// </summary>
        /// <param name="supplier"></param>
        /// <returns></returns>
        private SuppliersEntity SuppliersObjectToEntity(Suppliers supplier)
        {
            SuppliersEntity suppliersEntity = new SuppliersEntity();
            suppliersEntity.SupplierID = supplier.SupplierID;
            suppliersEntity.CompanyName = supplier.CompanyName;
            suppliersEntity.ContactName = supplier.ContactName;
            suppliersEntity.ContactTitle = supplier.ContactTitle;
            suppliersEntity.Address = supplier.Address;
            suppliersEntity.RegionID = supplier.RegionID;
            suppliersEntity.Phone = supplier.Phone;
            suppliersEntity.HomePage = supplier.HomePage;
            return suppliersEntity;
        }
        /// <summary>
        /// Get List Of Suppliers
        /// </summary>
        /// <returns></returns>
        public SuppliersCollection GetSuppliersList()
        {
            SuppliersCollection suppliersList = new SuppliersCollection();
            IEnumerable<Suppliers> suppliers = from supplier in this._suppliersDataContext.Suppliers
                                               orderby supplier.SupplierID
                                               select supplier;
            foreach (Suppliers supplier in suppliers)
            {
                suppliersList.Add(this.SuppliersObjectToEntity(supplier));
            }
            return suppliersList;
        }
        /// <summary>
        /// Get Single Supplier Information
        /// Select It By SupplierID
        /// </summary>
        /// <param name="supplierID"></param>
        /// <returns></returns>
        public SuppliersEntity GetSupplier(int supplierID)
        {
            SuppliersEntity suppliersEntity = new SuppliersEntity();
            IEnumerable<Suppliers> suppliers = from supplier in this._suppliersDataContext.Suppliers
                                               where supplier.SupplierID == supplierID
                                               select supplier;
            foreach(Suppliers supplier in suppliers)
            {
                suppliersEntity = this.SuppliersObjectToEntity(supplier);
            }
            return suppliersEntity;
        }

 
    }
    
}