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)");
}
