public void rptSongs_ItemCommand(object source, RepeaterCommandEventArgs e)
{
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var setSong = setSongService.GetSetSong(new Guid(e.CommandArgument.ToString()));
if (e.CommandName.ToLower() == "fix")
{
txtSongName.Text = setSong.SongName;
hdnSetSongIdToFix.Value = setSong.SetSongId.ToString();
}
else if (e.CommandName.ToLower() == "delete")
{
///TEST THIS SECTION
var songService = new SongService(Ioc.GetInstance<ISongRepository>());
var song = songService.GetSong(setSong.SongId.Value);
using (IUnitOfWork uow = UnitOfWork.Begin())
{
setSongService.Delete(setSong);
if (song != null)
songService.Delete(song);
uow.Commit();
}
var setsongs = setSongService.GetAllSetSongs().Where(x => x.SongName.Contains(txtSearchSongName.Text));
rptSongs.DataSource = setsongs;
rptSongs.DataBind();
}
}
public IQueryable<IAnalysis> GetAnalysisBySong(Guid songId)
{
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var setSongs = setSongService.GetSetSongBySong(songId);
var setSongIds = (from s in setSongs
select s.SetSongId);
return _repo.FindAll().Where(x => setSongIds.Contains(x.SetSongId));
}
public IQueryable <IAnalysis> GetAnalysisBySong(Guid songId)
{
var setSongService = new SetSongService(Ioc.GetInstance <ISetSongRepository>());
var setSongs = setSongService.GetSetSongBySong(songId);
var setSongIds = (from s in setSongs
select s.SetSongId);
return(_repo.FindAll().Where(x => setSongIds.Contains(x.SetSongId)));
}
public void Process(IQueryable<IWantedList> activeWantedLists)
{
var showService = new ShowService(Ioc.GetInstance<IShowRepository>());
var setService = new SetService(Ioc.GetInstance<ISetRepository>());
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var liveSongManglers = (from show in showService.GetAllShows().OrderByDescending(x => x.ShowDate).Take(10)
from set in setService.GetSetsForShow(show.ShowId)
from setsong in setSongService.GetSetSongsBySet(set.SetId)
select new LiveSongDateMangler { LiveSong = (SetSong)setsong, ShowDate = show.ShowDate.Value });
foreach (var wanted in activeWantedLists)
{
//bust it raw dawg
///LEFT OFF HERE
}
}
public void btnFixSetSong_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSongName.Text))
return;
if (string.IsNullOrEmpty(hdnSetSongIdToFix.Value))
return;
var changeSongNameToo = false;
if (chkSongToo.Checked)
changeSongNameToo = true;
var newSongName = txtSongName.Text.Trim();
var setSongId = new Guid(hdnSetSongIdToFix.Value);
using (IUnitOfWork uow = UnitOfWork.Begin())
{
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var setSong = setSongService.GetSetSong(setSongId);
setSong.SongName = newSongName;
var setsongs = setSongService.GetAllSetSongs().Where(x => x.SongName.Contains(txtSearchSongName.Text));
if (changeSongNameToo)
{
var songService = new SongService(Ioc.GetInstance<ISongRepository>());
var song = songService.GetSong(setSong.SongId.Value);
song.SongName = newSongName;
}
uow.Commit();
rptSongs.DataSource = setsongs;
rptSongs.DataBind();
}
}
public void btnBrih_Click(object sender, EventArgs e)
{
var setService = new SetService(Ioc.GetInstance<ISetRepository>());
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
using (IUnitOfWork uow = UnitOfWork.Begin())
{
//bool success = false;
//bool success2 = false;
//bool success3 = false;
//setService.Save(newSet, out success);
//setSongService.Save(davidbowie, out success2);
////setSongService.Save(highway, out success3);
//if (success && success2)
//{
// uow.Commit();
//}
}
}
private void Bind()
{
if (string.IsNullOrEmpty(Request.QueryString["setSongId"]))
Response.Redirect(LinkBuilder.DashboardLink());
var setSongId = new Guid(Request.QueryString["setSongId"]);
var showService = new ShowService(Ioc.GetInstance<IShowRepository>());
var setService = new SetService(Ioc.GetInstance<ISetRepository>());
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var setSong = setSongService.GetSetSong(setSongId);
var set = setService.GetSet(setSong.SetId.Value);
var show = showService.GetShow(set.ShowId.Value);
ShowName = show.GetShowName();
SongName = setSong.SongName;
lnkReviewShow.NavigateUrl = LinkBuilder.AnalysisLink(show.ShowId);
lnkNoReviews.NavigateUrl = LinkBuilder.AnalysisLink(show.ShowId);
SetPageTitle("Review of " + SongName + " from " + ShowName);
BindReviews(setSongId);
}
private FavoriteLiveSongList GetAnalysisPart(Song song)
{
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var analysisService = new AnalysisService(Ioc.GetInstance<IAnalysisRepository>());
var songService = new SongService(Ioc.GetInstance<ISongRepository>());
//Get all Analysis for that Song but in groups of SetSong
var analysis = analysisService.GetAnalysisBySong(song.SongId).GroupBy(x => x.SetSongId);
double highestRating = 0;
double? rating = 0;
List<Guid> setSongIds = new List<Guid>();
//If there are no analysis then there is nothing to see here
if (analysis.Count() == 0)
return null;
var fave = new FavoriteLiveSongList(SetSong.FromSong(song));
//If there are 1 or more analysis then we need to find out which is the highest ranked
foreach (var a in analysis)
{
rating = a.Average(x => x.Rating);
var setSongId = a.First().SetSongId;
if (rating.HasValue && rating.Value > highestRating)
{
highestRating = rating.Value;
fave.HighestRatedShows = new List<Show>();
var setSong = (SetSong)setSongService.GetSetSong(setSongId);
var show = GetShowFromSetSong(setSongId);
fave.HighestRatedShows.Add(show);
}
else if (rating.HasValue && rating.Value == highestRating)
{
var setSong = (SetSong)setSongService.GetSetSong(setSongId);
var show = GetShowFromSetSong(setSongId);
fave.HighestRatedShows.Add(show);
}
}
fave.HighestRating = highestRating;
return fave;
}
public void btnSubmit_Click(object sender, EventArgs e)
{
ResetPanels();
TopicService tourService = new TopicService(Ioc.GetInstance<ITopicRepository>());
SongService songService = new SongService(Ioc.GetInstance<ISongRepository>());
SetService setService = new SetService(Ioc.GetInstance<ISetRepository>());
SetSongService setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
bool success = false;
bool compiledSuccess = true;
if (string.IsNullOrEmpty(hdnId.Value))
{
Bind();
return;
}
var set = (Set)setService.GetSet(new Guid(hdnId.Value));
if (set == null)
{
Bind();
return;
}
if (lstSongs.Items.Count <= 0)
{
Bind();
return;
}
using (IUnitOfWork uow = TheCore.Infrastructure.UnitOfWork.Begin())
{
foreach (ListItem item in lstSongs.Items)
{
if (!item.Selected) { continue; }
var song = songService.GetSong(new Guid(item.Value));
if (song == null) { continue; }
short? order = 1;
if (set.SetSongs.Count > 0)
{
order = set.SetSongs.OrderBy(x => x.Order).Last().Order;
order++;
}
SetSong setSong = new SetSong()
{
Album = song.Album,
CreatedDate = DateTime.UtcNow,
SetSongId = Guid.NewGuid(),
SongId = song.SongId,
SongName = song.SongName,
Order = order,
Set = set,
SetId = set.SetId,
Segue = chkSegue.Checked
};
setSongService.Save(setSong, out success);
compiledSuccess = compiledSuccess && success;
}
if (compiledSuccess)
{
uow.Commit();
phSuccess.Visible = true;
phError.Visible = false;
}
else
{
phError.Visible = true;
phSuccess.Visible = false;
}
}
Bind();
}
public void btnSearchSongName_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSearchSongName.Text))
return;
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var setsongs = setSongService.GetAllSetSongs().Where(x => x.SongName.Contains(txtSearchSongName.Text));
rptSongs.DataSource = setsongs;
rptSongs.DataBind();
}
public static List<FavoriteSetSong> GenerateFavoriteVersionListByAlbum(string album)
{
var songService = new SongService(Ioc.GetInstance<ISongRepository>());
var setSongService = new SetSongService(Ioc.GetInstance<ISetSongRepository>());
var favoriteVersionService = new FavoriteVersionService(Ioc.GetInstance<IFavoriteVersionRepository>());
var showService = new ShowService(Ioc.GetInstance<IShowRepository>());
var setService = new SetService(Ioc.GetInstance<ISetRepository>());
FavoriteVersionSongList songList = new FavoriteVersionSongList();
foreach (var song in songService.GetSongsByAlbum(album))
{
var versions = favoriteVersionService.GetAllFavoriteVersions().Where(s => s.SongId == song.SongId).GroupBy(g => g.SetSongId).ToList();
if (versions == null || versions.Count() <= 0)
{
songList.AddFavoriteSongPair(null, SetSong.FromSong((Song)song), null);
continue;
}
if (versions.Count() == 1)
{
var version = versions[0].First();
var setSong = setSongService.GetSetSong(version.SetSongId.Value);
var set = setService.GetSet(setSong.SetId.Value);
var show = showService.GetShow(set.ShowId.Value);
songList.AddFavoriteSongPair((FavoriteVersion)version, (SetSong)setSong, (Show)show);
}
else
{
int count = 0;
Guid? setSongId = null;
FavoriteVersion fave = null;
SetSong setSong = null;
IShow show = null;
foreach (var version in versions)
{
if (version.Count() > count)
{
fave = (FavoriteVersion)version.First();
setSongId = version.First().SetSongId;
}
}
if(setSongId != null)
{
setSong = (SetSong)setSongService.GetSetSong(setSongId.Value);
var set = setService.GetSet(setSong.SetId.Value);
show = showService.GetShow(set.ShowId.Value);
}
songList.AddFavoriteSongPair(fave, setSong ?? SetSong.FromSong((Song)song) , (Show)show);
}
}
return songList.SongList;
}