public ActionResult AQHCumeImport(ImportDocumentAQHCumeViewModel viewModel)
{
if (ModelState.IsValid)
{
StreamReader streamReader = new StreamReader(viewModel.Document.InputStream);
CsvReader csvReader = new CsvReader(streamReader);
csvReader.Configuration.RegisterClassMap <ImportAQHCumeMap>();
IEnumerable <ImportAQHCumeViewModel> records = csvReader.GetRecords <ImportAQHCumeViewModel>().ToList();
foreach (var rec in records)
{
if (!rec.Band.Equals("ER", StringComparison.CurrentCultureIgnoreCase) && rec.AQH.Length != 0 && rec.Cume.Length != 0)
{
rec.Result = CRCDataAccess.UpdateStationAQHCume(rec.CallLetters, rec.Band, DataParser.GetLong(rec.AQH), DataParser.GetLong(rec.Cume), CRCUser.UserId);
}
}
viewModel.Results = records.ToList();
return(PartialView(viewModel));
}
else
{
return(PartialView(viewModel));
}
}
public ActionResult AQHCumeImport()
{
var viewModel = new ImportDocumentAQHCumeViewModel();
return(View(viewModel));
}
