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