public void ChangeData() { try { DateTime.Parse(_rowData.Cells["ReleaseDate"].Value.ToString()); Int32.Parse(_rowData.Cells["Price"].Value.ToString()); Int32.Parse(_rowData.Cells["Penalty"].Value.ToString()); Int32.Parse(_rowData.Cells["YearLimitation"].Value.ToString()); } catch (Exception e) { Thread showErrorMessage = new Thread(() => MessageBox.Show("Nie można przekonwertować wprowadzonych warotści. Proszę sprawdzić ich poprawność.", "Parsing error")); showErrorMessage.Start(); return; } using (filmyEntities entities = new filmyEntities()) { var movie = entities.Movie.Find(_movieList[_indexOfRow].ID_Movie); movie.Title = _rowData.Cells["Title"].Value.ToString(); movie.Director = _rowData.Cells["Director"].Value.ToString(); movie.Relase_Date = DateTime.Parse(_rowData.Cells["ReleaseDate"].Value.ToString()); movie.Category = _rowData.Cells["Category"].Value.ToString(); movie.Price = Int32.Parse(_rowData.Cells["Price"].Value.ToString()); movie.Penalty = Int32.Parse(_rowData.Cells["Penalty"].Value.ToString()); movie.Year_Limitation = Int32.Parse(_rowData.Cells["YearLimitation"].Value.ToString()); entities.SaveChanges(); } }
public void ChangeData() { using (filmyEntities entities = new filmyEntities()) { // find and delete all Transactions int IDToCheck = _movieList[_indexOfRow].ID_Movie; var movieInstancesContainingMovieID = entities.Movie_Instance.Where(e => e.FK_ID_Movie == IDToCheck).ToList(); // find all instances foreach (var instance in movieInstancesContainingMovieID) { IDToCheck = instance.ID_Movie_Instance; entities.Transactions.RemoveRange(entities.Transactions.Where(e => e.FK_ID_Movie_Instance == IDToCheck)); // get IDs of that instances and remove it form transaction } // remove instances IDToCheck = _movieList[_indexOfRow].ID_Movie; entities.Movie_Instance.RemoveRange(entities.Movie_Instance.Where(e => e.FK_ID_Movie == IDToCheck)); // removd movie var x = _movieList[_indexOfRow].ID_Movie; entities.Movie.RemoveRange(entities.Movie.Where(e => e.ID_Movie == x)); entities.SaveChanges(); } }