private void backButton_Click(object sender, EventArgs e)
{
Menu_vivsitor visitor = new Menu_vivsitor(IdVis);
Hide();
visitor.ShowDialog();
Close();
}
private void button2_Click(object sender, EventArgs e)
{
OleDbCommand commandStatus = new OleDbCommand("INSERT INTO StatusOrders (IdOrder, Status) VALUES (?, ?)", cn);
commandStatus.Parameters.AddWithValue("@IdOrder", NumberOrder.Text);
commandStatus.Parameters.AddWithValue("@Stat", status);
commandStatus.ExecuteNonQuery();
int bill = 0;
OleDbCommand commandBill = new OleDbCommand("INSERT INTO Bill (IdOrder, Bill) VALUES (?, ?)", cn);
commandBill.Parameters.AddWithValue("@IdOrder", NumberOrder.Text);
commandBill.Parameters.AddWithValue("@Pr", bill);
commandBill.ExecuteNonQuery();
Menu_vivsitor visitor = new Menu_vivsitor(IdVis);
Hide();
visitor.ShowDialog();
Close();
}
private void SignIn_Click(object sender, EventArgs e)
{
OleDbCommand selectUser = new OleDbCommand("SELECT IdUser, Surname FROM Users WHERE Login = ? AND Password = ?", cn);
selectUser.Parameters.AddWithValue("@Login", Login.Text);
selectUser.Parameters.AddWithValue("@IdTable", Password.Text);
selectUser.ExecuteNonQuery();
object idUser;
object Surname;
OleDbDataReader reader = selectUser.ExecuteReader();
if (reader.Read())
{
idUser = reader["IdUser"];
Surname = reader["Surname"];
}
else
{
MessageBox.Show(" Нет пользователя с таким логином или паролем! ");
return;
}
reader.Close();
OleDbCommand selectIdVisitor = new OleDbCommand("SELECT IdVisitor FROM Visitors WHERE Surname = ?", cn);
selectIdVisitor.Parameters.AddWithValue("@Sur", Surname);
selectIdVisitor.ExecuteNonQuery();
object idVisitor;
OleDbDataReader reader1 = selectIdVisitor.ExecuteReader();
if (reader1.Read())
{
idVisitor = reader1["IdVisitor"];
Menu_vivsitor vivsitor = new Menu_vivsitor(Convert.ToInt32(idVisitor));
Hide();
vivsitor.ShowDialog();
Close();
}
else
{
OleDbCommand selectIdEmp = new OleDbCommand("SELECT IdEmployee FROM Employees WHERE Surname = ?", cn);
selectIdEmp.Parameters.AddWithValue("@Sur", Surname);
selectIdEmp.ExecuteNonQuery();
object idEmployee;
OleDbDataReader reader2 = selectIdEmp.ExecuteReader();
if (reader2.Read())
{
idEmployee = reader2["IdEmployee"];
OleDbCommand selectPost = new OleDbCommand("SELECT Post FROM Employees WHERE IdEmployee = ?", cn);
selectPost.Parameters.AddWithValue("@IdEmpl", Convert.ToInt32(idEmployee));
selectPost.ExecuteNonQuery();
object Post;
OleDbDataReader reader3 = selectPost.ExecuteReader();
if (reader3.Read())
{
Post = reader3["Post"];
if (Post.ToString() == "Администратор")
{
Admin_menu admin = new Admin_menu(Convert.ToInt32(idEmployee));
Hide();
admin.ShowDialog();
Close();
}
else if (Post.ToString() == "Повар-стажер")
{
Cook_menu cook = new Cook_menu(Convert.ToInt32(idEmployee));
Hide();
cook.ShowDialog();
Close();
}
else if (Post.ToString() == "Закупщик")
{
MenuPurchaser purchaser = new MenuPurchaser(Convert.ToInt32(idEmployee));
Hide();
purchaser.ShowDialog();
Close();
}
}
}
}
}