<?php 
  session_start();
  if(!$_SESSION['id']){
    header('location:index.php');
  }
?>
<?php 
  require_once '../system/conn.php';
  if(isset($_POST["submit"]))
   {
    $name=$_POST['name'];
    $Details=$_POST['Details'];
    $updated_date=date("Y-m-d");
    
    $data = [
    'name' => $name,
    'Details' => $Details,
    'updated_date' => $updated_date,
    ];
    
    $sql = "INSERT INTO designation (name, Details, updated_date) VALUES (:name, :Details, :updated_date)";
    $stmt= $conn->prepare($sql);
    $statement = $stmt->execute($data);
    
    if($statement){
      echo "<script>alert('Designation added successfully.')</script>";
      echo " <script>window.location.assign('designation.php')</script>";
    } else {
        echo "not inserted";
    }
   } 
?>
<!doctype html>
<html lang="en" class="semi-dark">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    
    <!-- loader-->
	<link href="assets/css/pace.min.css" rel="stylesheet" />
	<script src="assets/js/pace.min.js"></script>

    <!--plugins-->
    <link href="assets/plugins/perfect-scrollbar/css/perfect-scrollbar.css" rel="stylesheet" />
    <link href="assets/plugins/simplebar/css/simplebar.css" rel="stylesheet" />
    <link href="assets/plugins/metismenu/css/metisMenu.min.css" rel="stylesheet" />

    <!-- CSS Files -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/bootstrap-extended.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <link href="assets/css/icons.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.7.2/font/bootstrap-icons.css">
    <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@400;500&display=swap" rel="stylesheet">

    <!--Theme Styles-->
    <link href="assets/css/dark-theme.css" rel="stylesheet" />
    <link href="assets/css/semi-dark.css" rel="stylesheet" />
    <link href="assets/css/header-colors.css" rel="stylesheet" />

    <title>UTCPL</title>
  </head>
  <body>
    

 <!--start wrapper-->
    <div class="wrapper">
    <?php include'system/header.php'?>
    <!--end top header-->


        <!-- start page content wrapper-->
        <div class="page-content-wrapper">
          <!-- start page content-->
         <div class="page-content">

             <!--start breadcrumb-->
            <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
              <div class="breadcrumb-title pe-3">Add Designation</div>
                <div class="ms-auto">
                </div>
            </div>
            <!--end breadcrumb-->


            <div class="row">
              <div class="col-xl-12 mx-auto">
                <hr/>
                <div class="card">
                  <div class="card-body">
                    <div class="p-4 border rounded">
                      <form class="row g-3 needs-validation" novalidate method="post" enctype="multipart/form-data" action="">
                        <div class="col-md-6">
                          <label for="validationCustom01" class="form-label">Enter Designation Name</label>
                          <input type="text" class="form-control" id="validationCustom01" placeholder="Enter Designation Name" name="name" required>
                          <div class="valid-feedback">Enter Designation Name!</div>
                        </div>
                        <div class="col-md-6">
                          <label for="validationCustom01" class="form-label">Enter Details</label>
                          <input type="text" class="form-control" id="validationCustom01" placeholder="Enter Details" name="Details" required>
                          <div class="valid-feedback">Enter Details!</div>
                        </div>
                        <div class="col-12">
                          <button class="btn btn-primary" type="submit" name="submit" value="submit" >Submit form</button>
                        </div>
                      </form>
                    </div>
                  </div>
                </div>
                
                
              </div>
            </div>
            <!--end row-->


          </div>
          <!-- end page content-->
         </div>
<?php include'system/footer.php'?>