public string PutArtist(clsBrand prArtist)

        { // update
            try

            {
                int lcRecCount = clsDbConnection.Execute(
                    "UPDATE Brand SET brand_description = @brandDescription WHERE brand_name = @brandName",
                    prepareArtistParameters(prArtist));
                if (lcRecCount == 1)
                {
                    return("One brand updated");
                }

                else
                {
                    return("Unexpected brand update count: " + lcRecCount);
                }
            }

            catch (Exception ex)

            {
                return(ex.GetBaseException().Message);
            }
        }
        private Dictionary <string, object> prepareArtistParameters(clsBrand prArtist)

        {
            Dictionary <string, object> par = new Dictionary <string, object>(3);

            par.Add("brandName", prArtist.BrandName);
            par.Add("brandDescription", prArtist.BrandDescription);
            //par.Add("Phone", prArtist.Phone);
            return(par);
        }