public ActionResult DetailsTrack(DetailTrackWithArtist model)
{
if (Request.QueryString["TrackId"] != null)
{
model.TrackId = (int)double.Parse(Request.QueryString["TrackId"]);
}
if (model.TrackId != 0)
{
model = DetailTrackDB.DetailFromId(model.TrackId);
}
else
{
return(RedirectToAction("ListTrack"));
}
return(View(model));
}
public ActionResult EditTrack(DetailTrackWithArtist model, string submit, string Search)
{
if (TempData["TrackInEdit"] != null)
{
model.TrackId = (int)TempData["TrackInEdit"];
}
if (model.TrackId != 0)
{
switch (submit)
{
case "Save":
if (ModelState.IsValid)
{
model = EditTrackDB.EditTrack(model); //zmapować ten model, na taki, żeby widok chciał go widziec, albo przejśc na strone z detalami, to w sumie dobry pomysł chyba tak zaaraz zrobię
return(RedirectToAction("DetailsTrack", new { TrackId = model.TrackId }));
}
break;
case "Search":
/*TODO cały mechanizm od szukajki */
if (model.Title != null)
{
TempData["TrackTitle"] = model.Title;
}
if (model.ReleaseDate != null)
{
Cookies.RememberDateFromModel(model.ReleaseDate);
}
TempData["TrackInEdit"] = model.TrackId;
return(RedirectToAction("SearchArtistEdit", new { searchString = model.SearchString }));
default:
break;
}
}
else
{
return(RedirectToAction("ListTrack"));
}
return(View(model));
}
public static string ModifyTrackSring(DetailTrackWithArtist NewModel, DetailTrackWithArtist Oldmodel)
{
{
int Numberofchange = 0;
string sql = @"UPDATE dbo.Track Set ";
if (NewModel.Title != null)
{
if (NewModel.Title != Oldmodel.Title)
{
sql += "Title = @Title, ";
Numberofchange++;
}
}
if (NewModel.ReleaseDate != null)
{
if (NewModel.ReleaseDate != Oldmodel.ReleaseDate)
{
sql += "ReleaseDate = @ReleaseDate, ";
Numberofchange++;
}
}
if (NewModel.ArtistIdFK != Oldmodel.ArtistIdFK)
{
sql += "ArtistIdFK = @ArtistIdFK, ";
Numberofchange++;
}
sql = sql.Remove(sql.Length - 2, 2);
sql += " Where TrackId = @TrackId; ";
if (Numberofchange != 0)
{
return(sql);
}
else
{
return(null);
}
}
}
public static DetailTrackWithArtist EditTrack(DetailTrackWithArtist NewModel)
{
DetailTrackWithArtist OldModel = DetailTrackDB.DetailFromId(NewModel.TrackId);
string sql = TrackFunctions.ModifyTrackSring(NewModel, OldModel);
if (sql == null)
{
return(NewModel);
}
else
{
DataAccess.SaveData(sql, NewModel);
}
DetailTrackWithArtist NewModelfromDB = new DetailTrackWithArtist();
NewModelfromDB = DetailTrackDB.DetailFromId(OldModel.TrackId);
return(NewModelfromDB);
}
