/home2/mshostin/farms.ms-hostingladz.com/app/Http/Controllers/StateController.php
<?php

namespace App\Http\Controllers;

use App\Models\State;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class StateController extends Controller
{
    public function index()
    {
        // Get all states for table and modal dropdowns
        $states = State::orderBy('name', 'asc')->get();
        return view('states.index', compact('states'));
    }

    public function store(Request $request)
    {
        $request->validate([
            'name' => 'required|string|max:255|unique:states,name',
        ]);

        State::create([
            'name' => $request->name,
            'created_by' => Auth::id(),
        ]);

        return back()->with('success', 'State created successfully.');
    }

    public function update(Request $request, State $state)
    {
        $request->validate([
            'name' => 'required|string|max:255|unique:states,name,' . $state->id,
        ]);

        $state->update([
            'name' => $request->name,
            'updated_by' => Auth::id(),
        ]);

        return back()->with('success', 'State updated successfully.');
    }

    public function destroy(State $state)
    {
        $state->delete();
        return back()->with('success', 'State deleted successfully.');
    }
}