protected void Update_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(EditAlbumID.Text)) { MessageUserControl.ShowInfo("Updating", "Search for an exsiting album before updating"); } else if (int.Parse(EditReleaseYear.Text) >= 1950 && int.Parse(EditReleaseYear.Text) <= DateTime.Today.Year) { MessageUserControl.TryRun(() => { Album item = new Album(); item.AlbumId = int.Parse(EditAlbumID.Text); item.Title = EditTitle.Text; item.ReleaseYear = int.Parse(EditReleaseYear.Text); item.ReleaseLabel = string.IsNullOrEmpty(EditReleaseLabel.Text) ? null : EditReleaseLabel.Text; item.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); AlbumController sysmgr = new AlbumController(); int rowsaffected = sysmgr.Album_Update(item); if (rowsaffected == 0) { throw new Exception("Album no longer on file. Refresh your search."); } else { ArtistList.SelectedValue = item.ArtistId.ToString(); AlbumList.DataBind(); } }, "Update", "Action successful"); } else { MessageUserControl.ShowInfo("Adding", "Release Year must be 1950 to today"); } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { string editID = EditAlbumID.Text; int albumID = 0; if (string.IsNullOrEmpty(editID)) { MessageUserControl.ShowInfo("Error", "Must have album to edit."); } else if (!int.TryParse(editID, out albumID)) { MessageUserControl.ShowInfo("Error", "Invalid album ID"); } else { string title = EditTitle.Text; int year = int.Parse(EditReleaseYear.Text); string label = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; int artist = int.Parse(EditAlbumArtistList.SelectedValue); int editAlbumID = int.Parse(EditAlbumID.Text); Album newAlbum = new Album(); newAlbum.AlbumId = editAlbumID; newAlbum.ArtistId = artist; newAlbum.Title = title; newAlbum.ReleaseYear = year; newAlbum.ReleaseLabel = label; MessageUserControl.TryRun(() => { AlbumController controller = new AlbumController(); int rows = controller.Album_Update(newAlbum); if (rows > 0) { AlbumList.DataBind(); } else { throw new Exception("No album found. Try again."); } }, "Sucessful!", "Album updated."); } } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { int editalbumid = 0; string albumid = EditAlbumID.Text; if (string.IsNullOrEmpty(albumid)) { MessageUserControl.ShowInfo("Attention", "Look up the album before editing"); } else if (int.TryParse(albumid, out editalbumid)) { MessageUserControl.ShowInfo("Attention", "Current Album ID is Invalid, Look Again!"); } else { //string albumtitle = //int albumyear = //string albumlabel = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; //int albumartist = int.Parse(EditAlbumArtistList.SelectedValue); Album theAlbum = new Album(); theAlbum.AlbumId = editalbumid; theAlbum.Title = EditTitle.Text; theAlbum.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); theAlbum.ReleaseYear = int.Parse(EditReleaseYear.Text); theAlbum.ReleaseLabel = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; MessageUserControl.TryRun(() => { AlbumController sysmgr = new AlbumController(); int rowsaffected = sysmgr.Album_Update(theAlbum); EditAlbumID.Text = albumid.ToString(); if (rowsaffected > 0) { AlbumList.DataBind(); } else { throw new Exception("Album was not found. Look up again"); } }, "Successful", "Album Updated"); } } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { //the validation that exists within the event is probably validation that // a) is not possible on the form // b) required for specific events only // c) for some reason, it was decided to the validation in code-behind if (string.IsNullOrEmpty(EditAlbumID.Text)) { MessageUserControl.ShowInfo("Updating", "Search for an exsiting album before updating"); } else if (int.Parse(EditReleaseYear.Text) >= 1950 && int.Parse(EditReleaseYear.Text) <= DateTime.Today.Year) { MessageUserControl.TryRun(() => { Album item = new Album(); item.AlbumId = int.Parse(EditAlbumID.Text); item.Title = EditTitle.Text; item.ReleaseYear = int.Parse(EditReleaseYear.Text); item.ReleaseLabel = string.IsNullOrEmpty(EditReleaseLabel.Text) ? null : EditReleaseLabel.Text; item.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); AlbumController sysmgr = new AlbumController(); int rowsaffected = sysmgr.Album_Update(item); if (rowsaffected == 0) { throw new Exception("Album no longer on file. Refresh your search."); } else { ArtistList.SelectedValue = item.ArtistId.ToString(); AlbumList.DataBind(); } }, "Update", "Action successful"); } else { MessageUserControl.ShowInfo("Adding", "Release Year must be 1950 to today"); } } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { int editalbumid = 0; string albumid = EditAlbumID.Text; if (string.IsNullOrEmpty(albumid)) { MessageUserControl.ShowInfo("Uh-oh!", "Look up the album before editing. Duh."); } else if (!int.TryParse(albumid, out editalbumid)) { MessageUserControl.ShowInfo("Attencion!", "Current album id is invalid. Perform look up again."); } else { //now put them inside an instance. Album theAlbum = new Album(); theAlbum.AlbumId = editalbumid; theAlbum.Title = EditTitle.Text; theAlbum.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); theAlbum.ReleaseYear = int.Parse(EditReleaseYear.Text); theAlbum.ReleaseLabel = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; MessageUserControl.TryRun(() => { AlbumController sysmgr = new AlbumController(); int rowsaffected = sysmgr.Album_Update(theAlbum); EditAlbumID.Text = albumid.ToString(); if (rowsaffected > 0) { AlbumList.DataBind(); // reexecute the ODS for my albumlist. } else { throw new Exception("Album was not found. Repeat look up and update again."); } }, "Successful", "Album Updated"); } } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { int editablumid = 0; string albumid = EditAlbumID.Text; if (string.IsNullOrEmpty(albumid)) { MessageUserControl.ShowInfo("Select the album before editing"); } else if (!int.TryParse(albumid, out editablumid)) { MessageUserControl.ShowInfo("failed", "invalid album id"); } else { Album theAlbum = new Album(); theAlbum.AlbumId = editablumid; theAlbum.Title = EditTitle.Text; theAlbum.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); theAlbum.ReleaseYear = int.Parse(EditReleaseYear.Text); theAlbum.ReleaseLabel = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; MessageUserControl.TryRun(() => { AlbumController sysmgr = new AlbumController(); int rowsAffected = sysmgr.Album_Update(theAlbum); EditAlbumID.Text = rowsAffected.ToString(); if (AlbumList.Rows.Count > 0) { AlbumList.DataBind(); } else { throw new Exception("Album was not found. Repeat lookup and update again."); } }, "Successful", "Album Updated"); } } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { int editalbumid = 0; string albumid = EditAlbumID.Text; if (string.IsNullOrEmpty(albumid)) { messageUserControl.ShowInfo("Attention, Actung! Arrividarchi!", "Lookup the album before editing, please."); } else if (!int.TryParse(albumid, out editalbumid)) { throw new Exception("Current albumid is invalid. Perform lookup again, please."); } else { Album theAlbum = new Album(); //brings in values to the webpage theAlbum.AlbumId = editalbumid; theAlbum.Title = EditTitle.Text; theAlbum.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); theAlbum.ReleaseYear = int.Parse(EditReleaseYear.Text); theAlbum.ReleaseLabel = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; messageUserControl.TryRun(() => { AlbumController sysmgr = new AlbumController(); int rowsaffected = sysmgr.Album_Update(theAlbum); if (rowsaffected > 0) { AlbumList.DataBind(); //re-executes the ods for the album list } else { messageUserControl.ShowInfo("Hello, I am title", "Album was not found. Repeat lookup and update again."); } }, "Successful", "Album added"); } } }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { string albumid = EditAlbumID.Text; int editalbumid = 0; if (string.IsNullOrEmpty(albumid)) { MessageUserControl.ShowInfo("Attention", "Lookup the album before editing, idiot"); } else if (!int.TryParse(albumid, out editalbumid)) { MessageUserControl.ShowInfo("Attention", "Current AlbumID is invalid, idiot"); } else { Album theAlbum = new Album(); theAlbum.AlbumId = editalbumid; //include pkey theAlbum.Title = EditTitle.Text; theAlbum.ArtistId = int.Parse(EditAlbumArtistList.SelectedValue); theAlbum.ReleaseYear = int.Parse(EditReleaseYear.Text); theAlbum.ReleaseLabel = EditReleaseLabel.Text == "" ? null : EditReleaseLabel.Text; MessageUserControl.TryRun(() => { AlbumController sysmgr = new AlbumController(); int rowsaffected = sysmgr.Album_Update(theAlbum); if (rowsaffected > 0) { AlbumList.DataBind(); //Re-execute the ODS for the Album List } else { throw new Exception("Album was not found. Repeat lookup and update again."); } }, "Successful", "Album updated"); } } }