public DeleteCar()
{
InitializeComponent();
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
var cars = from c in db.cars
select new
{
carID = c.car_id,
carBrand = c.brand,
carModel = c.model,
carPrice = c.price,
carColour = c.colour,
carProd = c.prod_date
};
foreach (var item in cars)
{
Console.WriteLine(item.carBrand);
Console.WriteLine(item.carModel);
Console.WriteLine(item.carColour);
Console.WriteLine(item.carPrice);
Console.WriteLine(item.carProd);
}
this.gridCars.ItemsSource = cars.ToList();
}
public ShowSale()
{
InitializeComponent();
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
var sales = from s in db.sales
select new
{
customerName = s.customer.name,
customerSurname = s.customer.surname,
carBrand = s.car.brand,
carModel = s.car.model,
carColour = s.car.colour,
carProd = s.car.prod_date,
transactionAmount = s.transaction_amount,
onCompany = s.on_company,
dealerID = s.dealer.dealer_id,
};
foreach (var item in sales)
{
Console.WriteLine(item.customerName);
Console.WriteLine(item.customerSurname);
Console.WriteLine(item.carBrand);
Console.WriteLine(item.carColour);
Console.WriteLine(item.transactionAmount);
Console.WriteLine(item.onCompany);
Console.WriteLine(item.dealerID);
}
this.gridSales.ItemsSource = sales.ToList();
}
private void AddSaleFn(object sender, RoutedEventArgs e)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
var sales = from s in db.sales
select new
{
transactionAmountC = s.car.price,
};
byte onFirm = IfOnFirm((bool)(checkCompany.IsChecked));
sale saleObj = new sale()
{
customer_id = int.Parse(txtClient.Text),
dealer_id = int.Parse(txtDealer.Text),
car_id = int.Parse(txtCar.Text),
transaction_amount = GetCarPrice(int.Parse(txtCar.Text), (bool)(checkCompany.IsChecked)),
on_company = onFirm,
};
db.sales.Add(saleObj);
db.SaveChanges();
MessageBox.Show("Sale added");
}
private void DelBtn(object sender, RoutedEventArgs e)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
var s = from c in db.cars
where c.car_id == this.cid
select c;
car obj = s.SingleOrDefault();
if (obj != null)
{
db.cars.Remove(obj);
db.SaveChanges();
}
}
private void RegisterDealerFn(object sender, RoutedEventArgs e)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
dealer dealerObj = new dealer()
{
name = txtName.Text,
surname = txtSurname.Text,
pesel = txtPesel.Text,
employment_date = int.Parse(txtDate.Text),
};
db.dealers.Add(dealerObj);
db.SaveChanges();
MessageBox.Show("Dealer registered!");
}
private void AddCarFn(object sender, RoutedEventArgs e)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
car carObj = new car()
{
brand = txtBrand.Text,
model = txtModel.Text,
colour = txtColour.Text,
prod_date = int.Parse(txtProd.Text),
price = decimal.Parse(txtPrice.Text),
};
db.cars.Add(carObj);
db.SaveChanges();
MessageBox.Show("Car added!");
}
private void RegisterCustomerFn(object sender, RoutedEventArgs e)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
customer customerObj = new customer()
{
name = txtName.Text,
surname = txtSurname.Text,
pesel = txtPesel.Text,
nip = txtNip.Text,
city = txtCity.Text,
};
db.customers.Add(customerObj);
db.SaveChanges();
MessageBox.Show("Customer registered!");
}
private decimal GetCarPrice(int car_id, bool infor)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
var s = from c in db.cars
where c.car_id == car_id
select c;
car obj = s.SingleOrDefault();
decimal price = obj.price;
decimal multiplyValue = Convert.ToDecimal(0.81);
if (infor == true)
{
return(price * multiplyValue);
}
else
{
return(price);
}
}
/// <summary>
/// Initializing WPF component and then after connecting to database shows data grids
/// </summary>
public AddSale()
{
InitializeComponent();
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
var cars = from c in db.cars
select new
{
carID = c.car_id,
carBrand = c.brand,
carModel = c.model,
carPrice = c.price,
carColour = c.colour,
carProd = c.prod_date
};
foreach (var item in cars)
{
Console.WriteLine(item.carID);
Console.WriteLine(item.carBrand);
Console.WriteLine(item.carModel);
Console.WriteLine(item.carColour);
Console.WriteLine(item.carPrice);
Console.WriteLine(item.carProd);
}
this.gridCars.ItemsSource = cars.ToList();
var clients = from cl in db.customers
select new
{
customerID = cl.customer_id,
customerName = cl.name,
customerSurname = cl.surname,
customerCity = cl.city,
customerNIP = cl.nip,
};
foreach (var item in cars)
{
Console.WriteLine(item.carBrand);
Console.WriteLine(item.carModel);
Console.WriteLine(item.carColour);
Console.WriteLine(item.carPrice);
Console.WriteLine(item.carProd);
}
this.gridClients.ItemsSource = clients.ToList();
var dealers = from d in db.dealers
select new
{
dealersID = d.dealer_id,
dealersName = d.name,
dealersSurname = d.surname,
};
foreach (var item in dealers)
{
Console.WriteLine(item.dealersID);
Console.WriteLine(item.dealersName);
Console.WriteLine(item.dealersSurname);
}
this.gridDealers.ItemsSource = dealers.ToList();
}
private void RefreshFn(object sender, RoutedEventArgs e)
{
CarDealershipAppDBEntities db = new CarDealershipAppDBEntities();
this.gridCars.ItemsSource = db.cars.ToList();
}
