private void but_enter_Click(object sender, EventArgs e) { bool logedIn = false; for (int i = 0; i < int.Parse(ds_shop.Tables["LOGINS"].Rows.Count.ToString()); i++) { if ((tb_login.Text == ds_shop.Tables["LOGINS"].Rows[i]["login"].ToString()) && (hashCode(tb_password.Text).ToString() == ds_shop.Tables["LOGINS"].Rows[i]["pasword"].ToString())) { Assistance AsistForm = new Assistance(this, shopDB, logins[i]); AsistForm.Show(); this.Hide(); logedIn = true; } } if (!logedIn) { MessageBox.Show("Неверно введен логин или пароль", "Авторизация", MessageBoxButtons.OK); } tb_password.Text = ""; }
public Extra(Assistance form_assist, OracleConnection shopDB) { InitializeComponent(); form_assist_ = form_assist; shopDB_ = shopDB; }
public Table(Assistance form_asist, Extra form_extra, int whatOption, string tableName, OracleConnection shopDB) { InitializeComponent(); form_assist_ = form_asist; tableName_ = tableName; whatOption_ = whatOption; shopDB_ = shopDB; form_extra_ = form_extra; switch (whatOption) { case 0: try { da = new OracleDataAdapter("SELECT * FROM " + tableName_, shopDB); DataTable table = new DataTable(tableName_); Text = tableName_; ds_shop.Tables.Add(table); dg_table.DataSource = ds_shop.Tables[tableName_]; da.Fill(ds_shop, tableName_); Show(); } catch (Exception) { MessageBox.Show("У вас нет доступа к этой таблице.", "Таблица", MessageBoxButtons.OK); if (tableName_ == "Warehouses") { form_assist_.war_opened = false; } else if (tableName_ == "Sales") { form_assist_.sales_opened = false; } else if (tableName_ == "Charges") { form_assist_.charges_opened = false; } else { form_assist_.exp_opened = false; } Close(); } break; case 1: try { da = new OracleDataAdapter("SELECT * FROM HELP", shopDB); DataTable table = new DataTable("HELP"); Text = "Middle count"; ds_shop.Tables.Add(table); dg_table.DataSource = ds_shop.Tables["HELP"]; da.Fill(ds_shop, "HELP"); Show(); } catch (Exception) { MessageBox.Show("Запрос не был выполнен.", "Таблица", MessageBoxButtons.OK); string strSQL = "DROP TABLE HELP"; OracleCommand cmdIC = shopDB_.CreateCommand(); cmdIC.CommandType = CommandType.Text; cmdIC.CommandText = strSQL; try { cmdIC.ExecuteNonQuery(); } catch (OracleException exc) { MessageBox.Show(exc.ToString()); } form_extra_.Enabled = true; Close(); } break; } }