public IActionResult Index()
{
// Check if Karaoke is accepting requests
using (var db = new SongDBContext())
{
try
{
Configuration state = db.Configurations.Where(
s => s.key == Constants.KARAOKE_STATE_FLAG).FirstOrDefault();
if (state == null || state.value == Constants.STOPPED_FLAG)
{
return(View("NotStarted"));
}
}
catch (InvalidOperationException)
{
return(View("NotStarted"));
}
catch (IndexOutOfRangeException)
{
return(View("NotStarted"));
}
}
String singerNameCookie = Request.Cookies[SINGERNAME_COOKIE];
SongRequest songRequest = new SongRequest();
songRequest.singerName = singerNameCookie;
songRequest.songId = 1;
return(View("Index", songRequest));
}
public ActionResult SubmitBtn(SongRequest songRequest)
{
if (ModelState.IsValid)
{
string singerName = songRequest.singerName;
using (var db = new SongDBContext())
{
try
{
string[] fields = songRequest.title.Trim().Split(" par ");
String query = fields[0] + fields[1];
Artist artist = (Artist)db.KaraokeArtists.Where(a => a.Name == fields[1]).First();
Song song = (Song)db.KaraokeSongs.Where(s => s.Title == fields[0] && s.ArtistId == artist.Id).First();
if (song != null)
{
Request request = new Request();
request.SingerName = singerName;
request.SongId = song.Id;
request.Notes = songRequest.notes;
request.RequestTime = DateTime.Now;
db.KaraokeRequests.Add(request);
db.SaveChanges();
}
}
catch (IndexOutOfRangeException)
{
ViewData["SubmitSong"] = "La chanson demandée n'existe pas";
return(View("Index", songRequest));
}
catch (InvalidOperationException)
{
ViewData["SubmitSong"] = "La chanson demandée n'existe pas";
return(View("Index", songRequest));
}
catch (ArgumentNullException)
{
ViewData["SubmitSong"] = "La chanson demandée n'existe pas";
return(View("Index", songRequest));
}
ModelState.Clear();
ViewData["SubmitSong"] = "Demande effectuée avec succès à " + String.Format("{0:HH:mm:ss}", DateTime.Now);
CookieOptions cookieOption = new CookieOptions();
cookieOption.Expires = DateTime.Now.AddDays(30);
Response.Cookies.Append(SINGERNAME_COOKIE, singerName, cookieOption);
}
SongRequest newRequest = new SongRequest();
newRequest.singerName = singerName;
return(View("Index", newRequest));
}
return(View("Index"));
}
public SongController(UserManager <ApplicationUser> userManager, SongDBContext songContext, MySongsDBContext mySongContext)
{
_Context = songContext;
_MySongsContext = mySongContext;
_user = userManager;
}
