public void ImportFromExcelFile(string path) { var excelRepository = new ExcelRepository(); var data = excelRepository.GetAllDataFrom(path, "TUSS.xls", "TUSS"); var list = new List<TUSS>(); foreach (DataRow row in data.Rows) { var tus = new TUSS(); foreach (DataColumn column in data.Columns) { switch (column.Caption) { case "Código do Termo": tus.Code = row[column].ToString(); break; case "Termo": tus.Description = row[column].ToString(); break; } } list.Add(tus); } var tusRepository = new TUSSRepository(); tusRepository.SaveList(list); }
private void AddProcedures(Legacy.Summary legacySummary, Summary newSummary) { var tusRepository = new TUSSRepository(); foreach (var legacyProcedure in legacySummary.Procedures) { if (legacyProcedure != null && legacyProcedure.DateProc.HasValue && !String.IsNullOrWhiteSpace(legacyProcedure.TusCode)) { DateTime procDate = legacyProcedure.DateProc.Value; TUSS tus = tusRepository.GetByCode(legacyProcedure.TusCode); newSummary.CreateProcedure(procDate.Month, procDate.Day, procDate.Year, tus); } } }