$Address_Id = $ClassMaster->LastID();
$tblClass['Company_Id'] = $_POST['Company_Id'];
$tblClass['Address_Id'] = $Address_Id;
if ($new_filename != '') {
$new_filename = "http://ClassCrashers.wheresthepen.com/uploads/" . $new_filename;
$tblClass['Class_Photo'] = $new_filename;
}
$tblClass['Class_Time'] = $_POST['txtOpenTimeHr'] . ":" . $_POST['txtOpenTimeMn'] . " " . $_POST['txtOpenTimeAMPM'] . " - " . $_POST['txtCloseTimeHr'] . ":" . $_POST['txtCloseTimeMn'] . " " . $_POST['txtCloseTimeAMPM'];
if ($_POST['class_id'] == '') {
$ClassMaster->insert('tblClass', $tblClass);
$Class_Id = $ClassMaster->LastID();
} else {
$Class_Id = mysqli_real_escape_string($ClassMaster->link(), $_POST['class_id']);
$ClassMaster->update('tblClass', $tblClass, "Class_Id = '" . $Class_Id . "'");
}
$ClassMaster->query("DELETE FROM tblInstructorClassXref WHERE Class_Id = '" . $Class_Id . "'");
foreach ($Instructors as $Instructor) {
$tblInstructorClassXref['Instructor_ID'] = $Instructor;
$tblInstructorClassXref['Class_Id'] = $Class_Id;
$ClassMaster->insert('tblInstructorClassXref', $tblInstructorClassXref);
}
$ClassMaster->query("DELETE FROM tblRequirementXref WHERE Class_Id = '" . $Class_Id . "'");
foreach ($Requirements as $Requirement) {
$tblRequirementXref['Requirement_Id'] = $Requirement;
$tblRequirementXref['Class_Id'] = $Class_Id;
$ClassMaster->insert('tblRequirementXref', $tblRequirementXref);
}
$ClassMaster->query("DELETE FROM tblDates WHERE Class_Id = '" . $Class_Id . "'");
$tblDates['Class_Id'] = $Class_Id;
$ClassMaster->insert('tblDates', $tblDates);
echo json_encode(array("Success" => "<strong>Success:</strong> Class added successfully."));
