public IActionResult InsertListings()
   {
       return View();
   }
    
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult InsertListings([Bind("ListingName")] ListingProjects listingProject) // Change to ListingProjects model
    {
        
        try
        {
            if (ModelState.IsValid)
            {
                _context.ListingDBTable.Add(listingProject);
                _context.SaveChanges();
                return RedirectToAction("TestDashboard1"); // Redirect to dashboard
            }
            else
            {
                // Model is invalid, handle it (e.g., show validation errors)
                return View(listingProject); // Return the view with error messages
            }
        }
        catch (DbUpdateException dbUpdateException)
        {
            ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists " +
                                         "see your system administrator.");
        }

        return View(listingProject);
    }

   public IActionResult InsertListings()
   {
       return View();
   }
    
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult InsertListings([Bind("ListingName")] ListingProjects listingProject) // Change to ListingProjects model
    {
        
        try
        {
            if (ModelState.IsValid)
            {
                _context.ListingDBTable.Add(listingProject);
                _context.SaveChanges();
                return RedirectToAction("TestDashboard1"); // Redirect to dashboard
            }
            else
            {
                // Model is invalid, handle it (e.g., show validation errors)
                return View(listingProject); // Return the view with error messages
            }
        }
        catch (DbUpdateException dbUpdateException)
        {
            ModelState.AddModelError("", "Unable to save changes. " +
                                         "Try again, and if the problem persists " +
                                         "see your system administrator.");
        }

        return View(listingProject);
    }

var app = builder.Build();

using (var scope = app.Services.CreateScope())
{
    var db = scope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
    db.Database.Migrate();
    var services = scope.ServiceProvider;

    var seeder = new DataSeed(db);
    seeder.SeedModels();  
}

var app = builder.Build();

using (var scope = app.Services.CreateScope())
{
    var db = scope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
    db.Database.Migrate();
    var services = scope.ServiceProvider;

    var seeder = new DataSeed(db);
    seeder.SeedModels();  
}

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM PortalUsers;
+---------------+------+-------------+-------------------------------------------------+
| Name          | Age  | Location    | DisplayInfo                                     |
+---------------+------+-------------+-------------------------------------------------+
| Alice Smith   | 30   | New York    | Name: Alice Smith Age: 30 Location: New York    |
| Bob Johnson   | 25   | Los Angeles | Name: Bob Johnson Age: 25 Location: Los Angeles |
| Charlie Brown | 35   | Chicago     | Name: Charlie Brown Age: 35 Location: Chicago   |
+---------------+------+-------------+-------------------------------------------------+
3 rows in set (0.00 sec)

public int[] FindBall(int[][] grid){
        int col = grid[0].Length;
        int row= grid.Length;
        int[] result = new int[col];
     
        for(int i=0; i< col; i++){
            result [i]= Helper(grid,row,col);
        }

        return result;
    }

    public int Helper(int[][] grid, int row, int col){
        int currCol = 0;
        int currRow = 0; //OutOfBoundsException
        while(currRow < row){
            if (grid[currRow][currCol]==1){
                if(currCol == col - 1 || grid[currRow][currCol+1]==-1){
                    return -1;
                    break;
                } else {
                    currCol++;
                    currRow++;
                }
            } else if (grid[currRow][currCol] ==-1){
                if(currCol <0 || grid[currRow][currCol-1]==1){
                    return -1;
                    break;
                } else {
                    currCol--;
                    currRow++;
                }
            } 
            currRow++;
        }
        if(currRow==row){
            currCol = grid[currRow][currCol];
        } 
        return currCol;
    }

public int[] FindBall(int[][] grid){
        int col = grid[0].Length;
        int row= grid.Length;
        int[] result = new int[col];
     
        for(int i=0; i< col; i++){
            result [i]= Helper(grid,row,col);
        }

        return result;
    }

    public int Helper(int[][] grid, int row, int col){
        int currCol = 0;
        int currRow = 0; //OutOfBoundsException
        while(currRow < row){
            if (grid[currRow][currCol]==1){
                if(currCol == col - 1 || grid[currRow][currCol+1]==-1){
                    return -1;
                    break;
                } else {
                    currCol++;
                    currRow++;
                }
            } else if (grid[currRow][currCol] ==-1){
                if(currCol <0 || grid[currRow][currCol-1]==1){
                    return -1;
                    break;
                } else {
                    currCol--;
                    currRow++;
                }
            } 
            currRow++;
        }
        if(currRow==row){
            currCol = grid[currRow][currCol];
        } 
        return currCol;
    }

public class ZigZagBallFallsTry
{

    public int[] FindBall(int[][] grid)
    {
        int col = grid[0].Length-1;
        int row = grid.Length-1;
        int[] result = new int[col];

        for (int i = 0; i < col; i++)
        {
            result[i] = BallHelp(grid, row, col);
        }

        return result;

    }

