//funcion login
public DataTable login1(E_login log)
{
DataTable validacion = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("usuarios.f_usuarios", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_usuario", NpgsqlDbType.Text).Value = log.User;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Text).Value = log.Clave;
conection.Open();
dataAdapter.Fill(validacion);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(validacion);
}
protected void Iniciar_Click(object sender, EventArgs e)
{
E_login login = new E_login();
login.User = Tx_Usuario.Text;
login.Clave = Tx_Clave.Text;
DAO log = new DAO();
DataTable inico;
inico = log.login(login);
if (inico.Rows.Count > 0) //if (int.Parse(inico.Rows[0]["id"].ToString()) > 0)
{
Session["id"] = inico.Rows[0]["id"].ToString();
Session["nombre"] = inico.Rows[0]["nombre_usuario"].ToString();
Session["apellido"] = inico.Rows[0]["apellido_usuario"].ToString();
Session["rol"] = inico.Rows[0]["id_rol"].ToString();
if (int.Parse(Session["rol"].ToString()) == 1)
{
//rediereccion al perfil surperadministrador
}
else if (int.Parse(Session["rol"].ToString()) == 2)
{
Response.Redirect("Perfil_administrador.aspx");
}
else if (int.Parse(Session["rol"].ToString()) == 3)
{
Response.Redirect("Perfil_Usuario.aspx");
}
}
else
{
Lb_error.Visible = true;
Lb_error.Text = "Error en los datos";
//Session["id"] = null;
}
}
