public ActionResult ImportRecords(HttpPostedFileBase file)
{
var filePath = string.Empty;
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
filePath = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName);
file.SaveAs(filePath);
}
var records = new CsvReaderHelper().GetRecordsFromCsv(filePath);
foreach (var record in records)
{
_recordRepository.SaveImportedRecord(record, Session["UserId"].ToString());
}
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
return(Redirect("Index"));
}
private static IEnumerable <BPostData> GetPreviouslyImportedData()
{
var importedFiles = Directory.GetFiles(_importPath, "*.csv");
var latestFile = string.Empty;
var latestImport = DateTimeOffset.MinValue;
foreach (var importedFile in importedFiles)
{
var fileName = Path.GetFileNameWithoutExtension(importedFile);
var timeStamp = DateTimeOffset.ParseExact(fileName, FileDateFormat, CultureInfo.InvariantCulture);
// If the file date is smaller than our last import, we skip it
if (timeStamp <= latestImport)
{
continue;
}
latestImport = timeStamp;
latestFile = importedFile;
}
return(string.IsNullOrEmpty(latestFile)
? new List <BPostData>()
: CsvReaderHelper.ReadBPostData(latestFile));
}
private void btnGenerate_Click(object sender, RoutedEventArgs e)
{
string path = txtFilePath.Text;
int startIndex = int.Parse(txtStartFrom.Text);
string prefix = txtPrefix.Text;
XmlProperty.PropertyPrefix = txtPropertyPrefix.Text.Trim();
CsvReaderHelper.UseTaxonomy = radioUseTaxonomy.IsChecked ?? true;
string classContent = CsvReaderHelper.ConvertFileToCode(path, prefix, startIndex);
textEditor.Text = classContent;
}
public ProfileContextSeed(CsvReaderHelper csvHelper, ILogger logger)
{
_csvHelper = csvHelper;
_logger = logger;
}
public ProfileContextSeed(CsvReaderHelper csvHelper)
{
_csvHelper = csvHelper;
}
private static IEnumerable <PostalName> GetPostalNamesWithLanguage()
{
var filePath = $"{AppDomain.CurrentDomain.BaseDirectory}\\postalNamesLanguage.csv";
return(CsvReaderHelper.ReadPostalNames(filePath));
}
