/// <summary>
        /// Updates ONE single User (PUT)
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public void UpdateUser(int userId)
        {
            UserViewModel item;
            DAL           objDAL = new DAL();

            string querySql = $"update clients set " +
                              $"Name = '{Username.ToString()}'," +
                              $"Password = '******'," +
                              $"Email = '{Email.ToString()}'," +
                              $"CreatedAt = '{DateTime.Parse(CreatedAt.ToString()).ToString("yyyy/MM/dd")}'," +
                              $"LastOrder = '{DateTime.Parse(LastOrder.ToString()).ToString("yyyy/MM/dd")}'," +
                              $"UrlImg = '{UrlImg.ToString()}'," +
                              $"Phone = '{Phone.ToString()}' " +
                              $"where UserId = {userId.ToString()}";

            objDAL.ExecutaComandoSQL(querySql);
        }
        //public virtual OrderViewModel Order { get; set; }

        #endregion

        #region HTTP Methods (GET/POST/PUT/DELETE)

        /// <summary>
        /// Registrar um novo usuário (POST)
        /// </summary>
        public void RegisterUser()
        {
            DAL objDAL = new DAL();

            //$ -> interpolação de strings
            string stringSql = $"insert into clients (" +
                               $" Name," +
                               $" Password," +
                               $" Email," +
                               $" CreatedAt," +
                               $" LastOrder," +
                               $" UrlImg," +
                               $" Phone)" +
                               $"values (" +
                               $"'{Username}'," +
                               $"'{Password}'," +
                               $"'{Email}'," +
                               $"'{DateTime.Parse(CreatedAt.ToString()).ToString("yyyy/MM/dd")}'," +
                               $"'{DateTime.Parse(LastOrder.ToString()).ToString("yyyy/MM/dd")}'," +
                               $"'{UrlImg}'," +
                               $"'{Phone}') ";

            objDAL.ExecutaComandoSQL(stringSql);
        }