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