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);
}
