using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL
{
    public class UsersLogin : IDisposable
    {
        private DAL.SQLite lite;

        public UsersLogin()
        {
            lite = new();
            lite.Connect();
        }

        public void Dispose()
        {
            lite.Close();
            lite = null;
        }

        public bool Logion(string userName, string password, out Model.UserLevel level)
        {
            level = Model.UserLevel.None;
            string sql = "SELECT ID,Level FROM Users WHERE UserName='" + userName + "' and Password='" + password + "'";
            bool rtn = lite.Select(sql, out string[][] data);
            if (!rtn) return false;
            if (data.Length != 1) return false;
            level = (Model.UserLevel)Convert.ToInt32(data[0][1]);
            return true;
        }
    }
}