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