public ActionResult CreateTrack(AddTracks model, string submit)
{
switch (submit)
{
case "Create":
if (ModelState.IsValid)
{
int JustaddedTrack = AddTrackDB.SaveTracktoDB(model);
if (JustaddedTrack != 0)
{
return(RedirectToAction("DetailsTrack", new { TrackId = JustaddedTrack }));
}
else
{
return(RedirectToAction("FailedTrack"));
}
}
break;
case "Search":
if (model.Title != null)
{
TempData["TrackTitle"] = model.Title;
}
if (model.ReleaseDate != null)
{
Cookies.RememberDateFromModel(model.ReleaseDate);
}
return(RedirectToAction("SearchArtistAdd", new { searchString = model.SearchString }));
default:
break;
}
return(View());
}
public static int SaveTracktoDB(AddTracks model)
{
AddTracks data = new AddTracks
{
ArtistIdFK = model.ArtistIdFK,
ReleaseDate = model.ReleaseDate,
Title = model.Title
};
string sqlSave = @"INSERT into dbo.Track (ArtistIdFK, ReleaseDate, Title) values (@ArtistIdFK, @ReleaseDate, @Title);";
int Numberofsaves = DataAccess.SaveData(sqlSave, data);
if (Numberofsaves == 1)
{
string date = model.ReleaseDate.ToString();
date = date.Substring(0, 10);
char separator = '.';
string[] temp = date.Split(separator);
date = temp[2] + "." + temp[1] + "." + temp[0];
string sqlLoad = @"SELECT TrackId from dbo.Track where " +
" ReleaseDate = '" + date + "' AND " +
" ArtistIdFK = '" + model.ArtistIdFK + "' AND " +
" Title = '" + model.Title + "' ;";
int AddedId = DataAccess.LoadData <DetailTracks>(sqlLoad).First().TrackId;
return(AddedId);
}
return(0);
}
