//######################## 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);
}
