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