public static void FillObject(Business.DataObjectVideo item, SqlDataReader sqlReader) { item.OriginalFormat = (_4screen.CSB.Common.VideoFormat)Enum.Parse(typeof(_4screen.CSB.Common.VideoFormat), sqlReader["OriginalFormat"].ToString()); item.Width = (int)sqlReader["Width"]; item.Height = (int)sqlReader["Height"]; item.SizeByte = (int)sqlReader["SizeByte"]; item.DurationSecond = (int)sqlReader["DurationSecond"]; if (sqlReader["OriginalLocation"] != DBNull.Value) { item.OriginalLocation = sqlReader["OriginalLocation"].ToString(); } if (sqlReader["ConvertMessage"] != DBNull.Value) { item.ConvertMessage = sqlReader["ConvertMessage"].ToString(); } item.External = (bool)sqlReader["External"]; if (sqlReader["URLReferenced"] != DBNull.Value) { item.URLReferenced = sqlReader["URLReferenced"].ToString(); } item.AspectRatio = decimal.Parse(sqlReader["AspectRatio"].ToString()); if (sqlReader["TypeReferenced"] != DBNull.Value) { item.TypeReferenced = sqlReader["TypeReferenced"].ToString(); } if (sqlReader["Site"] != DBNull.Value) { item.Site = sqlReader["Site"].ToString(); } }
private static void SetParameters(Business.DataObjectVideo item, SqlParameterCollection parameters) { parameters.AddWithValue("@OriginalFormat", item.OriginalFormat); parameters.AddWithValue("@Width", item.Width); parameters.AddWithValue("@Height", item.Height); parameters.AddWithValue("@SizeByte", item.SizeByte); parameters.AddWithValue("@DurationSecond", item.DurationSecond); if (!string.IsNullOrEmpty(item.Location)) { parameters.AddWithValue("@Location", item.Location); } else { parameters.AddWithValue("@Location", DBNull.Value); } if (!string.IsNullOrEmpty(item.OriginalLocation)) { parameters.AddWithValue("@OriginalLocation", item.OriginalLocation); } else { parameters.AddWithValue("@OriginalLocation", DBNull.Value); } if (!string.IsNullOrEmpty(item.ConvertMessage)) { parameters.AddWithValue("@ConvertMessage", item.ConvertMessage); } else { parameters.AddWithValue("@ConvertMessage", DBNull.Value); } parameters.AddWithValue("@External", item.External); if (!string.IsNullOrEmpty(item.URLReferenced)) { parameters.AddWithValue("@URLReferenced", item.URLReferenced); } else { parameters.AddWithValue("@URLReferenced", DBNull.Value); } parameters.AddWithValue("@AspectRatio", item.AspectRatio); if (!string.IsNullOrEmpty(item.TypeReferenced)) { parameters.AddWithValue("@TypeReferenced", item.TypeReferenced); } else { parameters.AddWithValue("@TypeReferenced", DBNull.Value); } if (!string.IsNullOrEmpty(item.Site)) { parameters.AddWithValue("@Site", item.Site); } else { parameters.AddWithValue("@Site", DBNull.Value); } }
public static string GetUpdateSQL(Business.DataObjectVideo item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("UPDATE hiobj_Video SET [Width] = @Width, [Height] = @Height, [AspectRatio] = @AspectRatio, [SizeByte] = @SizeByte, [External] = @External, [URLReferenced] = @URLReferenced, [TypeReferenced] = @TypeReferenced, [Site] = @Site, [OriginalLocation] = @OriginalLocation, [ConvertMessage] = @ConvertMessage"); }
public static string GetInsertSQL(Business.DataObjectVideo item, SqlParameterCollection parameters) { SetParameters(item, parameters); return("INSERT INTO hiobj_Video ([OBJ_ID],[Width],[Height],[AspectRatio],[SizeByte],[External],[URLReferenced],[TypeReferenced],[Site],[OriginalLocation],[ConvertMessage]) VALUES (@OBJ_ID,@Width,@Height,@AspectRatio,@SizeByte,@External,@URLReferenced,@TypeReferenced,@Site,@OriginalLocation,@ConvertMessage)"); }