private void LogIn_Click(object sender, EventArgs e)
{
this.Hide();
Logining login = new Logining(LoginInput.Text, PasswordInput.Text);
if (login.status != null)
{
if (login.status.ToUpper() == "ADMIN")
{
AdminUser admin = new AdminUser(login.UserId, login.LastName, login.FirstName,
login.SecondName, login.status, login.Login, login.Password);
fAdminConsoleUnit adminConsole = new fAdminConsoleUnit(admin);
adminConsole.ShowDialog();
}
else if (login.status.ToUpper() == "CASHIER")
{
CashierUser cashier = new CashierUser(login.UserId, login.LastName, login.FirstName,
login.SecondName, login.status, login.Login, login.Password);
fCashierConsoleUnit cashierConsole = new fCashierConsoleUnit(cashier);
cashierConsole.ShowDialog();
}
else if (login.status.ToUpper() == "VISITOR")
{
}
LoginInput.Text = "";
PasswordInput.Text = "";
}
else
{
MessageBox.Show("Неверный логин, пароль");
PasswordInput.Text = "";
}
this.Show();
}
public void AddCashierInList(int userId, string lastName, string firstName,
string secondName, string userStatus, string login, string password)
{
CashierUser cashier = new CashierUser(userId, lastName, firstName,
secondName, userStatus, login, password);
Cashiers.Add(cashier);
}
public void DeleteFromDatabase(CashierUser cashier)
{
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
("DELETE FROM [USERS] WHERE @USER_ID = USER_ID;"),
connectToDateBase);
command.Connection.Open();
command.Parameters.AddWithValue("@USER_ID", cashier.UserId);
command.ExecuteNonQuery();
}
}
public void WriteInDatabase(CashierUser cashier)
{
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
("INSERT INTO [USERS] (USER_LOGIN, USER_PASSWORD, FIRST_NAME, LAST_NAME, SECOND_NAME, STATUS_USER)" +
"VALUES (@USER_LOGIN, @USER_PASSWORD, @FIRST_NAME, @LAST_NAME, @SECOND_NAME, @STATUS_USER);"),
connectToDateBase);
command.Connection.Open();
command.Parameters.AddWithValue("@USER_LOGIN", cashier.Login);
command.Parameters.AddWithValue("@USER_PASSWORD", cashier.Password);
command.Parameters.AddWithValue("@FIRST_NAME", cashier.FirstName);
command.Parameters.AddWithValue("@LAST_NAME", cashier.LastName);
command.Parameters.AddWithValue("@SECOND_NAME", cashier.SecondName);
command.Parameters.AddWithValue("@STATUS_USER", cashier.UserStatus);
command.ExecuteNonQuery();
}
}
public void ReadFromDateBase()
{
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
"SELECT USER_ID, USER_LOGIN, USER_PASSWORD, FIRST_NAME, LAST_NAME, SECOND_NAME, STATUS_USER FROM [USERS];",
connectToDateBase);
connectToDateBase.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
if (reader.GetString(6).ToUpper() == "ADMIN")
{
AdminUser admin = new AdminUser(reader.GetInt32(0), reader.GetString(4), reader.GetString(3),
reader.GetString(5), reader.GetString(6), reader.GetString(1), reader.GetString(2));
adminList.Add(admin);
}
if (reader.GetString(6).ToUpper() == "CASHIER")
{
CashierUser cashier = new CashierUser(reader.GetInt32(0), reader.GetString(4), reader.GetString(3),
reader.GetString(5), reader.GetString(6), reader.GetString(1), reader.GetString(2));
cashierList.Add(cashier);
}
if (reader.GetString(6).ToUpper() == "VISITOR")
{
VisitorUser visitor = new VisitorUser(reader.GetInt32(0), reader.GetString(4), reader.GetString(3),
reader.GetString(5), reader.GetString(6), reader.GetString(1), reader.GetString(2));
visitorList.Add(visitor);
}
}
}
reader.Close();
}
}
public void UpdateInDatabase(CashierUser cashier)
{
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
("UPDATE [USERS]" +
"SET USER_LOGIN = @USER_LOGIN, USER_PASSWORD = @USER_PASSWORD, FIRST_NAME = @FIRST_NAME," +
"LAST_NAME = @LAST_NAME, SECOND_NAME = @SECOND_NAME, STATUS_USER = @STATUS_USER "
+ "WHERE @USER_ID = USER_ID;"),
connectToDateBase);
command.Connection.Open();
command.Parameters.AddWithValue("@USER_ID", cashier.UserId);
command.Parameters.AddWithValue("@USER_LOGIN", cashier.Login);
command.Parameters.AddWithValue("@USER_PASSWORD", cashier.Password);
command.Parameters.AddWithValue("@FIRST_NAME", cashier.FirstName);
command.Parameters.AddWithValue("@LAST_NAME", cashier.LastName);
command.Parameters.AddWithValue("@SECOND_NAME", cashier.SecondName);
command.Parameters.AddWithValue("@STATUS_USER", cashier.UserStatus);
command.ExecuteNonQuery();
}
}
public fCashierConsoleUnit(CashierUser cashier)
{
InitializeComponent();
this.cashier = cashier;
}
