public IHttpActionResult FetchBin(MasterBinQuery query) { try { return(Ok(_binService.FetchOne(query))); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public MasterBin FetchOne(MasterBinQuery query) { var bin = _binRepository.Query() .Include(b => b.ReaderModule) .Include(b => b.Item) .OrderBy(b => b.BinCode) .FirstOrDefault(b => b.ReaderModule != null && b.ReaderModule.ReaderModuleCode == query.ModuleCode && ((b.StackNo - 1) * b.ReaderModule.NoOfRow + b.RowNo) == query.BinIndex && b.ReaderModule.Shelve != null && b.ReaderModule.Shelve.ShelveCode == query.ShelveCode); return(bin); }