public static bool UpdateCategory(int categoryID, string categoryName, string description)
{
bool returnValue;
DatabaseProvider myDataBase = new DatabaseProvider();
myDataBase.AddinParameters("@CategoryID", DbType.Int32, categoryID);
myDataBase.AddinParameters("@CategoryName", DbType.String, categoryName);
myDataBase.AddinParameters("@Description", DbType.String, description);
returnValue = Convert.ToBoolean(myDataBase.ExecuteNonQuery("Update Categories SET CategoryName = @CategoryName, Description = @Description WHERE CategoryID = @CategoryID", CommandType.Text));
return(returnValue);
}
public static bool DeleteCategory(int categoryID)
{
bool returnValue;
DatabaseProvider myDatabase = new DatabaseProvider();
myDatabase.AddinParameters("@CategoryID", DbType.Int32, categoryID);
returnValue = Convert.ToBoolean(myDatabase.ExecuteNonQuery("DELETE FROM Categories WHERE CategoryID = @CategoryID", CommandType.Text));
return(returnValue);
}
public static Category GetCategoryByCategoryId(int categoryId)
{
Category newCategory = new Category();
DatabaseProvider myDatabase = new DatabaseProvider();
myDatabase.AddinParameters("@CategoryID", DbType.Int32, categoryId);
IDataReader myReader = myDatabase.ExecuteReader("SELECT * FROM Categories WHERE CategoryID = @CategoryID", CommandType.Text);
while (myReader.Read())
{
newCategory.CategoryId = myReader["CategoryID"] is DBNull ? 0 : Convert.ToInt32(myReader["CategoryID"]);
newCategory.CategoryName = myReader["CategoryName"] is DBNull ? string.Empty : myReader["CategoryName"].ToString();
newCategory.Description = myReader["Description"] is DBNull ? string.Empty : myReader["Description"].ToString();
}
return(newCategory);
}
