private void Delete_Click(object sender, RoutedEventArgs e) { try { getSelectedProject(); if (IsProjectHasChild()) { new MessageBoxCustom("Selected User Story has Issues attached you need to clear these issues to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } bool?Result = new MessageBoxCustom("Are you sure to delete Selected Project? ", MessageBoxCustom.MessageType.Confirmation, MessageBoxCustom.MessageButtons.YesNo).ShowDialog(); if (Result.Value) { Project SelectedProject = Globals.simpleJiraDB.Projects.Where(p => p.Name.Equals(tbProjectName.Text)).FirstOrDefault(); Globals.simpleJiraDB.Projects.Remove(SelectedProject); Globals.simpleJiraDB.SaveChanges(); Globals.AppWindow.LoadDataFromDb(Globals.currentUser); } else { return; } } catch (SqlException ex) { new MessageBoxCustom("Error Deleting Project from database:\n" + ex.Message, MessageBoxCustom.MessageType.Error, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } }
private void btDeleteUser_Click(object sender, RoutedEventArgs e) { try { if ((string.IsNullOrEmpty(cmbUserList.Text)) || (string.IsNullOrEmpty(cmbTeamList.Text))) { new MessageBoxCustom("Please choose user to delete", MessageBoxCustom.MessageType.Info, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } Team team = Globals.simpleJiraDB.Teams.Where(t => t.Name.Equals(cmbTeamList.SelectedItem.ToString())).FirstOrDefault <Team>(); if (team != null) { User userDelete = Globals.simpleJiraDB.Users.Where(u => u.LoginName.Equals(cmbUserList.SelectedItem.ToString())).Where(ut => ut.TeamId == team.TeamId).FirstOrDefault <User>(); int userStoryCount = Globals.simpleJiraDB.UserStories.Include("User").Where(ust => ust.OwnerId == userDelete.UserId).ToList <UserStory>().Count; int issueCount = Globals.simpleJiraDB.Issues.Include("User").Where(iss => iss.OwnerId == userDelete.UserId).ToList <Issue>().Count; if (issueCount == 0 && userStoryCount == 0) { if (userDelete != null) { bool?Result = new MessageBoxCustom("Are you sure to delete this user? ", MessageBoxCustom.MessageType.Confirmation, MessageBoxCustom.MessageButtons.YesNo).ShowDialog(); if (Result.Value) { Globals.simpleJiraDB.Users.Remove(userDelete); Globals.simpleJiraDB.SaveChanges(); new MessageBoxCustom("User Deleted", MessageBoxCustom.MessageType.Info, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); ResetAndLoadDataFromDB(); //if (currentUserInDialog != null) //{ // this.DialogResult = true; // TeamUserUpdateCallback?.Invoke(currentUserInDialog); //} } } else { new MessageBoxCustom("Cannot find User to Delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } else { new MessageBoxCustom("Please clear related Issue and UserStory before delete User", MessageBoxCustom.MessageType.Info, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } } catch (SqlException ex) { new MessageBoxCustom("Error Deleting User from database:\n" + ex.Message, MessageBoxCustom.MessageType.Error, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } }
private void btDeleteTeam_Click(object sender, RoutedEventArgs e) { try { Team teamDelete = Globals.simpleJiraDB.Teams.Where(t => t.Name.Equals(cmbNewTeamList.Text)).FirstOrDefault <Team>(); if (teamDelete != null) { int userCount = Globals.simpleJiraDB.Users.Include("Team").Where(u => u.TeamId == teamDelete.TeamId).ToList <User>().Count; int projectCount = Globals.simpleJiraDB.Projects.Include("Team").Where(p => p.TeamId == teamDelete.TeamId).ToList <Project>().Count; if (userCount == 0 && projectCount == 0) { bool?Result = new MessageBoxCustom("Are you sure to delete this Team? ", MessageBoxCustom.MessageType.Confirmation, MessageBoxCustom.MessageButtons.YesNo).ShowDialog(); if (Result.Value) { Globals.simpleJiraDB.Teams.Remove(teamDelete); Globals.simpleJiraDB.SaveChanges(); new MessageBoxCustom("Team deleted", MessageBoxCustom.MessageType.Info, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); ResetAndLoadDataFromDB(); //if (currentUserInDialog != null) //{ // this.DialogResult = true; // TeamUserUpdateCallback?.Invoke(currentUserInDialog); //} } } else { new MessageBoxCustom("Please remove the projects and users under this team before delete", MessageBoxCustom.MessageType.Info, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } } else { new MessageBoxCustom("Cannot find team to Delete", MessageBoxCustom.MessageType.Info, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } catch (SqlException ex) { new MessageBoxCustom("Error Deleting User from database:\n" + ex.Message, MessageBoxCustom.MessageType.Error, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } }
private void btDelete_Click(object sender, RoutedEventArgs e) { if (SprintView.IsVisible) { try { if (SprintListView.SelectedIndex == -1) { new MessageBoxCustom("Select Sprint to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } else { Globals.SelectedSprint = Globals.currentSprintList[SprintListView.SelectedIndex]; if (IsSprintHasChild()) { new MessageBoxCustom("Selected Sprint has User Stories attached, you need to clear these User Stories to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } } bool?Result = new MessageBoxCustom("Are you sure to delete Selected Sprint? ", MessageBoxCustom.MessageType.Confirmation, MessageBoxCustom.MessageButtons.YesNo).ShowDialog(); if (Result.Value) { Globals.simpleJiraDB.Sprints.Remove(Globals.SelectedSprint); Globals.simpleJiraDB.SaveChanges(); LoadDataFromDb(Globals.currentUser); } else { return; } } catch (SqlException ex) { new MessageBoxCustom("Error Deleting Sprint from database:\n" + ex.Message, MessageBoxCustom.MessageType.Error, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } if (UserStoryView.IsVisible) { try { if (UserStoryListView.SelectedIndex == -1) { new MessageBoxCustom("Select User Story to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } else { Globals.SelectedUserStory = Globals.currentUserStoryList[UserStoryListView.SelectedIndex]; if (IsUserStoryHasChild()) { new MessageBoxCustom("Selected User Story has Issues attached you need to clear these issues to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } } bool?Result = new MessageBoxCustom("Are you sure to delete Selected User Story? ", MessageBoxCustom.MessageType.Confirmation, MessageBoxCustom.MessageButtons.YesNo).ShowDialog(); if (Result.Value) { Globals.simpleJiraDB.UserStories.Remove(Globals.SelectedUserStory); Globals.simpleJiraDB.SaveChanges(); LoadDataFromDb(Globals.currentUser); } else { return; } } catch (SqlException ex) { new MessageBoxCustom("Error Deleting User Story from database:\n" + ex.Message, MessageBoxCustom.MessageType.Error, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } if (IssueView.IsVisible) { try { if (IssueListView.SelectedIndex < 0) { new MessageBoxCustom("Select Issue to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); return; } IssueListItem currentIssue = (IssueListItem)IssueListView.SelectedItem; Issue issueDelete = Globals.simpleJiraDB.Issues.Where(iss => iss.IssueId == currentIssue.IssueId).FirstOrDefault <Issue>(); if (issueDelete != null) { bool?Result = new MessageBoxCustom("Are you sure to delete this Team? ", MessageBoxCustom.MessageType.Confirmation, MessageBoxCustom.MessageButtons.YesNo).ShowDialog(); if (Result.Value) { Globals.simpleJiraDB.Issues.Remove(issueDelete); Globals.simpleJiraDB.SaveChanges(); LoadDataFromDb(Globals.currentUser); } } else { new MessageBoxCustom("Cannot find Issue to delete", MessageBoxCustom.MessageType.Warning, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } catch (SqlException ex) { new MessageBoxCustom("Error Deleting Issue from database:\n" + ex.Message, MessageBoxCustom.MessageType.Error, MessageBoxCustom.MessageButtons.Ok).ShowDialog(); } } }