public List <OrganismMappingListsDTO> GetOrganismMappingListWithModel(OrganismMappingSearch searchModel) { log.MethodStart(); List <OrganismMappingListsDTO> objList = new List <OrganismMappingListsDTO>(); using (var trans = _db.Database.BeginTransaction()) { try { objList = _db.OrganismMappingListsDTOs.FromSqlRaw <OrganismMappingListsDTO>("sp_GET_TROrganismMappingList {0}, {1}", searchModel.ogm_mappingid, searchModel.ogm_mst_code).ToList(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }
public IEnumerable <OrganismMappingListsDTO> Get_OrganismMappingListByModel([FromBody] OrganismMappingSearch searchModel) { var objReturn = _service.GetOrganismMappingListWithModel(searchModel); return(objReturn); }
public async Task <List <OrganismMappingListsDTO> > GetOrganismMappingListByModelAsync(OrganismMappingSearch searchData) { List <OrganismMappingListsDTO> objList = new List <OrganismMappingListsDTO>(); objList = await _apiHelper.GetDataListByModelAsync <OrganismMappingListsDTO, OrganismMappingSearch>("mapping_api/Get_OrganismMappingListByModel", searchData); return(objList); }