/// <summary> /// Return collection /// </summary> public static ExtendedCollection<Comment> GetDataFields(IDataReader dr) { ExtendedCollection<Comment> list = new ExtendedCollection<Comment>(); while (dr.Read()) { Comment item = new Comment(); if (dr["Author"] != DBNull.Value) { item.Author = (string)dr["Author"]; } if (dr["Email"] != DBNull.Value) { item.Email = (string)dr["Email"]; } if (dr["Date"] != DBNull.Value) { item.Date = (DateTime)(dr["Date"]); } if (dr["Comments"] != DBNull.Value) { item.Comments = (string)dr["Comments"]; } if (dr["UID"] != DBNull.Value) { item.UID = (int)dr["UID"]; } list.Add(item); } dr.Close(); return list; }
/// <summary> /// Update Lyric Comment /// </summary> /// <returns></returns> public int UpdateLyricComments(Comment comment) { SqlParameter prmID = new SqlParameter("@ID", SqlDbType.Int, 4); prmID.Value = comment.ID; SqlParameter prmComment = new SqlParameter("@Comment", SqlDbType.VarChar, 350); prmComment.Value = comment.Comments; return DataAccess.Execute("UpdateLyricComments", prmID, prmComment); }
/// <summary> /// Insert article comments /// </summary> /// <returns></returns> public int InsertArticleComment(Comment comment) { SqlParameter prmCommentID = new SqlParameter("@ID", SqlDbType.Int, 4); prmCommentID.Value = comment.ID; SqlParameter prmAuthor = new SqlParameter("@Author", SqlDbType.VarChar, 50); prmAuthor.Value = comment.Author; SqlParameter prmEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50); prmEmail.Value = comment.Email; SqlParameter prmComment = new SqlParameter("@Comments", SqlDbType.VarChar, 350); prmComment.Value = comment.Comments; SqlParameter prmUserID = new SqlParameter("@UserID", SqlDbType.Int, 4); prmUserID.Value = comment.UID; return DataAccess.Execute("spInsertArticleComment", prmCommentID, prmAuthor, prmEmail, prmComment, prmUserID); }
/// <summary> /// Delete individual article comment /// </summary> /// <returns></returns> public int DeleteArticleComment(Comment comment) { SqlParameter prmID = new SqlParameter("@ID", SqlDbType.Int, 4); prmID.Value = comment.ID; SqlParameter prmAID = new SqlParameter("@AID", SqlDbType.Int, 4); prmAID.Value = comment.RECID; return DataAccess.Execute("AdminDeleteArticleComments", prmID, prmAID); }
/// <summary> /// Delete Lyric Comment /// </summary> /// <returns></returns> public int AdminDeleteLyricComments(Comment comment) { SqlParameter prmID = new SqlParameter("@COMID", SqlDbType.Int, 4); prmID.Value = comment.ID; SqlParameter prmLyricID = new SqlParameter("@RecipeID", SqlDbType.Int, 4); prmLyricID.Value = comment.RECID; return DataAccess.Execute("AdminDeleteLyricComments", prmID, prmLyricID); }
public virtual int Update(Comment comment) { return 0; }
public virtual int Delete(Comment comment) { return 0; }
public virtual int Add(Comment comment) { return 0; }
/// <summary> /// Perform Update /// </summary> /// <returns></returns> public override int Update(Comment comment) { return Blogic.ActionProcedureDataProvider.UpdateLyricComments(comment); }
/// <summary> /// Perform Delete /// </summary> /// <returns></returns> public override int Delete(Comment comment) { return Blogic.ActionProcedureDataProvider.AdminDeleteLyricComments(comment); }
/// <summary> /// Perform Insert to Database /// </summary> /// <returns></returns> public override int Add(Comment comment) { return Blogic.ActionProcedureDataProvider.AddComment(comment); }
/// <summary> /// Perform Update /// </summary> /// <returns></returns> public override int Update(Comment comment) { return Blogic.ActionProcedureDataProvider.UpdateArticleComment(comment); }
/// <summary> /// Perform Insert to Database /// </summary> /// <returns></returns> public override int Add(Comment comment) { return Blogic.ActionProcedureDataProvider.InsertArticleComment(comment); }