why I got this error Sequence contains no elements

Question

I am using the following code in the view and tried a lot of solutions but still get this error Sequence Contains no elements , this is the view code :

    @model AljawdahNewSite.Models.Orders_Tables
    @{
        ViewBag.Title = "Result Details";
        //Layout = "~/Views/Shared/_LayoutPatients.cshtml";
        var hema = new List() { 1 };
        var bio = new List() { 2 };
        var ser = new List() { 3 };
        var hor = new List() { 4 };
        var histo = new List() { 5 };
        var culture = new List() { 8 };
        var para = new List() { 6 };
        var covid = new List() { 9 };
    
        var labPara = Model.LabParaResult.FirstOrDefault();
        var labCult = Model.LabCultureResults.FirstOrDefault();
        var labMicro = Model.LabMicroResults.FirstOrDefault();
        var labHisto = Model.LabHistoResult.FirstOrDefault();
        var LabResults = Model.LabResults;
        var labhema = LabResults.FirstOrDefault(x => x.deptid == 1);
        var labBio = LabResults.FirstOrDefault(x => x.deptid == 2);
        var labSer = LabResults.FirstOrDefault(x => x.deptid == 3);
        var labHor = LabResults.FirstOrDefault(x => x.deptid == 4);
        var labcovid = LabResults.FirstOrDefault(x => x.deptid == 9);
    
        var LABCLINICVIEW = Model.labClinicsViewResult;
        var LABCASHVIEW = Model.labCashView;
        var labPara1 = Model.LabParasitologyView.FirstOrDefault();
        var labCult1 = Model.LabCulturesView.FirstOrDefault();
        var labMicro1 = Model.LabMicroView.FirstOrDefault();
        var labHisto1 = Model.LabHistopathologyView.FirstOrDefault();
        var labhema1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 1);
        var labBio1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 2);
        var labSer1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 3);
        var labHor1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 4);
        var labcovid1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 9);
    } 


 

        @if (labcovid1 != null && labcovid1.Report_Date.HasValue)
        {


            
                
                    
                        
                        Download Covid Result
                    
                
            
            
                
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().Patient_Name)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().Patient_Name)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().Customer_Name)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().Customer_Name)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().Patient_No)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().Patient_No)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().Collection_Date)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().Collection_Date)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().SEX)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().SEX)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().Receiving_Date)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().Receiving_Date)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().AGE)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().AGE)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().Report_Date)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().Report_Date)
                    @Html.DisplayNameFor(model => model.labClinicsViewResult.FirstOrDefault().order_number)
                    @Html.DisplayFor(model => model.labClinicsViewResult.FirstOrDefault().order_number)
                
            
            
                Molecular Unit
                
                            @**@
                            
                    @foreach (var employee in Model.labClinicsViewResult.Where(x => covid.Contains(x.DEPTID.GetValueOrDefault())))
                {
                        
                            @**@
                            
                    }
                
                    
                        @Html.DisplayNameFor(m => m.labCashView.FirstOrDefault().Patient_No)
                                @Html.DisplayNameFor(m => m.labCashView.FirstOrDefault().Patient_Name) @Html.DisplayNameFor(m => m.labClinicsViewResult.FirstOrDefault().Test_Name)
                            @Html.DisplayNameFor(m => m.labClinicsViewResult.FirstOrDefault().Result)
                            @Html.DisplayNameFor(m => m.labClinicsViewResult.FirstOrDefault().Low_Range)
                            @Html.DisplayNameFor(m => m.labClinicsViewResult.FirstOrDefault().High_Range)
                            @Html.DisplayNameFor(m => m.labClinicsViewResult.FirstOrDefault().Text_Range)
                            @Html.DisplayNameFor(m => m.labClinicsViewResult.FirstOrDefault().Report_Date)

                        
                    
