private void button4_Click_1(object sender, EventArgs e)
{
List<bool> validationList = new List<bool>();
validationList.Add(ValidateAsSelectedfromCombobox(comboBox4, label24));
validationList.Add(ValidateAsNotNullText(textBox13, label23));
double minLimit = 0;
validationList.Add(ValidateAsDouble(textBox7, label21, out minLimit));
double maxLimit = 0;
validationList.Add(ValidateAsDouble(textBox4, label19, out maxLimit));
double desiredVoltage = 0;
validationList.Add(ValidateAsDouble(textBox11, label16, out desiredVoltage));
double voltageBase = 0;
validationList.Add(ValidateAsDouble(textBox3, label12, out voltageBase));
double phase = 0;
validationList.Add(ValidateAsDouble(textBox12, label11, out phase));
double voltage = 0;
validationList.Add(ValidateAsDouble(textBox2, label10, out voltage));
int sequencialNumber = 0;
validationList.Add(ValidateAsInt(textBox8,label9,out sequencialNumber));
int busNumber = 0;
validationList.Add(ValidateAsInt(textBox1,label9,out busNumber));
validationList.Add(ValidateAsSelectedfromCombobox(comboBox3, label7));
if(CompleteValidation(validationList)==true)
{
int caseID = GetTransmissionCaseID(comboBox3.SelectedIndex);
int areaID = GetAreaID(comboBox4.SelectedIndex);
DatabaseAccess.Insert databaseAccess = new DatabaseAccess.Insert();
string returnedMsg = databaseAccess.insert(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, "INSERT INTO `sql583577`.`bus` (`busNumber`, `caseID`, `sequencialNumber`, `busName`, `Voltage`, `phase`, `voltageBase`, `desiredVoltage`, `maxReactivePower`, `minReactivePower`, `areaID`) VALUES ('" + busNumber.ToString() + "', '" + caseID.ToString() + "', '" + sequencialNumber.ToString() + "', '" + textBox13.Text + "', '" + voltage.ToString().Replace(',', '.') + "', '" + phase.ToString().Replace(',', '.') + "', '" + voltageBase.ToString().Replace(',', '.') + "', '" + desiredVoltage.ToString().Replace(',', '.') + "', '" + maxLimit.ToString().Replace(',', '.') + "', '" + minLimit.ToString().Replace(',', '.') + "', '" + areaID.ToString() + "');");
if (returnedMsg.ToLower().Equals("ok"))
{
showMsg(GetLabel(DictionaryFileName, "InsertSuccess"));
comboBox3.Text = string.Empty;
textBox1.Text = string.Empty;
textBox8.Text = string.Empty;
textBox2.Text = string.Empty;
textBox12.Text = string.Empty;
textBox3.Text = string.Empty;
textBox11.Text = string.Empty;
textBox4.Text = string.Empty;
textBox7.Text = string.Empty;
textBox13.Text = string.Empty;
comboBox4.Text = string.Empty;
}
else
{
ShowInsertError(returnedMsg);
}
}
}
private string Insert(string insertMsg)
{
DatabaseAccess.Insert databaseAccess = new DatabaseAccess.Insert();
return databaseAccess.insert(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, insertMsg);
}
private void button2_Click_1(object sender, EventArgs e)
{
List<bool> validationList = new List<bool>();
string publicationDate = string.Empty;
publicationDate = dateTimePicker2.Value.Year.ToString() + "-" + dateTimePicker2.Value.Month.ToString() + "-" + dateTimePicker2.Value.Day.ToString();
string caseDate = string.Empty;
caseDate = dateTimePicker1.Value.Year.ToString() + "-" + dateTimePicker1.Value.Month.ToString() + "-" + dateTimePicker1.Value.Day.ToString();
double powerBase = 0;
validationList.Add(ValidateAsDouble(textBox6, label14, out powerBase));
validationList.Add(ValidateAsNotNullRichText(richTextBox2, label13));
validationList.Add(ValidateAsNotNullText(textBox5, label15));
if(CompleteValidation(validationList)==true)
{
DatabaseAccess.Insert databaseAccess = new DatabaseAccess.Insert();
string returnedMsg = databaseAccess.insert(GetLabel("config.ini", "Host"), GetLabel("config.ini", "UserID"), GetLabel("config.ini", "DatabaseName"), maskedTextBox1.Text, "INSERT INTO `sql583577`.`case` (`title`, `description`, `powerBase`, `caseDate`, `publicationDate`, `systemType`) VALUES ('" + textBox5.Text + "', '" + richTextBox2.Text + "', '" + textBox6.Text.Replace(',', '.') + "', '" + caseDate + "', '" + publicationDate + "', 'TRANSMISSION');");
//ValidateInsert(returnedMsg);
if (returnedMsg.ToLower().Equals("ok"))
{
showMsg(GetLabel(DictionaryFileName, "InsertSuccess"));
textBox5.Text = string.Empty;
richTextBox2.Text = string.Empty;
textBox6.Text = string.Empty;
}
else
{
ShowError(992, returnedMsg);
}
}
}
