public static string GetPropertyTypeLink(int vidID) { var sngs = new Songs(); sngs.GetSongsForVideo(vidID); var sb = new StringBuilder(); var sp = new SongProperty(); foreach (Song sng in sngs) { sp = new SongProperty(); sp.GetSongPropertySongIDTypeID(sng.SongID, SPropType.IT.ToString()); if (string.IsNullOrEmpty(sp.PropertyContent)) continue; sb.AppendFormat(@"<a target=""_blank"" class=""info"" href=""{0}"">", sp.PropertyContent); sb.Append(sng.Name); sb.Append(@"</a>"); } return HttpUtility.HtmlEncode(sb.ToString().Trim()); }
//private void RefreshLists() //{ // Artists arts = new Artists(); // arts.GetAll(); // ddlArtist1.DataSource = arts; // ddlArtist1.DataTextField = "name"; // ddlArtist1.DataValueField = "name"; // ddlArtist1.DataBind(); // General.SortDropDownList(ddlArtist1); // // // ddlArtist2.DataSource = arts; // ddlArtist2.DataTextField = "name"; // ddlArtist2.DataValueField = "name"; // ddlArtist2.DataBind(); // General.SortDropDownList(ddlArtist2); // // // ddlArtist3.DataSource = arts; // ddlArtist3.DataTextField = "name"; // ddlArtist3.DataValueField = "name"; // ddlArtist3.DataBind(); // General.SortDropDownList(ddlArtist3); // Statuses stus = new Statuses(); // stus.GetAll(); // ddlVideoStatus.DataSource = stus; // ddlVideoStatus.DataTextField = "statusDescription"; // ddlVideoStatus.DataValueField = "statusID"; // ddlVideoStatus.DataBind(); // /// // PropertyType propTyp = new PropertyType(SiteEnums.PropertyTypeCode.HUMAN); // MultiProperties mps = new MultiProperties(propTyp.PropertyTypeID); // ddlHumanType.DataSource = mps; // ddlHumanType.DataTextField = "name"; // ddlHumanType.DataValueField = "multiPropertyID"; // ddlHumanType.DataBind(); // /// // propTyp = new PropertyType(SiteEnums.PropertyTypeCode.FOOTG); // mps = new MultiProperties(propTyp.PropertyTypeID); // ddlFootageType.DataSource = mps; // ddlFootageType.DataTextField = "name"; // ddlFootageType.DataValueField = "multiPropertyID"; // ddlFootageType.DataBind(); // /// // propTyp = new PropertyType(SiteEnums.PropertyTypeCode.VIDTP); // mps = new MultiProperties(propTyp.PropertyTypeID); // ddlVideoType.DataSource = mps; // ddlVideoType.DataTextField = "name"; // ddlVideoType.DataValueField = "multiPropertyID"; // ddlVideoType.DataBind(); //} protected void btnSubmit_Click(object sender, EventArgs e) { try { IDictionaryEnumerator enumerator = HttpRuntime.Cache.GetEnumerator(); while (enumerator.MoveNext()) { HttpRuntime.Cache.Remove(enumerator.Key.ToString()); } // RefreshLists(); lblStatus.Text = "OK"; } catch (Exception ex) { lblStatus.Text = ex.Message; } // amazon var sp1 = new SongProperty(); sp1.SongID = sng.SongID; sp1.PropertyContent = txtAmazonLink.Text; sp1.PropertyType = SongProperty.SPropType.AM.ToString(); if (!string.IsNullOrEmpty(sp1.PropertyContent)) { sp1.Create(); } // itunes sp1 = new SongProperty(); sp1.SongID = sng.SongID; sp1.PropertyContent = txtiTunesLink.Text; sp1.PropertyType = SongProperty.SPropType.IT.ToString(); if (!string.IsNullOrEmpty(sp1.PropertyContent)) { sp1.Create(); } }
protected void ddlArtistSongs1_SelectedIndexChanged(object sender, EventArgs e) { var sp1 = new SongProperty(); //am sp1.GetSongPropertySongIDTypeID( sng.SongID, SongProperty.SPropType.AM.ToString()); txtAmazonLink.Text = sp1.PropertyContent; sp1 = new SongProperty(); //it sp1.GetSongPropertySongIDTypeID( sng.SongID, SongProperty.SPropType.IT.ToString()); txtiTunesLink.Text = sp1.PropertyContent; }