public async Task StorePatientRecordInExcelAsyncTest()
{
var patient = new Patient
{
Id = 0,
Name = "Muster",
Vorname = "Hans",
Strasse = "Teststrasse 99",
Plz = 9999,
Ort = "Testort",
Geburtsdatum = new DateTime(1901, 1, 1),
Geschlecht = GeschlechtType.M,
PatientenNr = "PatientenNr002",
AhvNr = "AhvNr002",
VekaNr = "VekaNr002",
VersichertenNr = "VersNr002",
Kanton = "TE",
Kopie = false,
VerguetungsArt = VerguetungsartType.Tp,
VertragsNr = "VertrNr002"
};
var excel = new ExcelConnector(ExcelFilePath);
//var res = await excel.StorePatientRecordInExcelAsync(patient);
await excel.StorePatientRecordInExcelAsync(patient);
}
private void GetPatientRecords()
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
_excel = new ExcelConnector(ExcelFilePath);
DataGridPatient.ItemsSource = _excel.ReadAllPatientsFromExcelAsync().Result;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Mouse.OverrideCursor = null;
}
}
public void GenerarReporte1(string archivo, List <List <String> > datos)
{
ExcelConnector excel = new ExcelConnector(archivo);
excel.WriteToSheet("CUENTAS", datos);
}
public async Task ReadAllPatientsFromExcelAsyncTest()
{
var excel = new ExcelConnector(ExcelFilePath);
var patients = await excel.ReadAllPatientsFromExcelAsync();
}
