private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (selectedType == typeof(Damage))
{
new DamageDAO().Delete((TableView.SelectedItem as Damage).Id);
((List <Rent>)TableView.ItemsSource).Remove((Rent)TableView.SelectedItem);
}
else if (selectedType == typeof(Invoice))
{
new InvoiceDAO().Delete((TableView.SelectedItem as Invoice).Id);
((List <Invoice>)TableView.ItemsSource).Remove((Invoice)TableView.SelectedItem);
}
else if (selectedType == typeof(InvoiceDetail))
{
new InvoiceDetailDAO().Delete((TableView.SelectedItem as InvoiceDetail).Id);
((List <InvoiceDetail>)TableView.ItemsSource).Remove((InvoiceDetail)TableView.SelectedItem);
}
else if (selectedType == typeof(Rent))
{
new RentDAO().Delete((TableView.SelectedItem as Rent).Id);
((List <Rent>)TableView.ItemsSource).Remove((Rent)TableView.SelectedItem);
}
else if (selectedType == typeof(Vehicle))
{
new VehicleDAO().Delete((TableView.SelectedItem as Vehicle).Id);
((List <Vehicle>)TableView.ItemsSource).Remove((Vehicle)TableView.SelectedItem);
}
else if (selectedType == typeof(BankAccount))
{
new BankAccountDAO().Delete((TableView.SelectedItem as BankAccount).Id);
((List <BankAccount>)TableView.ItemsSource).Remove((BankAccount)TableView.SelectedItem);
}
else if (selectedType == typeof(BlackList))
{
new BlackListDAO().Delete((TableView.SelectedItem as BlackList).Id);
((List <BlackList>)TableView.ItemsSource).Remove((BlackList)TableView.SelectedItem);
}
else if (selectedType == typeof(User))
{
new UserDAO().Delete((TableView.SelectedItem as User).Id);
((List <User>)TableView.ItemsSource).Remove((User)TableView.SelectedItem);
}
else if (selectedType == typeof(UserDetails))
{
new UserDetailsDAO().Delete((TableView.SelectedItem as UserDetails).Id);
((List <UserDetails>)TableView.ItemsSource).Remove((UserDetails)TableView.SelectedItem);
}
Notificationlabel.ShowSuccess("entry deleted successfully");
//TableView.Items.Remove(TableView.SelectedItem);
TableView.Items.Refresh();
}
catch (Exception ex)
{
DebugLog.WriteLine(ex);
Notificationlabel.ShowError("Could not delete Data");
}
}
private bool Update(Model model)
{
Type selectedType = model.GetType();
try
{
if (selectedType == typeof(Damage))
{
//Dispatcher.BeginInvoke(new Action(() => new DamageDAO().Update(TableView.SelectedItem as Damage)),
// System.Windows.Threading.DispatcherPriority.Background);
new DamageDAO().Update(model as Damage);
}
else if (selectedType == typeof(Invoice))
{
new InvoiceDAO().Update(model as Invoice);
}
else if (selectedType == typeof(InvoiceDetail))
{
new InvoiceDetailDAO().Update(model as InvoiceDetail);
}
else if (selectedType == typeof(Rent))
{
new RentDAO().Update(model as Rent);
}
else if (selectedType == typeof(Vehicle))
{
new VehicleDAO().Update(model as Vehicle);
}
else if (selectedType == typeof(BankAccount))
{
new BankAccountDAO().Update(model as BankAccount);
}
else if (selectedType == typeof(BlackList))
{
new BlackListDAO().Update(model as BlackList);
}
else if (selectedType == typeof(User))
{
new UserDAO().Update(model as User);
}
else if (selectedType == typeof(UserDetails))
{
new UserDetailsDAO().Update(model as UserDetails);
}
return(true);
}
catch (Exception ex)
{
Notificationlabel.ShowError("Could not edit Data " + model.GetType().Name + " : " + ex.Message);
return(false);
}
}
private bool Insert(Model model)
{
Type selectedType = model.GetType();
try
{
if (selectedType == typeof(Damage))
{
new DamageDAO().Insert(model as Damage);
}
else if (selectedType == typeof(Invoice))
{
new InvoiceDAO().Insert(model as Invoice);
}
else if (selectedType == typeof(InvoiceDetail))
{
new InvoiceDetailDAO().Insert(model as InvoiceDetail);
}
else if (selectedType == typeof(Rent))
{
new RentDAO().Insert(model as Rent);
}
else if (selectedType == typeof(Vehicle))
{
new VehicleDAO().Insert(model as Vehicle);
}
else if (selectedType == typeof(BankAccount))
{
new BankAccountDAO().Insert(model as BankAccount);
}
else if (selectedType == typeof(BlackList))
{
new BlackListDAO().Insert(model as BlackList);
}
else if (selectedType == typeof(User))
{
new UserDAO().Insert(model as User);
}
else if (selectedType == typeof(UserDetails))
{
new UserDetailsDAO().Insert(model as UserDetails);
}
return(true);
}
catch (Exception ex)
{
Notificationlabel.ShowError("Could not insert Data " + model.GetType().Name + " : " + ex.Message);
return(false);
}
}
private void UpdateButton_Click(object sender, RoutedEventArgs e)
{
if (objectsToUpdate.Count == 0)
{
Notificationlabel.ShowSuccess("Everything up to date");
return;
}
if (!rowEdited)
{
Notificationlabel.ShowError("Please First Press Enter to commit changes!");
rowEdited = true;
return;
}
Dictionary <Model, bool> successfulEdit = new Dictionary <Model, bool>();
foreach (Model model in objectsToUpdate.Keys)
{
if (objectsToUpdate[model] == Action.UPDATE)
{
successfulEdit.Add(model, Update(model));
}
else
{
successfulEdit.Add(model, Insert(model));
}
}
foreach (Model model in successfulEdit.Keys)
{
if (successfulEdit[model])
{
objectsToUpdate.Remove(model);
}
}
Notificationlabel.ShowSuccess("Update successfull");
TableView.Items.Refresh();
}
private void DatabaseComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
selectedType = (Type)DatabaseComboBox.SelectedItem;
GridView gridView = new GridView();
foreach (PropertyInfo property in selectedType.GetProperties())
{
gridView.Columns.Add(new GridViewColumn
{
Header = property.Name,
DisplayMemberBinding = new Binding(property.Name),
});
}
try
{
if (selectedType == typeof(Damage))
{
//ObservableCollection<Damage> ObsCollection =
// new ObservableCollection<Damage>();
//obsCollection.CollectionChanged +=
// new System.Collections.Specialized.NotifyCollectionChangedEventHandler(TableDataChanged);
this.TableView.ItemsSource = new DamageDAO().GetDamages();
}
else if (selectedType == typeof(Invoice))
{
this.TableView.ItemsSource = new InvoiceDAO().GetInvoices();
}
else if (selectedType == typeof(InvoiceDetail))
{
this.TableView.ItemsSource = new InvoiceDetailDAO().GetInvoiceDetails();
}
else if (selectedType == typeof(Rent))
{
this.TableView.ItemsSource = new RentDAO().GetRents();
}
else if (selectedType == typeof(Vehicle))
{
this.TableView.ItemsSource = new VehicleDAO().GetVehicles();
}
else if (selectedType == typeof(BankAccount))
{
this.TableView.ItemsSource = new BankAccountDAO().GetBankAccounts();
}
else if (selectedType == typeof(BlackList))
{
this.TableView.ItemsSource = new BlackListDAO().GetBlackLists();
}
else if (selectedType == typeof(User))
{
this.TableView.ItemsSource = new UserDAO().GetUsers();
}
else if (selectedType == typeof(UserDetails))
{
this.TableView.ItemsSource = new UserDetailsDAO().GetUserDetails();
}
}
catch (Exception ex)
{
Notificationlabel.ShowError("Something went wrong. Could not display data!");
DebugLog.WriteLine(ex);
}
numOfRecords = ((ICollection)TableView.ItemsSource).Count;
}