private void refresh_btn_Click(object sender, RoutedEventArgs e) { admin_desktop w = new admin_desktop(); w.Show(); this.Close(); }
private void sign_in_Click(object sender, RoutedEventArgs e) { string password = null; for (int i = 0; i < Current_user.admin_login_counter % 10; i++) { password += "1"; } for (int i = 0; i < sign_in_email.Text.Length; i++) { if (sign_in_email.Text[i] == 'a' || sign_in_email.Text[i] == 'e' || sign_in_email.Text[i] == 'i' || sign_in_email.Text[i] == 'o' || sign_in_email.Text[i] == 'u' || sign_in_email.Text[i] == 'A' || sign_in_email.Text[i] == 'E' || sign_in_email.Text[i] == 'I' || sign_in_email.Text[i] == 'O' || sign_in_email.Text[i] == 'U') { password += "0"; } } if (Regex.IsMatch(sign_in_email.Text, ".?admin.?")) { if (sign_in_password.Password == password) { MessageBox.Show("You Signed In Successfully As Admin"); Current_user.admin_login_counter++; admin_desktop w = new admin_desktop(); w.Show(); this.Close(); return; } } SqlConnection sqlConnection = new SqlConnection(connection_string); SqlDataReader sqlDataReader; SqlCommand sqlCommand; sqlConnection.Open(); if (check_conditions.email_check(sign_in_email.Text)) { sqlCommand = new SqlCommand("select * from Users where E_mail=@E_mail and _Password=@_Password", sqlConnection); sqlCommand.Parameters.AddWithValue("@E_mail", sign_in_email.Text); sqlCommand.Parameters.AddWithValue("@_Password", sign_in_password.Password); sqlDataReader = sqlCommand.ExecuteReader(); } else { sqlCommand = new SqlCommand("select * from Users where PhoneNUmber=@Phone_Number and _Password=@_Password", sqlConnection); sqlCommand.Parameters.AddWithValue("@Phone_Number", sign_in_email.Text); sqlCommand.Parameters.AddWithValue("@_Password", sign_in_password.Password); sqlDataReader = sqlCommand.ExecuteReader(); } while (sqlDataReader.Read()) { Current_user.FullName = sqlDataReader.GetValue(0).ToString(); Current_user.E_mail = sqlDataReader.GetValue(1).ToString(); Current_user.NationalCode = sqlDataReader.GetValue(2).ToString(); Current_user.PhoneNumber = sqlDataReader.GetValue(3).ToString(); Current_user.Password = sqlDataReader.GetValue(4).ToString(); Current_user.image_uri = sqlDataReader.GetValue(5).ToString(); Current_user.shopping_list = sqlDataReader.GetValue(6).ToString(); Current_user.cart = sqlDataReader.GetValue(7).ToString(); sqlDataReader.Close(); sqlCommand.Dispose(); sqlCommand = new SqlCommand("IF EXISTS(SELECT * from Food_Menu) SELECT 1 ELSE SELECT 0", sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); sqlDataReader.Read(); if ((int)sqlDataReader.GetValue(0) == 1) { MessageBox.Show("You Signed In Successfully As User"); user_desktop w = new user_desktop(); w.Show(); this.Close(); sqlDataReader.Close(); sqlCommand.Dispose(); sqlConnection.Close(); return; } else { MessageBox.Show("There is No Food,Please wait till admin put Food in Menu"); sqlDataReader.Close(); sqlCommand.Dispose(); sqlConnection.Close(); return; } } MessageBox.Show("Wrong Email or Password!"); sqlDataReader.Close(); sqlCommand.Dispose(); sqlConnection.Close(); }