public MediaGroup GetMediaGroupForWeb(int MediaID)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetMediaGroup";
cmd.Parameters.AddWithValue("@MediaID", MediaID);
DataTable dt = db.Execute(cmd);
DataRow dr = dt.Rows[0];
MediaGroup mediagroup = new MediaGroup
{
MediaID = Int32.Parse(dr["MediaID"].ToString()),
MediaTitle = dr["MediaTitle"].ToString(),
MediaType = dr["MediaType"].ToString(),
ProductID = Int32.Parse(dr["ProductID"].ToString()),
Active = bool.Parse(dr["Active"].ToString()),
DateCreated = DateTime.Parse(dr["DateCreated"].ToString())
};
db = new DB();
cmd.CommandText = "GetMediaGroupItemsForWeb";
DataTable dtitems = db.Execute(cmd);
foreach (DataRow dritems in dtitems.Rows)
{
MediaGroupItem mediagroupitem = new MediaGroupItem
{
MediaID = Int32.Parse(dritems["MediaID"].ToString()),
AssetID = dritems["AssetID"].ToString(),
VimeoID = dritems["VimeoID"].ToString(),
PlayURL = dritems["PlayURL"].ToString(),
FileName = dritems["FileName"].ToString(),
PreviewImageURL = dritems["PreviewImage"].ToString(),
FilePath = dritems["FilePath"].ToString(),
PermanentLinkURL = dritems["PermanentLink"].ToString(),
Sort = Int32.Parse(dritems["Sort"].ToString())
};
mediagroup.Items.Add(mediagroupitem);
}
return mediagroup;
}
public MediaGroupItem GetMediaGroupItem(string AssetID)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetMediaGroupItem";
cmd.Parameters.AddWithValue("@AssetID", AssetID);
DataTable dt = db.Execute(cmd);
foreach (DataRow dr in dt.Rows)
{
MediaGroupItem mediagroupitem = new MediaGroupItem
{
MediaID = Int32.Parse(dr["MediaID"].ToString()),
VimeoID = dr["VimeoID"].ToString(),
AssetID = dr["AssetID"].ToString(),
FileName = dr["FileName"].ToString(),
PreviewImageURL = dr["PreviewImage"].ToString(),
FilePath = dr["FilePath"].ToString(),
PermanentLinkURL = dr["PermanentLink"].ToString(),
FullDownLoadURL = dr["FullDownLoadURL"].ToString(),
Sort = Int32.Parse(dr["Sort"].ToString()),
Comments = dr["Comments"].ToString()
};
return mediagroupitem;
}
return null;
}
public AudioVideoGroup GetMediaAudioVideo(int GroupID, string Type)
{
string AudioVideoGroupTitle = string.Empty;
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetMediaAudioVideo";
cmd.Parameters.AddWithValue("@ID", GroupID);
cmd.Parameters.AddWithValue("@Type", Type);
DataTable dt = db.Execute(cmd);
List<MediaGroupItem> MediaGroupItems = new List<MediaGroupItem>();
foreach (DataRow dr in dt.Rows)
{
MediaGroupItem mediaGroupItem = new MediaGroupItem
{
MediaID = Int32.Parse(dr["MediaID"].ToString()),
AssetID = dr["AssetID"].ToString(),
FileName = dr["FileName"].ToString(),
PreviewImageURL = dr["PreviewImage"].ToString(),
FilePath = dr["FilePath"].ToString(),
PermanentLinkURL = dr["PermanentLink"].ToString(),
Sort = Int32.Parse(dr["Sort"].ToString())
};
AudioVideoGroupTitle = dr["Title"].ToString();
MediaGroupItems.Add(mediaGroupItem);
}
AudioVideoGroup group = new AudioVideoGroup
{
Title = AudioVideoGroupTitle,
mediagroupitems = MediaGroupItems
};
return group;
}