using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using NHibernate;
using NHibernate.Linq;
using Sleis.Models;
using Sleis.Infrastructure;
using Sleis.Utility;

namespace Sleis.Data
{
    public class UserData : BaseData<UserModel>, Sleis.Data.IUserData
    {

        public IList<UserModel> GetFacilityUsers(int facId)
        {
            using (ISession session = GetSession())
            {
                var tmp = (from d in session.Query<UserModel>()
                           join r in session.Query<UserRoleModel>()
                           on d.Id equals r.UserId 
                           where r.FacilityId == facId && d.Status!=SleisUserStatusType.Deleted
                           select d);
                return tmp.Distinct<UserModel>().ToList<UserModel>();
            }

        }

        

        public int GetAuthorizedUsers(int userId, int facilityId)
        {
            using (ISession session = GetSession())
            {
                var tmp = (from u in session.Query<UserModel>()
                           join r in session.Query<UserRoleModel>()
                           on u.Id equals r.UserId
                           where r.FacilityId.Value == facilityId
                           && r.UserId != userId && u.Status!=SleisUserStatusType.Deleted
                           select u.Id).ToList().Distinct();
                return tmp.Count();
            }

        }
        public int UserSecurityQuestionAnswered(int userId)
        {
            using (ISession session = GetSession())
            {
                var tmp = (from d in session.Query<UserAnswerModel>()
                           where d.UserId == userId
                           select d.UserId);
                return tmp.Count<Int32>();
            }
        }

        public bool IsElectronicSigVerified(int userId)
        {
            using (ISession session = GetSession())
            {
                return (from d in session.Query<UserModel>()
                        where d.Id == userId
                        select d.IsElectronicSigVerified).FirstOrDefault<bool>();
            }

        }

        public bool EmailExists(string email)
        {
            ArgumentValidationUtility.ThrowOnEmpty(email, "email");

            using (ISession session = GetSession())
            {
                return (from d in session.Query<UserModel>()
                        where d.Email.ToLowerInvariant().Equals(email.ToLowerInvariant())
                        select d.Email).ToList().Count > 0;
            }
        }

        public UserModel GetByEmail(string email)
        {
            ArgumentValidationUtility.ThrowOnEmpty(email, "email");

            using (ISession session = GetSession())
            {
                return (from d in session.Query<UserModel>()
                        where d.Email.ToLowerInvariant().Equals(email.ToLowerInvariant())
                        select d).FirstOrDefault<UserModel>();
            }
        }
    }
}