private bool VerificarCampos(string COND)
{
SQLiteConnection conn = new SQLiteConnection(conexao);
if (conn.State == ConnectionState.Closed)
conn.Open();
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM tb_games " + COND, conn);
SQLiteDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
return true;
}
else
{
return false;
}
conn.Clone();
}
public void SaveData()
{
conn = new System.Data.SQLite.SQLiteConnection(@"Data Source=CoreInkLib.dll");
conn.Open();
SQLiteCommand sqc = new SQLiteCommand("DELETE FROM character", conn);
sqc.ExecuteNonQuery();
sqc = new SQLiteCommand("DELETE FROM strokes", conn);
sqc.ExecuteNonQuery();
sqc = new SQLiteCommand("DELETE FROM variant", conn);
sqc.ExecuteNonQuery();
foreach (Character c in chars)
{
sqc = new SQLiteCommand("SELECT ifnull(max(char_id),0) FROM character", conn);
int id = Convert.ToInt32(sqc.ExecuteScalar());
id++;
sqc = new SQLiteCommand("INSERT INTO character VALUES (" + id.ToString() + ",'" + c.charx + "'," + c.lang.ToString() + ")", conn);
sqc.ExecuteNonQuery();
foreach (Variant v in c.variants)
{
sqc = new SQLiteCommand("SELECT ifnull(max(vid),0) FROM variant", conn);
int vid = Convert.ToInt32(sqc.ExecuteScalar());
vid++;
sqc = new SQLiteCommand("INSERT INTO variant VALUES (" + vid.ToString() + "," + id.ToString() + ")", conn);
sqc.ExecuteNonQuery();
int sti = 0;
foreach (Stroke st in v.Strokes)
{
sqc = new SQLiteCommand("SELECT ifnull(max(s_id),0) FROM strokes", conn);
int sid = Convert.ToInt32(sqc.ExecuteScalar());
sid++;
sqc = new SQLiteCommand("INSERT INTO strokes VALUES (" + sid.ToString() + "," + vid.ToString() + "," + id.ToString() + ",'" + Stroke2Int(st).ToString() + "','" + st.quadrant + "'," + sti.ToString() + ")", conn);
sqc.ExecuteNonQuery();
sti++;
}
}
}
conn.Clone();
}
/// <summary>
/// ADICIONANDO UM NOVO RAP
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tbAdd_Click(object sender, RoutedEventArgs e)
{
if (tbID.Text != "" && tbNome.Text != "" && tbRapCode.Text != "" && tbRapNome.Text != "")
{
SQLiteConnection conn = new SQLiteConnection(conexao);
if (conn.State == ConnectionState.Closed)
conn.Open();
SQLiteCommand cmd = new SQLiteCommand("INSERT INTO tb_raps (ID, NOME, RAPCODE, RAPNOME) VALUES (@ID, @NOME, @RAPCODE, @RAPNOME)", conn);
cmd.Parameters.AddWithValue("ID", tbID.Text.Trim());
cmd.Parameters.AddWithValue("NOME", tbNome.Text.Trim());
cmd.Parameters.AddWithValue("RAPCODE", tbRapCode.Text.Trim());
cmd.Parameters.AddWithValue("RAPNOME", tbRapNome.Text.Trim());
try
{
cmd.ExecuteNonQuery();
MsgBox.Show("Rap adicionado com sucesso!", "Sucesso", MsgBox.Buttons.OK);
tbID.Text = String.Empty;
tbNome.Text = String.Empty;
tbRapCode.Text = String.Empty;
tbRapNome.Text = String.Empty;
}
catch (Exception ex)
{
MessageBox.Show("Erro ao cadastrar:\n" + ex.Message);
}
conn.Clone();
}
else
{
MsgBox.Show("Você precisa preencher todos os campos", "Atenção", MsgBox.Buttons.OK);
}
}
/// <summary>
/// ENVIAR OS JOGOS
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEnviar_Click(object sender, RoutedEventArgs e)
{
if (VerificarCampos("WHERE ID = '" + tbID.Text + "'"))
{
MessageBox.Show("Você já cadastrou um jogo com esse ID");
return;
}
if (tbID.Text != "" && tbTitulo.Text != "" && tbTipo.Text != "" && tbRegiao.Text != "" && tbLink1.Text != "")
{
SQLiteConnection conn = new SQLiteConnection(conexao);
if (conn.State == ConnectionState.Closed)
conn.Open();
SQLiteCommand cmd = new SQLiteCommand("INSERT INTO tb_games (ID, TITULO, TIPO, REGIAO, LINK1, LINK2, LINK3, LINK4, LINK5, CAPA) VALUES (@ID, @TITULO, @TIPO, @REGIAO, @LINK1, @LINK2, @LINK3, @LINK4, @LINK5, @CAPA)", conn);
cmd.Parameters.AddWithValue("ID", tbID.Text.Trim());
cmd.Parameters.AddWithValue("TITULO", tbTitulo.Text.Trim());
cmd.Parameters.AddWithValue("TIPO", tbTipo.Text.Trim());
cmd.Parameters.AddWithValue("REGIAO", tbRegiao.Text.Trim());
cmd.Parameters.AddWithValue("LINK1", tbLink1.Text.Trim());
if (tbLink2.Text != "")
{
cmd.Parameters.AddWithValue("LINK2", tbLink2.Text.Trim());
}
else
{
cmd.Parameters.AddWithValue("LINK2", "");
}
if (tbLink3.Text != "")
{
cmd.Parameters.AddWithValue("LINK3", tbLink3.Text.Trim());
}
else
{
cmd.Parameters.AddWithValue("LINK3", "");
}
if (tbLink4.Text != "")
{
cmd.Parameters.AddWithValue("LINK4", tbLink4.Text.Trim());
}
else
{
cmd.Parameters.AddWithValue("LINK4", "");
}
if (tbLink5.Text != "")
{
cmd.Parameters.AddWithValue("LINK5", tbLink5.Text.Trim());
}
else
{
cmd.Parameters.AddWithValue("LINK5", "");
}
cmd.Parameters.AddWithValue("CAPA", tbID.Text.Trim() + ".jpg");
// FAZENDO UPLOAD DA IMAGEM
if (this.Cimage != "")
{
// MOVER ARQUIVO
if (File.Exists(path + "data\\covers\\" + tbID.Text.Trim() + ".jpg"))
{
File.Delete(path + "data\\covers\\" + tbID.Text.Trim() + ".jpg");
}
File.Copy(Cimage, path + "data\\covers\\" + tbID.Text.Trim() + ".jpg");
}
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Registro incluido com sucesso!");
LimparCampos();
}
catch (Exception ex)
{
MessageBox.Show("Erro ao cadastrar:\n" + ex.Message);
}
conn.Clone();
}
else
{
MessageBox.Show("Você precisa preecher todos os campos!", "OCORREU UM ERRO", MessageBoxButton.OK, MessageBoxImage.Error);
}// Validação campos vazios
}
public void SaveData()
{
conn = new System.Data.SQLite.SQLiteConnection(@"Data Source=CoreInkLib.dll");
conn.Open();
SQLiteCommand sqc = new SQLiteCommand("DELETE FROM character",conn);
sqc.ExecuteNonQuery();
sqc = new SQLiteCommand("DELETE FROM strokes", conn);
sqc.ExecuteNonQuery();
sqc = new SQLiteCommand("DELETE FROM variant", conn);
sqc.ExecuteNonQuery();
foreach (Character c in chars)
{
sqc = new SQLiteCommand("SELECT ifnull(max(char_id),0) FROM character", conn);
int id = Convert.ToInt32(sqc.ExecuteScalar());
id++;
sqc = new SQLiteCommand("INSERT INTO character VALUES (" + id.ToString() + ",'" + c.charx + "'," + c.lang.ToString() + ")", conn);
sqc.ExecuteNonQuery();
foreach (Variant v in c.variants)
{
sqc = new SQLiteCommand("SELECT ifnull(max(vid),0) FROM variant", conn);
int vid = Convert.ToInt32(sqc.ExecuteScalar());
vid++;
sqc = new SQLiteCommand("INSERT INTO variant VALUES (" + vid.ToString() + "," + id.ToString() + ")", conn);
sqc.ExecuteNonQuery();
int sti = 0;
foreach (Stroke st in v.Strokes)
{
sqc = new SQLiteCommand("SELECT ifnull(max(s_id),0) FROM strokes", conn);
int sid = Convert.ToInt32(sqc.ExecuteScalar());
sid++;
sqc = new SQLiteCommand("INSERT INTO strokes VALUES (" + sid.ToString() + "," + vid.ToString() + "," + id.ToString() + ",'" + Stroke2Int(st).ToString() + "','" + st.quadrant + "'," + sti.ToString() + ")", conn);
sqc.ExecuteNonQuery();
sti++;
}
}
}
conn.Clone();
}
/// <summary>
/// ALTERANDO O REGISTRO
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAlterar_Click(object sender, RoutedEventArgs e)
{
tbID.IsReadOnly = true;
SQLiteConnection conn = new SQLiteConnection(conexao);
if (conn.State == ConnectionState.Closed)
conn.Open();
SQLiteCommand cmd = new SQLiteCommand("UPDATE tb_raps SET NOME = @NOME, RAPCODE = @RAPCODE, RAPNOME = @RAPNOME WHERE ID = @ID", conn);
cmd.Parameters.AddWithValue("ID", tbID.Text.Trim());
cmd.Parameters.AddWithValue("NOME", tbNome.Text.Trim());
cmd.Parameters.AddWithValue("RAPCODE", tbRapCode.Text.Trim());
cmd.Parameters.AddWithValue("RAPNOME", tbRapNome.Text.Trim());
try
{
cmd.ExecuteNonQuery();
MsgBox.Show("Registro Alterado com sucesso!",
"Sucesso", MsgBox.Buttons.OK, MsgBox.Icon.Info, MsgBox.AnimateStyle.SlideDown);
LeituraDados();
}
catch (Exception ex)
{
MessageBox.Show("Erro ao atualizar:\n" + ex.Message);
}
conn.Clone();
}