Web Development

public class TestController : _ControllerBase
{
    [HttpPost]
    public void Post([FromBody] TestEntity entity)
    {
        Repository.AddTest(entity);
    }

    [HttpDelete]
    public void Delete(Guid id)
    {
        Repository.DeleteTest(id);
    }

    [HttpGet]
    public IEnumerable Get()
    {
        return Repository.GetTests();
    }

    [HttpGet]

    public TestEntity Get(Guid id)
    {
        return Repository.GetTest(id);
    }

    [HttpPut]
    public void Put(Guid id, [FromBody] TestEntity entity)
    {
        Repository.UpdateTest(entity);
    }
}

public class RouteConfig
{
    public static void RegisterRoutes(RouteCollection routes)
    {
        routes.IgnoreRoute("{resource}.axd/{*pathInfo}");

        routes.MapRoute(
            name: "Default",
            url: "{controller}/{action}/{id}",
            defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
        );
    }
}

public static function setJsonAuthCookie($userName, $userType): void {

        date_default_timezone_set('America/Los_Angeles');
        $today = new DateTime();

        $jsonData = array(
            "userName" => $userName,
            "userType" => $userType,
            "createdOn" => $today,
            "expires" => $today->add(new DateInterval('PT4H')),
            "token" => "",
            "auth0" => ""
        );

        $jsonEncode = json_encode($jsonData, JSON_FORCE_OBJECT);
        setcookie("authJson", $jsonEncode, time()+240);

    }

    public static function validateUser(): array {

        $cookie = clsAuth::getJsonAuthCookie();
        if (!isset($cookie)) {

            $formAction = "/pcad/unauthorized.phtml";
            header("Location: http://".$_SERVER['HTTP_HOST']."$formAction");

        } else {

            $userName = $cookie['userName'];
            $userType = $cookie['userType'];
            $createdOn = $cookie['createdOn'];
            $expires = $cookie['expires'];
            $token = $cookie['token'];
            $auth0 = $cookie['auth0'];

            // Convert the string date back into a date object
            date_default_timezone_set('America/Los_Angeles');
            $today = new DateTime();
            $dateString = $expires['date'];
            $timeZone = $expires['timezone'];

            echo "<div>validating token</div>";

            if ($dateString > $today) {

                echo "<div>token declined</div>";

                sleep(1);
                $formAction = "/pcad/";
                // header("Location: http://".$_SERVER['HTTP_HOST']."$formAction");

            } else {

                echo "<div>token accepted</div>";

// Cookie Value
%7B%22userName%22%3A%22jimk%22%2C%22userType%22%3A%22Executive%22%2C%22createdOn%22%3A%7B%22date%22%3A%222021-02-17%2018%3A32%3A54.638030%22%2C%22timezone_type%22%3A3%2C%22timezone%22%3A%22America%5C%2FLos_Angeles%22%7D%2C%22expires%22%3A%7B%22date%22%3A%222021-02-17%2018%3A32%3A54.638030%22%2C%22timezone_type%22%3A3%2C%22timezone%22%3A%22America%5C%2FLos_Angeles%22%7D%2C%22token%22%3A%22%22%2C%22auth0%22%3A%22%22%7D

<div class="col-lg-3">
   <div class="features-icons-item mx-auto mb-5 mb-lg-0 mb-lg-3">
      <div class="features-icons-icon d-flex">
       class="icon-playlist m-auto text-primary">

     </div>
     <a href="#schedule">
     <h3>Programming</h3>
   </a>
     <p class="lead mb-0">Schedule</p>
   </div>
 </div>

meta= 1
Notice: Trying to get property 'name' of non-object in C:\App\Dev\PCAD\class\cls_db_tools.php on line 137
Notice: Trying to get property 'name' of non-object in C:\App\Dev\PCAD\class\cls_db_tools.php on line 141
meta= 1

function db_Sel_Query($sqlQuery) {

<pre>
$Rows = Array();
$resQuery = mssql_query($sqlQuery) or die();
$cRows = mssql_num_rows($resQuery);
$cFields = mssql_num_fields($resQuery);

$rgFields = Array();
for ($i = 0; $i < $cFields; $i++) {
    $meta = mssql_fetch_field($resQuery);
    $rgFields[$i] = $meta->name;
}

public static function dbSelectQuery($sqlQuery): array {

<pre>
$Rows = array();
$rgFields = array();
$params = array();
$options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );

$conn = clsDbConnect::createConn();
$resQuery = sqlsrv_query($conn, $sqlQuery, $params, $options) or die();
$rowCount = sqlsrv_num_rows($resQuery);
$fieldCount = sqlsrv_num_fields($resQuery);

for ($i = 0; $i < $fieldCount; $i++) {

    $meta = sqlsrv_fetch_array($resQuery, SQLSRV_FETCH_ASSOC, $i);
    // $meta = sqlsrv_get_field($resQuery, $i);
    echo "<div>meta= " . print_r($meta) . "</div>";
    if ($meta->name) {
        echo "<div>meta.name= $meta->name</div>";
    }

    $rgFields[$i] = $meta->name;

}

echo "
 <td class='text-align-center'>
   <p class='margin-text-indent'> $sold_date </p>
 </td>";

$row_proj = sqlsrv_fetch_array($res_proj);
$projectNumber = $row_proj[0];
$proj_stage = $row_proj[1];
$version_no = $row_proj[2];
$customerNumber = $row_proj[3];
$sold_date = $row_proj[4]; // FIXME - convert smalldatetime to string
$sales_no = $row_proj[5];
$swan_job = $row_proj[6];