/// <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;
}
