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