My view table doesn't show all my data (MVC/mysql)

See more:

MySQL

MVC6

C#6.0

Hi Guys,

I'm creating a view for three tables to view different data based on a Proposal ID.
I've got all of them pulled and everything worked fine but when I tried to join them only two records from a total of 250 appeared (those two records are records I linked with Personal ID to test if the query works)

I'm using MySQL and when I put the query in MySQL Workbench it works fine and pulls all the data, but when I run my project it only shows these two records as I previously mentioned.

What I have tried:

Here is my Context code:

<pre>       public List<PendingModel> GetAllNames()
        {
            List<PendingModel> list = new List<PendingModel>();

            using (MySqlConnection conn = GetConnection())
            {
                conn.Open();
                //MySqlCommand cmd = new MySqlCommand("select * from pendingproposals", conn);
                MySqlCommand cmd = new MySqlCommand("SELECT lname, IRG, IRGDate FROM proposal LEFT JOIN pendingproposals USING(proposal_id)  LEFT JOIN proposal_research_team USING(proposal_id) WHERE proposal.status in ('Unsubmitted','Dept Approval In Process', 'Admin Office In Process', 'JIT Request Received', 'JIT Submitted', 'Submitted to Sponsor', 'Sub 1/4: Awaiting Agreement', 'Sub 2/4: Under Negotiation', 'Sub 3/4: Partially Executed') AND role = 'Lead Principal Investigator';", conn);
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                            if (!DBNull.Value.Equals(reader[2]))
                            {
                                list.Add(new PendingModel()
                                {
                                    PILastName = reader["lname"].ToString(),
                                    IRG = reader["IRG"].ToString(),
                                    IRGDate = (DateTime)reader["IRGDate"]
                                });
                            }
                    }
                }
            }
            return list;
        }

My Controller:

public IActionResult Index()
 {
     PendingContext context = HttpContext.RequestServices.GetService(typeof(PendingTest.Models.PendingContext)) as PendingContext;
     return View(context.GetAllNames());
 }

My View:

@model IEnumerable<PendingTest.Models.PendingModel>

@{
    ViewData["Title"] = "Pending Approvals";
}

<center>class="fa fa-github-alt fa-lg" href="url-here" style="margin: 10px"> Edit
                    </a>
                    <a class="btn btn-danger" href="#">
                        ^__i class="fa fa-heart-o fa-lg"> Delete
                    </a>
                </td>
            </tr>
            }
        </tbody>
    </table>

I would appreciate the help