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();
}
}
