/// <summary> /// Delete record from the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteTransaction(object sender, RoutedEventArgs e) { if (updatingTransactionID == null) { ShowInformationMessageBox("Select a row to delete", "No row selected"); return; } //Ask user to confirm action MessageBoxResult removeResult = MessageBox.Show("Remove selected object from database?", "Remove", MessageBoxButton.YesNo, MessageBoxImage.Warning, MessageBoxResult.No); if (removeResult == MessageBoxResult.Yes) { CarDealerManagementDBEntities context = new CarDealerManagementDBEntities(); var result = from d in context.TB_TRANSACTIONS where d.ID_TRANSACTION == this.updatingTransactionID select d; TB_TRANSACTIONS obj = result.SingleOrDefault(); if (obj != null) { context.TB_TRANSACTIONS.Remove(obj); context.SaveChanges(); ResetFieldValue(displayCarBox, displayClientBox, datepickerDisplayTransactionDate); updatingTransactionID = null; ReloadGrid(); } } }
/// <summary> /// Add record to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddTransaction(object sender, RoutedEventArgs e) { CarDealerManagementDBEntities db = new CarDealerManagementDBEntities(); //ComboBox SelectedIndex property counts from 0, so we add 1 to match ID TB_TRANSACTIONS transaction = new TB_TRANSACTIONS() { ID_CAR = db.TB_CAR.Where(car => car.ID_CAR == this.comboboxCar.SelectedIndex + 1).Select(car => car.ID_CAR).FirstOrDefault(), ID_CLIENT = db.TB_CLIENT.Where(client => client.ID_CLIENT == this.comboboxClient.SelectedIndex + 1).Select(client => client.ID_CLIENT).FirstOrDefault(), TRANSACTION_DATE = (DateTime)(this.datepickerTransaction.SelectedDate) }; // Add new object to DB db.TB_TRANSACTIONS.Add(transaction); db.SaveChanges(); ResetFieldValue(this.comboboxCar, this.comboboxClient, this.datepickerTransaction); ReloadGrid(); }
public TransactionManager(TB_TRANSACTIONS transaction) { //Build display format string clientBuilder = $"{transaction.TB_CLIENT.NAME}, " + $"{transaction.TB_CLIENT.SURNAME}, " + $"pesel: {transaction.TB_CLIENT.PESEL}, " + $"nip: {transaction.TB_CLIENT.NIP}, " + $"Address: {transaction.TB_CLIENT.TB_ADDRESS.STREET_NUMBER}," + $" {transaction.TB_CLIENT.TB_ADDRESS.CITY}," + $" {transaction.TB_CLIENT.TB_ADDRESS.ZIP_CODE}"; //Build display format string carBuilder = $"{transaction.TB_CAR.TB_CAR_MODEL.CAR_MODEL}, " + $"color: {transaction.TB_CAR.TB_CAR_COLOR.COLOR}, " + $"condition: {transaction.TB_CAR.TB_CAR_CONDITION.CONDITION}, " + $"country: {transaction.TB_CAR.TB_CAR_COUNTRY.COUNTRY}"; this.ID = transaction.ID_TRANSACTION; this.Client = clientBuilder; this.Car = carBuilder; this.DateOfTransaction = transaction.TRANSACTION_DATE; }