public frmMain()
{
Thread splashthread = new Thread(new ThreadStart(clsStatus.ShowScreen));
splashthread.IsBackground = true;
splashthread.Start();
InitializeComponent();
xmlData = new clsXMLData();
xmlData.connect();
settings = xmlData.ReadSettings();
clsStatus.UdpateStatusText(DateTime.Now.ToString());
clsStatus.UdpateStatusText("\r\nTimer : " + settings.timer + " Minute(s)\r\n");
Relicate();
try
{
System.Timers.Timer replicationTimer = new System.Timers.Timer();
replicationTimer.Interval = Convert.ToInt32(settings.timer) * 60 * 1000;
replicationTimer.Elapsed += new System.Timers.ElapsedEventHandler(MyTimer_Elapsed);
replicationTimer.Start();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DataTable GridFillSql()
{
clsXMLData clsXmlData = new clsXMLData();
settings = clsXmlData.ReadSettings();
dbinfo.ServerName = settings.serverName;
dbinfo.DBName = settings.dbName;
dbinfo.DBPort = settings.dbPort;
dbinfo.DBUser = settings.userName;
dbinfo.DBPWD = settings.password;
DataTable dt = new DataTable();
cnn = new MySqlConnection(connectionString);
conn = new MySqlConnection(connectionString1);
try
{
cnn.Open();
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT LASTCONNECTION,COUNT(ID),(SELECT COUNT(ID) FROM REPLICATIONLOG WHERE COMMANDSTATUS = 'SUCCESS') APPLIEDQUERY , (SELECT COUNT(ID) FROM REPLICATIONLOG WHERE UPDATESTATUS = 'SUCCESS') VERIFIEDQUERY FROM replicationinfo JOIN replicationlog ON replicationlog.DBCODE = replicationinfo.CODE ", conn);
cmd.CommandType = CommandType.Text;
MySqlDataAdapter sqlda = new MySqlDataAdapter(cmd);
sqlda.Fill(dt);
}
catch (Exception ex)
{
MessageBox.Show("Can't open connection" + ex.ToString());
}
finally
{
cnn.Close();
conn.Close();
}
return(dt);
}