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);
}
}
