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(); //string updatecorect = "update Records set lastVacation=0 where id=" + User.id; string updatecorect = "update Reports set report=\"" + reportTB.Text + "\", checked=\"false\" WHERE id=" + User.id + " AND checked=\"true\" AND finished=\"false\";"; SQLiteCommand updatec = new SQLiteCommand(updatecorect, sql_con); updatec.ExecuteNonQuery(); sql_con.Close(); LowClassEmployeeMenu lowRankMenu = new LowClassEmployeeMenu(); Hide(); lowRankMenu.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 Reports (id, report, checked, finished) values ('" + User.id + "','" + reportTB.Text + "','" + "false" + "','" + "false" + "');"; sql_cmd.ExecuteNonQuery(); sql_con.Close(); LowClassEmployeeMenu lowRankMenu = new LowClassEmployeeMenu(); Hide(); lowRankMenu.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; } }