private void rmBt_Click(object sender, EventArgs e)
{
SQLiteConnection sql_con = new SQLiteConnection(@"Data Source=D:\4семестр\прПР\PaymentSystem\systemDb.db; Version=3;");
sql_con.Open();
DataTable dTable = new DataTable();
string sqlQuery;
string FIO = fioTB.Text;
string id = "0";
sqlQuery = string.Format("SELECT * FROM Records WHERE FIO=\"{0}\";", FIO);
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlQuery, sql_con);
adapter.Fill(dTable);
if (dTable.Rows.Count > 0)
{
id = dTable.Rows[0][0].ToString();
}
else
{
return;
}
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = "DELETE FROM Records WHERE id=" + id;
sql_cmd.ExecuteNonQuery();
sql_cmd.CommandText = "DELETE FROM User WHERE id=" + id;
sql_cmd.ExecuteNonQuery();
sql_con.Close();
AdministratorMenu adminMenu = new AdministratorMenu();
Hide();
adminMenu.ShowDialog();
Close();
}
private void button1_Click(object sender, EventArgs e)
{
SQLiteConnection sql_con = new SQLiteConnection(@"Data Source=D:\4семестр\прПР\PaymentSystem\systemDb.db; Version=3;");
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = "insert into Records (id, FIO, goodsSold, hoursWorked, lastVacation) values ('" + idTB.Text + "','" + fioTB.Text + "','" + soldTB.Text + "','" + hoursTB.Text + "','" + vacationTB.Text + "');";
sql_cmd.ExecuteNonQuery();
sql_cmd.CommandText = "insert into User (id, login, password, type) values ('" + idTB.Text + "','" + loginTB.Text + "','" + passwordTB.Text + "','" + typeTB.Text + "');";
sql_cmd.ExecuteNonQuery();
sql_con.Close();
AdministratorMenu adminMenu = new AdministratorMenu();
Hide();
adminMenu.ShowDialog();
Close();
}
private void enterButton_Click(object sender, EventArgs e)
{
SQLiteConnection Connect = new SQLiteConnection(@"Data Source=D:\4семестр\прПР\PaymentSystem\systemDb.db; Version=3;");
Connect.Open();
DataTable dTable = new DataTable();
string login;
string password;
string sqlQuery;
login = loginTextBox.Text;
password = passwordTextBox.Text;
if (login == "")
{
MessageBox.Show(
"You have not entered a login",
"Warning");
return;
}
if (password == "")
{
MessageBox.Show(
"You have not entered a password",
"Warning");
return;
}
sqlQuery = string.Format("SELECT * FROM User WHERE login=\"{0}\" AND password=\"{1}\";", login, password);
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlQuery, Connect);
adapter.Fill(dTable);
if (dTable.Rows.Count > 0)
{
User.id = dTable.Rows[0][0].ToString();
User.login = dTable.Rows[0][1].ToString();
User.password = dTable.Rows[0][2].ToString();
User.type = dTable.Rows[0][3].ToString();
}
else
{
MessageBox.Show("No such user");
Connect.Close();
return;
}
Connect.Close();
switch (User.type)
{
case "1":
LowClassEmployeeMenu lowRankMenu = new LowClassEmployeeMenu();
Hide();
lowRankMenu.ShowDialog();
Close();
break;
case "2":
AdministratorMenu adminMenu = new AdministratorMenu();
Hide();
adminMenu.ShowDialog();
Close();
break;
case "3":
HighClassEmployeeMenu highRankMenu = new HighClassEmployeeMenu();
Hide();
highRankMenu.ShowDialog();
Close();
break;
default:
AdministratorMenu menu = new AdministratorMenu();
Hide();
menu.ShowDialog();
Close();
break;
}
}
