public static void FillObject(Business.DataObjectLocation item, SqlDataReader sqlReader)
{
if (sqlReader["Website"] != DBNull.Value)
{
item.Website = new Uri(sqlReader["Website"].ToString());
}
}
private static void SetParameters(Business.DataObjectLocation item, SqlParameterCollection parameters)
{
if (item.Website != null)
{
parameters.AddWithValue("@Website", item.Website.ToString());
}
else
{
parameters.AddWithValue("@Website", DBNull.Value);
}
}
public static string GetUpdateSQL(Business.DataObjectLocation item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_Location SET [Website] = @Website");
}
public static string GetInsertSQL(Business.DataObjectLocation item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return(@"INSERT INTO hiobj_Location (OBJ_ID,Website) VALUES (@OBJ_ID,@Website)");
}
