private void btnIngresar_Click(object sender, EventArgs e)
{
try
{
UserLoginBE ulogin = new UserLoginBE();
if (txtPassword.Text.Length == 0 && txtUsername.Text.Length == 0)
{
MessageBox.Show("Ingrese sus datos.");
}
else if (txtPassword.Text.Length == 0 || txtUsername.Text.Length == 0)
{
MessageBox.Show("Usuario y/o contrasenia esta vacia");
}
else
{
ulogin = userbc.getLogin(txtUsername.Text, txtPassword.Text);
if (ulogin.IdUser == null)
{
MessageBox.Show("Usuario y/o contrasenia incorrecto.");
}
else
{
////redirigir al main
this.Hide();
switch (ulogin.Role)
{
case "ADM":
var frmMainAdm = new FMainAdm();
frmMainAdm.ulogin = ulogin;
frmMainAdm.Show(); break;
case "DOC":
var frmMainMdc = new FMainMdc();
frmMainMdc.ulogin = ulogin;
frmMainMdc.Show(); break;
case "PCN":
var frmMainPcn = new FMainPcn();
frmMainPcn.ulogin = ulogin;
frmMainPcn.Show(); break;
default:
MessageBox.Show("Usuario no tiene rol asignado");
break;
}
}
}
}
catch (Exception)
{
MessageBox.Show("Ocurrio un error en el sistema.");
}
}
public UserLoginBE getUserByEmail(String email)
{
UserLoginBE user = new UserLoginBE();
try
{
user = userDALC.getUserByEmail(email);
}
catch (Exception)
{
throw;
}
return(user);
}
public UserLoginBE getLogin(String username, String password)
{
UserLoginBE user = new UserLoginBE();
try
{
user = userDALC.getLogin(username, password);
}
catch (Exception)
{
throw;
}
return(user);
}
public UserLoginBE getLogin(String username, String password)
{
UserLoginBE user = new UserLoginBE();
try
{
using (SqlConnection cnx = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("usp_login", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 600;
cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = username;
var pass = PasswordSC.PasswordEncriptarSHA512(password);
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = pass;
cnx.Open();
IDataReader dr = cmd.ExecuteReader();
using (dr)
{
while (dr.Read())
{
user.IdUser = dr.GetGuid(dr.GetOrdinal("IdUser")).ToString();
user.Name = dr.GetString(dr.GetOrdinal("Name"));
user.LastName = dr.GetString(dr.GetOrdinal("LastName"));
user.DNI = dr.GetString(dr.GetOrdinal("DNI"));
user.Role = dr.GetString(dr.GetOrdinal("rol"));
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(user);
}
public UserLoginBE getUserByEmail(String email)
{
UserLoginBE user = new UserLoginBE();
try
{
using (SqlConnection cnx = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("usp_getuserbyEmail", cnx);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 600;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = email;
cnx.Open();
IDataReader dr = cmd.ExecuteReader();
using (dr)
{
while (dr.Read())
{
user.IdUser = dr.GetGuid(dr.GetOrdinal("IdUser")).ToString();
user.Name = dr.GetString(dr.GetOrdinal("Name"));
user.LastName = dr.GetString(dr.GetOrdinal("LastName"));
user.DNI = dr.GetString(dr.GetOrdinal("DNI"));
user.Role = dr.GetString(dr.GetOrdinal("rol"));
user.Password = dr.GetString(dr.GetOrdinal("Password"));
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(user);
}
