protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var allartsis = new Artists();
allartsis.RemoveCache();
if (gvwRequestedVideos.SelectedDataKey != null)
{
vidreq = new VideoRequest(Convert.ToInt32(gvwRequestedVideos.SelectedDataKey.Value))
{
StatusType = 'A'
};
vidreq.Update();
}
vid = new Video("YT", txtVideoKey.Text)
{
Duration = (float) Convert.ToDouble(txtDuration.Text),
Intro = (float) Convert.ToDouble(txtSecondsIn.Text),
LengthFromStart = (float) Convert.ToDouble(txtElasedEnd.Text),
ProviderCode = ddlVideoProvider.SelectedValue,
ProviderUserKey = txtUserName.Text,
VolumeLevel = Convert.ToInt32(ddlVolumeLevel.SelectedValue),
IsEnabled = chkEnabled.Checked,
EnableTrim = chkEnabled.Checked
};
// vid.IsHidden = chkHidden.Checked;
/// publish date
var yousettings = new YouTubeRequestSettings("Das Klub", devkey);
var yourequest = new YouTubeRequest(yousettings);
var Url = new Uri("http://gdata.youtube.com/feeds/api/videos/" + vid.ProviderKey);
var video = new Google.YouTube.Video();
video = yourequest.Retrieve<Google.YouTube.Video>(Url);
vid.PublishDate = video.YouTubeEntry.Published;
if (vid.VideoID == 0)
{
vid.Create();
}
else
vid.Update();
// if there is a contest, add it now since there is an id
if (ddlContest.SelectedValue != unknownValue)
{
//TODO: check if it already is in the contest
ContestVideo.DeleteVideoFromAllContests(vid.VideoID);
var cv = new ContestVideo();
cv.ContestID = Convert.ToInt32(ddlContest.SelectedValue);
cv.VideoID = vid.VideoID;
cv.Create();
}
else
{
// TODO: JUST REMOVE FROM CURRENT CONTEST, NOT ALL
ContestVideo.DeleteVideoFromAllContests(vid.VideoID);
}
// vid type
if (!string.IsNullOrWhiteSpace(ddlVideoType.SelectedValue)
&& ddlVideoType.SelectedValue != selectText)
{
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.VIDTP);
mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
mp.RemoveCache();
MultiPropertyVideo.AddMultiPropertyVideo(
Convert.ToInt32(
ddlVideoType.SelectedValue), vid.VideoID);
}
// human
if (!string.IsNullOrWhiteSpace(ddlHumanType.SelectedValue)
&& ddlHumanType.SelectedValue != selectText)
{
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.HUMAN);
mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
mp.RemoveCache();
MultiPropertyVideo.AddMultiPropertyVideo(
Convert.ToInt32(
ddlHumanType.SelectedValue), vid.VideoID);
}
// footage
if (!string.IsNullOrWhiteSpace(ddlFootageType.SelectedValue)
&& ddlFootageType.SelectedValue != selectText)
{
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.FOOTG);
mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
mp.RemoveCache();
MultiPropertyVideo.AddMultiPropertyVideo(
Convert.ToInt32(
ddlFootageType.SelectedValue), vid.VideoID);
}
VideoSong.DeleteSongsForVideo(vid.VideoID);
// song 1
artst = string.IsNullOrEmpty(txtArtist1.Text.Trim())
? new Artist(ddlArtist1.SelectedValue)
: new Artist(txtArtist1.Text);
if (artst.ArtistID == 0)
{
artst.AltName = FromString.UrlKey(artst.Name);
artst.Create();
}
if (string.IsNullOrEmpty(txtArtistSong1.Text))
{
sng = new Song(artst.ArtistID, ddlArtistSongs1.SelectedValue);
}
else
{
sng = new Song(artst.ArtistID, txtArtistSong1.Text);
}
if (sng.SongID == 0)
{
sng.SongKey = FromString.UrlKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 1);
// song 2
if ((ddlArtist2.SelectedValue != unknownValue && !string.IsNullOrEmpty(ddlArtist2.SelectedValue)) ||
!string.IsNullOrEmpty(txtArtist2.Text))
{
artst = null;
sng = null;
if (string.IsNullOrEmpty(txtArtist2.Text.Trim()))
{
artst = new Artist(ddlArtist2.SelectedValue);
}
else
{
artst = new Artist(txtArtist2.Text);
}
if (artst.ArtistID == 0)
{
artst.AltName = FromString.UrlKey(artst.Name);
artst.Create();
}
if (string.IsNullOrEmpty(txtArtistSong2.Text))
{
sng = new Song(artst.ArtistID, ddlArtistSongs2.SelectedValue);
}
else
{
sng = new Song(artst.ArtistID, txtArtistSong2.Text);
}
if (sng.SongID == 0)
{
sng.SongKey = FromString.UrlKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 2);
if ((ddlArtist3.SelectedValue != unknownValue && !string.IsNullOrEmpty(ddlArtist3.SelectedValue)) ||
!string.IsNullOrEmpty(txtArtist3.Text))
{
// song 3
artst = null;
sng = null;
if (string.IsNullOrEmpty(txtArtist3.Text))
{
artst = new Artist(ddlArtist3.SelectedValue);
}
else
{
artst = new Artist(txtArtist3.Text);
}
if (artst.ArtistID == 0)
{
artst.AltName = FromString.UrlKey(artst.Name);
artst.Create();
}
if (string.IsNullOrEmpty(txtArtistSong3.Text))
{
sng = new Song(artst.ArtistID, ddlArtistSongs3.SelectedValue);
}
else
{
sng = new Song(artst.ArtistID, txtArtistSong3.Text);
}
if (sng.SongID == 0)
{
sng.SongKey = FromString.UrlKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 3);
if ((ddlArtist4.SelectedValue != unknownValue && !string.IsNullOrEmpty(ddlArtist4.SelectedValue)) ||
!string.IsNullOrEmpty(txtArtist4.Text))
{
// song 4
artst = null;
sng = null;
if (string.IsNullOrEmpty(txtArtist4.Text))
{
artst = new Artist(ddlArtist4.SelectedValue);
}
else
{
artst = new Artist(txtArtist4.Text);
}
if (artst.ArtistID == 0)
{
artst.AltName = FromString.UrlKey(artst.Name);
artst.Create();
}
if (string.IsNullOrEmpty(txtArtistSong4.Text))
{
sng = new Song(artst.ArtistID, ddlArtistSongs4.SelectedValue);
}
else
{
sng = new Song(artst.ArtistID, txtArtistSong4.Text);
}
if (sng.SongID == 0)
{
sng.SongKey = FromString.UrlKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 4);
if ((ddlArtist5.SelectedValue != unknownValue &&
!string.IsNullOrEmpty(ddlArtist5.SelectedValue)) ||
!string.IsNullOrEmpty(txtArtist5.Text))
{
// song 5
artst = null;
sng = null;
if (string.IsNullOrEmpty(txtArtist5.Text))
{
artst = new Artist(ddlArtist5.SelectedValue);
}
else
{
artst = new Artist(txtArtist5.Text);
}
if (artst.ArtistID == 0)
{
artst.AltName = FromString.UrlKey(artst.Name);
artst.Create();
}
if (string.IsNullOrEmpty(txtArtistSong5.Text))
{
sng = new Song(artst.ArtistID, ddlArtistSongs5.SelectedValue);
}
else
{
sng = new Song(artst.ArtistID, txtArtistSong5.Text);
}
if (sng.SongID == 0)
{
sng.SongKey = FromString.UrlKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 5);
if ((ddlArtist6.SelectedValue != unknownValue &&
!string.IsNullOrEmpty(ddlArtist6.SelectedValue)) ||
!string.IsNullOrEmpty(txtArtist6.Text))
{
// song 6
artst = null;
sng = null;
if (string.IsNullOrEmpty(txtArtist6.Text))
{
artst = new Artist(ddlArtist6.SelectedValue);
}
else
{
artst = new Artist(txtArtist6.Text);
}
if (artst.ArtistID == 0)
{
artst.AltName = FromString.UrlKey(artst.Name);
artst.Create();
}
if (string.IsNullOrEmpty(txtArtistSong6.Text))
{
sng = new Song(artst.ArtistID, ddlArtistSongs6.SelectedValue);
}
else
{
sng = new Song(artst.ArtistID, txtArtistSong6.Text);
}
if (sng.SongID == 0)
{
sng.SongKey = FromString.UrlKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 6);
}
}
}
}
}
// RefreshLists();
lblStatus.Text = "OK";
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
LoadGrid();
}
private void LoadVideo(string videoKey)
{
ClearInput();
try
{
vid = new Video("YT", videoKey);
litVideo.Text =
string.Format(
@"<iframe width=""425"" height=""349"" src=""http://www.youtube.com/embed/{0}"" frameborder=""0"" allowfullscreen></iframe>",
vid.ProviderKey);
txtSecondsIn.Text = vid.Intro.ToString();
txtElasedEnd.Text = vid.LengthFromStart.ToString();
ddlVideoProvider.SelectedValue = vid.ProviderCode;
chkEnabled.Checked = vid.IsEnabled;
ddlVolumeLevel.SelectedValue = vid.VolumeLevel.ToString();
lblVideoID.Text = vid.VideoID.ToString();
if (vid.VolumeLevel == 0)
{
ddlVolumeLevel.SelectedValue = "5";
chkEnabled.Checked = true;
}
var video = new Google.YouTube.Video();
try
{
var yousettings = new YouTubeRequestSettings("Das Klub", devkey);
var yourequest = new YouTubeRequest(yousettings);
var url = new Uri("http://gdata.youtube.com/feeds/api/videos/" + videoKey);
video = yourequest.Retrieve<Google.YouTube.Video>(url);
txtDuration.Text = video.YouTubeEntry.Duration.Seconds;
}
catch (GDataRequestException)
{
vid.IsEnabled = false;
vid.Update();
litVideo.Text = string.Empty;
return;
}
if (vid.LengthFromStart == 0)
{
txtElasedEnd.Text = video.YouTubeEntry.Duration.Seconds;
}
if (vid.LengthFromStart == 0)
{
txtDuration.Text = video.YouTubeEntry.Duration.Seconds;
}
txtUserName.Text = video.Uploader;
lblVideoID.Text = vid.VideoID.ToString();
txtVideoKey.Text = video.VideoId;
// vid type
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.VIDTP);
mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2) { return p1.Name.CompareTo(p2.Name); });
ddlVideoType.DataSource = mps;
ddlVideoType.DataTextField = "name";
ddlVideoType.DataValueField = "multiPropertyID";
ddlVideoType.DataBind();
ddlVideoType.Items.Insert(0, new ListItem(selectText));
if (mp.MultiPropertyID != 0)
ddlVideoType.SelectedValue = mp.MultiPropertyID.ToString();
// human
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.HUMAN);
mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2) { return p1.Name.CompareTo(p2.Name); });
ddlHumanType.DataSource = mps;
ddlHumanType.DataTextField = "name";
ddlHumanType.DataValueField = "multiPropertyID";
ddlHumanType.DataBind();
ddlHumanType.Items.Insert(0, new ListItem(selectText));
if (mp.MultiPropertyID != 0)
ddlHumanType.SelectedValue = mp.MultiPropertyID.ToString();
// footage
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.FOOTG);
mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2) { return p1.Name.CompareTo(p2.Name); });
ddlFootageType.DataSource = mps;
ddlFootageType.DataTextField = "name";
ddlFootageType.DataValueField = "multiPropertyID";
ddlFootageType.DataBind();
ddlFootageType.Items.Insert(0, new ListItem(selectText));
if (mp.MultiPropertyID != 0)
ddlFootageType.SelectedValue = mp.MultiPropertyID.ToString();
// contest
var vidInContest = new ContestVideo();
vidInContest.GetContestVideo(vid.VideoID);
if (vidInContest.ContestVideoID != 0)
{
ddlContest.SelectedValue = vidInContest.ContestID.ToString();
}
else
ddlContest.SelectedValue = unknownValue;
var sngs = new Songs();
artsngs = new Songs();
sngs.GetSongsForVideo(vid.VideoID);
Artist art = null;
var arts = new Artists();
arts.GetAll();
// artists 1
ddlArtist1.DataSource = arts;
ddlArtist1.DataTextField = "name";
ddlArtist1.DataValueField = "name";
ddlArtist1.DataBind();
Utilities.General.SortDropDownList(ddlArtist1);
ddlArtist1.Items.Insert(0, new ListItem(unknownValue));
// artists 2
ddlArtist2.DataSource = arts;
ddlArtist2.DataTextField = "name";
ddlArtist2.DataValueField = "name";
ddlArtist2.DataBind();
Utilities.General.SortDropDownList(ddlArtist2);
ddlArtist2.Items.Insert(0, new ListItem(unknownValue));
// artists 3
ddlArtist3.DataSource = arts;
ddlArtist3.DataTextField = "name";
ddlArtist3.DataValueField = "name";
ddlArtist3.DataBind();
Utilities.General.SortDropDownList(ddlArtist3);
ddlArtist3.Items.Insert(0, new ListItem(unknownValue));
// artists 4
ddlArtist4.DataSource = arts;
ddlArtist4.DataTextField = "name";
ddlArtist4.DataValueField = "name";
ddlArtist4.DataBind();
Utilities.General.SortDropDownList(ddlArtist4);
ddlArtist4.Items.Insert(0, new ListItem(unknownValue));
// artists 5
ddlArtist5.DataSource = arts;
ddlArtist5.DataTextField = "name";
ddlArtist5.DataValueField = "name";
ddlArtist5.DataBind();
Utilities.General.SortDropDownList(ddlArtist5);
ddlArtist5.Items.Insert(0, new ListItem(unknownValue));
// artists 6
ddlArtist6.DataSource = arts;
ddlArtist6.DataTextField = "name";
ddlArtist6.DataValueField = "name";
ddlArtist6.DataBind();
Utilities.General.SortDropDownList(ddlArtist6);
ddlArtist6.Items.Insert(0, new ListItem(unknownValue));
foreach (Song sng in sngs)
{
if (sng.Name == unknownValue || string.IsNullOrEmpty(sng.Name)) continue;
// sngrcd.SongDisplay += art.Name + " - " + sng.Name + " " ;
if (sng.RankOrder == 0 || sng.RankOrder == 1)
{
// song 1
art = new Artist(sng.ArtistID);
ddlArtist1.SelectedValue = art.Name;
artsngs = new Songs();
artsngs.GetSongsForArtist(art.ArtistID);
ddlArtistSongs1.DataSource = artsngs;
ddlArtistSongs1.DataTextField = "name";
ddlArtistSongs1.DataValueField = "name";
ddlArtistSongs1.DataBind();
ddlArtistSongs1.Items.Insert(0, new ListItem(unknownValue));
Utilities.General.SortDropDownList(ddlArtistSongs1);
ddlArtistSongs1.SelectedValue = sng.Name;
}
else if (sng.RankOrder == 2)
{
// song 2
art = new Artist(sng.ArtistID);
ddlArtist2.SelectedValue = art.Name;
artsngs = new Songs();
artsngs.GetSongsForArtist(art.ArtistID);
ddlArtistSongs2.DataSource = artsngs;
ddlArtistSongs2.DataTextField = "name";
ddlArtistSongs2.DataValueField = "name";
ddlArtistSongs2.DataBind();
ddlArtistSongs2.Items.Insert(0, new ListItem(unknownValue));
Utilities.General.SortDropDownList(ddlArtistSongs2);
ddlArtistSongs2.SelectedValue = sng.Name;
}
else if (sng.RankOrder == 3)
{
// song 3
art = new Artist(sng.ArtistID);
ddlArtist3.SelectedValue = art.Name;
artsngs = new Songs();
artsngs.GetSongsForArtist(art.ArtistID);
ddlArtistSongs3.DataSource = artsngs;
ddlArtistSongs3.DataTextField = "name";
ddlArtistSongs3.DataValueField = "name";
ddlArtistSongs3.DataBind();
ddlArtistSongs3.Items.Insert(0, new ListItem(unknownValue));
Utilities.General.SortDropDownList(ddlArtistSongs3);
ddlArtistSongs3.SelectedValue = sng.Name;
}
else if (sng.RankOrder == 4)
{
// song 4
art = new Artist(sng.ArtistID);
ddlArtist4.SelectedValue = art.Name;
artsngs = new Songs();
artsngs.GetSongsForArtist(art.ArtistID);
ddlArtistSongs4.DataSource = artsngs;
ddlArtistSongs4.DataTextField = "name";
ddlArtistSongs4.DataValueField = "name";
ddlArtistSongs4.DataBind();
ddlArtistSongs4.Items.Insert(0, new ListItem(unknownValue));
Utilities.General.SortDropDownList(ddlArtistSongs4);
ddlArtistSongs4.SelectedValue = sng.Name;
}
else if (sng.RankOrder == 5)
{
// song 5
art = new Artist(sng.ArtistID);
ddlArtist5.SelectedValue = art.Name;
artsngs = new Songs();
artsngs.GetSongsForArtist(art.ArtistID);
ddlArtistSongs5.DataSource = artsngs;
ddlArtistSongs5.DataTextField = "name";
ddlArtistSongs5.DataValueField = "name";
ddlArtistSongs5.DataBind();
ddlArtistSongs5.Items.Insert(0, new ListItem(unknownValue));
Utilities.General.SortDropDownList(ddlArtistSongs5);
ddlArtistSongs5.SelectedValue = sng.Name;
}
else if (sng.RankOrder == 6)
{
// song 6
art = new Artist(sng.ArtistID);
ddlArtist6.SelectedValue = art.Name;
artsngs = new Songs();
artsngs.GetSongsForArtist(art.ArtistID);
ddlArtistSongs6.DataSource = artsngs;
ddlArtistSongs6.DataTextField = "name";
ddlArtistSongs6.DataValueField = "name";
ddlArtistSongs6.DataBind();
ddlArtistSongs6.Items.Insert(0, new ListItem(unknownValue));
Utilities.General.SortDropDownList(ddlArtistSongs6);
ddlArtistSongs6.SelectedValue = sng.Name;
}
}
lblStatus.Text = "OK";
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
}