<?php 
	require_once('pdoconfig.php');
	
	$catid=$_REQUEST['catid'];
	$act=$_REQUEST['act'];
    $contid=$_REQUEST['contid'];

	
	$party=$_REQUEST['party']; 
	$qrate=$_REQUEST['qrate']; 
	$fdate=$_REQUEST['fdate'];	
	$remark=$_REQUEST['remark'];
	
	$fdate1=date('Y-m-d',strtotime($fdate));
	
	
			
		if($act == "add")
		{
		           //echo "insert into contract_attendee set filled_date='$fdate1',cont_id='$contid',party_id='$party',rate_for_cont='$qrate',remarks='$remark'";
		            //die();
					$sql="insert into contract_attendee set filled_date=?,cont_id=?,party_id=?,rate_for_cont=?,remarks=?";
					$arr=array($fdate1,$contid,$party,$qrate,$remark);
					$res=$action->insertp($sql,$arr);
	            if($res>0)
	            {
	            ?>
			    <script>
			        alert("Data Save successfully");
			        window.location.href="sanjay.php?contid=<?=$contid?>";				    
			    </script>
			    <?php
		    }
	    }
	    else if($act == "edit")
		{
		
					$sql="update contract_attendee set filled_date=?,cont_id=?,party_id=?,rate_for_cont=?,remarks=? where cont_attend_id=?";
					$arr=array($fdate1,$contid,$party,$qrate,$remark,$catid);
			        $res=$action->updatep($sql,$arr);				

	            if($res)
	            {
	            ?>
			    <script>
			        alert("Data update successfully");
			        window.location.href="sanjay.php?contid=<?=$contid?>";				    
			    </script>
			    <?php
		    }			
	    }
	    
	    else if($act == "del")
		{
			$sql="delete from contract_attendee where cont_attend_id=?"; 
			$arr=array($catid);
			
			$res=$action->deletep($sql,$arr);
				

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