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