bool exitsUserName()
{
//Necesito la base de datos para validar esta parte
string comando = "SELECT COUNT(*) FROM usuario WHERE usuario='" + txtUserName.Text + "';";
if (int.Parse(bd.consulta(comando).Rows[0][0].ToString()) != 0)
{
errorUserName.Text = "Usuario ya registrado. Introduzca otro.";
return(true);
}
return(false);
}
private void ObtainDeckData()
{
string query = "SELECT * FROM baraja WHERE id = " + idDeck + ";"; //obtener la información de la baraja
DataTable deckInfo = bd.consulta(query);
if (deckInfo.Rows.Count == 0)
{
return;
}
textBoxDeckTitle.Text = deckInfo.Rows[0]["titulo"].ToString();
checkBoxDeckPublic.Checked = !bool.Parse(deckInfo.Rows[0]["privacidad"].ToString());
}
private void ObtainCardsFromBD()
{
TarjetitasDB bd = new TarjetitasDB();
string query = "SELECT tipoDeTarjeta, frente, reverso FROM tarjetas WHERE idBaraja = " + idDeck + " AND elimLogica = 0;"; //obtener todas las cartas de la baraja seleccionada
cards = bd.consulta(query);
}
private void btnIniciarSesion_Click(object sender, EventArgs e)
{
//Buscar Usuario Existente
string query = "SELECT * FROM usuario WHERE usuario = '" + txtUsuario.Text + "' AND " +
"contraseña = '" + txtContraseña.Text + "';";
if (bd.consulta(query).Rows.Count != 0)
{
MenuPrincipal mp = new MenuPrincipal(txtUsuario.Text); //inicializar main menu
this.Hide(); //ocultar la página de iniciar sesión
mp.ShowDialog(); //mostrarlo
txtUsuario.Text = "Usuario"; //reestablecer valores de usuario y contraseña
txtContraseña.Text = "Contraseña";
if (!mp.LoggedOut()) //si no cerró sesión, entonces cerró la aplicación, también cerrar esta página.
{
this.Close();
return;
}
this.Show(); //mostrar página de iniciar sesión
}
else
{
errorLogIn.Visible = true;
}
}
private void GetAviableDecksFromUser()
{
string query = "SELECT id, titulo FROM baraja WHERE usuario = '" + labelUser.Text + "' AND elimLogica = 0;";
DataTable result = db.consulta(query);
for (int i = 0; i < result.Rows.Count; i++)
{
idAviableDecks.Add(int.Parse(result.Rows[i]["id"].ToString()));
comboBoxRecoveCard.Items.Add(result.Rows[i]["titulo"].ToString());
}
if (idAviableDecks.Count > 0)
{
comboBoxRecoveCard.SelectedIndex = 0;
}
}
private void ObtainDecksFromUser()
{
TarjetitasDB bd = new TarjetitasDB();
string query = "SELECT * FROM baraja WHERE usuario = '" + labelUser.Text + "' AND elimLogica = 0;";
DataTable result = bd.consulta(query);
if (result.Rows.Count == 0)
{
return;
}
for (int i = 0; i < result.Rows.Count; i++)
{
query = "SELECT COUNT(numTarjeta) FROM tarjetas WHERE idBaraja = " + result.Rows[i]["id"] + " AND elimLogica = 0;";
DataTable cards = bd.consulta(query);
AddDeckToFlowLayout(result.Rows[i]["titulo"].ToString(), int.Parse(cards.Rows[0]["COUNT(numTarjeta)"].ToString()), int.Parse(result.Rows[i]["id"].ToString()), bool.Parse(result.Rows[i]["privacidad"].ToString()));
}
}
private void ObtainDecksFromUser()
{
TarjetitasDB bd = new TarjetitasDB();
string query = labelDecksTitle.Text == "Barajas Públicas"
? "SELECT * FROM baraja WHERE privacidad = 0 AND elimLogica = 0;"
: "SELECT B.* FROM baraja_usuario_favoritiza BF INNER JOIN baraja B ON B.id = BF.idBaraja WHERE BF.usuario = '" + labelUser.Text + "' AND B.elimLogica = 0;";
DataTable result = bd.consulta(query);
if (result.Rows.Count == 0)
{
return;
}
for (int i = 0; i < result.Rows.Count; i++)
{
query = "SELECT COUNT(numTarjeta) FROM tarjetas WHERE idBaraja = " + result.Rows[i]["id"] + " AND elimLogica = 0;";
DataTable cards = bd.consulta(query);
AddDeckToFlowLayout(result.Rows[i]["titulo"].ToString(), result.Rows[i]["usuario"].ToString(), int.Parse(cards.Rows[0]["COUNT(numTarjeta)"].ToString()), int.Parse(result.Rows[i]["id"].ToString()), bool.Parse(result.Rows[i]["privacidad"].ToString()));
}
}
private void DeckButton_Load(object sender, EventArgs e)
{
TarjetitasDB db = new TarjetitasDB();
string query = "SELECT id FROM baraja_usuario_favoritiza WHERE usuario = '" + this.CurrentUser + "' AND idBaraja = " + this.Id + ";";
DataTable result = db.consulta(query);
if (result.Rows.Count == 0)
{
pictureBoxNotFavourite.Visible = true;
pictureBoxFavourite.Visible = false;
}
else
{
pictureBoxNotFavourite.Visible = false;
pictureBoxFavourite.Visible = true;
}
}
private void ObtainThemeFromUser()
{
TarjetitasDB bd = new TarjetitasDB(); //declarar conexion a BD
string query = "SELECT id, rgb_boton, rgb_panel, rgb_fondo FROM tema" +
" INNER JOIN usuario ON usuario.idTema = tema.id WHERE usuario = '" + labelUser.Text + "';";
DataTable result = bd.consulta(query); //obtener la tupla deseada
if (result.Rows.Count == 0)
{
MessageBox.Show("Error al cargar temas de usuario.");
this.Close();
}
idTheme = int.Parse(result.Rows[0]["id"].ToString());
colorButtons = System.Drawing.ColorTranslator.FromHtml(result.Rows[0]["rgb_boton"].ToString());
colorPanels = System.Drawing.ColorTranslator.FromHtml(result.Rows[0]["rgb_panel"].ToString());
colorBackground = System.Drawing.ColorTranslator.FromHtml(result.Rows[0]["rgb_fondo"].ToString());
}
void GetUserData()
{
string query = "SELECT * FROM usuario WHERE usuario = '" + User + "';";
UserData = bd.consulta(query);
}
private void GetAllCards()
{
string query = "SELECT * FROM tarjetas WHERE idBaraja=" + IdBaraja.ToString() + " AND elimLogica=0;";
cards = db.consulta(query);
}