public IList <T> FetchList(string FileName)
{
var discharges = new ToDataSet().Parse(FileName);
List <ModelDischarge> attendances = discharges.Tables[0].AsEnumerable()
.Select(row => new ModelDischarge
{
EpisodeId = row.Field <string>(0),
OrganisationCode = row.Field <string>(1),
OrganisationName = row.Field <string>(2),
PBCConsortiaName = row.Field <string>(3),
TypeOfAdmission = row.Field <string>(4),
DischargeWardCode = row.Field <string>(5),
DischargeWard = row.Field <string>(6),
DischargeHospitalSite = row.Field <string>(7),
DischargeSpeciality = row.Field <string>(8),
NHSNo = row.Field <string>(9),
PASHospitalNumber = row.Field <string>(10),
PatientName = row.Field <string>(11),
DateOfBirth = row.Field <DateTime>(12),
AdmissionDate = row.Field <DateTime>(13),
DischargeDate = row.Field <DateTime>(14),
DishDeceasedFlag = row.Field <string>(15)
}
).ToList();
return(attendances as IList <T>);
}
public IList <T> FetchList(string FileName)
{
var dsAttendances = new ToDataSet().Parse(FileName);
var attendances = dsAttendances.Tables[0].AsEnumerable()
.Select(row => new ModelAttendance
{
AandEDepartment = row.Field <string>(0) ?? "Null",
AandEDepartementName = row.Field <string>(1) ?? "Null",
AandEUniqueId = row.Field <string>(2) ?? "Null",
PasId = row.Field <string>(3) ?? "Null",
PatientName = row.Field <string>(4) ?? "Null",
DateOfBirth = row.Field <DateTime>(5),
PhoneNo = row.Field <string>(6) ?? "Null",
NHSNo = row.Field <string>(7) ?? "Null",
GPCode = row.Field <string>(8) ?? "Null",
OrganisationCode = row.Field <string>(9) ?? "Null",
OrgainsationName = row.Field <string>(10) ?? "Null",
DateOfArrival = row.Field <DateTime>(11),
TimeOfArrival = row.Field <string>(12) ?? "Null",
SourceOfReferralCode = row.Field <string>(13) ?? "Null",
ArrivalMode = row.Field <string>(14) ?? "Null",
PresentedWith = row.Field <string>(15) ?? "Null",
DiagnosisCode = row.Field <string>(16) ?? "Null",
DiagnosisDescription = row.Field <string>(17) ?? "Null",
InvestigationCodeOne = row.Field <string>(18) ?? "Null",
InvestigationCodeTwo = row.Field <string>(19) ?? "Null",
TreatmentCodeOne = row.Field <string>(20) ?? "Null",
TreatmentCodeTwo = row.Field <string>(21) ?? "Null",
TreatmentCodeThree = row.Field <string>(22) ?? "Null",
HRG = row.Field <string>(23) ?? "Null",
AttendanceDisposal = row.Field <string>(24) ?? "1"
}
).ToList();
return(attendances as IList <T>);
}