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;
}
}
