asp.net razor check if a list contain a string

Question

I have a model public class IsoRemoval { [Key] public int IdIR { get ; set ; } public DateTime IsoRemDate { get ; set ; } public string Equipment { get ; set ; } public string IsoRemMethod { get ; set ; } public int RemovedBy { get ; set ; } public int VerifiedBy { get ; set ; } } string Equipment may contain "Motor", "Pump" or "Compressor" How do I verify in the saved data if under Equipment there is any "Compressor"?

Sachin Singh · Answer

your code is correct ,idk why that dint work , so change it a little like string myString = "Removed" ; var matchingvalues = PTWIsoDetails.Where(x => x.IsStatus.Equals(myString)).ToList(); if (matchingvalues.count()>0) { return RedirectToPage( "/Page1" ); } else { return RedirectToPage( "/Page2" ); }

Sachin Singh · Answer

many ways are there method 1 if (MyList.Any(x=>x== "Compressor" )) method 2 if (MyList.Contains( "Comprassor" )) { return "yes" ; } return "No"

Marius Vasile · Answer

Working code PTWIsoDetails = await (from a in _context.IsoCerts.Where(s => s.PTWNo == idPTWNo) join b in _context.IsoDetails on a.IdIC equals b.IdIC into TempData1 from c in TempData1 select new IsoDetail { IsStatus = c.IsStatus }).ToListAsync(); if (PTWIsoDetails.Count() > 0) { foreach (var item in PTWIsoDetails) { string myString = "Installed" ; var matchingvalues = item.IsStatus.Equals(myString); if (matchingvalues == true ) { var ptwStatus = _context.PTWContents.First(s => s.PTWNo == idPTWNo); ptwStatus.PTWStatus = "Issued" ; await _context.SaveChangesAsync(); return RedirectToPage( "PTWForm" , "PTWNoId" , new { ptwNoId = idPTWNo }); } else { return RedirectToPage( "PTW" , "PTWNoId" , new { ptwNoId = idPTWNo }); } } } return RedirectToPage( "PTWForm" , "PTWNoId" , new { ptwNoId = idPTWNo });

Sachin Singh · Answer

if nothing works then use programing skill foreach (var item in checkIsoCert) { if (item== "Compressor" ) { return "Found" ; return "Not Found" ;

Marius Vasile · Answer

It is working, the proble was the IsStatus is Enumerable type and in table is stored as integer

Marius Vasile · Answer

it redirects to the same page in both situations

Marius Vasile · Answer

I tried this string myString = "Removed" ; var matchingvalues = PTWIsoDetails.Where(x => x.IsStatus.Equals(myString)); if (matchingvalues != null ) { return RedirectToPage( "/Page1" ); } else { return RedirectToPage( "/Page2" ); } but it redirects only to Page 1 so I guess that the logic in matchingvalues !=null has to be different

Marius Vasile · Answer

I read a lot about it before I waste your time with my questions but none fit. I managed to isolate the list where I search for the string by var checkIsoCert = await (from a in _context.IsoCerts.Where(s => s.PTWNo == idPTWNo) join b in _context.IsoDetails on a.IdIC equals b.IdIC into TempData1 from c in TempData1 select new { c.IsStatus }).ToListAsync(); I put it in a razor page and I can see all items. The problem I have is to search for a specific string into this list because Contains doesn't work