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