public IActionResult OpenFile(IFormFile file) { if (file != null) { string path = Path.GetFullPath(file.FileName); foreach (var employee in ReadCSVFile.ReadCSV(path)) { _repository.CreateItem(employee); } } return(RedirectToAction("Index", "Home")); }
public List <CompleteJobsEmp> Read(string filename) { var assignSignalsList = new List <CompleteJobsEmp>(); List <List <string> > listOfData; var result = new List <CompleteJobsEmp>(); ReadCSVFile readCSVFile = new ReadCSVFile(); listOfData = readCSVFile.Read(filename); listOfData.RemoveAt(0); listOfData.RemoveAt(0); listOfData.RemoveAt(listOfData.Count - 1); result = Load(listOfData); return(result); }
public List <Store_emp> Read(string filename) { List <Store_emp> assignSignalsList = new List <Store_emp>(); List <List <string> > listOfData; List <Store_emp> result = new List <Store_emp>(); ReadCSVFile readCSVFile = new ReadCSVFile(); listOfData = readCSVFile.Read(filename); listOfData.RemoveAt(0); listOfData.RemoveAt(0); listOfData.RemoveAt(listOfData.Count - 1); result = Load(listOfData); return(result); }
public List <Not_CompleteJobs_emp> Read(string inputFilename) { //var assignSignalsList = new List<Not_CompleteJobs_emp>(); List <List <string> > listOfData; //var result = new List<Not_CompleteJobs_emp>(); ReadCSVFile readCSVFile = new ReadCSVFile(); listOfData = readCSVFile.Read(inputFilename); listOfData.RemoveAt(0); listOfData.RemoveAt(0); listOfData.RemoveAt(listOfData.Count - 1); assignSignalsList = Load(listOfData); return(assignSignalsList); }
private void ReadFile() { try { var fileDialog = new System.Windows.Forms.OpenFileDialog(); var result = fileDialog.ShowDialog(); switch (result) { case System.Windows.Forms.DialogResult.OK: if (fileDialog.FileName.Contains(".csv")) { if (int.TryParse(Day.Text, out var day) && int.TryParse(Hours.Text, out var hours)) { var timeSet = ReadCSVFile.GetTimesPerDay(fileDialog.OpenFile(), day - 1, hours - 1); var times = new List <TimeObject>(); var project = (Project)Projects.SelectedItem; var module = (Projectmodule)Modules.SelectedItem; var worktype = (Projectworktype)WorkTypes.SelectedItem; times.AddRange(timeSet.Select(time => new TimeObject { personid = _primaryInformation != null ? _primaryInformation.Me.personid.ToString() : _userData.PersonId, time = Math.Round(time.Value, 2).ToString(CultureInfo.InvariantCulture), billable = "t", date = DateTime.Parse(time.Key).ToString("yyyy-MM-dd"), projectid = int.Parse(project.id).ToString(), moduleid = int.Parse(module.moduleid).ToString(), worktypeid = int.Parse(worktype.worktypeid).ToString() })); _userTimes = new UserTimes(_timeTaskService, times); Submit.IsEnabled = true; } } break; } } catch (Exception e) { MessageBox.Show(e.Message); } }
private void FileImportProcess_Click(object sender, RoutedEventArgs e) { if (File.Exists(FileImportLocation.Text) == false) { GlobalVariables.Logger.Log("Could not open file to import"); return; } GlobalVariables.Logger.Log("File import started"); string ThreadParam = FileImportLocation.Text; if (FIG1.IsChecked == true) { Task.Factory.StartNew(() => ReadCSVFile.ReadInvenotryCSVFile(ThreadParam)); } else if (FIG2.IsChecked == true) { Task.Factory.StartNew(() => ReadCSVFile.ReadVATCSVFile(ThreadParam)); } else if (FIG3.IsChecked == true) { Task.Factory.StartNew(() => ReadCSVFile.ReadAmazonOrdersCSVFile(ThreadParam, "Amazon_Orders", "AMAZON-ORDERS", true)); } else if (FIG4.IsChecked == true) { Task.Factory.StartNew(() => ReadCSVFile.ReadAmazonOrdersCSVFile(ThreadParam, "Amazon_Refunds", "AMAZON-REFUNDS", false)); } else if (FIG5.IsChecked == true) { Task.Factory.StartNew(() => ReadCSVFile.ReadPaypalSalesCSVFile(ThreadParam)); } else if (FIG6.IsChecked == true) { Task.Factory.StartNew(() => ReadCSVFile.ReadAmazonDeleteCSVFile(ThreadParam)); } }