private LinkedList <NetMeterProperty> ReplaceValues(PropertyIterator iter, ValueTransformer transform) { LinkedList <NetMeterProperty> props = new LinkedList <NetMeterProperty>(); while (iter.hasNext()) { NetMeterProperty val = iter.next(); if (log.IsDebugEnabled) { log.Debug("About to replace in property of type: " + val.GetType() + ": " + val); } if (typeof(StringProperty).IsAssignableFrom(val.GetType())) { // Must not convert TestElement.gui_class etc if (!val.getName().Equals(TestElement.GUI_CLASS) && !val.getName().Equals(TestElement.TEST_CLASS)) { val = transform.transformValue(val); if (log.IsDebugEnabled) { log.Debug("Replacement result: " + val); } } } else if (typeof(MultiProperty).IsAssignableFrom(val.GetType())) { MultiProperty multiVal = (MultiProperty)val; LinkedList <NetMeterProperty> newValues = ReplaceValues(multiVal.iterator(), transform); multiVal.Clear(); foreach (NetMeterProperty jmp in newValues) { multiVal.addProperty(jmp); } if (log.IsDebugEnabled) { log.Debug("Replacement result: " + multiVal); } } else { if (log.IsDebugEnabled) { log.Debug("Won't replace " + val); } } props.AddLast(val); } return(props); }
public ActionResult VideoSubmit(string video, string videoType, string personType, string footageType, string band, string song, string contestID) { string invalidSubmissionLink = string.Concat("~/videosubmission.aspx?statustype=", InvalidStatus.ToString()); if (string.IsNullOrWhiteSpace(video)) { Response.Redirect(invalidSubmissionLink); return new EmptyResult(); } var vir = new VideoRequest {RequestURL = video}; string vidKey = Utilities.ExtractYouTubeVideoKey(video); vir.RequestURL = vir.RequestURL; vir.VideoKey = vidKey; if (string.IsNullOrWhiteSpace(vir.VideoKey)) { vir.StatusType = InvalidStatus; Response.Redirect(invalidSubmissionLink); return new EmptyResult(); } if (string.IsNullOrWhiteSpace(videoType) || string.IsNullOrWhiteSpace(personType) || string.IsNullOrWhiteSpace(footageType) || string.IsNullOrWhiteSpace(band) || string.IsNullOrWhiteSpace(song)) { vir.StatusType = 'P'; Response.Redirect("~/videosubmission.aspx?statustype=P"); return new EmptyResult(); } var vid = new Lib.BOL.Video(Provider, vidKey) {ProviderCode = Provider}; try { var youTubeVideo = GetYouTubeVideo(vidKey); TimeSpan ts = XmlConvert.ToTimeSpan(youTubeVideo.ContentDetails.Duration); vid.Duration = (float) Convert.ToDouble(ts.TotalSeconds); vid.ProviderUserKey = youTubeVideo.Snippet.ChannelId; vid.PublishDate = Convert.ToDateTime(youTubeVideo.Snippet.PublishedAtRaw); } catch (GDataRequestException gdex) { vid.IsEnabled = false; vid.Update(); vir.StatusType = InvalidStatus; Response.Redirect(invalidSubmissionLink); return new EmptyResult(); } catch (ClientFeedException) { vir.StatusType = InvalidStatus; Response.Redirect(invalidSubmissionLink); return new EmptyResult(); } catch (Exception ex) { vir.StatusType = InvalidStatus; Response.Redirect(invalidSubmissionLink); return new EmptyResult(); } vid.VolumeLevel = 5; if (string.IsNullOrWhiteSpace(vid.ProviderKey)) { // invalid vir.StatusType = InvalidStatus; Response.Redirect(invalidSubmissionLink); return new EmptyResult(); } if (vid.VideoID == 0) { vid.IsHidden = false; vid.IsEnabled = true; vid.Create(); } else { // just go to the video... vid.Update(); Response.Redirect(vid.VideoURL); } // if there is a contest, add it now since there is an id int subContestId; if (!string.IsNullOrWhiteSpace(contestID) && int.TryParse(contestID, out subContestId) && subContestId > 0) { //TODO: check if it already is in the contest ContestVideo.DeleteVideoFromAllContests(vid.VideoID); var cv = new ContestVideo {ContestID = subContestId, VideoID = vid.VideoID}; cv.Create(); } else { // TODO: JUST REMOVE FROM CURRENT CONTEST, NOT ALL ContestVideo.DeleteVideoFromAllContests(vid.VideoID); } // vid type var propTyp = new PropertyType(SiteEnums.PropertyTypeCode.VIDTP); var 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); // song 1 var 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(); } var sng = new Song(artst.ArtistID, song.Trim()); if (sng.SongID == 0) { sng.Name = sng.Name.Trim(); sng.SongKey = FromString.UrlKey(sng.Name); sng.Create(); } // BUG: DON'T ADD 2X VideoSong.AddVideoSong(sng.SongID, vid.VideoID, 1); if (vid.VideoID > 0) { Response.Redirect(vid.VideoURL); // just send them to it } return new EmptyResult(); }
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 { 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; } }
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(); }