public async Task <IActionResult> Register(RegisterModel model)
{
if (ModelState.IsValid)
{
Euser user = await _context.Euser.FirstOrDefaultAsync(u => u.EuserLogin == model.Login);
if (user == null)
{
user = new Euser
{
EuserLogin = model.Login,
EuserPassword = model.Password,
RoleId = model.RoleId,
EmployeeId = model.EmployeeId
};
_context.Euser.Add(user);
await _context.SaveChangesAsync();
return(RedirectToAction("Index", "Home"));
}
else
{
RedirectToAction("Register");
}
}
return(View(model));
}
public DataTable Login(Euser usuario)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("uniempleo.f_loggin", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_name", NpgsqlDbType.Varchar).Value = usuario.UserName;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Varchar).Value = usuario.Clave;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable loogin(Euser enc)
{
DataTable Usuario = new DataTable();
NpgsqlConnection connection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiPrimeraConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("usuario.f_autenticar", connection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_name", NpgsqlDbType.Text).Value = enc.Username;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Text).Value = enc.Clave;
connection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(Usuario);
}
public DataTable cerrarSesion(Euser datos)//
{
DataTable user = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("seguridad.f_cerrar_session", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_session", NpgsqlDbType.Text).Value = datos.Sesion1;
conectar.Open();
dataAdapter.Fill(user);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();//
}
}
return(user);
}
public DataTable GuardarSesion(Euser datauser)//
{
DataTable loggin = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("seguridad.f_guarda_sesion", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_id", NpgsqlDbType.Integer).Value = datauser.Id;
dataAdapter.SelectCommand.Parameters.Add("_ip", NpgsqlDbType.Varchar, 100).Value = datauser.Ip;
dataAdapter.SelectCommand.Parameters.Add("_mac", NpgsqlDbType.Varchar, 100).Value = datauser.Mac;
dataAdapter.SelectCommand.Parameters.Add("_session", NpgsqlDbType.Text).Value = datauser.Sesion1;
conectar.Open();
dataAdapter.Fill(loggin);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();//
}
}
return(loggin);
}
public DataTable CambiarClave(Euser cambiarclave)
{
DataTable Operario = new DataTable();
NpgsqlConnection conectarOP = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("uniempleo.f_cambia_clave", conectarOP);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
//dataAdapter.SelectCommand.Parameters.Add("_token", NpgsqlDbType.Text).Value = cambiarclave.Token;
dataAdapter.SelectCommand.Parameters.Add("_user_id", NpgsqlDbType.Integer).Value = cambiarclave.Id;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Varchar).Value = cambiarclave.CambiaC;
conectarOP.Open();
dataAdapter.Fill(Operario);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectarOP != null)
{
conectarOP.Close();
}
}
return(Operario);
}
private async Task Authenticate(Euser user)
{
var claims = new List <Claim>
{
new Claim(ClaimsIdentity.DefaultNameClaimType, user.EuserLogin),
new Claim(ClaimsIdentity.DefaultRoleClaimType, user.Role.RoleName),
};
ClaimsIdentity id = new ClaimsIdentity(claims, "ApplicationCookie", ClaimsIdentity.DefaultNameClaimType,
ClaimsIdentity.DefaultRoleClaimType);
await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(id));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["id"] == null || Session["nombre"] == null || Session["rol"] == null)
{
Response.Redirect("Loggin.aspx");
Response.Cache.SetNoStore();
}
DUser user = new DUser();
Euser datos = new Euser();
datos.Sesion1 = Session.SessionID;
user.cerrarSesion(datos);
if (Session["id"] == null || Session["nombre"] == null || Session["rol"] == null)
{
Response.Redirect("Loggin.aspx");
}
}
public async Task <IActionResult> Login(LoginModel model)
{
if (ModelState.IsValid)
{
Euser user = await _context.Euser.Include(e => e.Employee)
.Include(u => u.Role)
.FirstOrDefaultAsync(u => u.EuserLogin == model.Login && u.EuserPassword == model.Password);
if (user != null)
{
await Authenticate(user);
return(RedirectToAction("Index", "Home"));
}
ModelState.AddModelError("", "Не правильний логін чи пароль");
}
return(View(model));
}
protected void btn_aceptar_Click(object sender, EventArgs e)
{
Euser encapsular = new Euser();
DaoUser datos = new DaoUser();
encapsular.Username = txt_usuario.Text.ToString();
encapsular.Clave = txt_clave.Text.ToString();
DataTable resultado = datos.loogin(encapsular);
if (resultado.Rows.Count > 0)
{
Session["userId"] = resultado.Rows[0]["user_id"].ToString();
Session["nombre"] = resultado.Rows[0]["nombre"].ToString();
//Response.Redirect("Agregar.aspx");
Response.Redirect("RegistrarUsuario.aspx");
}
else
{
lb_error.Text = "Usuario y/o clave incorrectos";
Session["userId"] = null;
}
}
public DataTable RegistraAspirante(Euser enviarR1)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("uniempleo.f_registrar_aspirante", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_nombre", NpgsqlDbType.Varchar).Value = enviarR1.Nombre;
dataAdapter.SelectCommand.Parameters.Add("_apellido", NpgsqlDbType.Varchar).Value = enviarR1.Apellido;
dataAdapter.SelectCommand.Parameters.Add("_nacimiento", NpgsqlDbType.Date).Value = enviarR1.Nacimiento;
dataAdapter.SelectCommand.Parameters.Add("_direccion", NpgsqlDbType.Varchar).Value = enviarR1.Direccion;
dataAdapter.SelectCommand.Parameters.Add("_celular", NpgsqlDbType.Varchar).Value = enviarR1.Celular;
dataAdapter.SelectCommand.Parameters.Add("_documento", NpgsqlDbType.Varchar).Value = enviarR1.Documento;
dataAdapter.SelectCommand.Parameters.Add("_estado", NpgsqlDbType.Varchar).Value = enviarR1.Estadocivil;
dataAdapter.SelectCommand.Parameters.Add("_sexo", NpgsqlDbType.Varchar).Value = enviarR1.Sexo;
dataAdapter.SelectCommand.Parameters.Add("_foto", NpgsqlDbType.Varchar).Value = enviarR1.Foto;
dataAdapter.SelectCommand.Parameters.Add("_sesion", NpgsqlDbType.Varchar).Value = enviarR1.Sesion1;
dataAdapter.SelectCommand.Parameters.Add("_idaspirante", NpgsqlDbType.Integer).Value = enviarR1.Id;
dataAdapter.SelectCommand.Parameters.Add("_e_stado", NpgsqlDbType.Integer).Value = enviarR1.Estado;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
