private void BindFromPhishNet()
        {
            const string apiCall = "http://api.phish.net/api.js?api=2.0&method=pnet.user.myshows.get&format=json&apikey=6D31B9439E9F9B550B42&username={0}";

            if (string.IsNullOrEmpty(txtUserName.Text))
                return;

            hdnBindFrom.Value = "phishnet";

            var url = string.Format(apiCall, txtUserName.Text);

            var request = (HttpWebRequest)WebRequest.Create(url);

            var response = (HttpWebResponse)request.GetResponse();

            var ver = response.ProtocolVersion.ToString();

            var reader = new StreamReader(response.GetResponseStream());

            var resp = reader.ReadToEnd();

            var showDates = JSONParser.AddMyShowJSON(resp);

            var showService = new ShowService(Ioc.GetInstance<IShowRepository>());
            var myShowService = new MyShowService(Ioc.GetInstance<IMyShowRepository>());
            var userId = new Guid(Membership.GetUser(User.Identity.Name).ProviderUserKey.ToString());

            var shows = showService.GetShows(showDates);

            var finalShows = myShowService.GetShowsNotInUsersMyShows(userId, shows);

            var labelName = txtUserName.Text + "'s Shows From Phish.Net";

            BindShows(labelName, false, finalShows);
        }
        private void Bind()
        {
            var photoService = new PhotoService(Ioc.GetInstance<IPhotoRepository>());
            var showService = new ShowService(Ioc.GetInstance<IShowRepository>());

            var photos = photoService.GetRecentlyAddedPhotos().ToList();
            var showIds = (from p in photos select p.ShowId.Value).ToList();
            var shows = showService.GetShows(showIds);

            var showPhotos = new List<ShowPhoto>();

            showPhotos = (from p in photos
                          from s in shows
                          where p.ShowId == s.ShowId
                          select new ShowPhoto { NickName = p.NickName, ShowDate = s.ShowDate.Value.ToShortDateString(), ShowId = s.ShowId.ToString() }).ToList();

            rptRecentlyAddedPictures.DataSource = showPhotos;
            rptRecentlyAddedPictures.DataBind();
        }