public List <LabFileUploadDataDTO> GetLabFileUploadListWithModel(LabFileUploadSearchDTO searchModel)
        {
            log.MethodStart();


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

            using (var trans = _db.Database.BeginTransaction())
            {
                try
                {
                    objList = _db.LabFileUploadDataDTOs.FromSqlRaw <LabFileUploadDataDTO>("sp_GET_TRLabFileUploadList {0} ,{1} ,{2} ,{3}", searchModel.lfu_Hos, searchModel.lfu_Province, searchModel.lfu_Area, null).ToList();
                    trans.Commit();
                }
                catch (Exception ex)
                {
                    // TODO: Handle failure
                    trans.Rollback();
                }
                finally
                {
                    trans.Dispose();
                }
            }
            log.MethodFinish();

            return(objList);
        }
        public async Task <List <LabFileUploadDataDTO> > GetLabFileUploadListByModelAsync(LabFileUploadSearchDTO model)
        {
            List <LabFileUploadDataDTO> objList = new List <LabFileUploadDataDTO>();

            objList = await _apiHelper.GetDataListByModelAsync <LabFileUploadDataDTO, LabFileUploadSearchDTO>("labfileupload_api/Get_LabFileUploadListByModel", model);

            return(objList);
        }
        public IEnumerable <LabFileUploadDataDTO> Get_LabFileUploadListByModel([FromBody] LabFileUploadSearchDTO searchModel)
        {
            var objReturn = _service.GetLabFileUploadListWithModel(searchModel);

            return(objReturn);
        }