public ActionResult DMAMetro(ImportDocumentViewModel viewModel)
{
if (ModelState.IsValid)
{
StreamReader streamReader = new StreamReader(viewModel.Document.InputStream);
CsvReader csvReader = new CsvReader(streamReader);
csvReader.Configuration.RegisterClassMap <ImportStationMap>();
IEnumerable <ImportStationViewModel> records = csvReader.GetRecords <ImportStationViewModel>().ToList();
long rank = 0;
foreach (var rec in records)
{
if (!rec.Band.Equals("ER", StringComparison.CurrentCultureIgnoreCase) && rec.Market.Length != 0 && rec.Rank.Length != 0 && viewModel.ImportType != null)
{
if (viewModel.ImportType.Equals("DMA"))
{
//rank = Int64.Parse(rec.Rank.Replace("t", ""));
rec.Result = CRCDataAccess.UpdateDMAMarket(rec.CallLetters, rec.Band, rec.Market, rec.Rank, CRCUser.UserId);
}
else
{
rec.Result = CRCDataAccess.UpdateMetroMarket(rec.CallLetters, rec.Band, rec.Market, rec.Rank.Replace("t", ""), CRCUser.UserId);
}
}
}
viewModel.Results = records.ToList();
return(PartialView(viewModel));
}
else
{
return(PartialView(viewModel));
}
}
public ActionResult ImportStations(ImportDocumentViewModel viewModel)
{
StreamReader streamReader = new StreamReader(viewModel.Document.InputStream);
CsvReader csvReader = new CsvReader(streamReader);
csvReader.Configuration.RegisterClassMap <ImportStationMap>();
IEnumerable <ImportStationViewModel> records = csvReader.GetRecords <ImportStationViewModel>();
foreach (var rec in records)
{
rec.Result = CRCDataAccess.UpdateDMAMarket(rec.CallLetters, rec.Band, rec.Market, rec.Rank, CRCUser.UserId);
}
return(null);
}
public ActionResult DMAMetro()
{
var viewModel = new ImportDocumentViewModel();
return(View(viewModel));
}
