private void buttonTest_Click(object sender, EventArgs e)
{
NameTest = textBoxNameTest.Text;
string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=cp1251";
MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect);
MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand();
myConnection.Open();
myCommand.Connection = myConnection;
myCommand.CommandText = string.Format("SELECT id FROM teacher WHERE login='******'", Main.LoginGlobal);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
int idtecher = (int)myCommand.ExecuteScalar(); //результат запроса
myCommand.CommandText = string.Format("INSERT INTO tests (idteacher,NameTest) " + "VALUES('{0}','{1}')", idtecher, NameTest);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
idtests = (int)myCommand.LastInsertedId; //получаем id
if (CheckPDF == true)
{
checkFolderFtp(url);
WebClient myWebClient = new WebClient();
Uri ftp_path = new Uri("ftp://*****:*****@31.31.196.162" + url + fileName); // file.txt - файл, который будет в конечном итоге залит; FTPLOGIN - логин к FTP; PASSWORD - пароль к FTP; LOGIN и PASSWORD разделяются двоеточием.
myWebClient.UploadFile(ftp_path, urlName); // anyfile.txt - загружаемый файл на FTP; C:/Files... - путь к загружаемому файлу; ftp_path - конечный путь и имя файла, которое будет на FTP сервере.
string urlFile = "http://www.imtis.ru/pdf/" + Main.LoginGlobal + "/" + fileName;
myCommand.CommandText = string.Format("UPDATE tests SET pdf = '{0}' WHERE id = '{1}'", urlFile, idtests);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
}
myConnection.Close();
CreatTest test = new CreatTest();
test.Show();
this.Hide();
}
private void buttonSendTest_Click(object sender, EventArgs e)
{
string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=cp1251";
MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect);
MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand();
myConnection.Open();
myCommand.Connection = myConnection;
if (CheckJPEG == true)
{
checkFolderFtp(url);
// читаем файл в строку
//string fileText = System.IO.File.ReadAllText(filename);
WebClient myWebClient = new WebClient();
Uri ftp_path = new Uri("ftp://*****:*****@31.31.196.162" + url + fileName); // file.txt - файл, который будет в конечном итоге залит; FTPLOGIN - логин к FTP; PASSWORD - пароль к FTP; LOGIN и PASSWORD разделяются двоеточием.
myWebClient.UploadFile(ftp_path, urlName); // anyfile.txt - загружаемый файл на FTP; C:/Files... - путь к загружаемому файлу; ftp_path - конечный путь и имя файла, которое будет на FTP сервере.
string urlFileJPEG = "http://www.imtis.ru/task/jpeg/" + Main.LoginGlobal + "/" + fileName;
myCommand.CommandText = string.Format("INSERT INTO task (TextTask,PicTask,idtest) VALUES('{0}','{1}','{2}')", textBoxVopros.Text, urlFileJPEG, Teacher.idtests);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
CheckJPEG = false;
}
else
{
myCommand.CommandText = string.Format("INSERT INTO task (TextTask,idtest) VALUES('{0}','{1}')", textBoxVopros.Text, Teacher.idtests);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
}
textBoxVopros.Text = "";
myConnection.Close();
}
public static Tuple <HashSet <vor>, HashSet <Brid> > voroviIBridoviSaSvojstvom(string karakteristika)
{
Tuple <HashSet <vor>, HashSet <Brid> > rješenje =
new Tuple <HashSet <vor>, HashSet <Brid> >(new HashSet <vor>(), new HashSet <Brid>());
try
{
DatabaseConnection.CheckSqlConnection();
MySqlCommand sqlCmd = DatabaseConnection.sqlCmd;
sqlCmd.Connection = DatabaseConnection.sqlConn;
sqlCmd.CommandText = "SELECT Cvorovi.Naziv " +
"FROM Cvorovi LEFT OUTER JOIN Karakteristike ON Cvorovi.ID = Karakteristike.ID_necega " +
"WHERE Karakteristike.Naziv = @karakteristika AND Karakteristike.Type = 'Cvor'";
karakteristikaParam.Value = karakteristika;
sqlCmd.Prepare();
MySqlDataReader sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
rješenje.Item1.Add(Plan.skupČvorova[(string)sqlReader["Naziv"]]);
}
sqlReader.Close();
sqlCmd.CommandText = "SELECT Bridovi.Naziv " +
"FROM Bridovi LEFT OUTER JOIN Karakteristike ON Bridovi.ID = Karakteristike.ID_necega " +
"WHERE Karakteristike.Naziv = @karakteristika AND Karakteristike.Type = 'Brid'";
sqlCmd.Prepare();
sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
rješenje.Item2.Add(Plan.skupBridova[(string)sqlReader["Naziv"]]);
}
sqlReader.Close();
}
catch (Exception ex)
{
MessageBox.Show("Greška pri čitanju iz baze! " + ex.Message, "Greška",
MessageBoxButtons.OK, MessageBoxIcon.Error);
rješenje = null;
}
return(rješenje);
}
private void button1_Click(object sender, EventArgs e)
{
MySql.Data.MySqlClient.MySqlConnection connectionSQL;
string myConnectionString;
myConnectionString = "Server=" + serverName.Text + "; UID=" + userTextBox.Text + "; Pwd=" + pwdTextBox.Text + "; database=" + dbNameTextBox.Text + ";";
connectionSQL = new MySql.Data.MySqlClient.MySqlConnection();
connectionSQL.ConnectionString = myConnectionString;
connectionSQL.Open();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "Poczatek polaczenia MySQL");
reWriteTimer.Enabled = true;
reWriteTimer.Start();
try
{
cmd.Connection = connectionSQL;
cmd.CommandText = "INSERT INTO " + tableNameTextBox.Text + "(`Action`, `Actor`) VALUES (null,null)";
cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
if (connectionSQL.State == ConnectionState.Open)
{
connectionSQL.Close();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- Koniec polaczenia MySQL- error");
reWriteTimer.Stop();
reWriteTimer.Enabled = false;
}
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + ex.Message);
}
connectionSQL.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string login = textBoxLogin.Text;
string pass = textBoxPassword.Text;
string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=cp1251";
MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect);
MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand();
myConnection.Open();
myCommand.Connection = myConnection;
myCommand.CommandText = string.Format("SELECT login FROM Student WHERE login='******' AND password='******' ", login, pass); //запрос: если есть такой логин в таблице
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
LoginGlobal = (string)myCommand.ExecuteScalar(); //результат запроса
if (LoginGlobal == login)
{
MessageBox.Show("Вы зашли как студент! Скачайте мобильное приложение для студентов.");
}
else if (LoginGlobal != login)
{
myCommand.CommandText = string.Format("SELECT login FROM teacher WHERE login='******' AND password='******' ", login, pass); //запрос: если есть такой логин в таблице
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
LoginGlobal = (string)myCommand.ExecuteScalar(); //результат запроса
if (LoginGlobal == login)
{
myCommand.CommandText = string.Format("SELECT id FROM teacher WHERE login='******' AND password='******' ", login, pass); //запрос: если есть такой логин в таблице
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
IdTeacher = (int)myCommand.ExecuteScalar(); //результат запроса
MessageBox.Show("Вы зашли как преподаватель");
Teacher teacher = new Teacher();
teacher.Show();
this.Hide();
}
else
{
MessageBox.Show("Логин или пароль не совпадают");
}
}
myConnection.Close();
}
catch (Exception ex)
{
}
}
private void sqlUpdate(object sender, EventArgs e)
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.CommandText = "UPDATE usuarios SET nickname = @NickName, password = @Pwd WHERE nickname = 'jjoselon'";
cmd.Connection = conn;
cmd.Prepare();
cmd.Parameters.AddWithValue("@NickName", "jjoselon2");
cmd.Parameters.AddWithValue("@Pwd", "1234");
int NumberOfRowsAffected = cmd.ExecuteNonQuery();
MessageBox.Show($"Rows affected {NumberOfRowsAffected}");
}
private void sqlCreate_Click(object sender, EventArgs e)
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.CommandText = "INSERT INTO usuarios(nickname, password) VALUES (@NickName, @Pwd)";
cmd.Connection = conn;
cmd.Prepare();
cmd.Parameters.AddWithValue("@NickName", "jjoselon");
cmd.Parameters.AddWithValue("@Pwd", "123");
int NumberOfRowsAffected = cmd.ExecuteNonQuery();
MessageBox.Show($"Rows affected {NumberOfRowsAffected}");
}
public override IDbCommand GetCommand(IGxConnection con, string stmt, GxParameterCollection parameters, bool isCursor, bool forFirst, bool isRpc)
{
if (isRpc)
{
stmt = convertToMySqlCall(stmt, parameters);
}
MySQLCommand mysqlcmd = (MySQLCommand)base.GetCommand(con, stmt, parameters);
if (preparedStmts && isCursor && !isRpc)
{
#if !NETCORE
mysqlcmd.UsePreparedStatement = true;
#endif
mysqlcmd.Prepare();
}
return(mysqlcmd);
}
protected override void Write(string realmName, HttpRequest request, MySql.Data.MySqlClient.MySqlCommand command)
{
var statementId = Convert.ToInt32(request["s"]);
var gameMode = request["g"];
var serverName = request["n"];
var propertyData = JsonConvert.DeserializeObject <Dictionary <string, object> >(request["v"]);
command.CommandText = _statements[statementId];
command.Prepare();
command.Parameters.AddWithValue("@Realm", realmName);
command.Parameters.AddWithValue("@GameMode", gameMode);
command.Parameters.AddWithValue("@ServerName", serverName);
foreach (var key in propertyData.Keys)
{
var value = propertyData[key];
command.Parameters.AddWithValue(string.Format("@{0}", key), value is string && (string)value == EMPTY_VALUE ? DBNull.Value : value);
}
command.ExecuteNonQuery();
}
public static string OpisBrida(string ime)
{
string opis;
try
{
DatabaseConnection.CheckSqlConnection();
MySqlCommand sqlCmd = DatabaseConnection.sqlCmd;
sqlCmd.Connection = DatabaseConnection.sqlConn;
sqlCmd.CommandText = "SELECT Opis FROM Bridovi WHERE Naziv = @naziv";
nazivParam.Value = ime;
sqlCmd.Prepare();
MySqlDataReader sqlReader = sqlCmd.ExecuteReader();
if (sqlReader.HasRows)
{
sqlReader.Read();
opis = (string)sqlReader["Opis"];
}
else
{
opis = "Nema opisa";
}
sqlReader.Close();
}
catch (Exception ex)
{
MessageBox.Show("Greška pri čitanju iz baze! " + ex.Message, "Greška",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opis = "Greška";
}
return(opis);
}
private void buttonSendTest_Click(object sender, EventArgs e)
{
try
{
string Vopros = textBoxVopros.Text;
string OtvetA = textBoxOtvetA.Text;
string OtvetB = textBoxOtvetB.Text;
string OtvetV = textBoxOtvetV.Text;
string OtvetG = textBoxOtvetG.Text;
if (radioButtonOtvetA.Checked == true)
{
TrueOtvet = 1;
}
else if (radioButtonOtvetB.Checked == true)
{
TrueOtvet = 2;
}
else if (radioButtonOtvetV.Checked == true)
{
TrueOtvet = 3;
}
else if (radioButtonOtvetG.Checked == true)
{
TrueOtvet = 4;
}
else
{
MessageBox.Show("Выберите правильный ответ!");
}
if (TrueOtvet != 0)
{
string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=cp1251";
MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect);
MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand();
myConnection.Open();
myCommand.Connection = myConnection;
myCommand.CommandText = string.Format("SELECT id FROM tests WHERE NameTest='{0}'", Teacher.NameTest);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
Teacher.idtests = (int)myCommand.ExecuteScalar(); //результат запроса
myCommand.CommandText = string.Format("INSERT INTO vopros (name,var1,var2,var3,var4,answer,idtest) " +
"VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
Vopros, OtvetA, OtvetB, OtvetV, OtvetG, TrueOtvet, Teacher.idtests);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
idvoprosa = (int)myCommand.LastInsertedId; //результат запроса
if (CheckJPEG == true)
{
checkFolderFtp(url);
// читаем файл в строку
//string fileText = System.IO.File.ReadAllText(filename);
WebClient myWebClient = new WebClient();
Uri ftp_path = new Uri("ftp://*****:*****@31.31.196.162" + url + fileName); // file.txt - файл, который будет в конечном итоге залит; FTPLOGIN - логин к FTP; PASSWORD - пароль к FTP; LOGIN и PASSWORD разделяются двоеточием.
myWebClient.UploadFile(ftp_path, urlName); // anyfile.txt - загружаемый файл на FTP; C:/Files... - путь к загружаемому файлу; ftp_path - конечный путь и имя файла, которое будет на FTP сервере.
string urlFileJPEG = "http://www.imtis.ru/jpeg/" + Main.LoginGlobal + "/" + fileName;
myCommand.CommandText = string.Format("UPDATE vopros SET pic = '{0}' WHERE id = '{1}'", urlFileJPEG, idvoprosa);
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
CheckJPEG = false;
}
myConnection.Close();
}
}
catch (Exception ex)
{
labelError.Text = ex.Message;
}
textBoxVopros.Text = String.Empty;
textBoxOtvetA.Text = String.Empty;
textBoxOtvetB.Text = String.Empty;
textBoxOtvetV.Text = String.Empty;
textBoxOtvetG.Text = String.Empty;
}
private void button1_Click(object sender, EventArgs e)
{
string login = textBoxLogin.Text;
string pass1 = textBoxPassword1.Text;
string pass2 = textBoxPassword2.Text;
string LastName = textBoxLastName.Text;
string FirstName = textBoxFirstName.Text;
string otch = textBoxOtchestvo.Text;
string group = textBoxGRorKAF.Text;
string zacketka = textBoxZachetka.Text;
if (pass1 != pass2)
{
labelError.Text = "Пароль не совпадает!";
}
else if (FirstName == String.Empty)
{
labelError.Text = "Введите Имя";
}
else if (LastName == String.Empty)
{
labelError.Text = "Введите Фамилию";
}
else if (otch == String.Empty)
{
labelError.Text = "Введите Отчество";
}
else if (group == String.Empty && checkBoxStudent.Checked == false)
{
labelError.Text = "Введите Группу";
}
else if (checkBoxStudent.Checked == false && zacketka == String.Empty)
{
labelError.Text = "Введите номер зачетки";
}
else
{
try
{
string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=cp1251";
MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect);
MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand();
myConnection.Open();
myCommand.Connection = myConnection;
if (checkBoxStudent.Checked == true)
{
myCommand.CommandText = string.Format("INSERT INTO teacher (LastName,FirstName,MiddleName,login,password) " +
"VALUES('{0}','{1}','{2}','{3}','{4}')", LastName, FirstName, otch, login, pass1);
}
else
{
myCommand.CommandText = string.Format("INSERT INTO Student (LastName,FirstName,MiddleName,groups,login,password,zachetka) " +
"VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", LastName, FirstName, otch, group, login, pass1, zacketka);
}
myCommand.Prepare(); //подготавливает строку
myCommand.ExecuteNonQuery(); //выполняет запрос
myConnection.Close();
}
catch (Exception ex)
{
labelError.Text = ex.Message;
}
this.Close();
MessageBox.Show("Регистрация прошла удачно!");
}
}
private bool ReWrite()
{
int writeCounter = 0;
int errorCounter = 0;
reWriteTimer.Stop();
reWriteTimer.Enabled = false;
//ReadDataTable("DSN=" + comboDSN.Text + "; Integrated Security=SSPI", "SELECT Action, Actor, AlarmLimit, AreaCode, AreaName, Block, Category, ChangedTime, Comment, ConditionName, Description, EventID, GDAServerName, LocationTagName, PrevValue, Priority, Source, SourceEntityName, Station, Time, TransactionID, Units, Value FROM \"Event2\" WHERE EventID>"+eventIdTextBox.Text);
switch (rewComboBox.Text)
{
case "R410":
ReadDataTable("DSN=" + comboDSN.Text + "; Integrated Security=SSPI", "SELECT Action, Actor, AlarmLimit, AreaCode, AreaName, Block, Category, ChangedTime, Comment, ConditionName, Description, EventID, GDAServerName, LocationTagName, PrevValue, Priority, Source, SourceEntityName, Station, Time, TransactionID, Units, Value FROM \"Event2\" WHERE EventID>" + eventIdTextBox.Text);
break;
case "R430":
ReadDataTable("DSN=" + comboDSN.Text + "; Integrated Security=SSPI", "SELECT Action, Actor, AlarmLimit, AreaCode, AreaName, Block, Category, ChangedTime, Comment, ConditionName, Description, EventID, GDAServerName, LocationTagName, PrevValue, Priority, Source, SourceEntityName, Station, Time, TransactionID, Units, Value FROM \"Event2\" WHERE EventID>" + eventIdTextBox.Text);
break;
case "R431":
ReadDataTable("DSN=" + comboDSN.Text + "; Uid=" + uidTextBox.Text + "; Pwd=" + pwdTextBox.Text + ";", "SELECT Action, Actor, AlarmLimit, AreaCode, AreaName, Block, Category, ChangedTime, Comment, ConditionName, Description, EventID, GDAServerName, LocationTagName, PrevValue, Priority, Source, SourceEntityName, Station, Time, TransactionID, Units, Value FROM \"Event2\" WHERE EventID>" + eventIdTextBox.Text);
break;
default:
ReadDataTable("DSN=" + comboDSN.Text + "; Uid=" + uidTextBox.Text + "; Pwd=" + pwdTextBox.Text + ";", "SELECT Action, Actor, AlarmLimit, AreaCode, AreaName, Block, Category, ChangedTime, Comment, ConditionName, Description, EventID, GDAServerName, LocationTagName, PrevValue, Priority, Source, SourceEntityName, Station, Time, TransactionID, Units, Value FROM \"Event2\" WHERE EventID>" + eventIdTextBox.Text);
//ReadDataTable("DSN=EXPDataSource; Uid=lotos; Pwd=lotos;", "SELECT Action, Actor, AlarmLimit, AreaCode, AreaName, Block, Category, ChangedTime, Comment, ConditionName, Description, EventID, GDAServerName, LocationTagName, PrevValue, Priority, Source, SourceEntityName, Station, Time, TransactionID, Units, Value FROM \"Event2\" WHERE EventID>" + eventIdTextBox.Text);
break;
}
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " \"Event2\" WHERE EventID>" + eventIdTextBox.Text);
dataGridView1.Columns[7].ValueType = typeof(DateTime);
dataGridView1.Columns[19].ValueType = typeof(DateTime);
string rowdata = null;
float maxEvent = float.Parse(eventNoNumericUpDown.Value.ToString()) + float.Parse(eventIdTextBox.Text);
//open transaction mysql
MySql.Data.MySqlClient.MySqlConnection connectionSQL;
string myConnectionString;
myConnectionString = "Server=" + serverName.Text + "; UID=" + userTextBox.Text + "; Pwd=" + pwdTextBox.Text + "; database=" + dbNameTextBox.Text + ";";
connectionSQL = new MySql.Data.MySqlClient.MySqlConnection();
connectionSQL.ConnectionString = myConnectionString;
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
//bylu tu
//////////////////////////////////////////////////////////
try
{ // przeniesione 4 linie
connectionSQL.Open();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- Poczatek polaczenia MySQL");
reWriteTimer.Enabled = true;
reWriteTimer.Start();
cmd.Connection = connectionSQL;
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- MySQL- conection OK");
cmd.CommandText = "START TRANSACTION;";
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- MySQL- transaction OK");
cmd.Prepare();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- MySQL- prepare OK");
cmd.ExecuteNonQuery();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- MySQL- query OK");
}
catch (Exception ex)
{
if (connectionSQL.State == ConnectionState.Open)
{
connectionSQL.Close();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- Koniec polaczenia MySQL- error");
reWriteTimer.Stop();
reWriteTimer.Enabled = false;
}
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + ex.Message);
}
//poczatek petli do zapisywania
for (int i = 0; i < (dataGridView1.Rows.Count - 1); i++)
{
if (writeCounter >= eventNoNumericUpDown.Value)
{
break;
}
for (int j = 0; j < (dataGridView1.Columns.Count); j++)
{
if (j > 0)
{
rowdata = rowdata + ",";
}
if (dataGridView1.Rows[i].Cells[j].Value.ToString() != string.Empty)
{
if (j == 7)
{
try
{
if ((rewComboBox.SelectedItem.ToString() == "R430") || (rewComboBox.SelectedItem.ToString() == "R431"))
{
rowdata = rowdata + " '" + TimeConvert(dataGridView1.Rows[i].Cells[j].Value.ToString()) + "'";
}
else
{
rowdata = rowdata + " '" + dataGridView1.Rows[i].Cells[j].Value.ToString() + "'";
}
}
catch (Exception Ee)
{
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + Ee.ToString());
return(false);
}
}
else
{
if (j == 19)
{
try
{
if ((rewComboBox.SelectedItem.ToString() == "R430") || (rewComboBox.SelectedItem.ToString() == "R431"))
{
rowdata = rowdata + " '" + TimeConvert(dataGridView1.Rows[i].Cells[j].Value.ToString()) + "'";
}
else
{
rowdata = rowdata + " '" + dataGridView1.Rows[i].Cells[j].Value.ToString() + "'";
}
}
catch (Exception Ee)
{
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + Ee.ToString());
return(false);
}
}
else
{
if (j == 11)
{
try
{
if (float.Parse(dataGridView1.Rows[i].Cells[j].Value.ToString()) > float.Parse(eventIdTextBox.Text))
{
eventIdTextBox.Text = dataGridView1.Rows[i].Cells[j].Value.ToString();
System.IO.StreamWriter SaveEventID = new System.IO.StreamWriter("EventID");
SaveEventID.WriteLine(eventIdTextBox.Text);
SaveEventID.Close();
}
rowdata = rowdata + " '" + dataGridView1.Rows[i].Cells[j].Value.ToString() + "'";
}
catch (Exception Ee)
{
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + Ee.ToString());
return(false);
}
}
else
{
try
{
rowdata = rowdata + " '" + dataGridView1.Rows[i].Cells[j].Value.ToString() + "'";
}
catch (Exception Ee)
{
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + Ee.ToString());
return(false);
}
}
}
}
}
else
{
try
{
rowdata = rowdata + " null";
}
catch (Exception Ee)
{
LogListBox.Items.Insert(0, Ee.ToString());
return(false);
}
}
}
//koniec
rowdata = "INSERT INTO " + tableNameTextBox.Text + "(`Action`, `Actor`, `AlarmLimit`, `AreaCode`, `AreaName`, `Block`, `Category`, `ChangedTime`, `Comment`, `ConditionName`, `Description`, `EventID`, `GDAServerName`, `LocationTagName`, `PrevValue`, `Priority`, `Source`, `SourceEntityName`, `Station`, `Time`, `TransactionID`, `Units`, `Value`) VALUES (" + rowdata + ")";
try
{
cmd.Connection = connectionSQL;
cmd.CommandText = rowdata;
cmd.Prepare();
cmd.ExecuteNonQuery();
writeCounter++;
}
catch (Exception ex)
{
if (connectionSQL.State == ConnectionState.Open)
{
connectionSQL.Close();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- Koniec polaczenia MySQL- error1");
}
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + ex.Message);
errorCounter++;
}
rowdata = null;
}
//koniec petli do zapisywania
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- zapisano do MySQL:" + writeCounter + ", bledow zapisu: " + errorCounter);
reWriteItemsTextBox.Enabled = true;
reWriteItemsTextBox.Text = writeCounter.ToString();
reWriteItemsTextBox.Enabled = false;
sumWriteTextBox.Enabled = true;
sumWriteTextBox.Text = (int.Parse(sumWriteTextBox.Text) + int.Parse(reWriteItemsTextBox.Text)).ToString();
sumWriteTextBox.Enabled = false;
try
{
cmd.Connection = connectionSQL;
cmd.CommandText = "COMMIT;";
cmd.Prepare();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
if (connectionSQL.State == ConnectionState.Open)
{
connectionSQL.Close();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- Koniec polaczenia MySQL- error");
reWriteTimer.Stop();
reWriteTimer.Enabled = false;
}
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + " " + ex.Message);
}
connectionSQL.Close();
LogListBox.Items.Insert(0, DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss") + "- Koniec polaczenia MySQL- koniec petli");
reWriteTimer.Stop();
reWriteTimer.Enabled = false;
return(true);
}
