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