private void exit_btn_Click(object sender, RoutedEventArgs e)
{
user_desktop w = new user_desktop();
w.Show();
this.Close();
}
private void exit_btn_Click(object sender, RoutedEventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(connection_string);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("update Users set FullName=@FullName,E_mail=@E_mail,_Password=@_Password,PhoneNumber=@PhoneNumber where FullName=@F and E_mail=@E and _Password=@_P", sqlConnection);
sqlCommand.Parameters.AddWithValue("@FullName", FullName_txt.Text);
sqlCommand.Parameters.AddWithValue("@E_mail", E_mail_txt.Text);
sqlCommand.Parameters.AddWithValue("@_Password", Password_txt.Text);
sqlCommand.Parameters.AddWithValue("@PhoneNumber", PhoneNumber_txt.Text);
sqlCommand.Parameters.AddWithValue("@F", Current_user.FullName);
sqlCommand.Parameters.AddWithValue("@E", Current_user.E_mail);
sqlCommand.Parameters.AddWithValue("@_P", Current_user.Password);
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
sqlCommand.Dispose();
user_desktop w = new user_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();
}