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 static ItemPrescriptionModel MapItemPrescriptionModelFrom(PrescriptionItem prescriptionItem)
{
Mapper.CreateMap<PrescriptionItem, ItemPrescriptionModel>();
var prescriptionModel = new ItemPrescriptionModel();//Mapper.Map<PrescriptionItem, ItemPrescriptionModel>(prescriptionItem);
prescriptionModel.Code = prescriptionItem.code;
prescriptionModel.Id = prescriptionItem.Id;
prescriptionModel.Description = prescriptionItem.Description;
prescriptionModel.Type = (short)prescriptionItem.PrescriptionItemType;
return prescriptionModel;
}
