private DBNewsComment GetNewsCommentFromReader(IDataReader dataReader)
{
DBNewsComment newsComment = new DBNewsComment();
newsComment.NewsCommentID = NopSqlDataHelper.GetInt(dataReader, "NewsCommentID");
newsComment.NewsID = NopSqlDataHelper.GetInt(dataReader, "NewsID");
newsComment.CustomerID = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
newsComment.Title = NopSqlDataHelper.GetString(dataReader, "Title");
newsComment.Comment = NopSqlDataHelper.GetString(dataReader, "Comment");
newsComment.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(newsComment);
}
private DBNewsComment GetNewsCommentFromReader(IDataReader dataReader)
{
var item = new DBNewsComment();
item.NewsCommentId = NopSqlDataHelper.GetInt(dataReader, "NewsCommentID");
item.NewsId = NopSqlDataHelper.GetInt(dataReader, "NewsID");
item.CustomerId = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
item.IPAddress = NopSqlDataHelper.GetString(dataReader, "IPAddress");
item.Title = NopSqlDataHelper.GetString(dataReader, "Title");
item.Comment = NopSqlDataHelper.GetString(dataReader, "Comment");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
return(item);
}
/// <summary>
/// Gets a news comment
/// </summary>
/// <param name="newsCommentId">News comment identifer</param>
/// <returns>News comment</returns>
public override DBNewsComment GetNewsCommentById(int newsCommentId)
{
DBNewsComment item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsCommentLoadByPrimaryKey");
db.AddInParameter(dbCommand, "NewsCommentID", DbType.Int32, newsCommentId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetNewsCommentFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Gets all news comments
/// </summary>
/// <returns>News comment collection</returns>
public override DBNewsCommentCollection GetAllNewsComments()
{
DBNewsCommentCollection newsCommentCollection = new DBNewsCommentCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsCommentLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBNewsComment newsComment = GetNewsCommentFromReader(dataReader);
newsCommentCollection.Add(newsComment);
}
}
return(newsCommentCollection);
}
/// <summary>
/// Gets a news comment collection by news identifier
/// </summary>
/// <param name="NewsID">The news identifier</param>
/// <returns>News comment collection</returns>
public override DBNewsCommentCollection GetNewsCommentsByNewsID(int NewsID)
{
DBNewsCommentCollection newsCommentCollection = new DBNewsCommentCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsCommentLoadByNewsID");
db.AddInParameter(dbCommand, "NewsID", DbType.Int32, NewsID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBNewsComment newsComment = GetNewsCommentFromReader(dataReader);
newsCommentCollection.Add(newsComment);
}
}
return(newsCommentCollection);
}
/// <summary>
/// Inserts a news comment
/// </summary>
/// <param name="NewsID">The news identifier</param>
/// <param name="CustomerID">The customer identifier</param>
/// <param name="Title">The title</param>
/// <param name="Comment">The comment</param>
/// <param name="CreatedOn">The date and time of instance creation</param>
/// <returns>News comment</returns>
public override DBNewsComment InsertNewsComment(int NewsID, int CustomerID, string Title,
string Comment, DateTime CreatedOn)
{
DBNewsComment newsComment = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsCommentInsert");
db.AddOutParameter(dbCommand, "NewsCommentID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "NewsID", DbType.Int32, NewsID);
db.AddInParameter(dbCommand, "CustomerID", DbType.Int32, CustomerID);
db.AddInParameter(dbCommand, "Title", DbType.String, Title);
db.AddInParameter(dbCommand, "Comment", DbType.String, Comment);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int NewsCommentID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@NewsCommentID"));
newsComment = GetNewsCommentByID(NewsCommentID);
}
return(newsComment);
}
/// <summary>
/// Inserts a news comment
/// </summary>
/// <param name="newsId">The news identifier</param>
/// <param name="customerId">The customer identifier</param>
/// <param name="ipAddress">The IP address</param>
/// <param name="title">The title</param>
/// <param name="comment">The comment</param>
/// <param name="createdOn">The date and time of instance creation</param>
/// <returns>News comment</returns>
public override DBNewsComment InsertNewsComment(int newsId, int customerId, string ipAddress,
string title, string comment, DateTime createdOn)
{
DBNewsComment item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsCommentInsert");
db.AddOutParameter(dbCommand, "NewsCommentID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "NewsID", DbType.Int32, newsId);
db.AddInParameter(dbCommand, "CustomerID", DbType.Int32, customerId);
db.AddInParameter(dbCommand, "IPAddress", DbType.String, ipAddress);
db.AddInParameter(dbCommand, "Title", DbType.String, title);
db.AddInParameter(dbCommand, "Comment", DbType.String, comment);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int newsCommentId = Convert.ToInt32(db.GetParameterValue(dbCommand, "@NewsCommentID"));
item = GetNewsCommentById(newsCommentId);
}
return(item);
}
