public List <GlassFileListDTO> GetGlassPublicRegHealthFileListDataModel(GlassFileListNationSearchDTO searchModel) { log.MethodStart(); List <GlassFileListDTO> objList = new List <GlassFileListDTO>(); //var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param); using (var trans = _db.Database.BeginTransaction()) { try { var objDataList = _db.DropdownGlassListDTOs.FromSqlRaw <GlassFileListDTO>("sp_GET_RPGlassPublicFileList {0},{1},{2}" , searchModel.start_year , searchModel.end_year , searchModel.arh_code ).ToList(); objList = _mapper.Map <List <GlassFileListDTO> >(objDataList); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }
public async Task <List <GlassFileListDTO> > GetGlassPublicFileListRegHealthModelAsync(GlassFileListNationSearchDTO searchData) { List <GlassFileListDTO> objList = new List <GlassFileListDTO>(); objList = await _apiHelper.GetDataListByModelAsync <GlassFileListDTO, GlassFileListNationSearchDTO>("glassreport_api/GetGlassPublicRegHealthFileListModel", searchData); return(objList); }