private void InsertButton_Click(object sender, RoutedEventArgs e) { try { Covid19deaths _newData = new Covid19deaths(); _newData.CountryRegion = this.CountryRegionComboBox.SelectedItem.ToString(); _newData.ProvinceState = this.ProvinceStateTextBox.Text; _newData.RecordDate = this.DateDatePicker.SelectedDate.Value.Date; _newData.DeathNumber = int.Parse(this.DeathsTextBox.Text); _context.Add(_newData); _context.SaveChanges(); var _covidList = _context.Covid19deaths.ToList(); this.CovidDataGrid.ItemsSource = _covidList; } catch (Exception ex) { MessageBox.Show("Item already exist"); return; } }
Covid19deaths StartAsync(string _filePath) { var _myResult = new Covid19deaths(); List <string> _getHeader = null; int progressCount = 0; using (StreamReader _readData = new StreamReader(_filePath)) { _getHeader = new List <string>(); while (true) { string _readLine = _readData.ReadLine(); if (_readLine == null) { break; } else { if (_getHeader.Count <= 0) { _getHeader.AddRange(_readLine.Split(',').ToList <string>()); } else { Regex _parseString = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); string[] _getCurrentRow = _parseString.Split(_readLine); int count = 0; foreach (var _getItem in _getHeader) { switch (_getItem) { case "Province/State": case "Country/Region": case "Lat": case "Long": count++; break; default: _context.AddRange( new Covid19deaths { ProvinceState = _getCurrentRow[0], CountryRegion = _getCurrentRow[1], RecordDate = Convert.ToDateTime(_getItem + "20"), DeathNumber = int.Parse(_getCurrentRow[count]) } ); IncrementProgress(progressCount); progressCount++; _context.SaveChanges(); count++; break; } } } } } } return(_myResult); }