public bool AddSong(string url, int profileId)
{
DBSong dbSong = new DBSong();
DbActivity dbActivity = new DbActivity();
using (IDbTransaction tran = DbConnection.GetInstance().BeginTransaction())
{
try
{
Song song = dbSong.FindSongByURL(url);
if (song != null)
{
return(false);
}
int activityId = dbActivity.CreateActivity(profileId);
if (activityId > 0 && dbSong.AddSong(GetVideoTitle(url), GetVideoDuration(url), url, activityId) > 0)
{
tran.Commit();
return(true);
}
else
{
tran.Rollback();
return(false);
}
}
catch (Exception)
{
tran.Rollback();
return(false);
}
}
}
public SongTests()
{
dbActivity = new DbActivity();
songController = new SongController();
dbConnection = DbConnection.GetInstance();
dbSong = new DBSong();
}
public void GetSongByIdTest()
{
//Niet correct? Door datum denk.
DBSong dbSong = new DBSong();
Song actual = dbSong.GetSongById(1);
Song expect = new Song(1, "Keep yourself Alive", 144, Convert.ToDateTime("2016-06-12"));
Assert.AreEqual(expect, actual);
}
public List <Song> FindSongsByName(string name)
{
DBSong dbSong = new DBSong();
SqlConnection con = new DbConnection().GetConnection();
try
{
return(dbSong.FindSongsByName(name, null, con));
}
finally
{
con.Close();
}
}
public SongTests()
{
dbActivity = new DbActivity();
songController = new SongController();
dbSong = new DBSong();
}
void Start()
{
// Instantiate
useSaveLevel = new UseSaveLevel();
dBLevel = new DBLevel();
useLoadLevel = new UseLoadLevel();
useInitLevel = new UseInitLevel();
useCreateNote = new UseCreateNote();
dBNote = new DBNote();
useDeleteNote = new UseDeleteNote();
useAbortLevel = new UseAbortLevel();
useInitSong = new UseInitSong();
dBSong = new DBSong();
useSetSong = new UseSetSong();
useLatencyReset = new UseLatencyReset();
dSLatency = new DSLatency();
useLatency = new UseLatency();
useJukeTime = new UseJukeTime();
conMenuState = new ConMenuState();
conMenuExitGame = new ConMenuExitGame();
conMenuExitEdit = new ConMenuExitEdit();
conMenuExitLatency = new ConMenuExitLatency();
conMenuLatency = new ConMenuLatency();
conMenuGame = new ConMenuGame();
conMenuEdit = new ConMenuEdit();
useNoteKiller = new UseNoteKiller();
conAbortLevel = new ConAbortLevel();
conLoadLevel = new ConLoadLevel();
conSetSong = new ConSetSong();
useHP = new UseHP();
// Update
updater.AddIMB(useSaveLevel);
updater.AddIMB(useLoadLevel);
updater.AddIMB(useInitLevel);
updater.AddIMB(useCreateNote);
updater.AddIMB(useDeleteNote);
updater.AddIMB(useAbortLevel);
updater.AddIMB(useInitSong);
updater.AddIMB(useSetSong);
updater.AddIMB(useLatencyReset);
updater.AddIMB(useLatency);
updater.AddIMB(useJukeTime);
updater.AddIMB(conMenuState);
updater.AddIMB(conMenuExitGame);
updater.AddIMB(conMenuExitEdit);
updater.AddIMB(conMenuExitLatency);
updater.AddIMB(conMenuLatency);
updater.AddIMB(conMenuGame);
updater.AddIMB(conMenuEdit);
updater.AddIMB(useNoteKiller);
updater.AddIMB(conAbortLevel);
updater.AddIMB(conLoadLevel);
updater.AddIMB(conSetSong);
updater.AddIMB(useHP);
// Connect
useSaveLevel.modelCrtLevelAction += dBLevel.ReceiveModelCrtLevel;
useLoadLevel.modelGetLevelAction += dBLevel.ReceiveModelGetLevel;
useInitLevel.modelGetLevelAction += dBLevel.ReceiveModelGetLevel;
useCreateNote.modelCrtNoteAction += dBNote.ReceiveModelCrtNote;
useDeleteNote.modelDelNoteAction += dBNote.ReceiveModelDelNote;
useAbortLevel.modelDelNoteAction += dBNote.ReceiveModelDelNote;
useSaveLevel.modelGetNoteAction += dBNote.ReceiveModelGetNote;
outCreateNote.modelCrtInsNoteAction += facNote.ReceiveModelCrtInsNote;
outDeleteNote.modelDelInsNoteAction += facNote.ReceiveModelDelInsNote;
outJukeTime.modelOutJukeTimeAction += outCam.ReceiveModelOutJukeTime;
outJukeTime.modelOutJukeTimeAction += inCreateNote.ReceiveModelOutJukeTime;
outJukeTime.modelOutJukeTimeAction += inDeleteNote.ReceiveModelOutJukeTime;
useInitSong.modelCrtSongAction += dBSong.ReceiveModelCrtSong;
useSetSong.modelGetSongAction += dBSong.ReceiveModelGetSong;
useLatencyReset.modelSetLatencyAction += dSLatency.ReceiveModelSetLatency;
useLatency.modelSetLatencyAction += dSLatency.ReceiveModelSetLatency;
useLatency.modelGetLatencyAction += dSLatency.ReceiveModelGetLatency;
useLoadLevel.modelGetLatencyAction += dSLatency.ReceiveModelGetLatency;
useJukeTime.modelGetLatencyAction += dSLatency.ReceiveModelGetLatency;
useCreateNote.noteAction += outCreateNote.ReceiveNote;
outMap.noteAction += outCreateNote.ReceiveNote;
inMenuEdit.menuStateAction += conMenuState.ReceiveMenuState;
inMenuExitEdit.menuStateAction += conMenuState.ReceiveMenuState;
inMenuLatency.menuStateAction += conMenuState.ReceiveMenuState;
inMenuGame.menuStateAction += conMenuState.ReceiveMenuState;
inMenuExitLatency.menuStateAction += conMenuState.ReceiveMenuState;
inMenuExitGame.menuStateAction += conMenuState.ReceiveMenuState;
conMenuExitGame.modelOutMenuAction += outMenu.ReceiveModelOutMenu;
conMenuExitEdit.modelOutMenuAction += outMenu.ReceiveModelOutMenu;
conMenuExitLatency.modelOutMenuAction += outMenu.ReceiveModelOutMenu;
conMenuLatency.modelOutMenuAction += outMenu.ReceiveModelOutMenu;
conMenuGame.modelOutMenuAction += outMenu.ReceiveModelOutMenu;
conMenuEdit.modelOutMenuAction += outMenu.ReceiveModelOutMenu;
conMenuExitLatency.modelOutLatencyAction += outLatency.ReceiveModelOutLatency;
conMenuLatency.modelOutLatencyAction += outLatency.ReceiveModelOutLatency;
conMenuGame.modelOutGameAction += outGame.ReceiveModelOutGame;
conMenuExitGame.modelOutGameAction += outGame.ReceiveModelOutGame;
conMenuExitEdit.modelOutEditAction += outEdit.ReceiveModelOutEdit;
conMenuEdit.modelOutEditAction += outEdit.ReceiveModelOutEdit;
inNet.modelInNetAction += outNet.ReceiveModelInNet;
inNet.modelInNetAction += useNoteKiller.ReceiveModelInNet;
useAbortLevel.modelOutClearAction += outClear.ReceiveModelOutClear;
conMenuExitGame.modelOutClearAction += outClear.ReceiveModelOutClear;
outSetSong.modelOutSetSongAction += outJukebox.ReceiveModelOutSetSong;
conMenuState.menuStateAction += outCam.ReceiveMenuState;
conMenuState.menuStateAction += inNet.ReceiveMenuState;
conMenuState.menuStateAction += inWin.ReceiveMenuState;
conMenuState.menuStateAction += outCardCtrl.ReceiveMenuState;
outJukebox.timeInfAction += inJukeTime.ReceiveTimeInf;
outJukebox.timeInfAction += inWin.ReceiveTimeInf;
outJukebox.timeInfAction += inLatency.ReceiveTimeInf;
useInitLevel.modelCrtInsLevelCardAction += facLevelCard.ReceiveModelCrtInsLevelCard;
outInitSong.modelCrtInsSongCardAction += facSongCard.ReceiveModelCrtInsSongCard;
outCardCtrl.modelGetInsSongCardAction += facSongCard.ReceiveModelGetInsSongCard;
outCardCtrl.modelGetInsLevelCardAction += facLevelCard.ReceiveModelGetInsLevelCard;
inJukeMove.modelInJukeMoveToOutJukeboxAction += outJukebox.ReceiveModelInJukeMoveToOutJukebox;
inJukebox.jukeOpAction += outJukebox.ReceiveJukeOp;
inJukeSpeed.modelInJukeSpeedToOutJukeboxAction += outJukebox.ReceiveModelInJukeSpeedToOutJukebox;
useLoadLevel.loadLevelAssetAction += outMap.ReceiveLoadLevelAsset;
useDeleteNote.modelUseDeleteNoteToOutDeleteNoteAction += outDeleteNote.ReceiveModelUseDeleteNoteToOutDeleteNote;
conAbortLevel.modelConAbortLevelToUseAbortLevelAction += useAbortLevel.ReceiveModelConAbortLevelToUseAbortLevel;
inSaveLevel.modelInSaveLevelToUseSaveLevelAction += useSaveLevel.ReceiveModelInSaveLevelToUseSaveLevel;
conLoadLevel.modelConLoadLevelToUseLoadLevelAction += useLoadLevel.ReceiveModelConLoadLevelToUseLoadLevel;
inDeleteNote.modelInDeleteNoteToUseDeleteNoteAction += useDeleteNote.ReceiveModelInDeleteNoteToUseDeleteNote;
inCreateNote.noteAction += useCreateNote.ReceiveNote;
inInit.modelInInitToUseInitSongAction += useInitSong.ReceiveModelInInitToUseInitSong;
conSetSong.modelConSetSongToUseSetSongAction += useSetSong.ReceiveModelConSetSongToUseSetSong;
useSetSong.modelUseSetSongToOutSetSongAction += outSetSong.ReceiveModelUseSetSongToOutSetSong;
useInitSong.modelUseInitSongToOutInitSongAction += outInitSong.ReceiveModelUseInitSongToOutInitSong;
inLatency.modelInLatencyToUseLatencyAction += useLatency.ReceiveModelInLatencyToUseLatency;
inLatencyReset.modelInLatencyResetToUseLatencyResetAction += useLatencyReset.ReceiveModelInLatencyResetToUseLatencyReset;
useLatency.modelUseLatencyToOutLatencyDisplayAction += outLatencyDisplay.ReceiveModelUseLatencyToOutLatencyDisplay;
inMenuEdit.modelInMenuEditToConMenuEditAction += conMenuEdit.ReceiveModelInMenuEditToConMenuEdit;
inMenuExitEdit.modelInMenuExitEditToConMenuExitEditAction += conMenuExitEdit.ReceiveModelInMenuExitEditToConMenuExitEdit;
inMenuGame.modelInMenuGameToConMenuGameAction += conMenuGame.ReceiveModelInMenuGameToConMenuGame;
conMenuGame.modelConMenuGameToConLoadLevelAction += conLoadLevel.ReceiveModelConMenuGameToConLoadLevel;
inMenuLatency.modelInMenuLatencyToConMenuLatencyAction += conMenuLatency.ReceiveModelInMenuLatencyToConMenuLatency;
inMenuExitGame.modelInMenuExitGameToConMenuExitGameAction += conMenuExitGame.ReceiveModelInMenuExitGameToConMenuExitGame;
conMenuExitEdit.modelConMenuExitEditToConAbortLevelAction += conAbortLevel.ReceiveModelConMenuExitEditToConAbortLevel;
inMenuExitLatency.modelInMenuExitLatencyToConMenuExitLatencyAction += conMenuExitLatency.ReceiveModelInMenuExitLatencyToConMenuExitLatency;
inJukeTime.modelInJukeTimeToUseJukeTimeAction += useJukeTime.ReceiveModelInJukeTimeToUseJukeTime;
useJukeTime.modelUseJukeTimeToOutJukeTimeAction += outJukeTime.ReceiveModelUseJukeTimeToOutJukeTime;
useLoadLevel.modelUseLoadLevelToUseNoteKillerAction += useNoteKiller.ReceiveModelUseLoadLevelToUseNoteKiller;
useNoteKiller.modelUseNoteKillerToUseHPAction += useHP.ReceiveModelUseNoteKillerToUseHP;
useHP.modelUseHPToOutHPAction += outHP.ReceiveModelUseHPToOutHP;
useHP.modelUseHPToOutFailAction += outFail.ReceiveModelUseHPToOutFail;
inWin.modelInWinToOutWinAction += outWin.ReceiveModelInWinToOutWin;
useLatencyReset.modelUseLatencyResetToOutLatencyDisplayAction += outLatencyDisplay.ReceiveModelUseLatencyResetToOutLatencyDisplay;
inInit.modelInInitToUseInitLevelAction += useInitLevel.ReceiveModelInInitToUseInitLevel;
conMenuEdit.modelConSetSongAction += conSetSong.ReceiveModelConSetSong;
conLoadLevel.modelConSetSongAction += conSetSong.ReceiveModelConSetSong;
}
public List <Song> FindSongsByName(string name)
{
DBSong dbSong = new DBSong();
return(dbSong.FindSongsByName(name));
}
