public DataTable registrar_categoria(Enca_Datos categoria)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("herramienta.f_registrar_categoria", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_nombre_cat", NpgsqlDbType.Varchar).Value = categoria.Nombre_cat;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable insertarRespuesta(Enca_Comenta user)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
Enca_Datos user1 = new Enca_Datos();
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("herramienta.insertar_respuesta", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_comen", NpgsqlDbType.Varchar, 50).Value = user.Respuesta;
dataAdapter.SelectCommand.Parameters.Add("_iduser", NpgsqlDbType.Integer, 50).Value = user.User_resp;
dataAdapter.SelectCommand.Parameters.Add("_idc", NpgsqlDbType.Integer, 50).Value = user.Valor;
conectar.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();
}
}
return(Usuario);
}
public DataTable bloqueadoss(Enca_Datos user)//usuarios bloqueadoss
{
DataTable Usuario = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("biblioseg.f_bloqueadoss", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
conectar.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();
}
}
return(Usuario);
}
public DataTable enviar_usuario(Enca_Datos user)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("biblioseg.f_muestra_usuarios", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable muestra_usuarios(Enca_Datos user)//comentarios realizados
{
DataTable Usuario = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("herramienta.muestra_categoria", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
conectar.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();
}
}
return(Usuario);
}
public DataTable registrar_usuario1(Enca_Datos user)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter(" biblioseg.f_registrar_usuario", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_id_rol", NpgsqlDbType.Integer).Value = user.Id_rol;
dataAdapter.SelectCommand.Parameters.Add("_nombre", NpgsqlDbType.Varchar).Value = user.Nombre;
dataAdapter.SelectCommand.Parameters.Add("_correo", NpgsqlDbType.Varchar).Value = user.Correo;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Varchar).Value = user.Clave;
dataAdapter.SelectCommand.Parameters.Add("_sitio_web", NpgsqlDbType.Varchar).Value = user.Sitio_web;
dataAdapter.SelectCommand.Parameters.Add("_nom_user", NpgsqlDbType.Varchar).Value = user.Nom_user;
dataAdapter.SelectCommand.Parameters.Add("_foto", NpgsqlDbType.Text).Value = user.Foto;
dataAdapter.SelectCommand.Parameters.Add("_puntos", NpgsqlDbType.Integer).Value = 10;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable correoUsuario(Enca_Datos user)
{
DataTable Usuario_Login = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("biblioseg.f_correo_usuario", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_name", NpgsqlDbType.Text).Value = user.Nom_user;
conection.Open();
dataAdapter.Fill(Usuario_Login);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario_Login);
}
public DataTable guardadoSession(Enca_Datos datos)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("seguridad.f_guardado_session", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_id", NpgsqlDbType.Integer).Value = datos.UserId;
dataAdapter.SelectCommand.Parameters.Add("_ip", NpgsqlDbType.Varchar, 100).Value = datos.Ip;
dataAdapter.SelectCommand.Parameters.Add("_mac", NpgsqlDbType.Varchar, 100).Value = datos.Mac;
dataAdapter.SelectCommand.Parameters.Add("_session", NpgsqlDbType.Text).Value = datos.Session;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable Login(Enca_Datos user)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("biblioseg.f_login", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_nom_user", NpgsqlDbType.Varchar).Value = user.Nom_user;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Varchar).Value = user.Clave;
dataAdapter.SelectCommand.Parameters.Add("_ip", NpgsqlDbType.Varchar).Value = user.Ip;
dataAdapter.SelectCommand.Parameters.Add("_mac", NpgsqlDbType.Varchar).Value = user.Mac;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public void cerrarSession(Enca_Datos datos)
{
DataTable loginUser = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("seguridad.f_modifica_session", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_id_user", NpgsqlDbType.Varchar).Value = datos.Id_rol;
conection.Open();
dataAdapter.Fill(loginUser);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
