<?php
    require_once('inc/ses_check.php');
    require_once('inc/mysql_connection.php');
    require_once('inc/my_functions.php');

    if(isset($_POST['pr_action'])){
    $action=$_POST['pr_action'];
    switch($action){
        case 1: //this is for add
            $module=$_POST['module'];
            $moduledesc=$_POST['module_desc'];
            $modulefilename=$_POST['module_fname'];

            if(!isModuleExist($module)){
            $sql="INSERT INTO tbl_modules(module,module_desc,module_filename)VALUES('$module','$moduled','$modulefilename');";
            $result=mysql_query($sql);
            if($result){
                echo infoMsg(1);
            }else{
                die("error");
            }
            }else{
                echo errMsg(1);
            }
            break;
        case 2: //retrieve values from the previous page
            $module=$_POST['module'];
            $moduledesc=$_POST['module_desc'];
            $modulefilename=$_POST['module_fname'];
            $temp_Id=$_POST['temp_id'];

			if(!checkIfUpdateDuplicatesModule($module,$temp_Id)){
            $sql="UPDATE tbl_modules SET module='$module',module_desc='$moduledesc',module_fname='$modulefilename' WHERE Id=$temp_Id;";
            $result=mysql_query($sql);
            if($result){
                echo infoMsg(2);
            }else{
                die("Error in updating record".mysql_error());
                }
            }else{
                echo errMsg(1);
            }
            break;
        case 3:
            $temp_Id=$_POST['selected_Id'];
            $sql="DELETE FROM tbl_modules WHERE Id=$temp_Id;";
            $result=mysql_query($sql);
            if(result){
                $_SESSION['errmsg']=infoMsg(3);
                header('location:table_modules.php');
            }else{
                die("Error in deleting record".mysql_error());
            }
            break;
        case 4:
            $search_str=$_POST['txt_search'];
            if($search_str<>""){
                $_SESSION['search_str']=$search_str;
            }
            header('location:table_modules.php');
            break;
			}
		}else{
			die("Invalid action!");
		}
?>