@employee.Patient_No
                                @employee.Patient_Name @employee.Test_Name
                            @employee.Result
                            @employee.Low_Range
                            @employee.High_Range
                            @employee.Text_Range
                            @employee.Report_Date

                        
            

        }

    


        @if (labPara1 != null && labPara1.Report_Date.HasValue)
        {
          
            
            
                
                    
                          
                        Print Parasitology Result
                    
                
            
            
                
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Patient_Name)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Patient_Name)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Customer_Name)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Customer_Name)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Patient_No)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Patient_No)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Collection_Date)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Collection_Date)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().SEX)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().SEX)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Receiving_Date)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Receiving_Date)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().AGE)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().AGE)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Report_Date)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Report_Date)
                    @Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().order_number)
                    @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().order_number)
                    @*@Html.DisplayNameFor(model => model.LabParasitologyView.FirstOrDefault().Test_Name)
                        @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Test_Name)*@
                
            
            
                @*Parasitology Department*@
                
                    @*
                            @Html.DisplayFor(model => model.LabParasitologyView.FirstOrDefault().Test_Name)
                        *@


                    
                        @foreach (var employee in Model.LabParaResult.Where(x => para.Contains(x.deptid.GetValueOrDefault())))
                {
                            
                        }
                    
                        
                            
                                @Html.DisplayNameFor(m => m.labtests.FirstOrDefault().TestName)
                                @Html.DisplayNameFor(m => m.LabParasitologyView.FirstOrDefault().SERIAL)
                                @Html.DisplayNameFor(m => m.LabParasitologyView.FirstOrDefault().TEXT)
                                @Html.DisplayNameFor(m => m.LabParasitologyView.FirstOrDefault().RESULT)
                                @Html.DisplayNameFor(m => m.LabParasitologyView.FirstOrDefault().UNIT)
                                @Html.DisplayNameFor(m => m.LabParasitologyView.FirstOrDefault().Reference_Range)
                                @Html.DisplayNameFor(m => m.LabParasitologyView.FirstOrDefault().Report_Date)



                            
                        


                                @employee.LabTests.TestName
                                @employee.SERIAL
                                @employee.TEXT
                                @employee.VALUE
                                @employee.unit
                                @employee.reference_range
                                @employee.APPROVED_DATE



                            
                
            
        }

this is part of controller code :

public ActionResult MasterDetails(int id)
        {

              
            var tables = new Orders_Tables
            {
                testsRanges = db.TestsRanges.ToList(),

                LabResults = db.LAB_RESULTS.Where(o => o.ORDER_ID == id)
                             .Include(p => p.LabTests)
                             .Include(t => t.Patients).ToList(),


                LabParaResult = db.LAB_PARA_RESULTS.Where(o => o.ORDER_ID == id).Include(t => t.Patients).Include(t => t.LabTests).Include(c => c.Customers).ToList(),
                LabCultureResults = db.LAB_CULTURE_RESULT.Where(o => o.ORDER_ID == id).Include(t => t.Patients).Include(t => t.LabTests).Include(c => c.Customers).ToList(),
                LabMicroResults = db.LAB_MICRO_NEGATIVE_RESULT.Where(o => o.ORDER_ID == id).ToList(),
                labCashView = db.LAB_RESULT_CASH_VIEW.Where(o => o.order_number == id).ToList(),
                labClinicsViewResult = db.LAB_RESULTS_CLINIC_VIEW.Where(o => o.order_number == id).ToList(),
                LabParasitologyView = db.LAB_PARASITOLOGY_VIEW.Where(o => o.order_number == id).ToList(),
                
            };

            return View(tables);
           
        }

the error show when try to run the result for

var labPara1 = Model.LabParasitologyView.FirstOrDefault();

but the error appear in this line

var labcovid1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 9);

I need your help please :

How I will handle the controller code

If labClinicsViewResult is empty and returned no value skip and go to the next ?

THIS IS THE CLASS :

public class Orders_Tables
{
   // internal IQueryable

user_17183942 · Answer

It looks like the sequence that contains no elements is LABCLINICVIEW. Which is being assigned from your model variable Orders_Tables.labClinicsViewResult. You are assigning this variable with the database call db.LAB_RESULTS_CLINIC_VIEW.Where(o => o.order_number == id).ToList(), so it seems to me that this database call is returning an empty set. Try debugging and step through and stop on the line return View(tables); and then inspect your variable tables to see if the member variable tables.labClinicsViewResult does in fact have anything in it. If it is empty then that's your problem. If it isn't empty then your problem is likely in the call var labcovid1 = LABCLINICVIEW.FirstOrDefault(x => x.DEPTID == 9); and it might not have a value where the DEPTID is equal to 9.

why I got this error Sequence contains no elements

1 Answers