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);
}
