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