private void addCars_Item_PreviewMouseUp(object sender, MouseButtonEventArgs e) { gridCarsImage.Visibility = Visibility.Hidden; gridParking.Visibility = Visibility.Hidden; gridHome.Visibility = Visibility.Hidden; gridDealerInfo.Visibility = Visibility.Hidden; gridAddCar.Visibility = Visibility.Visible; gridStatistics.Visibility = Visibility.Hidden; newMasina = new Masini(); featureACTB.Text = ""; makeACTB.Text = ""; modelACTB.Text = ""; priceACTB.Text = ""; yearACTB.Text = ""; horsePowerACTB.Text = ""; FuelTypeACTB.Text = ""; isSoldACCB.IsChecked = false; colorACTB.Text = ""; Co2EACTB.Text = ""; parkingSpotACTB.Text = ""; cosumptionACTB.Text = ""; tractionACTB.Text = ""; CilindricalACTB.Text = ""; countFACL.Content = "0"; countPACL.Content = "0"; countFACL.Visibility = Visibility.Hidden; countPACL.Visibility = Visibility.Hidden; }
private void ListViewProducts_PreviewMouseUp(object sender, MouseButtonEventArgs e) { Masini masina = (Masini)ListViewProducts.SelectedItem; if (ListViewProducts.SelectedItem != null) { try { if (masina.isSold == true) { new MessageBoxPoni("Masina Cumparata!").Show(); return; } } catch (Exception ex) { Console.WriteLine(ex.Message); return; } ProductPrezentation product = new ProductPrezentation(utilizator, masina); List <Masini> masinis = new List <Masini>(); product.ShowDialog(); // update User utilizator = product.GetUtilizator(); // update lista masini masina = product.GetMasini(); product.Close(); } }
public Masini(Masini masina, int carYear, int codITP, bool isSold, List <String> URL) { this.carId = masina.carId; this.make = masina.make; this.model = masina.model; this.carPrice = masina.carPrice; this.carYear = carYear; this.codITP = codITP; this.isSold = isSold; this.URL = URL; this.HorsePower = masina.HorsePower; this.FuelType = masina.FuelType; //name = make + " " + model; }
private void addCarACB_Click(object sender, RoutedEventArgs e) { if (TextsCheck() == true) { new MessageBoxPoni("All boxex must be completed \n" + "and you need to add a photo").Show(); } else { string feautersFormat = ""; foreach (string feat in newMasina.Features) { feautersFormat = feat + "@" + feautersFormat; } string urlFormat = ""; foreach (string url in newMasina.URL) { urlFormat = url + " " + urlFormat; } newMasina.make = makeACTB.Text; newMasina.model = modelACTB.Text; newMasina.isSold = isSoldACCB.IsChecked == true; newMasina.FuelType = FuelTypeACTB.Text; try { newMasina.carPrice = Convert.ToDouble(priceACTB.Text); }catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("The price is an number").Show(); return; } try { newMasina.carYear = Convert.ToInt32(yearACTB.Text); }catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("The year is an natural number").Show(); return; } newMasina.color = colorACTB.Text; try { newMasina.Co2E = Convert.ToInt32(Co2EACTB.Text); }catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("The CO2 emission \n is an natural number").Show(); return; } newMasina.ParkingSpot = parkingSpotACTB.Text; try { newMasina.Consumption = Convert.ToDouble(cosumptionACTB.Text); }catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("The car consumption \n is a number").Show(); return; } newMasina.Traction = tractionACTB.Text; try { newMasina.CilindricalCap = Convert.ToInt32(CilindricalACTB.Text); } catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("The Cilindrical capcacity \n is a natural number").Show(); return; } try { newMasina.HorsePower = Convert.ToInt32(horsePowerACTB.Text); }catch (Exception ex) { Console.WriteLine(ex.Message); new MessageBoxPoni("The Horse Power \n is a natural number").Show(); return; } SqlCommand cmd = new SqlCommand(); myCon.Open(); try { cmd = new SqlCommand("INSERT INTO [Car] (Make,[Model],CarPrice,CarYear,IsSold,link,HorsePower,FuelType) VALUES (@Make,@Model,@CarPrice,@CarYear,@IsSold,@link,@HorsePower,@FuelType) ", myCon); cmd.Parameters.AddWithValue("@Make", newMasina.make); cmd.Parameters.AddWithValue("@Model", newMasina.model); cmd.Parameters.AddWithValue("@CarPrice", newMasina.carPrice); cmd.Parameters.AddWithValue("@CarYear", newMasina.carYear); cmd.Parameters.AddWithValue("@IsSold", newMasina.isSold); cmd.Parameters.AddWithValue("@link", urlFormat); cmd.Parameters.AddWithValue("@HorsePower", newMasina.HorsePower); cmd.Parameters.AddWithValue("@FuelType", newMasina.FuelType); cmd.ExecuteNonQuery(); int carID = 0; DataSet dataset = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM [Car]", myCon); dataAdapter.Fill(dataset, "[Car]"); foreach (DataRow dr in dataset.Tables["[Car]"].Rows) { carID = Convert.ToInt32(dr.ItemArray.GetValue(0).ToString()); } cmd = new SqlCommand("INSERT INTO [SpecificationCar] (CarId,Color,Co2E,ParkingSpot,Consumption,Traction,CilindricalCap,Features) VALUES (@CarId,@Color,@Co2E,@ParkingSpot,@Consumption,@Traction,@CilindricalCap,@Features) ", myCon); cmd.Parameters.AddWithValue("@CarId", carID); cmd.Parameters.AddWithValue("@Color", newMasina.color); cmd.Parameters.AddWithValue("@Co2E", newMasina.Co2E); cmd.Parameters.AddWithValue("@ParkingSpot", newMasina.ParkingSpot); cmd.Parameters.AddWithValue("@Consumption", newMasina.Consumption); cmd.Parameters.AddWithValue("@Traction", newMasina.Traction); cmd.Parameters.AddWithValue("@CilindricalCap", newMasina.CilindricalCap); cmd.Parameters.AddWithValue("@Features", feautersFormat); cmd.ExecuteNonQuery(); }catch (Exception ex) { Console.WriteLine(ex.Message); } newMasina = new Masini(); featureACTB.Text = ""; makeACTB.Text = ""; modelACTB.Text = ""; priceACTB.Text = ""; yearACTB.Text = ""; horsePowerACTB.Text = ""; FuelTypeACTB.Text = ""; isSoldACCB.IsChecked = false; colorACTB.Text = ""; Co2EACTB.Text = ""; parkingSpotACTB.Text = ""; cosumptionACTB.Text = ""; tractionACTB.Text = ""; CilindricalACTB.Text = ""; countFACL.Content = "0"; countPACL.Content = "0"; countFACL.Visibility = Visibility.Hidden; countPACL.Visibility = Visibility.Hidden; 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(); }