Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }