public static bool Edit(Category cat)
{
return DataAccess.CreateInstance().EditCategory(cat);
}
public static Collection<Category> CreateCategoriesFromReader(SqlDataReader reader)
{
Collection<Category> catlist = new Collection<Category>();
if (reader.HasRows)
{
while (reader.Read())
{
Category c = new Category();
c.Id = Convert.ToInt32(reader["Id"]);
c.Name = Convert.ToString(reader["Name"]);
c.Slug = Convert.ToString(reader["Slug"]);
catlist.Add(c);
}
}
return catlist;
}
public bool EditCategory(Category cat)
{
int result;
using (SqlConnection connection = this.GetConnection())
{
connection.Open();
SqlCommand sc = new SqlCommand("EditCategory", connection);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.AddWithValue("CategoryId", cat.Id);
sc.Parameters.AddWithValue("Name", cat.Name);
sc.Parameters.AddWithValue("Slug", cat.Slug);
result = sc.ExecuteNonQuery();
}
return result == 1;
}
