public override void LoadData(string filePath) { string[] data = File.ReadAllLines(filePath); foreach (var dataLine in data.Skip(1)) { var sourceRepo = new SourceRepository(); var patientRepo = new PatientRepository(); var phenotypeRepo = new PhenotypeRepository(); var fields = dataLine.Split(Delimiter); var source = sourceRepo.AddSource(fields[5], string.Empty); var file = AddResultFile(filePath, source); var patient = patientRepo.AddPatient(fields[0], fields[1], fields[2], fields[3], DateTime.Parse(fields[4])); phenotypeRepo.AddResult(patient, file, fields[6], fields[7], fields[8], fields[9], DateTime.Parse(fields[10])); } }
public override void LoadData(string filePath) { string[] data = File.ReadAllLines(filePath); foreach (var dataLine in data.Skip(1)) { var patientRepo = new PatientRepository(); var variantRepo = new VariantRepository(); var sourceRepo = new SourceRepository(); var fields = dataLine.Split(Delimiter); var patient = patientRepo.AddPatient(fields[0], fields[1], fields[2], fields[3], DateTime.Parse(fields[4])); var resultedOn = DateTime.Parse(fields[5]); var lab = fields[6]; List<StarVariantResult> stars = new List<StarVariantResult>(); stars.Add(new StarVariantResult() { Gene = "CYP2C19", Result = fields[7] }); stars.Add(new StarVariantResult() { Gene = "CYP2C9", Result = fields[8] }); stars.Add(new StarVariantResult() { Gene = "VKORC1", Result = fields[9] }); var source = sourceRepo.AddSource(lab, string.Empty); var file = AddResultFile(filePath, source); variantRepo.AddStarVariants(patient, file, resultedOn, stars); } }