private void tentarLogin()
{
DataTable query = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT P_LOGIN_ID, P_LOGIN_VERIFIED FROM tbPart_Login WHERE P_LOGIN_EMAIL='{0}' AND P_LOGIN_PASS='******'", txtEmail.Text.Replace("'", "''"), PasswordHasher.hash(txtSenha.Text, "saltGoesHere")));
if (query == null)
{
lblAvisoSenha.Text = "Dificuldades em alcançar o banco de dados. Tente novamente daqui á pouco.";
}
else if (query.Rows.Count != 0)
{
if (query.Rows[0][1].ToString() == "0")
{
lblAvisoSenha.Text = "Sua conta ainda não foi verificada! Verifique sua caixa de entrada para obter o link de verificação";
}
else
{
Session["partSession"] = query.Rows[0][0].ToString();
Response.Redirect("AreaParticipante.aspx");
}
}
else
{
lblAvisoSenha.Text = "Senha ou Email errados!";
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (txtNome.Text == "")
{
MessageBox.Show("O nome do grupo não pode estar vazio!");
return;
}
if (Mode == FormMode.Edit)
{
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT GP_ID FROM tbGrupo WHERE GP_NOME='{0}'", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\")), Program.env).Rows.Count < 1 || txtNome.Text == eqp.Rows[0]["GP_NOME"].ToString())
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbGrupo SET GP_NOME='{0}', GP_FRASE='{1}', GP_COLOR='{2}' WHERE GP_ID={3}", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), txtFrase.Text.Replace("'", "''").Replace(@"\", @"\\"), colorDialog1.Color.R.ToString("X2") + colorDialog1.Color.G.ToString("X2") + colorDialog1.Color.B.ToString("X2"), id), Program.env);
Close();
}
else
{
MessageBox.Show("Este nome ja esta em uso por outro grupo.");
}
}
else
{
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT GP_ID FROM tbGrupo WHERE GP_NOME='{0}'", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\")), Program.env).Rows.Count < 1)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbGrupo SET GP_NOME='{1}', GP_FRASE='{2}', GP_COLOR='{3}' WHERE GP_ID={0}", id, txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), txtFrase.Text.Replace("'", "''").Replace(@"\", @"\\"), colorDialog1.Color.R.ToString("X2") + colorDialog1.Color.G.ToString("X2") + colorDialog1.Color.B.ToString("X2"), id), Program.env);
MessageBox.Show("Grupo adicionado com sucesso!");
Close();
}
else
{
MessageBox.Show("Este nome ja esta em uso por outro grupo.");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable query = new DataTable();
if (Session["email"] != null)
{
query = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT P_LOGIN_VERIFIED FROM tbPart_Login WHERE P_LOGIN_EMAIL='{0}'", Session["email"].ToString()));
}
else
{
Response.Redirect("Login.aspx");
}
if (query == null)
{
Response.Redirect("Login.aspx");
}
else if (query.Rows[0][0].ToString() == "1")
{
Response.Redirect("Login.aspx");
}
else
{
emailSpan.InnerText = Session["email"].ToString();
}
}
protected void BtnCriarGrupo_Click(object sender, EventArgs e)
{
String gpID = "";
String gpLink = "";
bool succ = false;
Random random = new Random();
for (int i = 30; i > 0; i--) //tenta gerar um ID de participante unico 30 vezes, e inserre uma entrada..
{
gpID = random.Next().ToString();
gpLink = Path.GetRandomFileName().Replace(".", "") + Path.GetRandomFileName().Replace(".", "").Remove(4);
string queryPart = "";
if (TxtNomeGrupo.Text != "" || TxtNomeGrupo.Text != null)
{
queryPart = String.Format("INSERT INTO tbGrupo(GP_ID, GP_NOME, GP_FRASE, GP_COLOR) VALUES({0}, '{1}', '{2}', '{3}')", gpID, TxtNomeGrupo.Text.Replace("'", "''"), TxtFraseGrupo.Text.Replace("'", "''"), cor);
}
if (QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", queryPart) != null)
{
succ = true; break;
}
}
if (!succ)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Campos preenchidos com valores já usados ou incorretos!');", true);
return;
}
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("INSERT INTO tbGrupo_Link (GP_ID, GP_LINK) VALUES ({0}, '{1}')", gpID, gpLink));
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("UPDATE tbParticipante SET P_GP_ID = {0} WHERE P_ID IN (SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {1})", gpID, Session["partSession"]));
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("INSERT INTO tbGrupoAdmin (GP_ID) VALUES (SELECT P_GP_ID FROM tbParticipante WHERE P_ID IN (SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {0}))", Session["partSession"]));
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("UPDATE tbGrupoAdmin SET P_ID = (SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {0})", Session["partLogin"]));
Response.Redirect("AreaParticipante.aspx");
}
protected void BtnEntratNoGrupo_Click(object sender, EventArgs e)
{
userData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT GP_LINK FROM tbGrupo_Link WHERE GP_LINK='{0}'", TxtLinkGrupo.Text));
if (userData.Rows.Count > 0)
{
userData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("UPDATE tbParticpante SET P_GP_ID = (SELECT GP_ID FROM tbGrupo_Link WHERE GP_LINK = '{0}') WHERE P_ID IN (SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {1})", TxtLinkGrupo.Text, (int)Session["partSession"]));
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Tem certeza que quer deletar este grupo? Quaisquer integrantes que estejam nele ficarão sem grupo.", "Aviso", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbGrupoAdmin WHERE GP_ID = {0}", id), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbParticipante SET P_GP_ID=NULL WHERE P_GP_ID = {0}", id), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbGrupo WHERE GP_ID = {0}", id), Program.env);
Close();
}
}
public frmAddTopico(string id)
{
InitializeComponent();
btnCancel.borderRadius = 15;
btnSave.borderRadius = 15;
btnDelete.borderRadius = 15;
Mode = FormMode.Edit;
top = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbTopico WHERE T_ID={0}", id), Program.env);
txtNome.Text = top.Rows[0]["T_NOME"].ToString();
this.id = id;
}
protected void BtnExcluirGrupo_Click(object sender, EventArgs e)
{
if (!DBNull.Value.Equals(userData.Rows[0]["P_GP_ID"]))
{
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("DELETE FROM tbGrupo_Link WHERE GP_ID = {0}", userData.Rows[0]["P_GP_ID"]));
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("DELETE FROM tbGrupoAdmin WHERE GP_ID = {0}", userData.Rows[0]["P_GP_ID"]));
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("UPDATE tbParticipante SET P_GP_ID=NULL WHERE P_GP_ID = {0}", userData.Rows[0]["P_GP_ID"]));
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("DELETE FROM tbGrupo WHERE GP_ID = {0}", userData.Rows[0]["P_GP_ID"]));
Response.Redirect("AreaParticipante.aspx");
}
}
public frmAddDificuldade(string id)
{
this.id = id;
InitializeComponent();
btnCancel.borderRadius = 10;
btnDelete.borderRadius = 10;
btnSave.borderRadius = 10;
Mode = FormMode.Edit;
dif = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"SELECT * FROM tbDificuldade WHERE DIF_ID={id}", Program.env);
txtNome.Text = dif.Rows[0]["DIF_NOME"].ToString();
nudVal.Value = Int32.Parse(dif.Rows[0]["DIF_VAL"].ToString());
}
private void BtnDelete_Click(object sender, EventArgs e)
{
var confirmResult = MessageBox.Show("Tem certeza que quer deletar este participante? Esta ação não pode ser desfeita.",
"Confirmar Ação",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbPart_Login WHERE P_ID={0}", id), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbParticipante WHERE P_ID={0}", id), Program.env);
Close();
}
}
private void BtnCancel_Click(object sender, EventArgs e)
{
if (Mode == FormMode.Edit)
{
this.Close();
}
else
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"UPDATE tbParticipante SET P_GP_ID=NULL WHERE P_GP_ID={id}", Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"DELETE FROM tbGrupo WHERE GP_ID={id}", Program.env);
Close();
}
}
protected void BtnRedefinirSenha_Click(object sender, EventArgs e)
{
userData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT P_LOGIN_EMAIL FROM tbToken_Senha WHERE P_TOKEN = '{0}'", Request.Params["token"].ToString()));
if (userData.Rows.Count > 0)
{
if (txtSenha.Text == txtConfirmar.Text)
{
userData2 = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("UPDATE tbPart_Login SET P_LOGIN_PASS = '******' WHERE P_ID IN (SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_EMAIL = (SELECT P_LOGIN_EMAIL FROM tbToken_Senha WHERE P_TOKEN = '{1}'))", PasswordHasher.hash(txtSenha.Text, "saltGoesHere"), Request.Params["token"].ToString()));
userData3 = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("DELETE FROM tbToken_Senha WHERE P_TOKEN = '{0}'", Request.Params["token"]));
Response.Redirect("Login.aspx");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Mode == FormMode.Edit)
{
if ((QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT DIF_ID FROM tbDificuldade WHERE DIF_NOME='{0}' AND NOT DIF_ID={2} OR DIF_VAL={1} AND NOT DIF_ID={2}", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), nudVal.Value, id), Program.env).Rows.Count < 1 || (txtNome.Text.Replace("'", "''").Replace(@"\", @"\\") == dif.Rows[0]["DIF_NOME"].ToString() && nudVal.Value == int.Parse(dif.Rows[0]["DIF_VAL"].ToString()))) && txtNome.Text != "")
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbDificuldade SET DIF_NOME='{0}', DIF_VAL={1} WHERE DIF_ID={2}", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), nudVal.Value, id), Program.env);
Close();
}
else
{
if (txtNome.Text == "")
{
MessageBox.Show("O nome da dificuldade não pode ser vazio!");
}
else
{
MessageBox.Show("Já há uma dificuldade com este nome/intensidade!");
}
}
}
else
{
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT DIF_ID FROM tbDificuldade WHERE DIF_NOME='{0}' OR DIF_VAL={1}", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), nudVal.Value), Program.env).Rows.Count < 1 && txtNome.Text != "")
{
Random random = new Random();
for (int i = 30; i > 0; i--) //tenta gerar um ID de participante unico 30 vezes, e inserre uma entrada..
{
id = random.Next().ToString();
string queryPart = "";
queryPart = String.Format("INSERT INTO tbDificuldade(DIF_ID, DIF_NOME, DIF_VAL) VALUES({0},'{1}', {2})", id, txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), nudVal.Value);
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", queryPart, Program.env) != null)
{
MessageBox.Show("Dificuldaade adicionada com sucesso!(e muito carinho!)"); Close(); break;
}
}
}
else
{
if (txtNome.Text == "")
{
MessageBox.Show("O nome da dificuldade não pode ser vazio!");
}
else
{
MessageBox.Show("Já há uma dificuldade com este nome/intensidade!");
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Mode == FormMode.Edit)
{
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT T_ID FROM tbTopico WHERE T_NOME='{0}'", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\")), Program.env).Rows.Count < 1 || txtNome.Text.Replace("'", "''").Replace(@"\", @"\\") == top.Rows[0]["T_NOME"].ToString() && txtNome.Text != "")
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbTopico SET T_NOME='{0}' WHERE T_ID={1}", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"), id), Program.env);
Close();
}
else
{
if (txtNome.Text == "")
{
MessageBox.Show("O nome da matéria não pode ser vazio!");
}
else
{
MessageBox.Show("Já há uma matéria com este nome!");
}
}
}
else
{
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT T_ID FROM tbTopico WHERE T_NOME='{0}'", txtNome.Text.Replace("'", "''").Replace(@"\", @"\\")), Program.env).Rows.Count < 1 && txtNome.Text != "")
{
Random random = new Random();
for (int i = 30; i > 0; i--) //tenta gerar um ID de participante unico 30 vezes, e inserre uma entrada..
{
id = random.Next().ToString();
string queryPart = "";
queryPart = String.Format("INSERT INTO tbTopico(T_ID, T_NOME) VALUES({0},'{1}')", id, txtNome.Text.Replace("'", "''").Replace(@"\", @"\\"));
if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", queryPart, Program.env) != null)
{
MessageBox.Show("Tópico adicionado com sucesso!(e muito carinho!)"); Close(); break;
}
}
}
else
{
if (txtNome.Text == "")
{
MessageBox.Show("O nome da matéria não pode ser vazio!");
}
else
{
MessageBox.Show("Já há uma matéria com este nome!");
}
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int quests = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT Q_ID FROM tbQuestao WHERE Q_TOPICO_ID={0}", id), Program.env).Rows.Count;
var confirmResult = MessageBox.Show($"Tem certeza que quer deletar este tópico? As {quests} questões que usam ele serão deletadas do Quiz permanentemente!",
"Confirmar Ação",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELTE FROM tbQuestao WHERE Q_TOPICO_ID={0}", id), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbTopico WHERE T_ID={0}", id), Program.env);
Close();
}
}
public void UpdateTable()
{
tableLayoutPanel1.SuspendLayout();
try
{
top = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", "SELECT * FROM tbTopico", Program.env);
tableLayoutPanel1.Controls.Clear();
tableLayoutPanel1.Controls.Add(lb1);
tableLayoutPanel1.Controls.Add(lb2);
if (top.Rows.Count == 0)
{
Label label1 = new Label();
label1.Font = lb1.Font;
label1.Dock = DockStyle.Fill;
label1.ForeColor = Color.Black;
label1.Text = "Ainda não há nenhuma matéria! Clique em 'Adicionar Matéria' para criar uma nova.";
tableLayoutPanel1.Controls.Add(label1, 0, 1);
}
else
{
for (int i = 0; i < top.Rows.Count; i++)
{
Label label1 = new Label();
Label label2 = new Label();
label1.Text = top.Rows[i]["T_NOME"].ToString();
label1.Font = lb1.Font;
label1.ForeColor = Color.Black;
label1.Dock = DockStyle.Fill;
label1.Click += (sender, e) => { OpenAddTopico_EditMode(sender, e); };
label2.Text = top.Rows[i]["T_ID"].ToString();
label2.Font = lb1.Font;
label2.ForeColor = Color.Black;
label2.Dock = DockStyle.Fill;
label2.Click += (sender, e) => { OpenAddTopico_EditMode(sender, e); };
label1.Name = top.Rows[i]["T_ID"].ToString();
label2.Name = top.Rows[i]["T_ID"].ToString();
tableLayoutPanel1.Controls.Add(label1, 0, i + 1);
tableLayoutPanel1.Controls.Add(label2, 1, i + 1);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
tableLayoutPanel1.ResumeLayout();
}
}
public void UpdateTable()
{
tableLayoutPanel1.SuspendLayout();
try
{
parts = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbParticipante WHERE P_GP_ID={0}", id), Program.env);
tableLayoutPanel1.Controls.Clear();
tableLayoutPanel1.Controls.Add(lb1);
tableLayoutPanel1.Controls.Add(lb2);
if (parts.Rows.Count == 0)
{
Label label1 = new Label();
label1.Font = label11.Font;
label1.Dock = DockStyle.Fill;
label1.Text = "Ainda não há nenhum participante! Clique em 'Adicionar Participante' para criar um novo.";
tableLayoutPanel1.Controls.Add(label1, 0, 1);
}
else
{
for (int i = 0; i < parts.Rows.Count; i++)
{
Label label1 = new Label();
Label label2 = new Label();
label1.Text = parts.Rows[i]["P_NOME"].ToString();
label1.Font = label11.Font;
label1.Dock = DockStyle.Fill;
label1.Click += (sender, e) => { RemoveIntegrante(sender, e); };
label2.Text = parts.Rows[i]["P_RM"].ToString();
label2.Font = label11.Font;
label2.Dock = DockStyle.Fill;
label2.Click += (sender, e) => { RemoveIntegrante(sender, e); };
label1.Name = parts.Rows[i]["P_ID"].ToString();
label2.Name = parts.Rows[i]["P_ID"].ToString();
tableLayoutPanel1.Controls.Add(label1, 0, i + 1);
tableLayoutPanel1.Controls.Add(label2, 1, i + 1);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
tableLayoutPanel1.ResumeLayout();
}
}
public frmAddGroup(string id)
{
InitializeComponent();
btnCancel.borderRadius = 10;
btnDelete.borderRadius = 10;
btnSave.borderRadius = 10;
button1.borderRadius = 15;
Mode = FormMode.Edit;
this.id = id;
lb1 = tableLayoutPanel1.Controls[0] as Label;
lb2 = tableLayoutPanel1.Controls[1] as Label;
UpdateTable();
eqp = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbGrupo WHERE GP_ID={0}", id), Program.env);
txtNome.Text = eqp.Rows[0]["GP_NOME"].ToString();
txtFrase.Text = eqp.Rows[0]["GP_FRASE"].ToString();
colorDialog1.Color = System.Drawing.ColorTranslator.FromHtml("#" + eqp.Rows[0]["GP_COLOR"].ToString());
panel1.BackColor = System.Drawing.ColorTranslator.FromHtml("#" + eqp.Rows[0]["GP_COLOR"].ToString());
}
private void AtualizarTabela()
{
if (comboBoxTipo.SelectedIndex == 0)
{
string queryPart = $"UPDATE tbQuestao SET DIF_ID = {dif.Rows[comboBoxDif.SelectedIndex]["DIF_ID"]}, Q_TOPICO_ID = {top.Rows[comboBoxTop.SelectedIndex]["T_ID"]}, Q_TEXTO='{txtCorpo.Text.Replace("'", "''")}', Q_TITULO='{txtTitulo.Text.Replace("'", "''")}',Q_DICA='{txtDica.Text.Replace("'", "''")}' ,Q_ISALTERNATIVE=0,Q_ENABLED={(checkBox1.Checked == true ? "1" : "0")} WHERE Q_ID={id}";
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", queryPart, Program.env);
}
else
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"DELETE FROM tbAlternativas WHERE ALT_Q_ID={id}", Program.env);
foreach (DataRow r in alt.Rows)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"INSERT INTO tbAlternativas(ALT_Q_ID, ALT_TEXTO, ALT_CERTA) VALUES({id}, '{r["ALT_TEXTO"].ToString().Replace("'","''")}', '{r["ALT_CERTA"].ToString()}')", Program.env);
}
string queryPart = $"UPDATE tbQuestao SET DIF_ID = {dif.Rows[comboBoxDif.SelectedIndex]["DIF_ID"]}, Q_TOPICO_ID = {top.Rows[comboBoxTop.SelectedIndex]["T_ID"]}, Q_TEXTO='{txtCorpo.Text.Replace("'", "''")}', Q_TITULO='{txtTitulo.Text.Replace("'", "''")}',Q_DICA='{txtDica.Text.Replace("'", "''")}' , Q_ISALTERNATIVE=1 ,Q_ENABLED={(checkBox1.Checked == true ? "1" : "0")} WHERE Q_ID={id}";
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", queryPart, Program.env);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int quests = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT Q_ID FROM tbQuestao WHERE Q_TOPICO_ID={0}", id), Program.env).Rows.Count;
var confirmResult = MessageBox.Show($"Tem certeza que quer deletar esta pergunta? As {quests} questões que usam ele serão deletadas do Quiz permanentemente!",
"Confirmar Ação",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbAlternativas WHERE ALT_Q_ID={0}", id), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbQuestao WHERE Q_ID={0}", id), Program.env);
if (!DBNull.Value.Equals(qst.Rows[0]["Q_IMG_ID"]))
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbImagem WHERE IMG_ID={0}", qst.Rows[0]["Q_IMG_ID"]), Program.env);
}
Close();
}
}
public frmAddPergunta()
{
InitializeComponent();
for (int i = 0; i < Controls.Count; i++)
{
if (Controls[i] is RoundedButton)
{
(Controls[i] as RoundedButton).borderRadius = 15;
}
}
top = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbTopico", id), Program.env);
dif = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbDificuldade", id), Program.env);
btnDelete.Visible = false;
Mode = FormMode.Add;
alt = new DataTable();
alt.Columns.Add("ALT_ID");
alt.Columns.Add("ALT_TEXTO");
alt.Columns.Add("ALT_CERTA");
}
public frmAddPart(string id)
{
InitializeComponent();
Mode = FormMode.Edit;
this.id = id;
part = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbParticipante WHERE P_ID={0}", id), Program.env);
eqp = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", "SELECT GP_ID, GP_NOME FROM tbGrupo", Program.env);
txtNome.Text = part.Rows[0]["P_NOME"].ToString();
txtRm.Text = part.Rows[0]["P_RM"].ToString();
comboBox1.Items.Add("(SEM GRUPO)");
foreach (DataRow r in eqp.Rows)
{
comboBox1.Items.Add(r["GP_NOME"]);
}
if (!DBNull.Value.Equals(part.Rows[0]["P_GP_ID"]))
{
comboBox1.SelectedIndex = comboBox1.FindStringExact(eqp.Select(String.Format("GP_ID={0}", part.Rows[0]["P_GP_ID"].ToString()))[0]["GP_NOME"].ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["token"] == null)
{
Response.Redirect("Login.aspx");
}
string token = Request.Params["token"].ToString().Replace("'", "''");
DataTable query = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT P_LOGIN_ID FROM tbPart_Login_Verify WHERE P_LOGIN_VERIFY_URL='{0}'", token));
if (query != null)
{
if (query.Rows.Count != 0)
{
QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("UPDATE tbPart_Login SET P_LOGIN_VERIFIED=1 WHERE P_LOGIN_ID='{0}'", query.Rows[0]["P_LOGIN_ID"]));
Session["email"] = null;
return;
}
}
Response.Redirect("Login.aspx");
}
private void RemoveIntegrante(object sender, EventArgs e)
{
if (MessageBox.Show("Tem certeza que quer remover este participante?", "Aviso", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var pId = (sender as Label).Name;
if (parts.Rows.Count == 1)
{
if (MessageBox.Show("Remover o participante deletará o grupo , pois não haverá nenhum participante no grupo. Deseja realmente remover o participante do grupo?", "Aviso", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbParticipante SET P_GP_ID=NULL WHERE P_ID={0}", pId), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbGrupoAdmin WHERE GP_ID={0}", id), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("DELETE FROM tbGrupo WHERE GP_ID={0}", id), Program.env);
Close();
}
else
{
return;
}
}
else if (QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT P_ID FROM tbGrupoAdmin WHERE GP_ID={0} AND P_ID={1}", id, pId), Program.env).Rows.Count == 1)
{
if (MessageBox.Show("Esse participante é administrador de seu grupo. Remove-lo do grupo irá transferir o cargo para outro integrante. Deseja continuar?", "Aviso", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbParticipante SET P_GP_ID=NULL WHERE P_ID={0}", pId), Program.env);
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbGrupoAdmin SET P_ID='{1}' WHERE GP_ID={0}", id, QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT TOP 1 P_ID FROM tbParticipante WHERE P_GP_ID={0}", id), Program.env).Rows[0][0].ToString()), Program.env);
UpdateTable();
}
else
{
return;
}
}
else
{
QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("UPDATE tbParticipante SET P_GP_ID=NULL WHERE P_ID={0}", pId), Program.env);
UpdateTable();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if ((string)Session["partSession"] == "" || Session["partSession"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
adminData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT P_ID FROM tbGrupoAdmin WHERE P_ID IN (SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {0})", Session["partSession"]));
if (adminData.Rows.Count > 0)
{
BtnGerenciarGrupo.Visible = false;
}
userData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT * FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {0}", Session["partSession"]));
lblNomeBemVindo.Text = userData.Rows[0]["P_NOME"].ToString();
lblNomePart.Text = userData.Rows[0]["P_NOME"].ToString();
lblEmailPart.Text = userData.Rows[0]["P_LOGIN_EMAIL"].ToString();
lblRmPart.Text = userData.Rows[0]["P_RM"].ToString();
if (!userData.Rows[0]["P_GP_ID"].Equals(DBNull.Value))
{
groupData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format($"SELECT * FROM tbGrupo WHERE GP_ID={userData.Rows[0]["P_GP_ID"]}"));
groupIntegrants = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", $"SELECT * FROM tbParticipante WHERE P_GP_ID={userData.Rows[0]["P_GP_ID"]}");
gpLink = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format($"SELECT * FROM tbGrupo_Link WHERE GP_ID={userData.Rows[0]["P_GP_ID"]}"));
bGpLink.InnerText = $"Link do grupo: {gpLink.Rows[0]["GP_LINK"]}";
TxtNomeGrupo.Text = groupData.Rows[0]["GP_NOME"].ToString();
TxtFraseGrupo.Text = groupData.Rows[0]["GP_FRASE"].ToString();
BtnCriarGrupo.Visible = false;
TxtLinkGrupo.Visible = false;
divEntreGrupo.Visible = false;
BtnEntrarNoGrupo.Visible = false;
}
else
{
BtnGerenciarGrupo.Visible = false;
BtnExcluirGrupo.Visible = false;
}
}
}
public frmAddPart()
{
InitializeComponent();
Mode = FormMode.Add;
eqp = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", "SELECT GP_ID, GP_NOME FROM tbGrupo", Program.env);
if (eqp.Rows.Count != 0)
{
comboBox1.Items.Add("(SEM GRUPO)");
foreach (DataRow r in eqp.Rows)
{
comboBox1.Items.Add(r["GP_NOME"]);
}
}
else
{
comboBox1.DropDownStyle = ComboBoxStyle.Simple;
comboBox1.Text = "[NENHUMA EQUIPE EXISTE]";
comboBox1.Enabled = false;
}
btnDelete.Visible = false;
}
public frmAddPergunta(string id)
{
InitializeComponent();
for (int i = 0; i < Controls.Count; i++)
{
if (Controls[i] is RoundedButton)
{
(Controls[i] as RoundedButton).borderRadius = 15;
}
}
Mode = FormMode.Edit;
this.id = id;
qst = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbQuestao WHERE Q_ID={0}", id), Program.env);
txtTitulo.Text = qst.Rows[0]["Q_TITULO"].ToString();
txtCorpo.Text = qst.Rows[0]["Q_TEXTO"].ToString();
txtDica.Text = qst.Rows[0]["Q_DICA"].ToString();
checkBox1.Checked = qst.Rows[0]["Q_ENABLED"].ToString() == "True";
top = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbTopico", id), Program.env);
dif = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbDificuldade", id), Program.env);
if (qst.Rows[0]["Q_ISALTERNATIVE"].ToString() == "True")
{
alt = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbAlternativas WHERE ALT_Q_ID={0}", id), Program.env);
comboBoxTipo.SelectedIndex = 1;
}
else
{
alt = new DataTable();
alt.Columns.Add("ALT_ID");
alt.Columns.Add("ALT_TEXTO");
alt.Columns.Add("ALT_CERTA");
comboBoxTipo.SelectedIndex = 0;
}
if (!DBNull.Value.Equals(qst.Rows[0]["Q_IMG_ID"]))
{
Directory.CreateDirectory("temp");
img = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", String.Format("SELECT * FROM tbImagem WHERE IMG_ID={0}", qst.Rows[0]["Q_IMG_ID"]), Program.env);
File.WriteAllBytes($"temp\\{img.Rows[0]["IMG_FILENAME"]}", (byte[])img.Rows[0]["IMG_DATA"]);
pictureBox1.ImageLocation = $"temp\\{img.Rows[0]["IMG_FILENAME"]}";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["partSession"] == null || (string)Session["partSession"] == "")
{
Response.Redirect("Login.aspx");
}
userData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT * FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_ID = {0}", Session["partSession"]));
groupIntegrants = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", $"SELECT * FROM tbParticipante WHERE P_GP_ID={userData.Rows[0]["P_GP_ID"]}");
i1.Visible = false;
i2.Visible = false;
i3.Visible = false;
i4.Visible = false;
i5.Visible = false;
try
{
TxtPartRM1.Text = groupIntegrants.Rows[0]["P_RM"].ToString();
TxtNome1.Text = groupIntegrants.Rows[0]["P_NOME"].ToString();
i1.Visible = true;
TxtPartRM2.Text = groupIntegrants.Rows[1]["P_RM"].ToString();
TxtNome2.Text = groupIntegrants.Rows[1]["P_NOME"].ToString();
i2.Visible = true;
TxtPartRM3.Text = groupIntegrants.Rows[2]["P_RM"].ToString();
TxtNome3.Text = groupIntegrants.Rows[2]["P_NOME"].ToString();
i3.Visible = true;
TxtPartRM4.Text = groupIntegrants.Rows[3]["P_RM"].ToString();
TxtNome4.Text = groupIntegrants.Rows[3]["P_NOME"].ToString();
i4.Visible = true;
TxtPartRM5.Text = groupIntegrants.Rows[4]["P_RM"].ToString();
TxtNome5.Text = groupIntegrants.Rows[4]["P_NOME"].ToString();
i5.Visible = true;
}
catch
{
}
}
public frmQuizConfig()
{
InitializeComponent();
btnJogar.borderRadius = 30;
button1.borderRadius = 15;
dif = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"SELECT * FROM tbDificuldade", Program.env);
mat = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"SELECT * FROM tbTopico", Program.env);
parts = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"SELECT * FROM tbParticipante", Program.env);
eqp = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"SELECT * FROM tbGrupo", Program.env);
pergs = QuizDBConnect.Query(Program.user, Program.pass, "dbQuiz2019", $"SELECT * FROM tbQuestao", Program.env);
dif.Columns.Add("ENABLED");
DataColumn num = new DataColumn();
num.DefaultValue = 0;
num.ColumnName = "NUM_Q";
dif.Columns.Add(num);
mat.Columns.Add("ENABLED");
eqp.Columns.Add("ENABLED");
}
protected void btnEsqueceuSenha_Click(object sender, EventArgs e)
{
userData = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("SELECT tP.P_ID FROM tbParticipante AS tP JOIN tbPart_Login AS tPL ON tP.P_ID = tPL.P_ID WHERE P_LOGIN_EMAIL = '{0}'", txtEmailEsq.Text));
if (userData.Rows.Count > 0)
{
string token = "";
for (int i = 30; i > 0; i--) //tenta gerar um ID de token unico 30 vezes, e insere uma entrada.
{
token = Path.GetRandomFileName().Replace(".", "") + Path.GetRandomFileName().Replace(".", "").Remove(4);
userData2 = QuizDBConnect.Query("sa", "etesp", "dbQuiz2019", String.Format("INSERT INTO tbToken_Senha (P_TOKEN, P_LOGIN_EMAIL) VALUES ('{0}', '{1}')", token, txtEmailEsq.Text));
if (userData2 != null)
{
break;
}
}
string htmlString = string.Format("<h1>Clique neste link para redefinir a senha da sua conta com o email {0}:</h1><br/><a href='http://siteDoQuiz.tk/RedefinirSenha.aspx?token={1}'>Redefinir Senha</a><br />Esta é uma mensagem automática. Não responda.", txtEmailEsq.Text, token);
MailMessage message = new MailMessage();
SmtpClient smtp = new SmtpClient();
message.From = new MailAddress("*****@*****.**");
message.To.Add(new MailAddress(txtEmailEsq.Text));
message.Subject = "Verifique sua conta de participante do Etesp Quiz";
message.IsBodyHtml = true;
message.Body = htmlString;
smtp.Port = 587;
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "b7fa4df2c0ba5fc40017de3990f09fe3e1fd60ef");
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Send(message);
}
Response.Redirect("EsqueceuSenha.aspx");
}
