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