    private int BallHelp(int[][] grid, int row, int col)
    {
        int currRow = 0;
        int currCol = col;

        while (currRow <= row)
        {
            if (grid[currRow][currCol] == 1)
            {
                if (currCol == col || grid[currRow][currCol + 1] == -1)
                {
                    return -1;
                }
                else
                {
                    currCol++;
                    currRow++;
                } 
            } 
            else if (grid[currRow][currCol] == -1)
            {
                if (currCol == 0 || grid[currRow][currCol - 1] == 1)
                {
                    return -1;
                }
                else
                {
                    currCol--;
                    currRow++;
                }
            } 
            else 
            {
                currRow++;
            }
        }

        return currCol;
    }

}

public class ZigZagBallFallsTry
{

    public int[] FindBall(int[][] grid)
    {
        int col = grid[0].Length-1;
        int row = grid.Length-1;
        int[] result = new int[col];

        for (int i = 0; i < col; i++)
        {
            result[i] = BallHelp(grid, row, col);
        }

        return result;

    }

    private int BallHelp(int[][] grid, int row, int col)
    {
        int currRow = 0;
        int currCol = col;

        while (currRow <= row)
        {
            if (grid[currRow][currCol] == 1)
            {
                if (currCol == col || grid[currRow][currCol + 1] == -1)
                {
                    return -1;
                }
                else
                {
                    currCol++;
                    currRow++;
                } 
            } 
            else if (grid[currRow][currCol] == -1)
            {
                if (currCol == 0 || grid[currRow][currCol - 1] == 1)
                {
                    return -1;
                }
                else
                {
                    currCol--;
                    currRow++;
                }
            } 
            else 
            {
                currRow++;
            }
        }

        return currCol;
    }

}

public class ZigZagBallFallsTry
{
    public int[] FindBall(int[][] grid)
    {
        int m = grid.Length - 1;
        int n = grid[0].Length - 1;

        int[] result = new int[grid[0].Length]; // Initialize result array with correct size

        for (int row = 0; row <= m; row++) // Loop until row <= m
        {
            result[row] = RecordBallMovements(grid, m, n); // Pass row index to RecordBallMovements
        }

        return result;
    }

    private int RecordBallMovements(int[][] grid, int m, int n)
    {
        int helperCol = 0; // Initialize helperCol here
        for (int helperRow = 0; helperRow < m; helperRow++) // Loop until helperRow <= row
        {
            for (; helperCol >= 0 && helperCol <=  n; helperCol++) // Correct loop condition and increment helperCol
            {
                if (grid[helperRow][helperCol] == 1)
                {
                    if (helperCol == n || grid[helperRow][helperCol + 1] == -1) // Use == instead of >
                    {
                        return -1;
                        break;
                    }
                }
                else if (grid[helperRow][helperCol] == -1)
                {
                    if (helperCol == 0 || grid[helperRow][helperCol - 1] == 1) // Use == instead of <
                    {
                        return -1;
                        break;
                    }
                    helperCol--; // Decrement helperCol for left movement
                }
            }
        }
        return helperCol; 
    }


}

public class ZigZagBallFallsTry
{
    public int[] FindBall(int[][] grid)
    {
        int m = grid.Length - 1;
        int n = grid[0].Length - 1;

        int[] result = new int[grid[0].Length]; // Initialize result array with correct size

        for (int row = 0; row <= m; row++) // Loop until row <= m
        {
            result[row] = RecordBallMovements(grid, m, n); // Pass row index to RecordBallMovements
        }

        return result;
    }

    private int RecordBallMovements(int[][] grid, int m, int n)
    {
        int helperCol = 0; // Initialize helperCol here
        for (int helperRow = 0; helperRow < m; helperRow++) // Loop until helperRow <= row
        {
            for (; helperCol >= 0 && helperCol <=  n; helperCol++) // Correct loop condition and increment helperCol
            {
                if (grid[helperRow][helperCol] == 1)
                {
                    if (helperCol == n || grid[helperRow][helperCol + 1] == -1) // Use == instead of >
                    {
                        return -1;
                        break;
                    }
                }
                else if (grid[helperRow][helperCol] == -1)
                {
                    if (helperCol == 0 || grid[helperRow][helperCol - 1] == 1) // Use == instead of <
                    {
                        return -1;
                        break;
                    }
                    helperCol--; // Decrement helperCol for left movement
                }
            }
        }
        return helperCol; 
    }


}

PM> dotnet ef migrations add InitialCreate
Build started...
Build failed. Use dotnet build to see the errors.
PM> dotnet build
MSBuild version 17.7.1+971bf70db for .NET
  Determining projects to restore...
  All projects are up-to-date for restore.
  CRUD_HomeFinder -> C:\Users\Mami Kawamura\Source\Repos\CRUD_HomeFinder\CRUD_HomeFinder\bin\Debug\net6.0\MVCCore.dll

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:02.35

PM> dotnet ef migrations add InitialCreate
Build started...
Build failed. Use dotnet build to see the errors.
PM> dotnet build
MSBuild version 17.7.1+971bf70db for .NET
  Determining projects to restore...
  All projects are up-to-date for restore.
  CRUD_HomeFinder -> C:\Users\Mami Kawamura\Source\Repos\CRUD_HomeFinder\CRUD_HomeFinder\bin\Debug\net6.0\MVCCore.dll

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:02.35

Employee not found

Employee not found

"Employee edited successfully!"

"Employee edited successfully!"