public async Task <List <AntibiogramDataDTO> > GetListByModelAsync(AntiHospitalSearchDTO searchData) { List <AntibiogramDataDTO> objList = new List <AntibiogramDataDTO>(); objList = await _apiHelper.GetDataListByModelAsync <AntibiogramDataDTO, AntiHospitalSearchDTO>("report_api/GetAntiHospModel", searchData); return(objList); }
public List <AntibiogramDataDTO> GetAntibiogramHospitalDataWithModel(AntiHospitalSearchDTO searchModel) { log.MethodStart(); List <AntibiogramDataDTO> objList = new List <AntibiogramDataDTO>(); //var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param); using (var trans = _db.Database.BeginTransaction()) { try { var objDataList = _db.DropdownListDTOs.FromSqlRaw <AntibiogramDataDTO>("sp_GET_RPAntibiogramHospital {0},{1},{2},{3},{4},{5},{6},{7}" , searchModel.hos_code , searchModel.prv_code , searchModel.arh_code , searchModel.gram , searchModel.spc_code , searchModel.org_code , searchModel.start_date_str , searchModel.end_date_str ).ToList(); objList = _mapper.Map <List <AntibiogramDataDTO> >(objDataList); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }
public async Task <List <AntibiogramNationTemplateDTO> > GetAntibiogramNationTemplateListModelAsync(AntiHospitalSearchDTO searchData) { List <AntibiogramNationTemplateDTO> objList = new List <AntibiogramNationTemplateDTO>(); objList = await _apiHelper.GetDataListByModelAsync <AntibiogramNationTemplateDTO, AntiHospitalSearchDTO>("antitemplate_api/GetAntiNationTemplateModel", searchData); return(objList); }
public IEnumerable <AntibiogramHospitalTemplateDTO> GetAntibiogramHospitalTemplateModel([FromBody] AntiHospitalSearchDTO searchModel) { var objReturn = _service.GetAntibiogramHospitalTemplateWithModel(searchModel); return(objReturn); }
public List <AntibiogramHospitalTemplateDTO> GetAntibiogramHospitalTemplateWithModel(AntiHospitalSearchDTO searchModel) { log.MethodStart(); List <AntibiogramHospitalTemplateDTO> objList = new List <AntibiogramHospitalTemplateDTO>(); using (var trans = _db.Database.BeginTransaction()) { try { var objDataList = _db.DropdownHospitalTemplateListDTOs.FromSqlRaw <AntibiogramHospitalTemplateDTO>("sp_GET_RPAntibiogramHospitalTemplateFile {0},{1},{2},{3},{4},{5}" , searchModel.hos_code , searchModel.prv_code , searchModel.arh_code , searchModel.spc_code , searchModel.start_date , searchModel.end_date ).ToList(); objList = _mapper.Map <List <AntibiogramHospitalTemplateDTO> >(objDataList); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }