/// <summary>
/// Update a localized category
/// </summary>
/// <param name="categoryLocalizedId">Localized category identifier</param>
/// <param name="categoryId">Category identifier</param>
/// <param name="languageId">Language identifier</param>
/// <param name="name">Name text</param>
/// <param name="description">Description text</param>
/// <param name="metaKeywords">Meta keywords text</param>
/// <param name="metaDescription">Meta descriptions text</param>
/// <param name="metaTitle">Metat title text</param>
/// <param name="seName">Se Name text</param>
/// <returns>Category content</returns>
public override DBCategoryLocalized UpdateCategoryLocalized(int categoryLocalizedId,
int categoryId, int languageId, string name, string description,
string metaKeywords, string metaDescription, string metaTitle,
string seName)
{
DBCategoryLocalized item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CategoryLocalizedUpdate");
db.AddInParameter(dbCommand, "CategoryLocalizedID", DbType.Int32, categoryLocalizedId);
db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, categoryId);
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "Description", DbType.String, description);
db.AddInParameter(dbCommand, "MetaKeywords", DbType.String, metaKeywords);
db.AddInParameter(dbCommand, "MetaDescription", DbType.String, metaDescription);
db.AddInParameter(dbCommand, "MetaTitle", DbType.String, metaTitle);
db.AddInParameter(dbCommand, "SEName", DbType.String, seName);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetCategoryLocalizedById(categoryLocalizedId);
}
return(item);
}
private DBCategoryLocalized GetCategoryLocalizedFromReader(IDataReader dataReader)
{
var item = new DBCategoryLocalized();
item.CategoryLocalizedId = NopSqlDataHelper.GetInt(dataReader, "CategoryLocalizedID");
item.CategoryId = NopSqlDataHelper.GetInt(dataReader, "CategoryID");
item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID");
item.Name = NopSqlDataHelper.GetString(dataReader, "Name");
item.Description = NopSqlDataHelper.GetString(dataReader, "Description");
item.MetaKeywords = NopSqlDataHelper.GetString(dataReader, "MetaKeywords");
item.MetaDescription = NopSqlDataHelper.GetString(dataReader, "MetaDescription");
item.MetaTitle = NopSqlDataHelper.GetString(dataReader, "MetaTitle");
item.SEName = NopSqlDataHelper.GetString(dataReader, "SEName");
return(item);
}
/// <summary>
/// Gets localized category by category id and language id
/// </summary>
/// <param name="categoryId">Category identifier</param>
/// <param name="languageId">Language identifier</param>
/// <returns>Category content</returns>
public override DBCategoryLocalized GetCategoryLocalizedByCategoryIdAndLanguageId(int categoryId, int languageId)
{
DBCategoryLocalized item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CategoryLocalizedLoadByCategoryIDAndLanguageID");
db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, categoryId);
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetCategoryLocalizedFromReader(dataReader);
}
}
return(item);
}
