private static void SetParameters(Business.DataObjectForumTopic item, SqlParameterCollection parameters) { parameters.AddWithValue("@TopicState", item.TopicState); parameters.AddWithValue("@TopicItemCount", item.TopicItemCount); if (item.LastTopicItemDate != null) { parameters.AddWithValue("@LastTopicItemDate", item.LastTopicItemDate); } else { parameters.AddWithValue("@LastTopicItemDate", DBNull.Value); } if (item.LastTopicItemID != null) { parameters.AddWithValue("@LastTopicItemID", item.LastTopicItemID); } else { parameters.AddWithValue("@LastTopicItemID", DBNull.Value); } if (item.LastTopicItemUserID != null) { parameters.AddWithValue("@LastTopicItemUserID", item.LastTopicItemUserID); } else { parameters.AddWithValue("@LastTopicItemUserID", DBNull.Value); } if (!string.IsNullOrEmpty(item.LastTopicItemNickname)) { parameters.AddWithValue("@LastTopicItemNickname", item.LastTopicItemNickname); } else { parameters.AddWithValue("@LastTopicItemNickname", DBNull.Value); } parameters.AddWithValue("@IsModerated", item.IsModerated); parameters.AddWithValue("@TopicItemCreationUsers", item.TopicItemCreationUsers); }
public static void FillObject(Business.DataObjectForumTopic item, SqlDataReader sqlReader) { item.TopicState = (Business.ForumTopicState)Enum.Parse(typeof(Business.ForumTopicState), sqlReader["TopicState"].ToString()); item.TopicItemCount = (int)sqlReader["TopicItemCount"]; if (sqlReader["LastTopicItemDate"] != DBNull.Value) { item.LastTopicItemDate = (DateTime)sqlReader["LastTopicItemDate"]; } if (sqlReader["LastTopicItemID"] != DBNull.Value) { item.LastTopicItemID = (Guid)sqlReader["LastTopicItemID"]; } if (sqlReader["LastTopicItemUserID"] != DBNull.Value) { item.LastTopicItemUserID = (Guid)sqlReader["LastTopicItemUserID"]; } if (sqlReader["LastTopicItemNickname"] != DBNull.Value) { item.LastTopicItemNickname = sqlReader["LastTopicItemNickname"].ToString(); } item.IsModerated = (bool)sqlReader["IsModerated"]; item.TopicItemCreationUsers = (_4screen.CSB.Common.CommunityUsersType)Enum.Parse(typeof(_4screen.CSB.Common.CommunityUsersType), sqlReader["TopicItemCreationUsers"].ToString()); }
public static string GetUpdateSQL(Business.DataObjectForumTopic item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("UPDATE hiobj_ForumTopic SET [TopicState] = @TopicState, [TopicItemCount] = @TopicItemCount, [LastTopicItemDate] = @LastTopicItemDate, [LastTopicItemID] = @LastTopicItemID, [LastTopicItemUserID] = @LastTopicItemUserID, [LastTopicItemNickname] = @LastTopicItemNickname, [IsModerated] = @IsModerated, [TopicItemCreationUsers] = @TopicItemCreationUsers"); }
public static string GetInsertSQL(Business.DataObjectForumTopic item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("INSERT INTO hiobj_ForumTopic ([OBJ_ID],[TopicState],[TopicItemCount],[LastTopicItemDate],[LastTopicItemID],[LastTopicItemUserID],[LastTopicItemNickname],[IsModerated],[TopicItemCreationUsers]) VALUES (@OBJ_ID,@TopicState,@TopicItemCount,@LastTopicItemDate,@LastTopicItemID,@LastTopicItemUserID,@LastTopicItemNickname,@IsModerated,@TopicItemCreationUsers)"); }