/// <summary>
/// Gets an IList with page of instances of KLNewsComment.
/// </summary>
/// <param name="pageNumber">The page number.</param>
/// <param name="pageSize">Size of the page.</param>
/// <param name="totalPages">total pages</param>
public static List <KLNewsComment> GetPage(int pageNumber, int pageSize, out int totalPages)
{
totalPages = 1;
IDataReader reader = DBKLNewsComment.GetPage(pageNumber, pageSize, out totalPages);
return(LoadListFromReader(reader));
}
public static List <KLNewsComment> GetPageByAuthor(int pageNumber, int pageSize, out int totalPages, int authorid, int isapproved, int newsid, int newtype, int parent)
{
totalPages = 1;
IDataReader reader = DBKLNewsComment.GetPageByAuthor(pageNumber, pageSize, out totalPages, authorid, isapproved, newsid, newtype, parent);
return(LoadListFromReader(reader));
}
/// <summary>
/// Updates this instance of KLNewsComment. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return(DBKLNewsComment.Update(
this.commentID,
this.commentParentID,
this.newsID,
this.userID,
this.name,
this.title,
this.email,
this.createDate,
this.phone,
this.comment,
this.isPublish,
this.iSDel));
}
/// <summary>
/// Persists a new instance of KLNewsComment. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
int newID = 0;
newID = DBKLNewsComment.Create(
this.commentParentID,
this.newsID,
this.userID,
this.name,
this.title,
this.email,
this.createDate,
this.phone,
this.comment,
this.isPublish,
this.iSDel);
this.commentID = newID;
return(newID > 0);
}
/// <summary>
/// Gets an instance of KLNewsComment.
/// </summary>
/// <param name="commentID"> commentID </param>
private void GetKLNewsComment(
int commentID)
{
using (IDataReader reader = DBKLNewsComment.GetOne(
commentID))
{
if (reader.Read())
{
this.commentID = Convert.ToInt32(reader["CommentID"]);
this.commentParentID = Convert.ToInt32(reader["CommentParentID"]);
this.newsID = Convert.ToInt32(reader["NewsID"]);
this.userID = Convert.ToInt32(reader["UserID"]);
this.name = reader["Name"].ToString();
this.title = reader["Title"].ToString();
this.email = reader["Email"].ToString();
this.createDate = Convert.ToDateTime(reader["CreateDate"]);
this.phone = reader["Phone"].ToString();
this.comment = reader["Comment"].ToString();
this.isPublish = Convert.ToBoolean(reader["IsPublish"]);
this.iSDel = Convert.ToBoolean(reader["ISDel"]);
}
}
}
/// <summary>
/// Gets an IList with all instances of KLNewsComment.
/// </summary>
public static List <KLNewsComment> GetAll()
{
IDataReader reader = DBKLNewsComment.GetAll();
return(LoadListFromReader(reader));
}
public static int GetCountByNewsID(int newsid)
{
return(DBKLNewsComment.GetCountByNewsID(newsid));
}
/// <summary>
/// Gets a count of KLNewsComment.
/// </summary>
public static int GetCount()
{
return(DBKLNewsComment.GetCount());
}
/// <summary>
/// Deletes an instance of KLNewsComment. Returns true on success.
/// </summary>
/// <param name="commentID"> commentID </param>
/// <returns>bool</returns>
public static bool Delete(
int commentID)
{
return(DBKLNewsComment.Delete(
commentID));
}
