public ActionResult Upload(HttpPostedFileBase file)
{
//http://joshclose.github.io/CsvHelper/
Stream stream = file.InputStream;
StreamReader streamReader = new StreamReader(stream);
TextReader textReader = (TextReader)streamReader;
var csv = new CsvHelper.CsvReader(textReader);
List<ImportDTO> listOfDTOs = new List<ImportDTO>();
while (csv.Read())
{
ImportDTO record = csv.GetRecord<ImportDTO>();
listOfDTOs.Add(record);
}
//Map DTO to models
foreach (ImportDTO item in listOfDTOs)
{
//Get countries
List<string> countries = item.Countries.Split(new char[] { '|' }).ToList();
Collection<Country> countryCollection = new Collection<Country>();
foreach (string countryName in countries)
{
countryCollection.Add(new Country { Name = countryName });
}
//Get start and end times
DateTime start = DateTime.ParseExact(item.StartDate + " " + item.StartTime, "dd/MM/yyyy HH:mm",
System.Globalization.CultureInfo.InvariantCulture);
DateTime end = DateTime.ParseExact(item.EndDate + " " + item.EndTime, "dd/MM/yyyy HH:mm",
System.Globalization.CultureInfo.InvariantCulture);
Film newFilm = new Film();
newFilm.Country = countryCollection;
TimeSlot slot = new TimeSlot();
slot.StartTime = start;
slot.EndTime = end;
}
return View("Index");
}
public void DeleteFilm(Film film)
{
filmDb.Films.Remove(film);
filmDb.SaveChanges();
}
public void AddFilm(Film film)
{
filmDb.Films.Add(film);
filmDb.SaveChanges();
}
public void ModifyFilmState(Film film, EntityState state)
{
filmDb.Entry(film).State = state;
filmDb.SaveChanges();
}
public void UpdateFilm(Film film)
{
var tmpFilm = filmDb.Films.Single(f => f.Id == film.Id);
tmpFilm.Country = film.Country;
tmpFilm.Description = film.Description;
tmpFilm.Director = film.Director;
tmpFilm.Images = film.Images;
tmpFilm.Title = film.Title;
tmpFilm.TrailerURL = film.TrailerURL;
tmpFilm.Year = film.Year;
tmpFilm.Slots = film.Slots;
tmpFilm.Venues = film.Venues;
filmDb.SaveChanges();
}
