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;
}
}
