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