private void auth(string user, string pass) { foreach (User usr in users) { if (usr.username == user && usr.passiscorrect(pass)) { if (usr.isAdmin) { if ((_AdminPanel = (AdminPanel)checkifwinopen(typeof(AdminPanel))) == null && (_UserPanel = (UserPanel)checkifwinopen(typeof(UserPanel))) == null) { _AdminPanel = new AdminPanel(usr.username); _AdminPanel.Show(); } } else { if ((_AdminPanel = (AdminPanel)checkifwinopen(typeof(AdminPanel))) == null && (_UserPanel = (UserPanel)checkifwinopen(typeof(UserPanel))) == null) { _UserPanel = new UserPanel(usr.username); _UserPanel.Show(); } } } } }
private void button2_Click(object sender, EventArgs e) { this.Hide(); Form f2 = new AdminPanel(); f2.Show(); }
private void button10_Click(object sender, EventArgs e) { Form f2 = new AdminPanel(); f2.Show(); }
private void login_Click(object sender, EventArgs e) { if (!System.IO.File.Exists("baza.db")) { connection = new SQLiteConnection("Data Source=baza.db;Version=3;"); SQLiteConnection.CreateFile("baza.db"); connection.Open(); SQLiteCommand cmd = new SQLiteCommand("CREATE TABLE USER (ID INTEGER NOT NULL" + " PRIMARY KEY AUTOINCREMENT , USERNAME VARCHAR(255), PASSWORD VARCHAR(255), ISADMIN INTEGER)", connection); int k = cmd.ExecuteNonQuery(); //wywolanie komendy cmd.CommandText = "INSERT INTO USER (ID, USERNAME, PASSWORD,ISADMIN) VALUES" + " (@ID,@USERNAME, @PASSWORD, @ISADMIN)"; cmd.Parameters.Clear(); cmd.Parameters.Add("@ID", DbType.Int32).Value = 1; cmd.Parameters.Add("@USERNAME", DbType.String).Value = "kamil"; cmd.Parameters.Add("@PASSWORD", DbType.String).Value = "haslo"; cmd.Parameters.Add("@ISADMIN", DbType.Int32).Value = 1; cmd.ExecuteNonQuery(); cmd.CommandText = "INSERT INTO USER (USERNAME, PASSWORD,ISADMIN) VALUES" + " (@USERNAME, @PASSWORD, @ISADMIN)"; cmd.Parameters.Clear(); cmd.Parameters.Add("@USERNAME", DbType.String).Value = "admin"; cmd.Parameters.Add("@PASSWORD", DbType.String).Value = "admin1"; cmd.Parameters.Add("@ISADMIN", DbType.Int32).Value = 1; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); cmd.Parameters.Add("@USERNAME", DbType.String).Value = "user1"; cmd.Parameters.Add("@PASSWORD", DbType.String).Value = "user"; cmd.Parameters.Add("@ISADMIN", DbType.Int32).Value = 0; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); cmd.Parameters.Add("@USERNAME", DbType.String).Value = "user"; cmd.Parameters.Add("@PASSWORD", DbType.String).Value = "user1"; cmd.Parameters.Add("@ISADMIN", DbType.Int32).Value = 0; cmd.ExecuteNonQuery(); } else { try { SQLiteConnection connection = new SQLiteConnection("Data Source=baza.db;Version=3;"); Int64 ID = 0; Int64 ISADMIN = 0; connection.Open(); SQLiteCommand cmd = new SQLiteCommand("SELECT ID, ISADMIN FROM USER" + " where USERNAME=@USERNAME AND PASSWORD=@PASSWORD", connection); cmd.Parameters.Clear(); cmd.Parameters.Add("@USERNAME", DbType.String).Value = loginBox.Text; cmd.Parameters.Add("@PASSWORD", DbType.String).Value = passBox.Text; SQLiteDataReader rdr = null; rdr = cmd.ExecuteReader(); while (rdr.Read()) { ID = (Int64)rdr[0]; //lub rdr[0]; ISADMIN = (Int64)rdr[1]; //musi byc int64 bo baza jest 64 bit if (ID > 0) { break; } } if (rdr != null) { rdr.Close(); } connection.Close(); if (ID > 0 && ISADMIN == 1) { (_AdminPanel = new AdminPanel(connection, loginBox.Text)).Show(); } else if (ID > 0 && ISADMIN == 0) { (_UserPanel = new UserPanel(loginBox.Text)).Show(); } else { MessageBox.Show("Brak uzytkownikow"); } } catch (SQLiteException err) { MessageBox.Show(err.Message); } } }