private void button1_Click(object sender, EventArgs e)
{
Random rnd = new Random();
long pesel = LongRandom(50000000000, 45000000000, rnd);
addedPESEL = "" + pesel;
addedLogin = textBoxLogin.Text;
addedPassword = textBoxPassword.Text;
addedPasswordAgain = textBoxPasswordRepeat.Text;
//DataTable doesUserExists = ourDB.getData("SELECT * FROM Uzytkownik WHERE PESELpracownika = '" + addedPESEL + "'");
DataTable doesThisLoginExists = ourDB.getData("SELECT * FROM Uzytkownik WHERE LoginUsera = '" + addedLogin + "'");
//DataTable isAnyEmployeePESEL = ourDB.getData("SELECT * FROM Pracownik WHERE PESEL = '" + addedPESEL + "'");
// if (isAnyEmployeePESEL.Rows.Count == 0)
// MessageBox.Show("Brak pracownika o podanym PESELu, bledny PESEL!");
// else if (doesUserExists.Rows.Count != 0)
// MessageBox.Show("Pracownik o danym PESELu ma juz konto uzytkownika!");
// else
if (doesThisLoginExists.Rows.Count != 0)
{
MessageBox.Show("Taki login jest juz w uzyciu, wybierz inny!");
}
else if (addedPassword != addedPasswordAgain)
{
MessageBox.Show("Hasla sa niezgodne!");
}
else
{
string query = pracownikGenerator();
if (ourDB.executeSettingData(new SqlCommand(query, ourDB.connection)) == false)
{
return;
}
addedPassword = LogForm.Szyfruj(addedPassword);
string adminPesel = ourDB.getData("SELECT PESEL FROM Pracownik WHERE Stanowisko = 'admin'").Rows[0][0].ToString();
query = "INSERT INTO Uzytkownik values ('" + addedLogin + "','" + addedPassword + "','" + addedPESEL + "',1);"; //(@LoginUsera, @HasloUsera, @PESELpracownika, 1)";
query += "INSERT INTO Historia values ('admin', '" + addedLogin + "', 'stworzenie konta', '', '', '', '', 1,0)"; //"+ adminPesel + ",', '', 1,0)";
ourDB.executeSettingData(new SqlCommand(query, ourDB.connection));
userComboBox.Items.Add(addedLogin);
mainInfoLabel.Text = "Utworzono nowego \n użytkownika";
MessageBox.Show("Utworzono nowego użytkownika");
}
infoLabel.Visible = true;
//textBoxID.Text = "";
textBoxLogin.Text = "";
textBoxPassword.Text = "";
textBoxPasswordRepeat.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
addedPESEL = textBoxID.Text;
addedLogin = textBoxLogin.Text;
addedPassword = textBoxPassword.Text;
addedPasswordAgain = textBoxPasswordAgain.Text;
DataTable doesUserExists = ourDB.getData("SELECT * FROM Uzytkownik WHERE PESELpracownika = '" + addedPESEL + "'");
DataTable doesThisLoginExists = ourDB.getData("SELECT * FROM Uzytkownik WHERE LoginUsera = '" + addedLogin + "'");
DataTable isAnyEmployeePESEL = ourDB.getData("SELECT * FROM Pracownik WHERE PESEL = '" + addedPESEL + "'");
if (isAnyEmployeePESEL.Rows.Count == 0)
{
MessageBox.Show("Brak pracownika o podanym PESELu, bledny PESEL!");
}
else if (doesUserExists.Rows.Count != 0)
{
MessageBox.Show("Pracownik o danym PESELu ma juz konto uzytkownika!");
}
else if (doesThisLoginExists.Rows.Count != 0)
{
MessageBox.Show("Taki login jest juz w uzyciu, wybierz inny!");
}
else if (addedPassword != addedPasswordAgain)
{
MessageBox.Show("Hasla sa niezgodne!");
}
else
{
addedPassword = this.szyfruj(addedPassword);
string query = "INSERT INTO Uzytkownik (LoginUsera, HasloUsera, PESELpracownika) values (@LoginUsera, @HasloUsera, @PESELpracownika)";
SqlCommand command = new SqlCommand(query, ourDB.connection);
command.Parameters.Add("@LoginUsera", addedLogin);
command.Parameters.Add("@HasloUsera", addedPassword);
command.Parameters.Add("@PESELpracownika", addedPESEL);
command.ExecuteNonQuery();
query = "INSERT INTO Historia (Dawca, Biorca, RodzajOperacji, Uprawnienia, WszystkiePosiadaneUprawnienia, RodziceWDrzewie, CzyAktualne) values (@Dawca, @Biorca, @RodzajOperacji, @Uprawnienia, @WszystkiePosiadaneUprawnienia, @RodziceWDrzewie, 1)";
command = new SqlCommand(query, ourDB.connection);
command.Parameters.Add("@Dawca", "admin");
command.Parameters.Add("@Biorca", addedLogin);
command.Parameters.Add("@RodzajOperacji", "stworzenie konta");
command.Parameters.Add("@Uprawnienia", "");
command.Parameters.Add("@WszystkiePosiadaneUprawnienia", "");
command.Parameters.Add("@RodziceWDrzewie", "95031211111, ");
command.ExecuteNonQuery();
this.Close();
}
}
public SearchForm(DatabaseConnector ourDB, DataGridView questionResult, Int32 oldRowCount, string tableName)
{
InitializeComponent();
this.ourDB = ourDB;
this.oldRowCount = oldRowCount;
this.tableName = tableName;
this.questionResult = questionResult;
string bla = "SELECT COLUMN_NAME,* FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tableName + "'";
queryResult = ourDB.getData(bla);
if (queryResult == null)
{
this.Close();
}
for (int i = 0; i < queryResult.Rows.Count; i++)
{
conditionList.Add(queryResult.Rows[i][0].ToString());
}
conditionsLeft = queryResult.Rows.Count - 1;
comboBoxList.Add(conditionBox);
textBoxList.Add(conditionTextBox);
labelList.Add(label1);
}
private void logInButton_Click(object sender, EventArgs e)
{
typedLogin = logInUserName.Text;
typedPassword = Szyfruj(logInPassword.Text);
DataTable row = ourDB.getData("SELECT * FROM Uzytkownik WHERE LoginUsera = '" + typedLogin + "' AND HasloUsera = '" + typedPassword + "'");
if (row == null)
{
return;
}
if (row.Rows.Count.Equals(1))
{
app = new MainForm(this, typedLogin, ourDB);
app.Show();
this.Hide();
logInUserName.Text = "";
logInPassword.Text = "";
}
else
{
MessageBox.Show("Niepoprawny login lub haslo.");
logInUserName.Text = "";
logInPassword.Text = "";
}
}
public FlagForm(String currentUser, DatabaseConnector ourDB)// Form1 form, String table_name, User current_user, User chosen_user)
{
InitializeComponent();
selectComboBox.Items.Add("Faktura");
selectComboBox.Items.Add("Historia");
selectComboBox.Items.Add("Potrawa");
selectComboBox.Items.Add("Pracownik");
selectComboBox.Items.Add("Restauracja");
DataTable queryResult = ourDB.getData("SELECT * FROM Historia WHERE Biorca = '" + currentUser + "' and CzyAktualne = '1'");
if (queryResult == null)
{
this.Close();
}
try
{
id = Int32.Parse(queryResult.Rows[0][0].ToString());
currentPrivilages = queryResult.Rows[0][5].ToString();
usersParents = queryResult.Rows[0][6].ToString();
flagList = queryQuasiParser(queryResult.Rows[0][7].ToString());
}
catch { }
this.currentUser = currentUser;
this.ourDB = ourDB;
_timer.Elapsed += OnTimerElapsed;
_timer.Interval = 1000;
_timer.AutoReset = false;
}
