public async Task <IActionResult> Edit(string id, [Bind("ID,Name,Details,Delimiter,RequiredHeader,CreatedBy,CreatedDate,LastModifiedDate,Status")] CsvParserConfig csvParserConfig)
        {
            if (id != csvParserConfig.ID)
            {
                return(NotFound());
            }

            csvParserConfig.LastModifiedDate = DateTime.Now;
            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(csvParserConfig);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!CsvParserConfigExists(csvParserConfig.ID))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(csvParserConfig));
        }
        public async Task <IActionResult> Create([Bind("Name,Details,Delimiter,RequiredHeader,CreatedBy=GetCurrentUserAsync().Result")] CsvParserConfig csvParserConfig)
        {
            csvParserConfig.CreatedBy        = GetCurrentUserAsync().Result;
            csvParserConfig.CreatedDate      = DateTime.Now;
            csvParserConfig.LastModifiedDate = DateTime.Now;
            csvParserConfig.Status           = "Active";
            if (ModelState.IsValid)
            {
                _context.Add(csvParserConfig);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(csvParserConfig));
        }
        public async Task <IActionResult> RunNewCsvParser(MainViewModel main, CsvParserConfig parserCsvFile, string ProcessedDataInSelectedCsvParserConfig, bool isCheckedSaveParser = false)
        {
            main.ProcessedData = ProcessedDataInSelectedCsvParserConfig;
            //System.IO.File.WriteAllLines(@"~/TestData/Raw/TemporaryFileHHH.txt", ProcessedDataInSelectCsvParserConfig);
            main.SelectedParser.Delimiter = parserCsvFile.Delimiter;
            if (ModelState.IsValid && isCheckedSaveParser)
            {
                _context.CsvParserConfigs.Add(main.SelectedParser);
                await _context.SaveChangesAsync();
            }

            var processedData = DisplayParsedCsvFile(main.ProcessedData, main.SelectedParser.RequiredHeader, main.SelectedParser.Delimiter.ToString());

            if (processedData == null)
            {
                return(PartialView("~/Views/Shared/_GeneralError.cshtml"));
            }
            main.parsedData = processedData;
            return(PartialView("~/Views/Main/_ShowParsedData.cshtml", main));
        }