private void dealerFireBt_Click(object sender, RoutedEventArgs e) { bool ok = true; myCon.Open(); Utilizator delDealer = new Utilizator(); try { delDealer = dealers.ElementAt(dealrLB.SelectedIndex); }catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("Dealer not selected").Show(); myCon.Close(); return; } dealrLB.Items.Clear(); SqlCommand cmd = new SqlCommand(); try { cmd = new SqlCommand("DELETE FROM [Dealer] WHERE Email= @email", myCon); cmd.Parameters.AddWithValue("email", delDealer.email); cmd.ExecuteNonQuery(); cmd = new SqlCommand("DELETE FROM [user] WHERE Email= @email", myCon); cmd.Parameters.AddWithValue("email", delDealer.email); cmd.ExecuteNonQuery(); ok = true; } catch (Exception ex) { new MessageBoxPoni("Error").Show(); ok = false; Console.WriteLine(ex.Message); myCon.Close(); return; } myCon.Close(); dealers.Clear(); dealers = ReadDealers(); foreach (Utilizator utilizator in dealers) { dealrLB.Items.Add(utilizator.nume + " " + utilizator.prenume); } if (ok) { new MessageBoxPoni("Dealer Fired").Show(); } }
private void addDealerBt_Click(object sender, RoutedEventArgs e) { try { Utilizator test = null; SignUp signUp = new SignUp(test); signUp.ShowDialog(); test = signUp.getUtil(); signUp.Close(); if (test != null) { dealers.Add(test); dealrLB.Items.Add(test.nume + ' ' + test.prenume); new MessageBoxPoni("Dealer Aded").Show(); } } catch (Exception ex) { Console.WriteLine(ex.Message); return; } }
public ChangePass(Utilizator utilizator) { InitializeComponent(); this.utilizator = utilizator; }
public UserMenu(Utilizator utilizator) { InitializeComponent(); this.utilizator = utilizator; emailTextBlock.Text = utilizator.email; myCon.Open(); if (this.utilizator.isAdmin == 1) { infoDealearItem.Visibility = Visibility.Visible; addCars_Item.Visibility = Visibility.Visible; StatisticsItem.Visibility = Visibility.Visible; List <Utilizator> utilizatori = new List <Utilizator>(); DataSet dataset = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [Admin]", myCon); dataAdapter.Fill(dataset, "[Admin]"); foreach (DataRow dr in dataset.Tables["[Admin]"].Rows) { String firstName = dr.ItemArray.GetValue(1).ToString(); String lastName = dr.ItemArray.GetValue(2).ToString(); int admin = Convert.ToInt32(dr.ItemArray.GetValue(3).ToString()); String emailRead = dr.ItemArray.GetValue(4).ToString(); String passRead = dr.ItemArray.GetValue(5).ToString(); utilizatori.Add(new Utilizator(emailRead, passRead, admin, lastName, firstName)); } foreach (Utilizator utilizator1 in utilizatori) { if (utilizator1.email == utilizator.email) { utilizator.nume = utilizator1.nume; utilizator.prenume = utilizator1.prenume; } } } else { List <Utilizator> utilizatori = new List <Utilizator>(); DataSet dataset = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [Dealer]", myCon); dataAdapter.Fill(dataset, "[Dealer]"); foreach (DataRow dr in dataset.Tables["[Dealer]"].Rows) { String firstName = dr.ItemArray.GetValue(1).ToString(); String lastName = dr.ItemArray.GetValue(2).ToString(); int admin = Convert.ToInt32(dr.ItemArray.GetValue(3).ToString()); int sales = Convert.ToInt32(dr.ItemArray.GetValue(4).ToString()); String emailRead = dr.ItemArray.GetValue(5).ToString(); String passRead = dr.ItemArray.GetValue(6).ToString(); utilizatori.Add(new Utilizator(emailRead, passRead, admin, lastName, firstName, sales)); } foreach (Utilizator utilizator1 in utilizatori) { if (utilizator1.email == utilizator.email) { utilizator.nume = utilizator1.nume; utilizator.prenume = utilizator1.prenume; utilizator.salesNumber = utilizator1.salesNumber; } } } myCon.Close(); }
public ProductPrezentation(Utilizator utilizator, Masini masina) { InitializeComponent(); myCon.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\ii-proj\Developer-s-Work\WpfApp1\WpfApp1\PCDB.mdf;Integrated Security=True"; this.utilizator = utilizator; this.masina = masina; emailTextBlock.Text = utilizator.email; var products = GetProducts(); myCon.Open(); DataSet dataset = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [SpecificationCar]", myCon); dataAdapter.Fill(dataset, "[SpecificationCar]"); foreach (DataRow dr in dataset.Tables["[SpecificationCar]"].Rows) { int carId = Convert.ToInt32(dr.ItemArray.GetValue(1).ToString()); if (carId == masina.carId) { masina.color = dr.ItemArray.GetValue(2).ToString(); masina.Co2E = Convert.ToInt32(dr.ItemArray.GetValue(3).ToString()); masina.ParkingSpot = dr.ItemArray.GetValue(4).ToString(); masina.Consumption = Convert.ToDouble(dr.ItemArray.GetValue(5).ToString()); masina.Traction = dr.ItemArray.GetValue(6).ToString(); masina.CilindricalCap = Convert.ToDouble(dr.ItemArray.GetValue(7).ToString()); String[] feat = dr.ItemArray.GetValue(8).ToString().Split('@'); List <String> f = new List <string>(); for (int i = 0; i < feat.Length; i++) { f.Add(feat[i]); } brand.Text = brand.Text + ": " + masina.make; model.Text = model.Text + ": " + masina.model; culoare.Text = culoare.Text + ": " + masina.color; combustibil.Text = combustibil.Text + ": " + masina.FuelType; caiputere.Text = caiputere.Text + ": " + masina.HorsePower.ToString(); tractiune.Text = tractiune.Text + ": " + masina.Traction; capcilindrica.Text = capcilindrica.Text + ": " + masina.CilindricalCap.ToString(); locparcare.Text = locparcare.Text + ": " + masina.ParkingSpot; pret.Text = "$" + masina.carPrice.ToString(); f.RemoveAt(f.Count - 1); features.Items.Clear(); foreach (String feature in f) { features.Items.Add(feature); } } } products.RemoveAt(products.Count - 1); if (products.Count > 0) { PhotosList.ItemsSource = products; } try { var uriSource = new Uri(@"/WpfApp1;component/" + products.ElementAt(0).Image, UriKind.Relative); BigImg.Source = new BitmapImage(uriSource); BigImg.Width = 400; BigImg.Height = 400; } catch (Exception ex) { Console.WriteLine(ex.Message); } myCon.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { if (emailTB.Text == "" || PassP.Password == "" || SallaryTB.Text == "" || FirstNameTB.Text == "" || LastNameTB.Text == "") { new MessageBoxPoni("All Blocks must be completed").Show(); return; } try { int emailok = 1, firstletterfn = 1, firstletterln = 1, lnok = 1, fnok = 1, salaryok = 1; string[] emailstr = emailTB.Text.Split(new char[] { '@', '.' }, StringSplitOptions.RemoveEmptyEntries); if (!(emailstr[1] == "gmail" && emailstr[1] == "yahoo") && !(emailstr[2] == "com")) { emailok = 0; //new MessageBoxPoni("Wrong email format!").Show(); } string firstname = FirstNameTB.Text; string lastname = LastNameTB.Text; if (firstname[0] >= 'A' && firstname[0] <= 'Z') { for (int i = 1; i < firstname.Length; i++) { if (!(firstname[i] >= 'a' && firstname[i] <= 'z')) { fnok = 0; } } } else { firstletterfn = 0; } if (lastname[0] >= 'A' && lastname[0] <= 'Z') { for (int i = 1; i < lastname.Length; i++) { if (!(lastname[i] >= 'a' && lastname[i] <= 'z')) { lnok = 0; } } } else { firstletterln = 0; } string s = SallaryTB.Text; if (s[0] == '0')// Daca salariul incepe cu cifra 0 { salaryok = 0; } for (int i = 0; i < s.Length; i++) { if (!(s[i] >= '1' && s[i] <= '9')) { salaryok = 0; } } if (emailok == 1 && firstletterfn == 1 && firstletterln == 1 && lnok == 1 && fnok == 1 && salaryok == 1) { myCon.Open(); cmd = new SqlCommand("INSERT INTO [user] (Email,[Password],Salary) VALUES (@Email,@Password,@Salary) ", myCon); cmd.Parameters.AddWithValue("@Email", emailTB.Text); cmd.Parameters.AddWithValue("@Password", PassP.Password); cmd.Parameters.AddWithValue("@Salary", SallaryTB.Text); cmd.ExecuteNonQuery(); cmd = new SqlCommand("INSERT INTO [Dealer] (FirstName,LastName,Email,[Password]) VALUES (@FirstName,@LastName,@email,@Password) ", myCon); cmd.Parameters.AddWithValue("@FirstName", FirstNameTB.Text); cmd.Parameters.AddWithValue("@LastName", LastNameTB.Text); cmd.Parameters.AddWithValue("@Email", emailTB.Text); cmd.Parameters.AddWithValue("@Password", PassP.Password); cmd.ExecuteNonQuery(); double salary = Convert.ToDouble(SallaryTB.Text); utilizator = new Utilizator(emailTB.Text, PassP.Password, 0, salary); utilizator.nume = LastNameTB.Text; utilizator.prenume = FirstNameTB.Text; utilizator.salesNumber = 0; } else { new MessageBoxPoni("Email,FirstName,LastName or Salary fields might have a wrong format!").Show(); emailTB.Text = ""; PassP.Password = ""; FirstNameTB.Text = ""; LastNameTB.Text = ""; SallaryTB.Text = ""; } } catch (IndexOutOfRangeException ex) { new MessageBoxPoni("Wrong email format! Hint: Use [email protected] \n or [email protected]").Show(); Console.WriteLine(ex.Message); emailTB.Text = ""; PassP.Password = ""; FirstNameTB.Text = ""; LastNameTB.Text = ""; SallaryTB.Text = ""; myCon.Close(); return; } catch (SqlException ex) { new MessageBoxPoni("No connection to the database!").Show(); Console.WriteLine(ex.Message); myCon.Close(); emailTB.Text = ""; PassP.Password = ""; FirstNameTB.Text = ""; LastNameTB.Text = ""; SallaryTB.Text = ""; return; } myCon.Close(); this.Hide(); }
public SignUp(Utilizator utilizator) { InitializeComponent(); this.utilizator = utilizator; }