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