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!");
}