/// <summary> /// Return Recipe Comment /// </summary> public static ExtendedCollection <Comment> GetComments(int ID) { //Instantiate Action Stored Procedure object Blogic FetchData = new Blogic(); ExtendedCollection <Comment> GetComment = new ExtendedCollection <Comment>(); IDataReader dr = FetchData.GetCommentsRecipeDetail(ID); 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"]; } GetComment.Add(item); } dr.Close(); return(GetComment); FetchData = null; }