private DBBlogPost GetBlogPostFromReader(IDataReader dataReader) { DBBlogPost blogPost = new DBBlogPost(); blogPost.BlogPostID = NopSqlDataHelper.GetInt(dataReader, "BlogPostID"); blogPost.LanguageID = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); blogPost.BlogPostTitle = NopSqlDataHelper.GetString(dataReader, "BlogPostTitle"); blogPost.BlogPostBody = NopSqlDataHelper.GetString(dataReader, "BlogPostBody"); blogPost.BlogPostAllowComments = NopSqlDataHelper.GetBoolean(dataReader, "BlogPostAllowComments"); blogPost.CreatedByID = NopSqlDataHelper.GetInt(dataReader, "CreatedByID"); blogPost.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn"); return(blogPost); }
/// <summary> /// Gets an blog post /// </summary> /// <param name="BlogPostID">Blog post identifier</param> /// <returns>Blog post</returns> public override DBBlogPost GetBlogPostByID(int BlogPostID) { DBBlogPost blogPost = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostLoadByPrimaryKey"); db.AddInParameter(dbCommand, "BlogPostID", DbType.Int32, BlogPostID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { blogPost = GetBlogPostFromReader(dataReader); } } return(blogPost); }
/// <summary> /// Gets all blog posts /// </summary> /// <param name="LanguageID">Language identifier. 0 if you want to get all news</param> /// <returns>Blog posts</returns> public override DBBlogPostCollection GetAllBlogPosts(int LanguageID) { DBBlogPostCollection blogPostCollection = new DBBlogPostCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostLoadAll"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBBlogPost blogPost = GetBlogPostFromReader(dataReader); blogPostCollection.Add(blogPost); } } return(blogPostCollection); }
/// <summary> /// Updates the blog post /// </summary> /// <param name="LanguageID">The language identifier</param> /// <param name="BlogPostID">Blog post identifier</param> /// <param name="BlogPostTitle">The blog post title</param> /// <param name="BlogPostBody">The blog post title</param> /// <param name="BlogPostAllowComments">A value indicating whether the blog post comments are allowed</param> /// <param name="CreatedByID">The user identifier who created the blog post</param> /// <param name="CreatedOn">The date and time of instance creation</param> /// <returns>Blog post</returns> public override DBBlogPost UpdateBlogPost(int BlogPostID, int LanguageID, string BlogPostTitle, string BlogPostBody, bool BlogPostAllowComments, int CreatedByID, DateTime CreatedOn) { DBBlogPost blogPost = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostUpdate"); db.AddInParameter(dbCommand, "BlogPostID", DbType.Int32, BlogPostID); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); db.AddInParameter(dbCommand, "BlogPostTitle", DbType.String, BlogPostTitle); db.AddInParameter(dbCommand, "BlogPostBody", DbType.String, BlogPostBody); db.AddInParameter(dbCommand, "BlogPostAllowComments", DbType.Boolean, BlogPostAllowComments); db.AddInParameter(dbCommand, "CreatedByID", DbType.Int32, CreatedByID); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn); if (db.ExecuteNonQuery(dbCommand) > 0) { blogPost = GetBlogPostByID(BlogPostID); } return(blogPost); }
/// <summary> /// Inserts an blog post /// </summary> /// <param name="languageId">The language identifier</param> /// <param name="blogPostTitle">The blog post title</param> /// <param name="blogPostBody">The blog post title</param> /// <param name="blogPostAllowComments">A value indicating whether the blog post comments are allowed</param> /// <param name="createdById">The user identifier who created the blog post</param> /// <param name="createdOn">The date and time of instance creation</param> /// <returns>Blog post</returns> public override DBBlogPost InsertBlogPost(int languageId, string blogPostTitle, string blogPostBody, bool blogPostAllowComments, int createdById, DateTime createdOn) { DBBlogPost item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostInsert"); db.AddOutParameter(dbCommand, "BlogPostID", DbType.Int32, 0); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); db.AddInParameter(dbCommand, "BlogPostTitle", DbType.String, blogPostTitle); db.AddInParameter(dbCommand, "BlogPostBody", DbType.String, blogPostBody); db.AddInParameter(dbCommand, "BlogPostAllowComments", DbType.Boolean, blogPostAllowComments); db.AddInParameter(dbCommand, "CreatedByID", DbType.Int32, createdById); db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn); if (db.ExecuteNonQuery(dbCommand) > 0) { int blogPostId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@BlogPostID")); item = GetBlogPostById(blogPostId); } return(item); }