public List <ColumnConfigDTO> GetListWithModel(ColumnConfigSearchDTO searchModel)
        {
            log.MethodStart();

            List <ColumnConfigDTO> objList = new List <ColumnConfigDTO>();

            //var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);

            using (var trans = _db.Database.BeginTransaction())
            {
                try
                {
                    objList = _db.ColumnConfigDTOs.FromSqlRaw <ColumnConfigDTO>("sp_GET_ColumnConfigDTO {0}", searchModel.sch_mnu_code).ToList();

                    //objList = _mapper.Map<List<ColumnConfigDTO>>(objDataList);

                    trans.Commit();
                }
                catch (Exception ex)
                {
                    // TODO: Handle failure
                    log.Error(ex);

                    trans.Rollback();
                }
                finally
                {
                    trans.Dispose();
                }
            }

            log.MethodFinish();

            return(objList);
        }
Пример #2
0
        public async Task <List <ColumnConfigDTO> > GetListByModelAsync(ColumnConfigSearchDTO searchData)
        {
            List <ColumnConfigDTO> objList = new List <ColumnConfigDTO>();

            objList = await _apiHelper.GetDataListByModelAsync <ColumnConfigDTO, ColumnConfigSearchDTO>("columnconfig_api/Get_ListByModel", searchData);

            return(objList);
        }
Пример #3
0
        public async Task <List <ColumnConfigDTO> > GetListByParamAsync(ColumnConfigSearchDTO searchData)
        {
            List <ColumnConfigDTO> objList = new List <ColumnConfigDTO>();

            var searchJson = JsonSerializer.Serialize(searchData);

            objList = await _apiHelper.GetDataListByParamsAsync <ColumnConfigDTO>("columnconfig_api/Get_List", searchJson);

            return(objList);
        }
Пример #4
0
        public IEnumerable <ColumnConfigDTO> Get_ListByModel([FromBody] ColumnConfigSearchDTO searchModel)
        {
            var objReturn = _service.GetListWithModel(searchModel);

            return(objReturn);
        }