public bool IsNameTaken(string name)
        {
            DataTable dt = new DataTable();

            if (name.Equals(string.Empty) || name.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.IsNameTaken(name));
            }

            int num = 0;

            foreach (DataRow ms in dt.Rows)
            {
                num = int.Parse(ms[0].ToString());
            }

            if (num == 0)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
        public UserModel ReturnUserByNamePassword(string userNickName, string userPassword)
        {
            if (userNickName == null || userNickName.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            if (userPassword == null || userPassword.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }

            if (!CheckStringFormat.IsBase64String(userPassword))
            {
                userPassword = ComputeHash.ComputeNewHash(userPassword);
            }
            DataTable dt = new DataTable();

            UserModel userModel = new UserModel();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.ReturnUserByNamePassword(userNickName, userPassword));
            }

            foreach (DataRow ms in dt.Rows)
            {
                userModel = UserModel.ToObject(ms);
            }

            return(userModel);
        }
        public int DeleteUser(string id)
        {
            int i = 0;

            using (MySqlCommand command = new MySqlCommand())
            {
                i = ExecuteNonQuery(UserStringsMySql.DeleteUser(id));
            }

            return(i);
        }
        public UserModel UploadUserImage(string id, string img)
        {
            UserModel userModel = new UserModel();
            DataTable dt        = new DataTable();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.UploadUserImage(id, img));
            }
            foreach (DataRow ms in dt.Rows)
            {
                userModel = UserModel.ToObject(ms);
            }

            return(userModel);
        }
        public List <UserModel> GetAllUsers()
        {
            DataTable        dt      = new DataTable();
            List <UserModel> arrUser = new List <UserModel>();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.GetAllUsers());
            }

            foreach (DataRow ms in dt.Rows)
            {
                arrUser.Add(UserModel.ToObject(ms));
            }

            return(arrUser);
        }
        public string ReturnUserIdByImdbPass(string imdbPass)
        {
            DataTable dt     = new DataTable();
            string    userId = "";

            if (imdbPass.Equals(string.Empty) || imdbPass.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.ReturnUserIdByImdbPass(imdbPass));
            }
            foreach (DataRow ms in dt.Rows)
            {
                userId = ms[0].ToString();
            }

            return(userId);
        }
        public UserModel AddUser(UserModel userModel)
        {
            string    orPass = userModel.userPassword;
            DataTable dt     = new DataTable();

            userModel.userPassword = ComputeHash.ComputeNewHash(userModel.userPassword);
            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.AddUser(userModel));
            }
            foreach (DataRow ms in dt.Rows)
            {
                userModel = UserModel.ToObject(ms);
            }

            if (ComputeHash.ComputeNewHash(orPass).Equals(userModel.userPassword))
            {
                userModel.userPassword = orPass;
            }

            return(userModel);
        }
        public UserModel GetOneUserById(string id)
        {
            DataTable dt = new DataTable();

            if (id.Equals(string.Empty) || id.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            UserModel userModel = new UserModel();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.GetOneUserById(id));
            }

            foreach (DataRow ms in dt.Rows)
            {
                userModel = UserModel.ToObject(ms);
            }

            return(userModel);
        }
        public string ReturnImdbPassByNamePassword(LoginModel checkUser)
        {
            DataTable dt = new DataTable();

            checkUser.userPassword = ComputeHash.ComputeNewHash(checkUser.userPassword);
            if (checkUser == null)
            {
                throw new ArgumentOutOfRangeException();
            }
            LoginModel loginModel = new LoginModel();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.ReturnUserByNamePassword(checkUser));
            }

            foreach (DataRow ms in dt.Rows)
            {
                loginModel = LoginModel.ToObject(ms);
            }

            return(loginModel.userImdbPass);
        }
        public string ReturnUserIdByUserPass(string userPass)
        {
            DataTable dt     = new DataTable();
            string    userId = "";

            if (userPass.Equals(string.Empty) || userPass.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            userPass = ComputeHash.ComputeNewHash(userPass);

            UserModel userModel = new UserModel();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(UserStringsMySql.ReturnUserIdByUserPass(userPass));
            }
            foreach (DataRow ms in dt.Rows)
            {
                userId = ms[0].ToString();
            }

            return(userId);
        }