using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace eraproject_site.Models
{

    public class CheckUser
    {
        private int role_id = 4;
        private UserLoginInfo _UserLoginInfo;
        private DtabaseConnect.CRUD.IEnumTable table = new DtabaseConnect.CRUD.IEnumTable();

        public string Username { get; set; }

        public CheckUser(UserLoginInfo info)
        {
            _UserLoginInfo = info;
        }

        private void SetRole()
        {
            var tt = table.ReturnAllTable();
            foreach (var item in tt.IEnumUser_role)
            {
                if (item.id == role_id)
                {
                    DatabaseStatistics.CurentUser = item.role_name;
                    return;
                }
            }
        }

        public void SetPermission()
        {
            var tt = table.ReturnAllTable();
            foreach (var item in tt.IEnumUsers)
            {
                if (item.username == Username)
                {
                    role_id = item.id_role;
                }
            }
          SetRole();
          DtabaseConnect.Connection.SetDatabaseConnection.Role(role_id);
        }

        public bool ReturnResult()
        {
            var tt = table.ReturnAllTable();
            foreach (var item in tt.IEnumUsers)
            {
                if ((item.username == _UserLoginInfo.login) && (item.password == _UserLoginInfo.password) && (item.id_role <= 3))
                {
                    Username = item.username;
                    SetPermission();
                    return true;
                }
            }
            return false;
        }
    }

    public class UserLoginInfo
    {
        public string role { get; set; }
        public string login { get; set; }
        public string password { get; set; }
    }
}