Here i am doing searching different things from diffrent tables table i got all result except "oilIDs".
for example while i select OIL0000004 in drop down list and click on search button i got a result like below...
Here is my code.
Model = Cardata.Where(v => v.TyreID == ityreID || ityreID == -1)
.Where(v => v.oilIDs.Contains(stroil) || string.IsNullOrEmpty(stroil.Trim()))
.Where(v => v.BlockID == iBlockID || iBlockID == -1)
.Where(v => v.Revision == iRevision || iRevision == -1)
.Where(v => v.Disposition == strDispositions || string.IsNullOrEmpty(strDispositions.Trim()))
.OrderBy(v => v.ValveBlockID)
.ToList();
Note: i will try Equal in place of Contains but no use..
search all:
__________
-----------------------------------------------------------------------------------------------------
| TyreID | oilIDs | BlockID | Revision |
------------------------------------------------------------------------------- ---------------------
| T00001 | OIL0000004 | B00000034 | 1 |
| ----------------------------------------------------------------------------------------------------
| T00002 | OIL0000005, OIL0000006 | B000000053 | 2 | ____________________________________________________________________
some times OIL0000005, OIL0000006 both are in one record like above
so that if we search for OIL0000005 then show like below
search by oilIDs
-------------------
-----------------------------------------------------------------------------------------------------
| TyreID | oilIDs | BlockID | Revision |
------------------------------------------------------------------------------- ---------------------
| T00002 | OIL0000005 | B000000053 | 2 |
____________________________________________________________________
and if we search OIL0000006
----------------------------------------------------------------------------------------------------------
| TyreID | oilIDs | BlockID | Revision |
------------------------------------------------------------------------------- --------------------------
| T00002 | OIL0000005 | B000000053 | 2 |
-------------------------------------------------------------------------------------------------------------------
so if i search by TyreID there is no problem if search by Block ID no problem. if Search by oilIDs i have problem no records found
Please help me...
Thanks