public static void FillObject(Business.DataObjectForumTopicItem item, SqlDataReader sqlReader)
{
if (sqlReader["ReferencedItemId"] != DBNull.Value)
{
item.ReferencedItemId = (Guid)sqlReader["ReferencedItemId"];
}
item.ItemStatus = (_4screen.CSB.Common.CommentStatus)Enum.Parse(typeof(_4screen.CSB.Common.CommentStatus), sqlReader["Status"].ToString());
}
private static void SetParameters(Business.DataObjectForumTopicItem item, SqlParameterCollection parameters)
{
if (item.ReferencedItemId.HasValue)
{
parameters.AddWithValue("@ReferencedItemId", item.ReferencedItemId.Value);
}
else
{
parameters.AddWithValue("@ReferencedItemId", DBNull.Value);
}
parameters.AddWithValue("@Status", item.ItemStatus);
}
public static string GetUpdateSQL(Business.DataObjectForumTopicItem item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_ForumTopicItem SET [ReferencedItemId] = @ReferencedItemId, [Status] = @Status");
}
public static string GetInsertSQL(Business.DataObjectForumTopicItem item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_ForumTopicItem ([OBJ_ID],[ReferencedItemId],[Status]) VALUES (@OBJ_ID,@ReferencedItemId,@Status)");
}
