public ActionResult Create([Bind(Include = "ID,Title,Artist,ReleaseDate,Genre,Price")] Song song)
{
if (ModelState.IsValid)
{
db.Songs.Add(song);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(song));
}
public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Singer,SongWriter")] Song song)
{
if (ModelState.IsValid)
{
db.Playlist.Add(song);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(song));
}
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"));
}