private void insertData(string usernames, string password, string email)
{
auth = new SprawdzW_BD();
auth.getConnection();
try
{
using (SQLiteConnection con = new SQLiteConnection(auth.connectionString))
{
con.Open();
SQLiteCommand cmd = new SQLiteCommand();
string query = @"INSERT INTO Agus (Username, Password, Email) VALUES (@username, @password, @email)";
cmd.CommandText = query;
cmd.Connection = con;
cmd.Parameters.Add(new SQLiteParameter("@username", usernames));
cmd.Parameters.Add(new SQLiteParameter("@password", password));
cmd.Parameters.Add(new SQLiteParameter("@email", email));
cmd.ExecuteNonQuery();
MessageBox.Show("Dokonales rejestracji na V semestr UTP!", "Rejestracja pomyslna!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void checkAccount(string username, string password)
{
auth = new SprawdzW_BD();
auth.getConnection();
try
{
using (SQLiteConnection con = new SQLiteConnection(auth.connectionString))
{
con.Open();
SQLiteCommand cmd = new SQLiteCommand();
string query = @"SELECT * FROM Agus WHERE Username='******'";
int count = 0;
cmd.CommandText = query;
cmd.Connection = con;
SQLiteDataReader read = cmd.ExecuteReader();
while (read.Read())
{
count++;
}
if (count == 1)
{
MessageBox.Show("Zalogowano pomyslnie!", "Komunikat poprawnego logowania", MessageBoxButtons.OK, MessageBoxIcon.Information);
usernames = username;
this.Close();
}
else
{
MessageBox.Show("Podany uzytkownik nie istnieje lub podales nieprawidlowy login lub haslo.", "Bledne dane", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void checkAccount(string username)
{
auth = new SprawdzW_BD();
auth.createDatabase();
auth.getConnection();
try {
using (SQLiteConnection con = new SQLiteConnection(auth.connectionString))
{
SQLiteCommand cmd = new SQLiteCommand();
con.Open();
int count = 0;
string query = @"SELECT * FROM Agus WHERE Username='******'";
cmd.CommandText = query;
cmd.Connection = con;
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
count++;
}
if (count == 1)
{
MessageBox.Show("Cos tam komunikat 33333", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (count == 0)
{
insertData(txtUsername.Text, txtPassword.Text, txtEmail.Text);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}