/// <summary> /// Updates a category /// </summary> public override bool UpdateCategory(CategoryDetails category) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("wa_Articles_UpdateCategory", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = category.ID; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = category.Title; cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = category.Importance; cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = category.ImageUrl; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = category.Description; cmd.Parameters.Add("@IsArticles", SqlDbType.Bit).Value = category.IsArticles; cn.Open(); int ret = ExecuteNonQuery(cmd); return (ret == 1); } }
public abstract int InsertCategory(CategoryDetails category);
/// <summary> /// Creates a new category /// </summary> public override int InsertCategory(CategoryDetails category) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("wa_Articles_InsertCategory", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = category.AddedDate; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = category.AddedBy; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = category.Title; cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = category.Importance; cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = category.ImageUrl; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = category.Description; cmd.Parameters.Add("@IsArticles", SqlDbType.Bit).Value = category.IsArticles; cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return (int)cmd.Parameters["@CategoryID"].Value; } }
protected virtual CategoryDetails GetCategoryFromReader(IDataReader reader) { var newCategoryDetails = new CategoryDetails( (int)reader["CategoryID"], (DateTime)reader["AddedDate"], reader["AddedBy"].ToString(), reader["Title"].ToString(), (int)reader["Importance"], reader["Description"].ToString(), reader["ImageUrl"].ToString(), (bool)reader["IsArticles"]); if (reader["PublishedArticlesCount"] != DBNull.Value && reader["PublishedArticlesCount"] != null) { newCategoryDetails.PublishedArticlesCount = (int)reader["PublishedArticlesCount"]; } if (reader["PublishedProgramsCount"] != DBNull.Value && reader["PublishedProgramsCount"] != null) { newCategoryDetails.PublishedProgramsCount = (int)reader["PublishedProgramsCount"]; } return newCategoryDetails; }
public abstract bool UpdateCategory(CategoryDetails category);
/// <summary> /// Returns a Category object filled with the data taken from the input CategoryDetails /// </summary> private static Category GetCategoryFromCategoryDetails(CategoryDetails record) { if (record == null) return null; else { var newCategory = new Category(record.ID, record.AddedDate, record.AddedBy, record.Title, record.Importance, record.Description, record.ImageUrl, record.IsArticles); newCategory.PublishedArticlesCount = record.PublishedArticlesCount; newCategory.PublishedProgramsCount = record.PublishedProgramsCount; return newCategory; } }
/// <summary> /// Updates an existing category /// </summary> public static bool UpdateCategory(int id, string title, int importance, string description, string imageUrl, bool isArticles) { CategoryDetails record = new CategoryDetails(id, DateTime.Now, "", title, importance, description, imageUrl, isArticles); bool ret = SiteProvider.Articles.UpdateCategory(record); BizObject.PurgeCacheItems("articles_categor"); return ret; }
/// <summary> /// Creates a new category /// </summary> public static int InsertCategory(string title, int importance, string description, string imageUrl, bool isArticles) { CategoryDetails record = new CategoryDetails(0, DateTime.Now, BizObject.CurrentUserName, title, importance, description, imageUrl, isArticles); int ret = SiteProvider.Articles.InsertCategory(record); BizObject.PurgeCacheItems("articles_categor"); return ret; }