private static void SetParameters(Business.DataObjectNews item, SqlParameterCollection parameters) { if (!string.IsNullOrEmpty(item.NewsText)) { parameters.AddWithValue("@NewsText", item.NewsText); } else { parameters.AddWithValue("@NewsText", DBNull.Value); } if (!string.IsNullOrEmpty(item.newsTextLinked)) { parameters.AddWithValue("@NewsTextLinked", item.newsTextLinked); } else { parameters.AddWithValue("@NewsTextLinked", DBNull.Value); } if (item.ReferenceURL != null) { parameters.AddWithValue("@ReferenceURL", item.ReferenceURL.ToString()); } else { parameters.AddWithValue("@ReferenceURL", DBNull.Value); } parameters.AddWithValue("@Links", item.newsLinksXml.OuterXml); }
public static void FillObject(Business.DataObjectNews item, SqlDataReader sqlReader) { if (sqlReader["NewsText"] != DBNull.Value) { item.NewsText = sqlReader["NewsText"].ToString(); } if (sqlReader["NewsTextLinked"] != DBNull.Value) { item.NewsTextLinked = sqlReader["NewsTextLinked"].ToString(); } if (sqlReader["ReferenceURL"] != DBNull.Value) { item.ReferenceURL = new Uri(sqlReader["ReferenceURL"].ToString()); } if (sqlReader["Links"] != DBNull.Value) { item.newsLinksXml.LoadXml(sqlReader["Links"].ToString()); } }
public static string GetUpdateSQL(Business.DataObjectNews item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("UPDATE hiobj_News SET [NewsText] = @NewsText, [NewsTextLinked] = @NewsTextLinked, [ReferenceURL] = @ReferenceURL, [Links] = @Links"); }
public static string GetInsertSQL(Business.DataObjectNews item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("INSERT INTO hiobj_News ([OBJ_ID],[NewsText],[NewsTextLinked],[ReferenceURL],[Links]) VALUES (@OBJ_ID,@NewsText,@NewsTextLinked,@ReferenceURL,@Links)"); }