private void frmLogin_Load(object sender, EventArgs e)
{
// soruları kouşullara gore guncelledik
MySQLQuerryExecuter mys = new MySQLQuerryExecuter();
string sorgu = "CALL CALC_QUESTABLE_QUESTIONS()";
mys.execute(sorgu);
btnUserLogin.Visible = false;
btnNewUser.Visible = false;
lblKontrol.Visible = false;
loginBind db = new loginBind();
List <string> users = new List <string>();
users = db.bindUsers();
foreach (string item in users)
{
if (item == "Admin")
{
continue;
}
cmbUsers.Items.Add(item);
}
}
private void btnEditWord_Click(object sender, EventArgs e)
{
MySQLQuerryExecuter MyS = new MySQLQuerryExecuter();
if (toggleSilGuncelle.Checked == true)
{
DialogResult dr = MetroMessageBox.Show(this, "\n\n" + SecilenKelime + " Silinecek onaylıyor musunuz?", "Kelime Silme Onayı", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dr == DialogResult.Yes)
{
string querryString = "CALL DELETE_WORD_BY_CATEGORY(" + (cmbCategories.SelectedIndex + 1).ToString() + ",'" + SecilenKelime + "')";
MyS.execute(querryString);
MetroMessageBox.Show(this, "Silindi..!");
this.Height = 337;
this.Width = 257;
}
else
{
}
}
else
{
DialogResult dr = MetroMessageBox.Show(this, "\n\n" + SecilenKelime + " Güncellenecek onaylıyor musunuz?", "Kelime Güncelleme Onayı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
string querryString = "CALL UPDATE_WORD_BY_CATEGORY('" + txtNewWord.Text + "'," + (cmbEditCategories.SelectedIndex + 1).ToString() + ",'" + txtNewToTurkish.Text + "','" + txtExmSentence.Text + "','" + txtNewDataPath.Text + "'," + (cmbCategories.SelectedIndex + 1).ToString() + ",'" + SecilenKelime + "')";
MyS.execute(querryString);
MetroMessageBox.Show(this, "Güncelleme Yapıldı..!");
this.Height = 357;
this.Width = 257;
}
}
}
private void btnNewUser_Click(object sender, EventArgs e)
{
MySQLQuerryExecuter MyS = new MySQLQuerryExecuter();
string MySQuerry = "CALL ADD_NEW_USER('" + txtNewUser.Text + "')";
MyS.execute(MySQuerry);
getUserID getID = new getUserID();
this.Hide();
frmUser frmNew = new frmUser(getID.Data(txtNewUser.Text), txtNewUser.Text);
frmNew.ShowDialog();
this.Close();
}