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