private void button1_Click(object sender, EventArgs e)
{
button1.Visible = false;
if(button1.Text.Equals(GetLabel(DictionaryFileName,"StopButton")))
{
// Clean panel
Close_panel();
// Back
comboBox1.Enabled = true;
comboBox2.Enabled = true;
maskedTextBox1.Enabled = true;
radioButton1.Enabled = true;
radioButton2.Enabled = true;
panel4.Visible = true;
radioButton3.Enabled = true;
radioButton4.Enabled = true;
button1.Text = GetLabel(DictionaryFileName, "RunButton");
}
else if (button1.Text.Equals(GetLabel(DictionaryFileName,"RunButton")))
{
List<bool> validation = new List<bool>();
validation.Add(ValidateAsSelectedfromCombobox(comboBox2, label3));
if (radioButton1.Checked == false && radioButton2.Checked == false && radioButton3.Checked == false && radioButton4.Checked == false)
{
validation.Add(false);
ShowError(989, label2.Text.Split(':')[0]);
}
else
{
validation.Add(true);
}
validation.Add(ValidateAsSelectedfromCombobox(comboBox1, label1));
if (CompleteValidation(validation) == true)
{
bool noerror = false;
// Testar conexão
DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
List<string[]> matrix = new List<string[]>();
bool errorShown = false;
try
{
matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, "SELECT * FROM `case`");
if (matrix[0][0].ToLower().Contains("*error*") && matrix[0][0].ToLower().Contains("access denied for user"))
{
ShowError(997, label4.Text.Split(':')[0]);
errorShown = true;
}
else if (matrix[0][0].ToLower().Contains("*error*"))
{
ShowError(984, GetLabel(DictionaryFileName,"InternetConnection"));
errorShown = true;
}
else
{
noerror = true;
}
}
catch
{
if (matrix.Count == 0)
{
// Means that read ok but there isn't anything on the database
noerror = true;
}
}
if (noerror == false)
{
if ( errorShown == false)
{
ShowError(997, label4.Text.Split(':')[0]);
}
}
else
{
comboBox1.Enabled = false;
comboBox2.Enabled = false;
label5.Text = GetLabel(DictionaryFileName, "NoError.OK");
maskedTextBox1.Enabled = false;
radioButton1.Enabled = false;
int operationSelectedValue = -1;
if (radioButton1.Checked == true)
{
operationSelectedValue = 0;
}
radioButton2.Enabled = false;
if (radioButton2.Checked == true)
{
operationSelectedValue = 1;
}
radioButton3.Enabled = false;
if (radioButton3.Checked == true)
{
operationSelectedValue = 2;
}
radioButton4.Enabled = false;
if (radioButton4.Checked == true)
{
operationSelectedValue = 3;
}
GenerateNewForm(maskedTextBox1.Text, comboBox1.SelectedIndex, comboBox2.SelectedIndex, operationSelectedValue);
button1.Text = GetLabel(DictionaryFileName, "StopButton");
}
}
else
{
}
}
else
{
ShowError(992, "dictionary.dat");
}
button1.Visible = true;
}
private List<string[]> GetTransmissionMatrix()
{
DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
List<string[]> matrix = new List<string[]>();
matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text,"SELECT * FROM `case`");
matrix = CaseTransmissionFiltering(matrix);
return matrix;
}
private List<string[]> Query(string msgQuery)
{
List<string[]> matrix = new List<string[]>();
DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, msgQuery);
return matrix;
}
private int GetAreaID(int selectedIndex)
{
if (selectedIndex >= 0)
{
List<string[]> matrix = new List<string[]>();
DatabaseAccess.Query databaseAccess = new DatabaseAccess.Query();
matrix = databaseAccess.query(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, "SELECT * FROM `area`");
try
{
return Convert.ToInt32(matrix[selectedIndex][0]);
}
catch
{
return -1;
}
}
else
{
return -1;
}
}