private void ButtonDelete_Click(object sender, RoutedEventArgs e) { //Code that deletes a project from Db bool result = CBZ.DeleteFromDb("Enterprises", CBZ.TempEnterprise.Id.ToString()); CBZ.TempEnterprise = new Enterprise(); if (result) { //Show Confirmation MessageBox.Show("Entrepriselisten blev slettet", "Entrepriser", MessageBoxButton.OK, MessageBoxImage.Information); //Reset Boxes TextBoxName.Text = ""; TextBoxElaboration.Text = ""; TextBoxOfferList.Text = ""; ComboBoxCraftGroup1.SelectedIndex = -1; ComboBoxCraftGroup2.SelectedIndex = -1; ComboBoxCraftGroup3.SelectedIndex = -1; ComboBoxCraftGroup4.SelectedIndex = -1; //Update Enterprise List RefreshIndexedEnterprises(); ListBoxEnterprises.ItemsSource = ""; ListBoxEnterprises.ItemsSource = IndexedEnterprises; } else { //Show error MessageBox.Show("Databasen returnerede en fejl. Entrepriselisten blev ikke slettet. Prøv igen.", "Entrepriser", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void ButtonErase_Click(object sender, RoutedEventArgs e) { if (CheckBoxEraseProject.IsChecked == true) { if (MessageBox.Show("Er du sikker på, at du vil slette projektet? Alle data vil gå tabt!", "Slet Projekt", MessageBoxButton.OKCancel, MessageBoxImage.Warning) == MessageBoxResult.OK) { // Code that changes project status bool result = Bizz.DeleteFromDb("Projects", Bizz.TempProject.Id.ToString()); if (result) { foreach (Enterprise enterprise in Bizz.EnterpriseList) { if (enterprise.Project.Id == Bizz.TempProject.CaseId) { foreach (SubEntrepeneur subEntrepeneur in Bizz.SubEntrepeneurs) { if (subEntrepeneur.EnterpriseList.Id == enterprise.Id) { Bizz.DeleteFromDb("Requests", subEntrepeneur.Request.Id.ToString()); Bizz.DeleteFromDb("IttLetters", subEntrepeneur.IttLetter.Id.ToString()); Bizz.DeleteFromDb("Offers", subEntrepeneur.Offer.Id.ToString()); Bizz.DeleteFromDb("SubEntrepeneurs", subEntrepeneur.Id.ToString()); } } Bizz.DeleteFromDb("EnterpriseList", enterprise.Id.ToString()); } } //Show Confirmation MessageBox.Show("Projektet blev slettet", "Slet Projekt", MessageBoxButton.OK, MessageBoxImage.Information); //Update list of projects Bizz.RefreshList("Projects"); Bizz.RefreshIndexedList("IndexedActiveProjects"); Bizz.RefreshIndexedList("IndexableProjects"); //Close right UserControl Bizz.UcRightActive = false; UcRight.Content = new UserControl(); } else { //Show error MessageBox.Show("Databasen returnerede en fejl. Projektet blev ikke slettet. Prøv igen.", "Slet Projekt", MessageBoxButton.OK, MessageBoxImage.Information); } } } else { //Show error MessageBox.Show("Du har glemt at markere 'Godkend sletning af projekt'.", "Slet Projekt", MessageBoxButton.OK, MessageBoxImage.Information); } }
/// <summary> /// Method, that deletes the selected Contact from Db /// </summary> /// <returns>bool</returns> private bool DeleteContactFromDb() { bool result = false; try { bool tempResult = CBZ.DeleteFromDb("Contacts", CBZ.TempContact.Id.ToString()); result = true; } catch (Exception ex) { MessageBox.Show(CBZ.TempContact.Person.Name + " kunne ikke slettes, da den er tilknyttet en Entrepenør." + ex, "Kontakter", MessageBoxButton.OK, MessageBoxImage.Error); } return(result); }
private void ButtonDelete_Click(object sender, RoutedEventArgs e) { bool allSubEntrepeneursDeleted = true; bool allRequestsDeleted = true; bool allIttLettersDeleted = true; bool allOffersDeleted = true; bool allEnterprisesDeleted = true; bool someSubEntrepeneursDeleted = false; bool someRequestsDeleted = false; bool someIttLettersDeleted = false; bool someOffersDeleted = false; bool someEnterprisesDeleted = false; bool result = false; if (CheckBoxEraseProject.IsChecked == true) { if (MessageBox.Show("Er du sikker på, at du vil slette projektet? Alle projektets data inkl. entrepriser & underentrepenører vil gå tabt!", "Projekter", MessageBoxButton.OKCancel, MessageBoxImage.Warning) == MessageBoxResult.OK) { try { foreach (Enterprise enterprise in CBZ.Enterprises) { if (enterprise.Project.Id == CBZ.TempProject.Case) { foreach (SubEntrepeneur subEntrepeneur in CBZ.SubEntrepeneurs) { if (subEntrepeneur.Enterprise.Id == enterprise.Id) { SubEntrepeneur sub = new SubEntrepeneur(subEntrepeneur); // Code that deletes SubEntrepeneur bool subEntrepeneurDeleted = CBZ.DeleteFromDb("SubEntrepeneurs", sub.Id.ToString()); if (subEntrepeneurDeleted && !someSubEntrepeneursDeleted) { someSubEntrepeneursDeleted = true; // Code that deletes Request bool requestDeleted = CBZ.DeleteFromDb("Requests", sub.Request.Id.ToString()); if (requestDeleted && !someRequestsDeleted) { someRequestsDeleted = true; } else if (!requestDeleted && allRequestsDeleted) { allRequestsDeleted = false; } // Code that deletes IttLetter bool ittLetterDeleted = CBZ.DeleteFromDb("IttLetters", sub.IttLetter.Id.ToString()); if (ittLetterDeleted && !someIttLettersDeleted) { someIttLettersDeleted = true; } else if (!ittLetterDeleted && allIttLettersDeleted) { allIttLettersDeleted = false; } // Code that deletes Offer bool offerDeleted = CBZ.DeleteFromDb("Offers", sub.Offer.Id.ToString()); if (offerDeleted && !someOffersDeleted) { someOffersDeleted = true; } else if (!offerDeleted && allOffersDeleted) { allOffersDeleted = false; } } else if (!someSubEntrepeneursDeleted && allSubEntrepeneursDeleted) { allSubEntrepeneursDeleted = false; allRequestsDeleted = false; allIttLettersDeleted = false; allOffersDeleted = false; } } } // Code that deletes Enterprise if (someSubEntrepeneursDeleted) { bool enterpriseDeleted = CBZ.DeleteFromDb("Enterprises", enterprise.Id.ToString()); if (enterpriseDeleted && !someEnterprisesDeleted) { someEnterprisesDeleted = true; } else if (!enterpriseDeleted && allEnterprisesDeleted) { allEnterprisesDeleted = false; } } } if (someEnterprisesDeleted) { // Code that deletes Project result = CBZ.DeleteFromDb("Projects", CBZ.TempProject.Id.ToString()); if (result) { //Show results ShowDependencystatus(allSubEntrepeneursDeleted, allRequestsDeleted, allIttLettersDeleted, allOffersDeleted, allEnterprisesDeleted, someSubEntrepeneursDeleted, someRequestsDeleted, someIttLettersDeleted, someOffersDeleted, someEnterprisesDeleted); MessageBox.Show("Projektet blev slettet", "Projekter", MessageBoxButton.OK, MessageBoxImage.Information); } else { //Show results ShowDependencystatus(allSubEntrepeneursDeleted, allRequestsDeleted, allIttLettersDeleted, allOffersDeleted, allEnterprisesDeleted, someSubEntrepeneursDeleted, someRequestsDeleted, someIttLettersDeleted, someOffersDeleted, someEnterprisesDeleted); MessageBox.Show("Projektet blev ikke slettet", "Projekter", MessageBoxButton.OK, MessageBoxImage.Error); } } //Reset form ComboBoxCaseId.SelectedIndex = -1; CheckBoxEraseProject.IsChecked = false; //Update list of projects CBZ.RefreshIndexedList("SubEntrepeneurs"); } } catch (Exception ex) { //Show results ShowDependencystatus(allSubEntrepeneursDeleted, allRequestsDeleted, allIttLettersDeleted, allOffersDeleted, allEnterprisesDeleted, someSubEntrepeneursDeleted, someRequestsDeleted, someIttLettersDeleted, someOffersDeleted, someEnterprisesDeleted); MessageBox.Show("Databasen returnerede en fejl. Projektet blev ikke slettet. Prøv igen.\n" + ex, "Projekter", MessageBoxButton.OK, MessageBoxImage.Error); } } } else { //Show error MessageBox.Show("Du har glemt at markere 'Godkend sletning af projekt'.", "Projekter", MessageBoxButton.OK, MessageBoxImage.Error); } }