/**
  * This function loads the Assign Tasks page for a particular event 
  *
  *
  * @return    Assign Tasks page with Quote Requests/Users table data 
  */
 public function Assign()
 {
     $input = Request::all();
     //if no inputs, redirect to Task Templates page
     if ($input == null) {
         return redirect('dashboard/events/assign-tasks');
     }
     //check with db if EventName is valid
     $evid = $_GET['EventID'];
     $quote = Quote_Requests::select('*')->where('id', $evid)->get();
     //if not valid,  redirect to Task Templates page
     if ($quote == '[]') {
         return redirect('dashboard/events/assign-tasks');
     }
     foreach ($quote as $quote1) {
         $evetype = $quote1->EventType;
     }
     $tasks = Task_Templates::select('*')->where('EventName', $evetype)->get();
     $team = Users::distinct()->select('*')->where('role', 'team-member')->get();
     $alreadyassigned = Event_Tasks::select('*')->where('EventID', $evid)->get();
     return view('assign_task.assign')->with(array('team' => $team, 'quote' => $quote, 'tasks' => $tasks, 'already' => $alreadyassigned));
 }
                                    </thead>

                                    <tbody>
                                        <?php 
use App\Models\Task_Templates;
foreach ($result as $todo) {
    echo '<tr>';
    echo '<td ><b> <font size="4">
                                            ' . $todo->EventName . '</font> </b>
                                            <table class="table table-striped table-borderd">
                                            <thead>
                                            <td width="300px"><b>To Do Task</b></td>
                                            <td><b>Description</b></td>
                                            </thead>
                                            <tbody>';
    $result2 = Task_Templates::select('*')->where('EventName', $todo->EventName)->get();
    foreach ($result2 as $todo2) {
        echo '<tr>';
        echo '<td>' . $todo2->ToDoTask . '</td>';
        echo '<td>' . $todo2->Description . '</td>';
        echo '</tr>';
    }
    echo '</tbody>
                                            </table>
                                            </td>';
    echo '<td style="vertical-align:middle;" align="center" ><a href ="tasks/edit?EventName=' . $todo->EventName . '" ><i class="fa fa-edit"></i></td>';
    echo '</tr>';
}
?>
                                    </tbody>
                                </table>
 /**
  * This function gives the Exsisting Task Template for given EventName
  *
  * @param   EventName
  *
  * @return  Edit Task Templates page with task_template table data
  */
 public function GetTaskDetails()
 {
     $ename = $_POST['EvName'];
     $result = Task_Templates::select('ToDoTask', 'Description')->where('EventName', $ename)->get();
     return $result;
 }