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); }