public mcl.Films GetCsvData()
{
mcl.Films films = new mcl.Films();
using (CsvReader csv = new CsvReader(new StreamReader(CsvPath.filmsCSV), true))
{
int fieldCount = csv.FieldCount;
while (csv.ReadNextRecord())
{
if (films.Any(item => item.FilmID == csv[csvMovies.FilmID]))
{
mcl.Film tmpFilm = films.Find(item => item.FilmID == csv[csvMovies.FilmID]);
if (tmpFilm.Directors.Any(item => item.PersonID == csv[csvMovies.DirectorID]) != true)
{
mcl.Director director = getDirectorFromCSV(csv);
tmpFilm.Directors.Add(director);
}
if (tmpFilm.Actors.Any(item => item.PersonID == csv[csvMovies.ActorID]) != true)
{
mcl.Actor actor = getActorFromCSV(csv);
tmpFilm.Actors.Add(actor);
}
}
else
{
mcl.Film film = getFilmFromCSV(csv);
films.Add(film);
}
}
}
return(films);
}
private void addActor(mcl.Film film, DataRow row)
{
if (film.Actors.Any(item => item.PersonID == row.ItemArray[dict[avItems.ActorID]].ToString()) == false)
{
mcl.Actor actor = new mcl.Actor(row.ItemArray[dict[avItems.ActorID]].ToString()
, row.ItemArray[dict[avItems.ActorName]].ToString());
film.Actors.Add(actor);
}
}
private mcl.Film getFilmFromCSV(CsvReader csv) // gets information from the film csv. it is used in the while loop if a director has been selected.
{
mcl.Director director = getDirectorFromCSV(csv);
mcl.Actor actor = getActorFromCSV(csv);
mcl.Film film = new mcl.Film(csv[csvMovies.FilmID]
, csv[csvMovies.FilmName]
, csv[csvMovies.ImdbRating]
, csv[csvMovies.FilmYear]);
film.Directors.Add(director); // if a film has been selected it also adds a director and an actor associated with that film.
film.Actors.Add(actor);
return(film);
}
private mcl.Film getFilmFromCSV(CsvReader csv)
{
mcl.Director director = getDirectorFromCSV(csv);
mcl.Actor actor = getActorFromCSV(csv);
mcl.Film film = new mcl.Film(csv[csvMovies.FilmID]
, csv[csvMovies.FilmName]
, csv[csvMovies.ImdbRating]
, csv[csvMovies.FilmYear]
, csv[csvMovies.RottenRating]);
film.Directors.Add(director);
film.Actors.Add(actor);
return(film);
}
//--------------------------------------------------------------------- CSV
public mcl.Films GetCsvData(string CsvPath)
{
mcl.Films films = new mcl.Films();
//-- FilmID = csv[0];
//-- FilmName = csv[1];
//-- ImdbRating = csv[2];
//-- FilmYear = csv[7];
//-- DirectorID = csv[3];
//-- DirectorName = csv[4];
//-- ActorID = csv[5];
//-- ActorName = csv[6];
using (CsvReader csv = new CsvReader(new StreamReader(CsvPath), true)) // looks up where the data is being held.
{
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord()) // while reading the data. This if else statement is checking if any of the dropdown fields have been selected. if one has been selected it pulls the data from that csv file and populates the drop down.
{
if (films.Any(item => item.FilmID == csv[csvMovies.FilmID]))
{
mcl.Film tmpFilm = films.Find(item => item.FilmID == csv[csvMovies.FilmID]);
if (tmpFilm.Directors.Any(item => item.PersonID == csv[csvMovies.DirectorID]))
{
}
else
{
mcl.Director director = getDirectorFromCSV(csv);
tmpFilm.Directors.Add(director);
}
if (tmpFilm.Actors.Any(item => item.PersonID == csv[csvMovies.ActorID]))
{
}
else
{
mcl.Actor actor = getActorFromCSV(csv);
tmpFilm.Actors.Add(actor);
}
}
else
{
mcl.Film film = getFilmFromCSV(csv);
films.Add(film);
}
}
}
return(films); // returns the results of the if, else statements above.
}
private mcl.Actor getActorFromCSV(CsvReader csv) // gets information from the Actor csv. it is used in the while loop if a director has been selected.
{
mcl.Actor actor = new mcl.Actor(csv[csvMovies.ActorID]
, csv[csvMovies.ActorName]);
return(actor);
}
private mcl.Actor getActorFromCSV(CsvReader csv)
{
mcl.Actor actor = new mcl.Actor(csv[csvMovies.ActorID]
, csv[csvMovies.ActorName]);
return(actor);
}
