private DBManufacturerLocalized GetManufacturerLocalizedFromReader(IDataReader dataReader) { var item = new DBManufacturerLocalized(); item.ManufacturerLocalizedId = NopSqlDataHelper.GetInt(dataReader, "ManufacturerLocalizedID"); item.ManufacturerId = NopSqlDataHelper.GetInt(dataReader, "ManufacturerID"); 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 manufacturer by manufacturer id and language id /// </summary> /// <param name="manufacturerId">Manufacturer identifier</param> /// <param name="languageId">Language identifier</param> /// <returns>Manufacturer content</returns> public override DBManufacturerLocalized GetManufacturerLocalizedByManufacturerIdAndLanguageId(int manufacturerId, int languageId) { DBManufacturerLocalized item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerLocalizedLoadByManufacturerIDAndLanguageID"); db.AddInParameter(dbCommand, "ManufacturerID", DbType.Int32, manufacturerId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetManufacturerLocalizedFromReader(dataReader); } } return(item); }
/// <summary> /// Update a localized manufacturer /// </summary> /// <param name="manufacturerLocalizedId">Localized manufacturer identifier</param> /// <param name="manufacturerId">Manufacturer 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>Manufacturer content</returns> public override DBManufacturerLocalized UpdateManufacturerLocalized(int manufacturerLocalizedId, int manufacturerId, int languageId, string name, string description, string metaKeywords, string metaDescription, string metaTitle, string seName) { DBManufacturerLocalized item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ManufacturerLocalizedUpdate"); db.AddInParameter(dbCommand, "ManufacturerLocalizedID", DbType.Int32, manufacturerLocalizedId); db.AddInParameter(dbCommand, "ManufacturerID", DbType.Int32, manufacturerId); 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 = GetManufacturerLocalizedById(manufacturerId); } return(item); }