private Dictionary <string, object> prepareCategoryParameters(clsCategory prCategory) { Dictionary <string, object> par = new Dictionary <string, object>(2); par.Add("CategoryName", prCategory.CategoryName); par.Add("CategoryDescription", prCategory.CategoryDescription); return(par); }
public string PutCategory(clsCategory prCategory) { //update try { int lcRecCount = clsDbConnection.Execute( "UPDATE category SET CategoryDescription = @CategoryDescription WHERE CategoryName = @CategoryName", prepareCategoryParameters(prCategory)); if (lcRecCount == 1) { return("One category updated"); } else { return("Unexpected category update count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }