/// <summary> /// Updates the localized topic /// </summary> /// <param name="topicLocalizedId">The localized topic identifier</param> /// <param name="topicId">The topic identifier</param> /// <param name="languageId">The language identifier</param> /// <param name="title">The title</param> /// <param name="body">The body</param> /// <param name="createdOn">The date and time of instance creation</param> /// <param name="updatedOn">The date and time of instance update</param> /// <param name="metaKeywords">The meta keywords</param> /// <param name="metaDescription">The meta description</param> /// <param name="metaTitle">The meta title</param> /// <returns>Localized topic</returns> public override DBLocalizedTopic UpdateLocalizedTopic(int topicLocalizedId, int topicId, int languageId, string title, string body, DateTime createdOn, DateTime updatedOn, string metaKeywords, string metaDescription, string metaTitle) { DBLocalizedTopic item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedUpdate"); db.AddInParameter(dbCommand, "TopicLocalizedID", DbType.Int32, topicLocalizedId); db.AddInParameter(dbCommand, "TopicID", DbType.Int32, topicId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); db.AddInParameter(dbCommand, "Title", DbType.String, title); db.AddInParameter(dbCommand, "Body", DbType.String, body); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn); db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, updatedOn); db.AddInParameter(dbCommand, "MetaKeywords", DbType.String, metaKeywords); db.AddInParameter(dbCommand, "MetaDescription", DbType.String, metaDescription); db.AddInParameter(dbCommand, "MetaTitle", DbType.String, metaTitle); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetLocalizedTopicById(topicLocalizedId); } return(item); }
private DBLocalizedTopic GetLocalizedTopicFromReader(IDataReader dataReader) { DBLocalizedTopic localizedTopic = new DBLocalizedTopic(); localizedTopic.TopicLocalizedID = NopSqlDataHelper.GetInt(dataReader, "TopicLocalizedID"); localizedTopic.TopicID = NopSqlDataHelper.GetInt(dataReader, "TopicID"); localizedTopic.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); localizedTopic.Title = NopSqlDataHelper.GetString(dataReader, "Title"); localizedTopic.Body = NopSqlDataHelper.GetString(dataReader, "Body"); localizedTopic.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); localizedTopic.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); localizedTopic.ShowOnHomePage = NopSqlDataHelper.GetInt(dataReader, "ShowOnHomePage"); return(localizedTopic); }
private DBLocalizedTopic GetLocalizedTopicFromReader(IDataReader dataReader) { var item = new DBLocalizedTopic(); item.TopicLocalizedId = NopSqlDataHelper.GetInt(dataReader, "TopicLocalizedID"); item.TopicId = NopSqlDataHelper.GetInt(dataReader, "TopicID"); item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); item.Title = NopSqlDataHelper.GetString(dataReader, "Title"); item.Body = NopSqlDataHelper.GetString(dataReader, "Body"); item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); item.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn"); item.MetaDescription = NopSqlDataHelper.GetString(dataReader, "MetaDescription"); item.MetaKeywords = NopSqlDataHelper.GetString(dataReader, "MetaKeywords"); item.MetaTitle = NopSqlDataHelper.GetString(dataReader, "MetaTitle"); return(item); }
/// <summary> /// Gets all topics shows on the home page /// </summary> /// <returns>Localized topic collection</returns> public override DBLocalizedTopicCollection TopicLocalizedLoadAllOnHomePage() { DBLocalizedTopicCollection localizedTopics = new DBLocalizedTopicCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedLoadAllOnHomePage"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBLocalizedTopic localizedTopic = GetLocalizedTopicFromReader(dataReader); localizedTopics.Add(localizedTopic); } } return(localizedTopics); }
/// <summary> /// Gets a localized topic by name and language identifier /// </summary> /// <param name="name">Topic name</param> /// <param name="languageId">Language identifier</param> /// <returns>Localized topic</returns> public override DBLocalizedTopic GetLocalizedTopic(string name, int languageId) { DBLocalizedTopic item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedLoadByNameAndLanguageID"); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetLocalizedTopicFromReader(dataReader); } } return(item); }
/// <summary> /// Gets all localized topics /// </summary> /// <param name="TopicName">Topic name</param> /// <returns>Localized topic collection</returns> public override DBLocalizedTopicCollection GetAllLocalizedTopics(string TopicName) { DBLocalizedTopicCollection localizedTopics = new DBLocalizedTopicCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedLoadAllByName"); db.AddInParameter(dbCommand, "Name", DbType.String, TopicName); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBLocalizedTopic localizedTopic = GetLocalizedTopicFromReader(dataReader); localizedTopics.Add(localizedTopic); } } return(localizedTopics); }
/// <summary> /// Gets a localized topic by parent TopicID and language identifier /// </summary> /// <param name="TopicID">The topic identifier</param> /// <param name="LanguageID">Language identifier</param> /// <returns>Localized topic</returns> public override DBLocalizedTopic GetLocalizedTopic(int TopicID, int LanguageID) { DBLocalizedTopic localizedTopic = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedLoadByTopicIDAndLanguageID"); db.AddInParameter(dbCommand, "TopicID", DbType.Int32, TopicID); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { localizedTopic = GetLocalizedTopicFromReader(dataReader); } } return(localizedTopic); }
/// <summary> /// Gets a localized topic by identifier /// </summary> /// <param name="localizedTopicId">Localized topic identifier</param> /// <returns>Localized topic</returns> public override DBLocalizedTopic GetLocalizedTopicById(int localizedTopicId) { DBLocalizedTopic item = null; if (localizedTopicId == 0) { return(item); } Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedLoadByPrimaryKey"); db.AddInParameter(dbCommand, "TopicLocalizedID", DbType.Int32, localizedTopicId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetLocalizedTopicFromReader(dataReader); } } return(item); }
/// <summary> /// Updates the localized topic /// </summary> /// <param name="TopicLocalizedID">The localized topic identifier</param> /// <param name="TopicID">The topic identifier</param> /// <param name="LanguageID">The language identifier</param> /// <param name="Title">The title</param> /// <param name="Body">The body</param> /// <param name="CreatedOn">The date and time of instance creation</param> /// <param name="UpdatedOn">The date and time of instance update</param> /// <param name="ShowOnHomePage">The state of showing topic on the main page</param> /// <returns>Localized topic</returns> public override DBLocalizedTopic UpdateLocalizedTopic(int TopicLocalizedID, int TopicID, int LanguageID, string Title, string Body, DateTime CreatedOn, DateTime UpdatedOn, int ShowOnHomePage) { DBLocalizedTopic localizedTopic = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TopicLocalizedUpdate"); db.AddInParameter(dbCommand, "TopicLocalizedID", DbType.Int32, TopicLocalizedID); db.AddInParameter(dbCommand, "TopicID", DbType.Int32, TopicID); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); db.AddInParameter(dbCommand, "Title", DbType.String, Title); db.AddInParameter(dbCommand, "Body", DbType.String, Body); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn); db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, UpdatedOn); db.AddInParameter(dbCommand, "ShowOnHomePage", DbType.Int32, ShowOnHomePage); if (db.ExecuteNonQuery(dbCommand) > 0) { localizedTopic = GetLocalizedTopicByID(TopicLocalizedID); } return(localizedTopic); }