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(); } }
public List <Movie> Refresh() { if (string.IsNullOrEmpty(_title)) { _title = ""; } if (string.IsNullOrEmpty(_director)) { _director = ""; } if (string.IsNullOrEmpty(_category)) { _category = ""; } filmyEntities entities = new filmyEntities(); _movieList = entities.Movie.Where(c => c.Title.Contains(_title) && c.Director.Contains(_director) && c.Category.Contains(_category)).ToList(); _movies.Rows.Clear(); foreach (var movie in _movieList) { DataGridViewRow r = _movies.Rows[_movies.Rows.Add()];//new DataGridViewRow(); r.Cells["ID"].Value = movie.ID_Movie; r.Cells["Title"].Value = movie.Title; r.Cells["Director"].Value = movie.Director; r.Cells["ReleaseDate"].Value = movie.Relase_Date; r.Cells["Category"].Value = movie.Category; r.Cells["Price"].Value = movie.Price; r.Cells["Penalty"].Value = movie.Penalty; r.Cells["YearLimitation"].Value = movie.Year_Limitation; // count number of copies var querry = entities.Movie.Join(entities.Movie_Instance, s => s.ID_Movie, c => c.FK_ID_Movie, (s, c) => new { s, c }).Where(sc => sc.c.FK_ID_Movie == movie.ID_Movie && sc.c.Is_Rented == false).Select(sc => sc.s) .Count(); r.Cells["Copies"].Value = querry; } return(_movieList); }
public void ShowData() { _dataGrid.Rows.Clear(); using (filmyEntities entities = new filmyEntities()) { int id = Int32.Parse(_id); var view = entities.MoviesRentedByAUser.Where(e => e.ID_client == id).ToList(); foreach (var _view in view) { DataGridViewRow row = _dataGrid.Rows[_dataGrid.Rows.Add()]; row.Cells["ClientID"].Value = _view.ID_client; row.Cells["Client"].Value = _view.Name + " " + _view.Surname; row.Cells["Title"].Value = _view.Title; row.Cells["MovieID"].Value = _view.ID_Movie; // is returned? string isReturned = ""; if (_view.Is_Rented.Value == true) { isReturned = "NIE"; } else { isReturned = "TAK"; } row.Cells["Returned"].Value = isReturned; // total cost DateTime rentTime = _view.rental_date.Value; int cost = _view.Price.Value; if ((DateTime.Now - rentTime).TotalMinutes > 60 * 24 * 7) { cost += _view.Penalty.Value * (((int)(DateTime.Now - rentTime).TotalMinutes - 60 * 24 * 7) / (60 * 24) + 1); } row.Cells["Cost"].Value = cost.ToString(); } } }