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);
}
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 UpdateIndex()
{
var repository = new DEFRepository();
var def = repository.All<DEF>().ToList();
var service = new SaveDefInLuceneService(ConfigurationManager.AppSettings["DEFIndexPath"]);
service.Save(def, ConfigurationManager.AppSettings["DEFIndexPath"]);
}
public SummaryController()
{
_defsRepository = _defsRepository ?? (_defsRepository = new DEFRepository());
}
