public DataTable mostrarUsuarios(varuser user)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("f_muestra_registro", 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 insertarUsuario(varuser user)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("f_insertar_usuario", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
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("sweb", NpgsqlDbType.Varchar).Value = user.Sweb;
dataAdapter.SelectCommand.Parameters.Add("foto", NpgsqlDbType.Text).Value = user.Url;
conectar.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();
}
}
return(Usuario);
}
