public bool ValidaLogIn(LogInVendedor logIn)
{
bool rs = false;
SqlConnection oConnection = new SqlConnection(@"Server=localhost;Data Source=LAPTOP-RS890769\SQLEXPRESS;Database=AllSalesApp;Integrated Security=SSPI");
if (oConnection.State != System.Data.ConnectionState.Open)
{
oConnection.Open();
}
SqlParameter paramCedula = new SqlParameter("@Cedula", logIn.Login);
SqlParameter paramPass = new SqlParameter("@password", logIn.Password);
string sql = "SELECT Cedula, Password FROM tblVendedor WHERE(Cedula = @Cedula) AND(Password = @password)";
SqlCommand oCommand = new SqlCommand();
oCommand.Connection = oConnection;
oCommand.CommandType = System.Data.CommandType.Text;
oCommand.CommandText = sql;
oCommand.Parameters.Add(paramCedula);
oCommand.Parameters.Add(paramPass);
SqlDataReader sqlDataReader = oCommand.ExecuteReader();
if (sqlDataReader.HasRows == true)
{
while (sqlDataReader.Read())
{
if (sqlDataReader["Cedula"] != DBNull.Value)
{
rs = true;
}
if (sqlDataReader["Password"] != DBNull.Value)
{
rs = true;
}
}
}
else
{
rs = false;
}
return(rs);
}
private void Arranca()
{
using (LogInServices intento = new LogInServices())
{
LogInVendedor dato = new LogInVendedor();
dato.Login = Cedula;
dato.Password = Password;
if (intento.ValidaLogIn(dato))
{
Hide();
IDVendedor(dato.Login);
}
else
{
MessageBox.Show("Acceso Denegado", "allSalesApp", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
