public ActionResult NewFileProcessing(UploadCsvFileViewModel viewModel)
        {
            if (!ModelState.IsValid)
            {
                return(View(viewModel));
            }

            string fileExt = Path.GetExtension(viewModel.UpLoadedCsvFile.FileName).ToUpper();

            if (fileExt == ".CSV")
            {
                string fileName = Path.GetFileName(viewModel.UpLoadedCsvFile.FileName);
                string path     = AppDomain.CurrentDomain.BaseDirectory + "Upload\\" + fileName;
                viewModel.UpLoadedCsvFile.SaveAs(path);

                using (StreamReader input = System.IO.File.OpenText(path))
                    using (CsvReader csvReader = new CsvReader(input, CultureInfo.InvariantCulture))
                    {
                        IEnumerable <CsvRecord> records = csvReader.GetRecords <CsvRecord>();

                        csvReader.Configuration.Delimiter         = ";";
                        csvReader.Configuration.IgnoreBlankLines  = true;
                        csvReader.Configuration.MissingFieldFound = null;
                        csvReader.Configuration.RegisterClassMap <CsvRecordMap>();

                        //Processing records to seed the database
                        SeedDatabase(records);
                    }
                return(RedirectToAction("Index", "DataShow"));
            }
            else
            {
                ViewData["error"] = "upload failed";
                return(View(viewModel));
            }
        }
        public ActionResult NewFileProcessing()
        {
            var uploadedFile = new UploadCsvFileViewModel();

            return(View(uploadedFile));
        }