public static function updateTid($id, $data) { try { $sql = "UPDATE tipo_id SET "; foreach ($data as $key => $value) { $sql = $sql . " " . $key . " = '" . $value . "', "; } $newLeng = strlen($sql) - 2; $sql = substr($sql, 0, $newLeng); $sql = $sql . " WHERE cod_tip_id = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("El tipo de Identificacion {$id} no ha podido ser actualizado"); } return $rsp; } catch (PDOException $e) { DataBaseClass::getCnx()->rollBack(); return $e; } }
/** * * @param type $id * @param type $data * @return boolean|\PDOException * @throws PDOException */ public static function updateMatricula($id, $data) { try { $sql = "UPDATE matricula SET "; foreach ($data as $key => $value) { $sql = $sql . " " . $key . " = '" . $value . "', "; } $newLeng = strlen($sql) - 2; $sql = substr($sql, 0, $newLeng); $sql = $sql . " WHERE num_ficha = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("La Matricula no ha podido ser actualizado"); } return $rsp; } catch (PDOException $e) { DataBaseClass::getCnx()->rollBack(); return $e; } }
/** * * @param type $id * @return boolean|\PDOException * @throws PDOException */ public static function deleteDepto($id) { try { $sql = "DELETE FROM depto WHERE cod_depto = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("El Departamento no ha podido ser eliminado", 2633); } return $rsp; } catch (PDOException $e) { dataBaseClass::getCnx()->rollback(); return $e; } }
/** * * @param type $id * @return boolean|\PDOException * @throws PDOException */ public static function deleteCredencial($id) { try { $sql = "DELETE FROM usuario_credencial WHERE id = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("El usuario credencial no ha podido ser eliminado", 2633); } return $rsp; } catch (PDOException $e) { dataBaseClass::getCnx()->rollback(); return $e; } }
public static function updateDatUser($id, $data) { try { $sql = "UPDATE Datos_usuario SET "; foreach ($data as $key => $value) { $sql = $sql . " " . $key . " = '" . $value . "', "; } $newLeng = strlen($sql) - 2; $sql = substr($sql, 0, $newLeng); $sql = $sql . " WHERE id = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("Los Datos Del Usuario no han podido ser actualizado", 2632); } return $rsp; } catch (PDOException $e) { DataBaseClass::getCnx()->rollBack(); return $e; } }
/** * * @param type $id * @return boolean|\PDOException * @throws PDOException */ public static function deleteFicha($id) { try { $sql = "DELETE FROM ficha WHERE num_ficha = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("La ficha no ha podido ser eliminado", 2633); } return $rsp; } catch (PDOException $e) { dataBaseClass::getCnx()->rollback(); return $e; } }
/** * * @param type $id * @return boolean|\PDOException * @throws PDOException */ public static function deleteCausaDesercion($id) { try { $sql = "DELETE FROM causa_desercion WHERE cod_causa = " . $id; dataBaseClass::getCnx()->beginTransaction(); $rsp = dataBaseClass::getCnx()->exec($sql); dataBaseClass::getCnx()->commit(); if ($rsp !== false) { $rsp = true; } else { throw new PDOException("La causa de desercion no ha podido ser ELIMINADA", 2633); } return $rsp; } catch (PDOException $e) { dataBaseClass::getCnx()->rollback(); return $e; } }