using System;
using System.Data.Objects;
using System.Linq;
using SupplierManual.Data;
using SupplierManual.Services.Interfaces;
using System.Configuration;

namespace SupplierManual.Services
{
    public class UserService : IUserService
    {
        private IRepository repositry;

        public UserService(IRepository repository)
        {
            this.repositry = repository;
        }

        private readonly SupplierManualEntities context = new SupplierManualEntities(ConfigurationManager.ConnectionStrings["SupplierManualEntities"].ConnectionString);

        public aspnet_User AddUser()
        {
            throw new NotImplementedException();
        }

        public aspnet_User GetUser()
        {
            throw new NotImplementedException();
        }

        public aspnet_User UpdateUser()
        {
            throw new NotImplementedException();
        }

        public void DeleteUser()
        {
            throw new NotImplementedException();
        }

        public IQueryable<aspnet_User> GetSuppliers()
        {
            IQueryable<aspnet_User> suppliers = context.aspnet_User.Where(p => !String.IsNullOrEmpty(p.SupplierName))
             .Select(p => p);
            return suppliers;
        }

        public IQueryable<aspnet_User> GetAdministrators()
        {
            IQueryable<aspnet_User> administrators = context.aspnet_User.Where(p => String.IsNullOrEmpty(p.SupplierName))
            .Select(p => p);
            return administrators;
        }
    }
}