asp.net razor check if a list contain a string

Marius Vasile

5y1.6k.NET

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"?

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted 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");
            }
+1
Marius Vasile5y ago
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 });
+1
Marius Vasile5y ago
It is working, the proble was the IsStatus is Enumerable type and in table is stored as integer
+1
Marius Vasile5y ago
it redirects to the same page in both situations
+1
Marius Vasile5y ago
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
+1
Sachin Singh5y ago
if nothing works then use programing skill
foreach(var item in checkIsoCert)
{

if(item=="Compressor")
{
return "Found";

return "Not Found";
+1
Marius Vasile5y ago
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
+1
Sachin Singh5y ago
many ways are there
method 1
if(MyList.Any(x=>x=="Compressor"))
method 2
if(MyList.Contains("Comprassor"))
{
  return "yes";
}
return "No"
+2