public static void FillObject(Business.DataObjectEvent item, SqlDataReader sqlReader)
{
if (sqlReader["Content"] != DBNull.Value)
{
item.Content = sqlReader["Content"].ToString();
}
if (sqlReader["Time"] != DBNull.Value)
{
item.Time = sqlReader["Time"].ToString();
}
if (sqlReader["Age"] != DBNull.Value)
{
item.Age = sqlReader["Age"].ToString();
}
if (sqlReader["Price"] != DBNull.Value)
{
item.Price = sqlReader["Price"].ToString();
}
if (sqlReader["EventTypeIds"] != DBNull.Value)
{
item.EventTypeIds = sqlReader["EventTypeIds"].ToString();
}
if (sqlReader["MusicStyleIds"] != DBNull.Value)
{
item.MusicStyleIds = sqlReader["MusicStyleIds"].ToString();
}
if (sqlReader["JoinedUser"] != DBNull.Value)
{
item.JoinedUser = sqlReader["JoinedUser"].ToString();
}
}
private static void SetParameters(Business.DataObjectEvent item, SqlParameterCollection parameters)
{
if (!string.IsNullOrEmpty(item.Content))
{
parameters.AddWithValue("@Content", item.Content);
}
else
{
parameters.AddWithValue("@Content", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Time))
{
parameters.AddWithValue("@Time", item.Time);
}
else
{
parameters.AddWithValue("@Time", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Age))
{
parameters.AddWithValue("@Age", item.Age);
}
else
{
parameters.AddWithValue("@Age", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Price))
{
parameters.AddWithValue("@Price", item.Price);
}
else
{
parameters.AddWithValue("@Price", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.EventTypeIds))
{
parameters.AddWithValue("@EventTypeIds", item.EventTypeIds);
}
else
{
parameters.AddWithValue("@EventTypeIds", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.MusicStyleIds))
{
parameters.AddWithValue("@MusicStyleIds", item.MusicStyleIds);
}
else
{
parameters.AddWithValue("@MusicStyleIds", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.JoinedUser))
{
parameters.AddWithValue("@JoinedUser", item.JoinedUser);
}
else
{
parameters.AddWithValue("@JoinedUser", DBNull.Value);
}
}
private static void SetParameters(Business.DataObjectEvent item, SqlParameterCollection parameters)
{
if (!string.IsNullOrEmpty(item.Content))
{
parameters.AddWithValue("@Content", item.Content);
}
else
{
parameters.AddWithValue("@Content", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Time))
{
parameters.AddWithValue("@Time", item.Time);
}
else
{
parameters.AddWithValue("@Time", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Age))
{
parameters.AddWithValue("@Age", item.Age);
}
else
{
parameters.AddWithValue("@Age", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.Price))
{
parameters.AddWithValue("@Price", item.Price);
}
else
{
parameters.AddWithValue("@Price", DBNull.Value);
}
if (item.Website != null)
{
parameters.AddWithValue("@Website", item.Website.ToString());
}
else
{
parameters.AddWithValue("@Website", DBNull.Value);
}
}
public static void FillObject(Business.DataObjectEvent item, SqlDataReader sqlReader)
{
if (sqlReader["Content"] != DBNull.Value)
{
item.Content = sqlReader["Content"].ToString();
}
if (sqlReader["Time"] != DBNull.Value)
{
item.Time = sqlReader["Time"].ToString();
}
if (sqlReader["Age"] != DBNull.Value)
{
item.Age = sqlReader["Age"].ToString();
}
if (sqlReader["Price"] != DBNull.Value)
{
item.Price = sqlReader["Price"].ToString();
}
if (sqlReader["Website"] != DBNull.Value)
{
item.Website = new Uri(sqlReader["Website"].ToString());
}
}
public static string GetUpdateSQL(Business.DataObjectEvent item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_Event SET [Content] = @Content, [Time] = @Time, [Age] = @Age, [Price] = @Price, [EventTypeIds] = @EventTypeIds, [MusicStyleIds] = @MusicStyleIds, [JoinedUser] = @JoinedUser");
}
public static string GetInsertSQL(Business.DataObjectEvent item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_Event ([OBJ_ID],[Content],[Time],[Age],[Price],[EventTypeIds],[MusicStyleIds],[JoinedUser]) VALUES (@OBJ_ID,@Content,@Time,@Age,@Price,@EventTypeIds,@MusicStyleIds,@JoinedUser)");
}
public static string GetUpdateSQL(Business.DataObjectEvent item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_Event SET [Content] = @Content, [Time] = @Time, [Age] = @Age, [Price] = @Price, [Website] = @Website");
}
public static string GetInsertSQL(Business.DataObjectEvent item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_Event ([OBJ_ID],[Content],[Time],[Age],[Price],[Website]) VALUES (@OBJ_ID,@Content,@Time,@Age,@Price,@Website)");
}
