private void label7_Click(object sender, EventArgs e) { this.Hide(); AvtoMesh avto = new AvtoMesh(); avto.Show(); avto.id.Text = id; avto.admin = ad; avto.Valutka.Text = valll; }
private void label5_Click(object sender, EventArgs e) { DataGridViewRow row = dataGridView1.CurrentRow; DB db = new DB(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("UPDATE `zapic` set `idAv`=@namz, `nameAv`=@vidwork, `idAvu`=@adVu, `Status`=@stat WHERE `id`=@id", db.GetConnection()); command.Parameters.Add("@id", MySqlDbType.VarChar).Value = row.Cells[0].Value.ToString(); command.Parameters.Add("@namz", MySqlDbType.VarChar).Value = id; command.Parameters.Add("@vidwork", MySqlDbType.VarChar).Value = nameAv; command.Parameters.Add("@adVu", MySqlDbType.VarChar).Value = id; command.Parameters.Add("@stat", MySqlDbType.VarChar).Value = 2; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Заказ взят"); this.Hide(); AvtoMesh avto = new AvtoMesh(); avto.Show(); avto.id.Text = id; avto.nameAv = nameAv; avto.admin = ad; avto.Valutka.Text = valll; } else { MessageBox.Show("Ошибка"); } db.closeConnection(); }
private void label7_Click(object sender, EventArgs e) { if (ad == "0") { this.Hide(); Menu mainMenu = new Menu(); mainMenu.Show(); mainMenu.id.Text = id1; mainMenu.admin = ad; mainMenu.Valutka.Text = valll; } else if (ad == "1") { this.Hide(); AdminPanel adminPanel = new AdminPanel(); adminPanel.Show(); adminPanel.id.Text = id1; adminPanel.admin = ad; adminPanel.Valutka.Text = valll; } else if (ad == "2") { this.Hide(); AvtoMesh avto = new AvtoMesh(); avto.Show(); avto.id.Text = id1; avto.admin = ad; avto.nameAv = nameAv; avto.Valutka.Text = valll; } else { MessageBox.Show("Вы даун"); } }
private void bLogin_Click(object sender, EventArgs e) { DB db = new DB(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("UPDATE `users` set `Valutka`=`Valutka`+@namz WHERE `id`=@id", db.GetConnection()); command.Parameters.Add("@id", MySqlDbType.VarChar).Value = id; command.Parameters.Add("@namz", MySqlDbType.VarChar).Value = balnc.Text; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Баланс успешно пополнен"); } else { MessageBox.Show("Ошибка"); } db.closeConnection(); DB dbb = new DB(); DataTable ttable = new DataTable(); MySqlDataAdapter aadapter = new MySqlDataAdapter(); MySqlCommand ccommand = new MySqlCommand("SELECT * FROM `users` WHERE `id`=@id", dbb.GetConnection()); ccommand.Parameters.Add("@id", MySqlDbType.VarChar).Value = id; aadapter.SelectCommand = ccommand; aadapter.Fill(ttable); valll = ttable.Rows[0][7].ToString(); dbb.openConnection(); if (ad == "1") { this.Hide(); AdminPanel adminPanel = new AdminPanel(); adminPanel.Show(); adminPanel.id.Text = id; adminPanel.admin = ad; adminPanel.Valutka.Text = valll; } if (ad == "2") { this.Hide(); AvtoMesh avtoMesh = new AvtoMesh(); avtoMesh.id.Text = id; avtoMesh.admin = ad; avtoMesh.Valutka.Text = valll; } if (ad == "0") { this.Hide(); Menu mainMenu = new Menu(); mainMenu.Show(); mainMenu.id.Text = id; mainMenu.admin = ad; mainMenu.Valutka.Text = valll; } dbb.closeConnection(); }
public void bLogin_Click(object sender, EventArgs e) { String loginUser = loginField.Text; String passUser = passField.Text; DB db = new DB(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `login`=@uL AND `pass`=@uP AND `Admin` != 'NULL'", db.GetConnection()); command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = loginUser; command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = passUser; adapter.SelectCommand = command; adapter.Fill(table); if (table.Rows.Count == 0 ) { MessageBox.Show("Такого аккаунта не существует"); return; } admin = table.Rows[0][6].ToString(); if (table.Rows.Count > 0 && admin == "0") { this.Hide(); Menu mainForm = new Menu(); mainForm.Show(); mainForm.id.Text = table.Rows[0][0].ToString(); mainForm.admin = table.Rows[0][6].ToString(); mainForm.Valutka.Text = table.Rows[0][7].ToString(); } else if (table.Rows.Count > 0 && admin == "1") { this.Hide(); AdminPanel adminchik = new AdminPanel(); adminchik.Show(); adminchik.id.Text = table.Rows[0][0].ToString(); adminchik.admin = table.Rows[0][6].ToString(); adminchik.Valutka.Text = table.Rows[0][7].ToString(); } else if (table.Rows.Count > 0 && admin == "2") { this.Hide(); AvtoMesh adminc = new AvtoMesh(); adminc.Show(); adminc.id.Text = table.Rows[0][0].ToString(); adminc.admin = table.Rows[0][6].ToString(); adminc.nameAv = table.Rows[0][3].ToString(); adminc.Valutka.Text = table.Rows[0][7].ToString(); } else { MessageBox.Show("No"); } }