<?php
	require_once('pdoconfig.php');

	$catid=$_REQUEST['catid'];
	$act=$_REQUEST['act'];
	
	$remarks=$_REQUEST['remarks'];
	
	$crs_name=$_REQUEST['crs_name'];
	$duration=$_REQUEST['duration'];
	$fee=$_REQUEST['fee'];
	$link=$_REQUEST['link'];
	 $uploadresume=$_FILES["file"]["name"];
	 $description=$_REQUEST['desc'];
	 //die($act);

	//if($active=='on'){ $aa1=1;}else{ $aa1=0;}


/*if($category=='' || strlen($category)>50)
{
   die("Something went wrong! <br> <a href='category_master.php'>Continue</a>");   
}*/

       if($act == "add")
		{
	
			$sql="insert into aa_studio_master set crs_name=?, duration=?, fee=?,description=?,remarks=?"; 
			$arr=array($crs_name,$duration,$fee,$description,$remarks);
			$res=$action->insertp($sql,$arr);
	        $prod_id=$res;
	           
	            if($res>0)
	            {
	                /***************Image1************************************/
               		if($uploadresume!='')
                    {
                        
        		        $file_tmp =$_FILES['file']['tmp_name'];	   
        	            $pos=strpos($uploadresume,".");     
        	            if($uploadresume=="")
        				{
        				    $new_file_name="";
        				}
        				else
        				{
            				$new_file_name="Studio".'-'.$prod_id.substr($uploadresume, $pos,strlen($uploadresume)-$pos);
        				}
    				    move_uploaded_file($file_tmp,"upload/studio_image/".$new_file_name);
        				//echo $new_file_name;
        				$qry="update aa_studio_master set image=? where std_id=?";
        				$arr=array($new_file_name,$prod_id);
        		        $action->updatep($qry,$arr);
    			    }
			
	            ?>
			    <script>
			        alert("Data Save successfully");
			        window.location.href="studio_master.php";				    
			    </script>
			    <?php
		    }
	    }
	    else if($act == "edit")
		{
			$sql="update aa_studio_master set crs_name=?, duration=?, fee=?, description=? where std_id=?"; 
			$arr=array($crs_name,$duration,$fee,$description,$catid);			
			$res=$action->updatep($sql,$arr);				
          
            
	            if($res>0)
	            {
	                	 
    	            if($uploadresume!='')
    	            {
    	               //die($uploadresume);
        		        $file_tmp =$_FILES['file']['tmp_name'];	   
    	                $pos=strpos($uploadresume,".");     
        	            if($uploadresume=="")
        				{
        				    $new_file_name="";
        				}
        				else
        				{
            				$new_file_name="Studio".'-'.$catid.substr($uploadresume, $pos,strlen($uploadresume)-$pos);
        				}
        				    move_uploaded_file($file_tmp,"upload/studio_image/".$new_file_name);
        				    $qry="update aa_studio_master set image=? where std_id=?";
        				    $arr=array($new_file_name,$catid);
        		            $action->updatep($qry,$arr);
    			    }
	            ?>
			    <script>
			        alert("Data update successfully");
			        window.location.href="studio_master.php";				    
			    </script>
			    <?php
		    }			
	    }
	    
	    else if($act == "del")
		{
			$sql="delete from aa_studio_master where std_id=?"; 
			$arr=array($catid);
			
			$res=$action->deletep($sql,$arr);
				

	            if($res)
	            {
	            ?>
			    <script>
			        alert("Data delete successfully");
			        window.location.href="studio_master.php";				    
			    </script>
			    <?php
		        }			
	    }
	    
		
?>