//######################## UI events ######################## void SelectQuestionsListItem(object sender, MouseEventArgs e) { if (questionsListBox.SelectedItems.Count == 0) { return; } DepartmentQuestion question; question = (DepartmentQuestion)questionsListBox.SelectedItems[0]; if (question == null) { activeQuestion = null; UI_UpdateList(); return; } question = DepartmentDatabaseHandler.GetQuestion(question.id); if (question == null) { activeQuestion = null; UI_UpdateList(); return; } UI_UpdateQuestionInfo(question); }
//######################## UI updates ######################## //Updates questions list void UI_UpdateList() { //Caso seja invocado por outro thread Invoke((MethodInvoker) delegate { questionsListBox.Items.Clear(); List <DepartmentQuestion> questionsList = DepartmentDatabaseHandler.GetAllQuestions(); if (questionsList != null) { for (int i = 0; i < questionsList.Count; i++) { questionsListBox.Items.Add(questionsList[i]); } } }); }
void AnswerBtnClick(object sender, EventArgs e) { if (activeQuestion == null || answerTxt.Text == "") { return; } if (ticketService.AnswerQuestion(activeQuestion.serverQuestionId, answerTxt.Text)) { DepartmentDatabaseHandler.RemoveQuestion(activeQuestion.id); activeQuestion = null; answerBtn.Enabled = false; questionTitleTxt.Text = ""; questionDetailsTxt.Text = ""; notificationServiceClient.SendMessage(EventOperation.QUESTION_ANSWERED, userId, ""); UI_UpdateList(); } }
void UI_LBOX() { if (InvokeRequired) { BeginInvoke(new MethodInvoker(() => UI_LBOX())); } else { questionsListBox.Items.Clear(); List <DepartmentQuestion> questionsList = DepartmentDatabaseHandler.GetAllQuestions(); if (questionsList != null) { for (int i = 0; i < questionsList.Count; i++) { questionsListBox.Items.Add(questionsList[i]); } } } }
static void Main(string[] args) { DatabaseHandlerFactory factory; Console.WriteLine("Enter Input as described below:"); Console.WriteLine("Enter " + (int)Databases.SQL + " to create a SQL database handler for employee"); Console.WriteLine("Enter " + (int)Databases.MYSQL + " to create a MYSQL database handler for employee"); Console.WriteLine("Enter " + (int)Databases.NOSQL + " to create a NOSQL database handler for employee"); Console.WriteLine("Input: "); DatabaseHandler handler = null; var input = Console.ReadLine(); int database = int.Parse(input); if (database == (int)Databases.MYSQL) { factory = MYSQLDatabaseHandlerFactory.GetInstance(); } else if (database == (int)Databases.NOSQL) { factory = NOSQLDatabaseHandlerFactory.GetInstance(); } else { factory = SQLDatabaseHandlerFactory.GetInstance(); } EmployeeDatabaseHandler employeeHandler = factory.GetDatabaseHandler().GetEmployeeDatabaseHandler(); DepartmentDatabaseHandler departmentHandler = factory.GetDatabaseHandler().GetDepartmentDatabaseHandler(); employeeHandler.CreateEmployee(); employeeHandler.DeleteEmployee(); employeeHandler.GetEmployee(); employeeHandler.UpdateEmployee(); departmentHandler.CreateDepartment(); departmentHandler.DeleteDepartment(); departmentHandler.GetDepartment(); departmentHandler.UpdateDepartment(); }
void DebugTestes() { string msg = "\n\n\n------------------ Debug: ------------------\n"; msg += "\n################## Questions ##################\n"; if (DepartmentDatabaseHandler.AddQuestion("T1", "quest1", 1, 3)) { msg += "1: OK\n"; } else { msg += "1: ERROR\n"; } if (DepartmentDatabaseHandler.AddQuestion("T2", "quest2", 1, 3)) { msg += "2: OK\n"; } else { msg += "2: ERROR\n"; } if (DepartmentDatabaseHandler.GetQuestion(1).title == "T1" && DepartmentDatabaseHandler.GetQuestion(1).question == "quest1" && DepartmentDatabaseHandler.GetQuestion(1).serverQuestionId == 1 && DepartmentDatabaseHandler.GetQuestion(1).ticketId == 3) { msg += "3: OK\n"; } else { msg += "3: ERROR\n"; } if (DepartmentDatabaseHandler.GetAllQuestions(3).Count == 2) { msg += "4: OK\n"; } else { msg += "4: ERROR\n"; } if (DepartmentDatabaseHandler.RemoveQuestion(1)) { msg += "5: OK\n"; } else { msg += "5: ERROR\n"; } if (DepartmentDatabaseHandler.GetAllQuestions(3).Count == 1) { msg += "6: OK\n"; } else { msg += "6: ERROR\n"; } if (!DepartmentDatabaseHandler.IsAllQuestionsAnswered(3)) { msg += "7: OK\n"; } else { msg += "7: ERROR\n"; } if (DepartmentDatabaseHandler.RemoveQuestion(2)) { msg += "8: OK\n"; } else { msg += "8: ERROR\n"; } if (DepartmentDatabaseHandler.GetAllQuestions(3) == null) { msg += "9: OK\n"; } else { msg += "9: ERROR\n"; } if (DepartmentDatabaseHandler.IsAllQuestionsAnswered(3)) { msg += "10: OK\n"; } else { msg += "10: ERROR\n"; } Console.WriteLine("\n\n\n" + msg); }