public static Data_PushBBVA.Login Login2(string user, string pass)
{
string sql = @"SELECT *
FROM Admin
WHERE idAdmin = @usuario AND password = @password ";
using (SqlConnection conn = new SqlConnection(connectionString: conex))
{
Data_PushBBVA.Login access = new Data_PushBBVA.Login();
try
{
SqlCommand command = new SqlCommand(sql, conn);
command.Parameters.AddWithValue("@usuario", user);
command.Parameters.AddWithValue("@password", pass);
conn.Open();
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
DataSet dtDatos = new DataSet();
daAdaptador.Fill(dtDatos);
foreach (DataRow _dr in dtDatos.Tables[0].Rows)
{
access.name = _dr["firtsName"].ToString() + " " + _dr["lastName"].ToString();
access.user = _dr["idAdmin"].ToString();
access.status = "Success";
}
return(access);
}
catch (Exception ex)
{
access.status = "Error";
return(access);
}
}
}
public static Data_PushBBVA.Login Login2(string user, string pass)
{
string sql = @"SELECT *
FROM Admin
WHERE idAdmin = @usuario AND password = @password ";
using (SqlConnection conn = new SqlConnection(connectionString: conex))
{
Data_PushBBVA.Login access = new Data_PushBBVA.Login();
try
{
SqlCommand command = new SqlCommand(sql, conn);
command.Parameters.AddWithValue("@usuario", user);
command.Parameters.AddWithValue("@password", pass);
conn.Open();
SqlDataAdapter daAdaptador = new SqlDataAdapter(command);
DataSet dtDatos = new DataSet();
daAdaptador.Fill(dtDatos);
foreach (DataRow _dr in dtDatos.Tables[0].Rows)
{
access.name = _dr["firtsName"].ToString() + " " + _dr["lastName"].ToString();
access.user = _dr["idAdmin"].ToString();
access.status = "Success";
}
return access;
}
catch (Exception ex)
{
access.status = "Error";
return access;
}
}
}
