public DataTable PrestamoUsuario(EPrestamo ePres, String user)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
DataTable Prestamo = new DataTable();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlDataAdapter dataAdapter = new MySqlDataAdapter("sp_agregar_SolPrestamo", conection); //crea objeto para llamar el proceso almacenado
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_id_elemento", MySqlDbType.Int32).Value = ePres.Id_elemento;
dataAdapter.SelectCommand.Parameters.Add("_id_usuario", MySqlDbType.Int32).Value = ePres.Usuario_id;
dataAdapter.SelectCommand.Parameters.Add("_Estado_id", MySqlDbType.Int32).Value = ePres.Estado_id;
dataAdapter.SelectCommand.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
dataAdapter.SelectCommand.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
dataAdapter.SelectCommand.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
dataAdapter.Fill(Prestamo);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Prestamo);
}
public void RegistrarPrestamo(EPrestamo ePres, String user)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlCommand command = new MySqlCommand("sp_agregar_Prestamo", conection); //crea objeto para llamar el proceso almacenado
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_id", MySqlDbType.Int32).Value = ePres.Id;
command.Parameters.Add("_id_administrador", MySqlDbType.Int32).Value = ePres.Admin_id;
command.Parameters.Add("_Estado_id", MySqlDbType.Int32).Value = ePres.Estado_id;
command.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
command.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
command.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public void DevolverPrestamo(int id)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//conexion base de datos
try
{
conection.Open();
MySqlCommand command = new MySqlCommand("sp_devolver_prestamo", conection);//proceso almancenado a usar
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_id", MySqlDbType.Int32).Value = id;
command.ExecuteNonQuery();
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public void EliminarBibliote(int cedula, String user)
{ //metodo para registrar Usuarios
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlCommand command = new MySqlCommand("sp_eliminar_bibliotecarios", conection); //crea objeto para llamar el proceso almacenado
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_id", MySqlDbType.VarChar, 100).Value = cedula;
command.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
command.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
command.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public void AgregarParametrizacion(EParametrizar eParametros)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
DataTable Autor = new DataTable();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlCommand command = new MySqlCommand("sp_parametrizar", conection); //crea objeto para llamar el proceso almacenado
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_dias", MySqlDbType.Int32).Value = eParametros.Dias;
command.Parameters.Add("_valor", MySqlDbType.Int64).Value = eParametros.Valor;
command.Parameters.Add("_libros", MySqlDbType.Int32).Value = eParametros.LibrosPrest;
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public DataTable SaldarMultas(int id, string user)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
DataTable Usuario = new DataTable();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//conexion base de datos
try
{
MySqlDataAdapter dataAdapter = new MySqlDataAdapter("sp_desbloquear_usuario", conection);//proceso almancenado a usar
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_id", MySqlDbType.Int32).Value = id;
dataAdapter.SelectCommand.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
dataAdapter.SelectCommand.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
dataAdapter.SelectCommand.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public void EliminarElemento(int cedula, String user)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//conexion base de datos
try
{
conection.Open();
MySqlCommand command = new MySqlCommand("sp_eliminar_elemento", conection);//proceso almancenado a usar
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_id", MySqlDbType.Int32).Value = cedula;
command.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
command.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
command.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
command.ExecuteNonQuery();
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public DataTable AgregarAutores(EAutor autor, String user)
{ //metodo para registrar Usuarios
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
DataTable Autor = new DataTable();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlDataAdapter dataAdapter = new MySqlDataAdapter("sp_agregar_autores", conection); //crea objeto para llamar el proceso almacenado
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_nombre", MySqlDbType.VarChar, 30).Value = autor.Nombre;
dataAdapter.SelectCommand.Parameters.Add("_año", MySqlDbType.Int32).Value = autor.Año;
dataAdapter.SelectCommand.Parameters.Add("_nacionalidad", MySqlDbType.Int32).Value = autor.Nacionalidad;
dataAdapter.SelectCommand.Parameters.Add("_sexo", MySqlDbType.VarChar, 30).Value = autor.Sexo;
dataAdapter.SelectCommand.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
dataAdapter.SelectCommand.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
dataAdapter.SelectCommand.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
dataAdapter.Fill(Autor);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Autor);
}
public void ModificarAutores(Int32 Id, String Nombre, Char Sexo, String Nacionalidad, String user, Int32 año_de_nacimiento)
{ //metodo para registrar Usuarios
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlCommand command = new MySqlCommand("sp_modificar_autores", conection); //crea objeto para llamar el proceso almacenado
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_id", MySqlDbType.Int32).Value = Id;
command.Parameters.Add("_nombre", MySqlDbType.VarChar, 50).Value = Nombre;
command.Parameters.Add("_año", MySqlDbType.Int32).Value = año_de_nacimiento;
command.Parameters.Add("_nacionalidad", MySqlDbType.VarChar, 30).Value = Nacionalidad;
command.Parameters.Add("_sexo", MySqlDbType.VarChar, 30).Value = Sexo;
command.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
command.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
command.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public void AgregarRCategorias(String nombre, int id, String user)
{
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString); //conexion base de datos
try
{
conection.Open();
MySqlCommand command = new MySqlCommand("sp_agregar_relacion_categorias", conection); //proceso almancenado a usar
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_nombre", MySqlDbType.VarChar, 50).Value = nombre;
command.Parameters.Add("_id", MySqlDbType.Int32).Value = id;
command.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
command.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
command.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
command.ExecuteNonQuery();
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public DataTable RegistrarUsuario(EUsuario usuario, String user) //metodo para registrar Usuarios
{
DataTable Usuario = new DataTable();
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlDataAdapter dataAdapter = new MySqlDataAdapter("sp_registrar_usuarios", conection); //crea objeto para llamar el proceso almacenado
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_nombre", MySqlDbType.VarChar, 50).Value = usuario.Nombre;
dataAdapter.SelectCommand.Parameters.Add("_nickname", MySqlDbType.VarChar, 30).Value = usuario.Nickname;
dataAdapter.SelectCommand.Parameters.Add("_clave", MySqlDbType.VarChar, 30).Value = usuario.Clave;
dataAdapter.SelectCommand.Parameters.Add("_correo", MySqlDbType.VarChar, 200).Value = usuario.Correo;
dataAdapter.SelectCommand.Parameters.Add("_telefono", MySqlDbType.VarChar, 100).Value = usuario.Telefono;
dataAdapter.SelectCommand.Parameters.Add("_rol_id", MySqlDbType.Int32).Value = usuario.Id_rol;
dataAdapter.SelectCommand.Parameters.Add("_estado_id", MySqlDbType.Int32).Value = usuario.Id_estado;
dataAdapter.SelectCommand.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
dataAdapter.SelectCommand.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
dataAdapter.SelectCommand.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
dataAdapter.Fill(Usuario);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable AgregarElementos(EElemento elemento, String user)
{ //metodo para registrar Usuarios
string ipAddress = Ip.GetIP();
string MacAddress = Mac.GetMACAddress2();
DataTable Elemento = new DataTable();
MySqlConnection conection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Mybd"].ConnectionString);//procede la conexion llamada "Mybd" ver web.config
try
{
conection.Open(); //abre coneccion
MySqlDataAdapter dataAdapter = new MySqlDataAdapter("sp_agregar_elementos", conection); //crea objeto para llamar el proceso almacenado
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_nombre", MySqlDbType.VarChar, 50).Value = elemento.Nombre;
dataAdapter.SelectCommand.Parameters.Add("_editorial", MySqlDbType.VarChar, 50).Value = elemento.Editorial;
dataAdapter.SelectCommand.Parameters.Add("_año", MySqlDbType.Int32).Value = elemento.Año;
dataAdapter.SelectCommand.Parameters.Add("_tipo_id", MySqlDbType.Int32).Value = elemento.Tipo_id;
dataAdapter.SelectCommand.Parameters.Add("_url", MySqlDbType.VarChar, 500).Value = elemento.Url;
dataAdapter.SelectCommand.Parameters.Add("_cantidad", MySqlDbType.Int32).Value = elemento.Cantidad;
dataAdapter.SelectCommand.Parameters.Add("_reserva", MySqlDbType.Int32).Value = elemento.Reserva;
dataAdapter.SelectCommand.Parameters.Add("_ip", MySqlDbType.VarChar, 100).Value = ipAddress;
dataAdapter.SelectCommand.Parameters.Add("_mac", MySqlDbType.VarChar, 100).Value = MacAddress;
dataAdapter.SelectCommand.Parameters.Add("_user", MySqlDbType.VarChar, 30).Value = user;
dataAdapter.Fill(Elemento);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Elemento);
}
