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 UpdateTimeSlot(TimeSlot timeSlot) { var tmpSlot = filmDb.Slots.Single(s => s.Id == timeSlot.Id); tmpSlot.EndTime = timeSlot.EndTime; tmpSlot.Film = timeSlot.Film; tmpSlot.Selected = timeSlot.Selected; tmpSlot.StartTime = timeSlot.StartTime; tmpSlot.Venue = timeSlot.Venue; filmDb.SaveChanges(); }
public void DeleteTimeSlot(TimeSlot timeSlot) { filmDb.Slots.Remove(timeSlot); filmDb.SaveChanges(); }
public void AddTimeSlot(TimeSlot timeSlot) { filmDb.Slots.Add(timeSlot); filmDb.SaveChanges(); }