<?php
/*
* John L. Kotos
* PHP33 Final Project
* MIS 126-270 Fall 2016 Semester
* Introduction to PHP
* Instructor: Mike Pavlak
* Date: December 02, 2016
* Filename: manufacturer_db.php
* Code based 'My Guitar Shop' from: Harris, R. & Murach, J. (2014). Murach's php and mysql. Fresno, CA: Mike Murach and Associates.
*/

function get_manufacturers()
{
    global $db;
    $query = 'SELECT * FROM manufacturers
              ORDER BY manufacturerID';
    try 
    {
        $statement = $db->prepare($query);
        $statement->execute();
        $manufacturers = $statement->fetchAll();
        $statement->closeCursor();
        return $manufacturers;
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}

function get_manufacturer($manufacturer_id)
{
    global $db;
    $query = 'SELECT * FROM manufacturers
              WHERE manufacturerID = :manufacturer_id';
    try 
    {
        $statement = $db->prepare($query);
        $statement->bindValue(':manufacturer_id', $manufacturer_id);
        $statement->execute();
        $manufacturer = $statement->fetch();
        $statement->closeCursor();
        return $manufacturer;
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}

function add_manufacturer($name, $address, $city, $state, $zipcode, $phone, $website)
{
    global $db;
    $query = 'INSERT INTO manufacturers (name, address, city, state, zipcode, phone, website)
              VALUES (:name, :address, :city, :state, :zipcode, :phone, :website)';
    try 
    {
        $statement = $db->prepare($query);
        $statement->bindValue(':name', $name);
        $statement->bindValue(':address', $address);
        $statement->bindValue(':city', $city);
        $statement->bindValue('state', $state);
        $statement->bindValue('zipcode', $zipcode);
        $statement->bindValue('phone', $phone);
        $statement->bindValue('website', $website);
        $statement->execute();
        $statement->closeCursor();
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}

function delete_manufacturer($manufacturer_id)
{
    global $db;
    $query = 'DELETE FROM manufacturers WHERE manufacturerID = :manufacturer_id';
    try 
    {
        $statement = $db->prepare($query);
        $statement->bindValue(':manufacturer_id', $manufacturer_id);
        $statement->execute();
        $statement->closeCursor();
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}

function update_manufacturer($manufacturer_id, $name, $address, $city, $state, $zipcode, $phone, $website)
{
    global $db;
    $query = 'UPDATE manufacturers
              SET name = :name,
                  address = :address,
                  city = :city,
                  state = :state,
                  zipcode = :zipcode,
                  phone = :phone,
                  website = :website
              WHERE manufacturerID = :manufacturer_id';
    try 
    {
        $statement = $db->prepare($query);
        $statement->bindValue(':manufacturer_id', $manufacturer_id);
        $statement->bindValue(':name', $name);
        $statement->bindValue(':address', $address);
        $statement->bindValue(':city', $city);
        $statement->bindValue(':state', $state);
        $statement->bindValue(':zipcode', $zipcode);
        $statement->bindValue(':phone', $phone);
        $statement->bindValue(':website', $website);
        $statement->execute();
        $statement->closeCursor();
    }
    catch (PDOException $e)
    {
        $errorMessage = $e->getMessage();
        include('../View/database_error.php');
    }
}
?>