public ActionResult Index()
{
// CONTESTS
Contest cndss = Contest.GetCurrentContest();
ContestVideos cvids = new ContestVideos();
Videos vidsInContest = new Videos();
BootBaronLib.AppSpec.DasKlub.BOL.Video vid2 = null;
foreach (ContestVideo cv1 in cvids)
{
vid2 = new BootBaronLib.AppSpec.DasKlub.BOL.Video(cv1.VideoID);
vidsInContest.Add(vid2);
}
vidsInContest.Sort(delegate(BootBaronLib.AppSpec.DasKlub.BOL.Video p1, BootBaronLib.AppSpec.DasKlub.BOL.Video p2)
{
return p2.PublishDate.CompareTo(p1.PublishDate);
});
SongRecords sngrcds3 = new SongRecords();
SongRecord sng3 = new SongRecord();
foreach (BootBaronLib.AppSpec.DasKlub.BOL.Video v1 in vidsInContest)
{
sng3 = new SongRecord(v1);
sngrcds3.Add(sng3);
}
ViewBag.ContestVideoList = sngrcds3.VideosList();
ViewBag.CurrentContest = cndss;
//
PhotoItems pitms = new PhotoItems();
pitms.UseThumb = true;
pitms.ShowTitle = false;
pitms.GetPhotoItemsPageWise(1, 4);
ViewBag.PhotoList = pitms.ToUnorderdList;
Contents cnts = new Contents();
cnts.GetContentPageWiseAll(1, 3);
ViewBag.RecentArticles = cnts.ToUnorderdList;
UserAccounts uas = new UserAccounts();
uas.GetNewestUsers();
ViewBag.NewestUsers = uas.ToUnorderdList;
Videos newestVideos = new Videos();
newestVideos.GetMostRecentVideos();
SongRecords newSongs = new SongRecords();
SongRecord sng1 = null;
foreach (BootBaronLib.AppSpec.DasKlub.BOL.Video v1 in newestVideos)
{
sng1 = new SongRecord(v1);
newSongs.Add(sng1);
}
ViewBag.NewestVideos = newSongs.VideosList();
BootBaronLib.AppSpec.DasKlub.BOL.Video vid = new BootBaronLib.AppSpec.DasKlub.BOL.Video(BootBaronLib.AppSpec.DasKlub.BOL.Video.RandomVideoIDVideo());
ViewBag.RandomVideoKey = vid.ProviderKey;
///video submit
MultiProperties addList = null;
PropertyType propTyp = null;
MultiProperties mps = null;
// video typesa
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.VIDTP);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
{
return p1.DisplayName.CompareTo(p2.DisplayName);
});
ViewBag.VideoTypes = mps;
// person types
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.HUMAN);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
{
return p1.DisplayName.CompareTo(p2.DisplayName);
});
ViewBag.PersonTypes = mps;
//// footage types
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.FOOTG);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
{
return p1.DisplayName.CompareTo(p2.DisplayName);
});
addList = new MultiProperties();
ViewBag.FootageTypes = mps;
return View();
}
public ActionResult VideoSubmit(string video, string videoType, string personType,
string footageType, string band, string song, string contestID)
{
if (string.IsNullOrWhiteSpace(video))
{
Response.Redirect("~/videosubmission.aspx?statustype=I");
return new EmptyResult();
}
VideoRequest vir = new VideoRequest();
vir.RequestURL = video;
string vidKey = string.Empty;
vir.RequestURL = vir.RequestURL.Replace("https", "http");
if (vir.RequestURL.Contains("http://youtu.be/"))
{
vir.VideoKey = vir.RequestURL.Replace("http://youtu.be/", string.Empty);
}
else if (vir.RequestURL.Contains("http://www.youtube.com/watch?"))
{
NameValueCollection nvcKey = System.Web.HttpUtility.ParseQueryString(vir.RequestURL.Replace("http://www.youtube.com/watch?", string.Empty));
vir.VideoKey = nvcKey["v"];
vidKey = nvcKey["v"];
}
else
{
// invalid
vir.StatusType = 'I';
Response.Redirect("~/videosubmission.aspx?statustype=I");
return new EmptyResult();
}
if (string.IsNullOrWhiteSpace(videoType) ||
string.IsNullOrWhiteSpace(personType) ||
string.IsNullOrWhiteSpace(footageType) ||
string.IsNullOrWhiteSpace(band) ||
string.IsNullOrWhiteSpace(song))
{
// invalid
vir.StatusType = 'P';
Response.Redirect("~/videosubmission.aspx?statustype=P");
return new EmptyResult();
}
try
{
//IDictionaryEnumerator enumerator = HttpContext.Current.Cache.GetEnumerator();
//while (enumerator.MoveNext())
//{
// HttpContext.Current.Cache.Remove(enumerator.Key.ToString());
//}
//Artists allartsis = new Artists();
//allartsis.RemoveCache();
//if (gvwRequestedVideos.SelectedDataKey != null)
//{
// vidreq = new VideoRequest(Convert.ToInt32(gvwRequestedVideos.SelectedDataKey.Value));
// vidreq.StatusType = 'A';
// vidreq.Update();
//}
BootBaronLib.AppSpec.DasKlub.BOL.Video vid = new BootBaronLib.AppSpec.DasKlub.BOL.Video("YT", vidKey);
vid.ProviderCode = "YT";
Google.YouTube.Video video2;
video2 = new Google.YouTube.Video();
try
{
YouTubeRequestSettings yousettings = new YouTubeRequestSettings("You Manager", devkey, username, password);
YouTubeRequest yourequest;
Uri Url;
yourequest = new YouTubeRequest(yousettings);
Url = new Uri("http://gdata.youtube.com/feeds/api/videos/" + vidKey);
video2 = yourequest.Retrieve<Google.YouTube.Video>(Url);
vid.Duration = (float)Convert.ToDouble(video2.YouTubeEntry.Duration.Seconds);
vid.ProviderUserKey = video2.Uploader;
vid.PublishDate = video2.YouTubeEntry.Published;
}
catch (GDataRequestException)
{
vid.IsEnabled = false;
vid.Update();
//litVideo.Text = string.Empty;
// return;
// invalid
vir.StatusType = 'I';
Response.Redirect("~/videosubmission.aspx?statustype=I");
return new EmptyResult();
}
vid.VolumeLevel = 5;
// vid.HumanType = personType;
// t(string video, string videoType, string personType,
//string footageType, string band, string song, string contestID)
// vid.VideoType = videoType;
//vid.Duration = (float)Convert.ToDouble(txtDuration.Text);
//vid.Intro = (float)Convert.ToDouble(txtSecondsIn.Text);
//vid.LengthFromStart = (float)Convert.ToDouble(txtElasedEnd.Text);
//vid.ProviderCode = ddlVideoProvider.SelectedValue;
//vid.ProviderUserKey = txtUserName.Text;
//vid.VolumeLevel = Convert.ToInt32(ddlVolumeLevel.SelectedValue);
//vid.IsEnabled = chkEnabled.Checked;
//// vid.IsHidden = chkHidden.Checked;
//vid.EnableTrim = chkEnabled.Checked;
///// publish date
//YouTubeRequestSettings yousettings =
// new YouTubeRequestSettings("You Manager", devkey, username, password);
//YouTubeRequest yourequest;
//Uri Url;
//yourequest = new YouTubeRequest(yousettings);
//Url = new Uri("http://gdata.youtube.com/feeds/api/videos/" + vid.ProviderKey);
//video = new Google.YouTube.Video();
//video = yourequest.Retrieve<Google.YouTube.Video>(Url);
//vid.PublishDate = video.YouTubeEntry.Published;
if (string.IsNullOrWhiteSpace(vid.ProviderKey))
{
// invalid
vir.StatusType = 'I';
Response.Redirect("~/videosubmission.aspx?statustype=I");
return new EmptyResult();
}
if (vid.VideoID == 0)
{
vid.IsHidden = false;
vid.IsEnabled = true;
vid.Create();
}
else
{
vid.Update();
}
// if there is a contest, add it now since there is an id
int subContestID = 0;
if (!string.IsNullOrWhiteSpace(contestID) && int.TryParse(contestID, out subContestID) && subContestID > 0)
{
//TODO: check if it already is in the contest
ContestVideo.DeleteVideoFromAllContests(vid.VideoID);
ContestVideo cv = new ContestVideo();
cv.ContestID = subContestID;
cv.VideoID = vid.VideoID;
cv.Create();
}
else
{
// TODO: JUST REMOVE FROM CURRENT CONTEST, NOT ALL
ContestVideo.DeleteVideoFromAllContests(vid.VideoID);
}
PropertyType propTyp = null;
MultiProperty mp = null;
// vid type
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(videoType), vid.VideoID);
// human
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(personType), vid.VideoID);
// footage
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(footageType), vid.VideoID);
//// guitar
//if (!string.IsNullOrWhiteSpace(this.ddlGuitarType.SelectedValue)
// && this.ddlGuitarType.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.GUITR);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(ddlGuitarType.SelectedValue), vid.VideoID);
//}
//// Language
//if (!string.IsNullOrWhiteSpace(this.ddlLanguage.SelectedValue)
// && this.ddlLanguage.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.LANGE);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(ddlLanguage.SelectedValue), vid.VideoID);
//}
//// genre
//if (!string.IsNullOrWhiteSpace(this.ddlGenre.SelectedValue)
// && this.ddlGenre.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.GENRE);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(ddlGenre.SelectedValue), vid.VideoID);
//}
//// difficulty
//if (!string.IsNullOrWhiteSpace(this.ddlDifficultyLevel.SelectedValue)
// && this.ddlDifficultyLevel.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.DIFFC);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(this.ddlDifficultyLevel.SelectedValue), vid.VideoID);
//}
//VideoSong.DeleteSongsForVideo(vid.VideoID);
// song 1
Artist artst = new Artist(band.Trim());
if (artst.ArtistID == 0)
{
artst.GetArtistByAltname(band.Trim());
}
if (artst.ArtistID == 0)
{
artst.Name = band.Trim();
artst.AltName = FromString.URLKey(artst.Name);
artst.Create();
}
Song sng = new Song(artst.ArtistID, song.Trim());
if (sng.SongID == 0)
{
sng.Name = sng.Name.Trim();
sng.SongKey = FromString.URLKey(sng.Name);
sng.Create();
}
VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 1);
// RefreshLists();
// lblStatus.Text = "OK";
if (vid.VideoID > 0)
{
Response.Redirect(vid.VideoURL);// just send them to it
}
}
catch
{
// lblStatus.Text = ex.Message;
//{
Response.Redirect("~/videosubmission.aspx?statustype=I");
return new EmptyResult();
//}
}
//Video v1 = new Video();
//if (!string.IsNullOrEmpty(vir.VideoKey))
//{
// v1 = new Video("YT", vir.VideoKey);
//}
//if (v1.VideoID > 0 && v1.IsEnabled)
//{
// Response.Redirect(v1.VideoURL);// just send them to it
// return new EmptyResult();
//}
//vir.GetVideoRequest();
//if (vir.StatusType == 'W')
//{
// Response.Redirect("~/videosubmission.aspx?statustype=W");
// return new EmptyResult();
//}
//else if (vir.StatusType == 'R')
//{
// Response.Redirect("~/videosubmission.aspx?statustype=R");
// return new EmptyResult();
//}
//vir.StatusType = 'W';
//vir.Create();
// Response.Redirect("~/videosubmission.aspx?statustype=W");
// return new EmptyResult();
//if (vir.StatusType == 'W')
//{
// Response.Redirect("~/videosubmission.aspx?statustype=W");
// return new EmptyResult();
//}
//else if (vir.StatusType == 'R')
//{
// Response.Redirect("~/videosubmission.aspx?statustype=R");
// return new EmptyResult();
//}
//else
//{
// v1 = new Video("YT", vir.VideoKey);
// if (v1.VideoID > 0 && v1.IsEnabled)
// {
// Response.Redirect(v1.VideoURL);// just send them to it
// }
// else
// {
// vir.StatusType = 'W';
// vir.Create();
// Response.Redirect("~/videosubmission.aspx?statustype=W");
// return new EmptyResult();
// }
//}
return new EmptyResult();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//IDictionaryEnumerator enumerator = HttpContext.Current.Cache.GetEnumerator();
//while (enumerator.MoveNext())
//{
// HttpContext.Current.Cache.Remove(enumerator.Key.ToString());
//}
Artists allartsis = new Artists();
allartsis.RemoveCache();
if (gvwRequestedVideos.SelectedDataKey != null)
{
vidreq = new VideoRequest(Convert.ToInt32(gvwRequestedVideos.SelectedDataKey.Value));
vidreq.StatusType = 'A';
vidreq.Update();
}
vid = new BootBaronLib.AppSpec.DasKlub.BOL.Video("YT", txtVideoKey.Text);
vid.Duration = (float)Convert.ToDouble(txtDuration.Text);
vid.Intro = (float)Convert.ToDouble(txtSecondsIn.Text);
vid.LengthFromStart = (float)Convert.ToDouble(txtElasedEnd.Text);
vid.ProviderCode = ddlVideoProvider.SelectedValue;
vid.ProviderUserKey = txtUserName.Text;
vid.VolumeLevel = Convert.ToInt32(ddlVolumeLevel.SelectedValue);
vid.IsEnabled = chkEnabled.Checked;
// vid.IsHidden = chkHidden.Checked;
vid.EnableTrim = chkEnabled.Checked;
/// publish date
YouTubeRequestSettings yousettings =
new YouTubeRequestSettings("You Manager", devkey, username, password);
YouTubeRequest yourequest;
Uri Url;
Google.YouTube.Video video;
yourequest = new YouTubeRequest(yousettings);
Url = new Uri("http://gdata.youtube.com/feeds/api/videos/" + vid.ProviderKey);
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);
ContestVideo 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(this.ddlVideoType.SelectedValue)
&& this.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(this.ddlHumanType.SelectedValue)
&& this.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(this.ddlFootageType.SelectedValue)
&& this.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);
}
//// guitar
//if (!string.IsNullOrWhiteSpace(this.ddlGuitarType.SelectedValue)
// && this.ddlGuitarType.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.GUITR);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(ddlGuitarType.SelectedValue), vid.VideoID);
//}
//// Language
//if (!string.IsNullOrWhiteSpace(this.ddlLanguage.SelectedValue)
// && this.ddlLanguage.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.LANGE);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(ddlLanguage.SelectedValue), vid.VideoID);
//}
//// genre
//if (!string.IsNullOrWhiteSpace(this.ddlGenre.SelectedValue)
// && this.ddlGenre.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.GENRE);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(ddlGenre.SelectedValue), vid.VideoID);
//}
//// difficulty
//if (!string.IsNullOrWhiteSpace(this.ddlDifficultyLevel.SelectedValue)
// && this.ddlDifficultyLevel.SelectedValue != selectText)
//{
// propTyp = new PropertyType(SiteEnums.PropertyTypeCode.DIFFC);
// mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
// MultiPropertyVideo.DeleteMultiPropertyVideo(mp.MultiPropertyID, vid.VideoID);
// mp.RemoveCache();
// MultiPropertyVideo.AddMultiPropertyVideo(
// Convert.ToInt32(this.ddlDifficultyLevel.SelectedValue), vid.VideoID);
//}
VideoSong.DeleteSongsForVideo(vid.VideoID);
// song 1
if (string.IsNullOrEmpty(txtArtist1.Text.Trim()))
{
artst = new Artist(ddlArtist1.SelectedValue);
}
else
{
artst = 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 LoadFilteredVideos(bool isAjax)
{
int? personType = null;
int? footageType = null;
int? videoType = null;
if (!string.IsNullOrEmpty(
Request.QueryString[SiteEnums.QueryStringNames.videoType.ToString()]))
{
videoType = Convert.ToInt32(
Request.QueryString[SiteEnums.QueryStringNames.videoType.ToString()]);
}
if (!string.IsNullOrEmpty(
Request.QueryString[SiteEnums.QueryStringNames.personType.ToString()]))
{
personType = Convert.ToInt32(
Request.QueryString[SiteEnums.QueryStringNames.personType.ToString()]);
}
if (!string.IsNullOrEmpty(
Request.QueryString[SiteEnums.QueryStringNames.footageType.ToString()]))
{
footageType = Convert.ToInt32(
Request.QueryString[SiteEnums.QueryStringNames.footageType.ToString()]);
}
toShow.GetListFilter(videoPageNumber, pageSize, personType, footageType, videoType);
if(isAjax) return;//this is ajax
if (videoPageNumber == 1)
{
SongRecords sngrcs = new SongRecords();
SongRecord sngrcd = null;
foreach (BootBaronLib.AppSpec.DasKlub.BOL.Video vi in toShow)
{
sngrcd = new SongRecord(vi);
sngrcs.Add(sngrcd);
}
ViewBag.VideosFiltered = sngrcs.VideosPageList();
}
MultiProperties addList = null;
PropertyType propTyp = null;
MultiProperties mps = null;
// video types
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.VIDTP);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
{
return p1.DisplayName.CompareTo(p2.DisplayName);
});
addList = new MultiProperties();
foreach (MultiProperty mp1 in mps)
{
if (Videos.HasResults(footageType, mp1.MultiPropertyID, personType))
{
addList.Add(mp1);
}
}
ViewBag.VideoTypes = addList;
// person types
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.HUMAN);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
{
return p1.DisplayName.CompareTo(p2.DisplayName);
});
addList = new MultiProperties();
foreach (MultiProperty mp1 in mps)
{
if (Videos.HasResults( footageType, videoType, mp1.MultiPropertyID ))
{
addList.Add(mp1);
}
}
ViewBag.PersonTypes = addList;
//// footage types
propTyp = new PropertyType(SiteEnums.PropertyTypeCode.FOOTG);
mps = new MultiProperties(propTyp.PropertyTypeID);
mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
{
return p1.DisplayName.CompareTo(p2.DisplayName);
});
addList = new MultiProperties();
foreach (MultiProperty mp1 in mps)
{
if (Videos.HasResults(footageType, mp1.MultiPropertyID, personType))
{
addList.Add(mp1);
}
}
ViewBag.FootageTypes = addList;
}
private void LoadVideo(string videoKey)
{
ClearInput();
try
{
vid = new BootBaronLib.AppSpec.DasKlub.BOL.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;
}
Google.YouTube.Video video;
video = new Google.YouTube.Video();
try
{
YouTubeRequestSettings yousettings = new YouTubeRequestSettings("You Manager", devkey, username, password);
YouTubeRequest yourequest;
Uri Url;
yourequest = new YouTubeRequest(yousettings);
Url = new Uri("http://gdata.youtube.com/feeds/api/videos/" + videoKey);
video = yourequest.Retrieve<Google.YouTube.Video>(Url);
txtDuration.Text = video.YouTubeEntry.Duration.Seconds.ToString();
}
catch (GDataRequestException)
{
vid.IsEnabled = false;
vid.Update();
litVideo.Text = string.Empty;
return;
}
if (vid.LengthFromStart == 0)
{
txtElasedEnd.Text = video.YouTubeEntry.Duration.Seconds.ToString();
}
if (vid.LengthFromStart == 0)
{
txtDuration.Text = video.YouTubeEntry.Duration.Seconds.ToString();
}
txtUserName.Text = video.Uploader;
lblVideoID.Text = vid.VideoID.ToString();
txtVideoKey.Text = video.VideoId;
// if (vid.VideoID == 0) return;
//// status
//Statuses stus = new Statuses();
//stus.GetAll();
//ddlVideoStatus.DataSource = stus;
//ddlVideoStatus.DataTextField = "statusDescription";
//ddlVideoStatus.DataValueField = "statusID";
//ddlVideoStatus.DataBind();
//if (vid.StatusID != 0)
// ddlVideoStatus.SelectedValue = vid.StatusID.ToString();
// 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();
//// gutiar type
//propTyp = new PropertyType(SiteEnums.PropertyTypeCode.GUITR);
//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);
//});
//ddlGuitarType.DataSource = mps;
//ddlGuitarType.DataTextField = "name";
//ddlGuitarType.DataValueField = "multiPropertyID";
//ddlGuitarType.DataBind();
//ddlGuitarType.Items.Insert(0, new ListItem(selectText));
//if (mp.MultiPropertyID != 0)
// ddlGuitarType.SelectedValue = mp.MultiPropertyID.ToString();
//// language
//propTyp = new PropertyType(SiteEnums.PropertyTypeCode.LANGE);
//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);
//});
//ddlLanguage.DataSource = mps;
//ddlLanguage.DataTextField = "name";
//ddlLanguage.DataValueField = "multiPropertyID";
//ddlLanguage.DataBind();
//ddlLanguage.Items.Insert(0, new ListItem(selectText));
//if (mp.MultiPropertyID != 0)
// ddlLanguage.SelectedValue = mp.MultiPropertyID.ToString();
//// genre
//propTyp = new PropertyType(SiteEnums.PropertyTypeCode.GENRE);
//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);
//});
//ddlGenre.DataSource = mps;
//ddlGenre.DataTextField = "name";
//ddlGenre.DataValueField = "multiPropertyID";
//ddlGenre.DataBind();
//ddlGenre.Items.Insert(0, new ListItem(selectText));
//if (mp.MultiPropertyID != 0)
// ddlGenre.SelectedValue = mp.MultiPropertyID.ToString();
//// difficulty
//propTyp = new PropertyType(SiteEnums.PropertyTypeCode.DIFFC);
//mp = new MultiProperty(vid.VideoID, propTyp.PropertyTypeID, SiteEnums.MultiPropertyType.VIDEO);
//mps = new MultiProperties(propTyp.PropertyTypeID);
//mps.Sort(delegate(MultiProperty p1, MultiProperty p2)
//{
// // sort by entry
// return p1.MultiPropertyID.CompareTo(p2.MultiPropertyID);
//});
//ddlDifficultyLevel.DataSource = mps;
//ddlDifficultyLevel.DataTextField = "name";
//ddlDifficultyLevel.DataValueField = "multiPropertyID";
//ddlDifficultyLevel.DataBind();
//ddlDifficultyLevel.Items.Insert(0, new ListItem(selectText));
//if (mp.MultiPropertyID != 0)
// ddlDifficultyLevel.SelectedValue = mp.MultiPropertyID.ToString();
// contest
ContestVideo vidInContest = new ContestVideo();
vidInContest.GetContestVideo(vid.VideoID);
if (vidInContest.ContestVideoID != 0)
{
ddlContest.SelectedValue = vidInContest.ContestID.ToString();
}
else
ddlContest.SelectedValue = unknownValue;
Songs sngs = new Songs();
artsngs = new Songs();
sngs.GetSongsForVideo(vid.VideoID);
Artist art = null;
Artists arts = new Artists();
arts.GetAll();
// artists 1
ddlArtist1.DataSource = arts;
ddlArtist1.DataTextField = "name";
ddlArtist1.DataValueField = "name";
ddlArtist1.DataBind();
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtist1);
ddlArtist1.Items.Insert(0, new ListItem(unknownValue));
// artists 2
ddlArtist2.DataSource = arts;
ddlArtist2.DataTextField = "name";
ddlArtist2.DataValueField = "name";
ddlArtist2.DataBind();
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtist2);
ddlArtist2.Items.Insert(0, new ListItem(unknownValue));
// artists 3
ddlArtist3.DataSource = arts;
ddlArtist3.DataTextField = "name";
ddlArtist3.DataValueField = "name";
ddlArtist3.DataBind();
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtist3);
ddlArtist3.Items.Insert(0, new ListItem(unknownValue));
// artists 4
ddlArtist4.DataSource = arts;
ddlArtist4.DataTextField = "name";
ddlArtist4.DataValueField = "name";
ddlArtist4.DataBind();
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtist4);
ddlArtist4.Items.Insert(0, new ListItem(unknownValue));
// artists 5
ddlArtist5.DataSource = arts;
ddlArtist5.DataTextField = "name";
ddlArtist5.DataValueField = "name";
ddlArtist5.DataBind();
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtist5);
ddlArtist5.Items.Insert(0, new ListItem(unknownValue));
// artists 6
ddlArtist6.DataSource = arts;
ddlArtist6.DataTextField = "name";
ddlArtist6.DataValueField = "name";
ddlArtist6.DataBind();
BootBaronLib.Operational.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));
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtistSongs1);
ddlArtistSongs1.SelectedValue = sng.Name.ToString();
}
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));
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtistSongs2);
ddlArtistSongs2.SelectedValue = sng.Name.ToString();
}
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));
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtistSongs3);
ddlArtistSongs3.SelectedValue = sng.Name.ToString();
}
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));
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtistSongs4);
ddlArtistSongs4.SelectedValue = sng.Name.ToString();
}
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));
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtistSongs5);
ddlArtistSongs5.SelectedValue = sng.Name.ToString();
}
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));
BootBaronLib.Operational.Utilities.General.SortDropDownList(ddlArtistSongs6);
ddlArtistSongs6.SelectedValue = sng.Name.ToString();
}
}
lblStatus.Text = "OK";
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
}
