public void ImportPrescriptionItemFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "DEF.xls", "Sheet1");
var list = new List<PrescriptionItem>();
foreach (DataRow row in data.Rows)
{
var def = new PrescriptionItem();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "PRINCÍPIO ATIVO":
def.ActivePrinciple = (string)row[column];
break;
case "PRODUTO":
def.Description = (string)row[column];
break;
}
}
def.code = Guid.NewGuid().ToString();
def.PrescriptionItemType = PrescriptionItemType.Medicamentos;
list.Add(def);
}
var defs = new DEFRepository();
defs.SaveList(list);
}
public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "DEF.xls", "Sheet1");
var list = new List<DEF>();
foreach (DataRow row in data.Rows)
{
var def = new DEF();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "PRINCÍPIO ATIVO":
def.ActivePrinciple = (string)row[column];
break;
case "PRODUTO":
def.Description = (string)row[column];
break;
}
}
list.Add(def);
}
var defs = new DEFRepository();
defs.SaveList(list);
}
