Example #1
0
        //Update statement
        public void UpdateSmsStatusToSent(string id)
        {
            MySqlConnection connection = null;
            string          query      = "UPDATE sms SET sent=1 WHERE id=" + id;

            try
            {
                //Open connection
                connection = this.OpenConnection();
                {
                    //create mysql command
                    MySqlCommand cmd = new MySqlCommand();
                    //Assign the query using CommandText
                    cmd.CommandText = query;
                    //Assign the connection using Connection
                    cmd.Connection = connection;

                    //Execute query
                    cmd.ExecuteNonQuery();

                    //close connection
                    this.CloseConnection(connection);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
            }
        }
Example #2
0
        public void UpdateHostForConnectionIssue(string hostId, int status = 0)
        {
            MySqlConnection connection = null;
            string          query      = "UPDATE host SET connection_status=" + status + " WHERE id=" + hostId;

            try
            {
                //Open connection
                connection = this.OpenConnection();
                {
                    //create mysql command
                    MySqlCommand cmd = new MySqlCommand();
                    //Assign the query using CommandText
                    cmd.CommandText = query;
                    //Assign the connection using Connection
                    cmd.Connection = connection;

                    //Execute query
                    cmd.ExecuteNonQuery();

                    //close connection
                    this.CloseConnection(connection);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
            }
        }
        protected override void OnStart(string[] args)
        {
            hasScanner = new Hashtable();
            hasUpgrade = new Hashtable();
            // Load config
            config = FileHelper.ReadConfigFile();
            if (config.Exception != null)
            {
                ServiceLog.WriteErrorLog(config.Exception);
                // Stop service
                OnStop();
            }

            // Try to connect to DB
            mySql = new MySqlHelper(config.MySql.Server, config.MySql.User, config.MySql.Pass, config.MySql.DBName, config.MySql.SSL);

            timeDelay = new Timer();
            this.timeDelay.Interval = config.Interval;
            this.timeDelay.Elapsed += new ElapsedEventHandler(WorkProcess);
            if (config.EnableUpgradeJob)
            {
                // Config WorkProcess_Upgrade
                ServiceLog.WriteErrorLog("Add WorkProcess_Upgrade");
                this.timeDelay.Elapsed += new ElapsedEventHandler(WorkProcess_Upgrade);
            }
            timeDelay.Enabled = true;
            ServiceLog.WriteErrorLog("Scanner service started");
        }
Example #4
0
        public void UpdateUpgradeLog(string hostId, string log)
        {
            MySqlConnection connection = null;

            log = log.Replace("'", "\"");
            string query = "UPDATE host SET log_upgrade='" + log + "' WHERE id=" + hostId;

            try
            {
                //Open connection
                connection = this.OpenConnection();
                {
                    //create mysql command
                    MySqlCommand cmd = new MySqlCommand();
                    //Assign the query using CommandText
                    cmd.CommandText = query;
                    //Assign the connection using Connection
                    cmd.Connection = connection;

                    //Execute query
                    cmd.ExecuteNonQuery();

                    //close connection
                    this.CloseConnection(connection);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
            }
        }
Example #5
0
        public List <Message> Select_SMSPending()
        {
            MySqlConnection connection = null;

            try
            {
                var list = new List <Message>();

                string query = @"
                    select sms.id, sms.hostId, sms.deviceId, sms.sent, sms.device_hostId, sms_type.message, h.name as hostname, sms.createddate
                    from sms join sms_type on sms.type = sms_type.id and sms_type.allowsendsms = 1
                    join host h on h.id = sms.hostId
                    where sms.sent = 0 
                    order by sms.createddate asc
                ";

                //Create a list to store the result
                //Open connection
                connection = this.OpenConnection();
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();

                    //Read the data and store them in the list
                    while (dataReader.Read())
                    {
                        list.Add(new Message()
                        {
                            id            = dataReader["id"] + "",
                            hostId        = dataReader["hostId"] + "",
                            deviceId      = dataReader["deviceId"] + "",
                            sent          = dataReader["sent"] + "",
                            device_hostId = dataReader["device_hostId"] + "",
                            message       = dataReader["message"] + "",
                            hostname      = dataReader["hostname"] + "",
                            createddate   = dataReader["createddate"] + ""
                        });
                    }

                    //close Data Reader
                    dataReader.Close();

                    //close Connection
                    this.CloseConnection(connection);

                    //return list to be displayed
                    return(list);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
                return(new List <Message>());
            }
        }
Example #6
0
        public List <Host> Select_HostToScan()
        {
            MySqlConnection connection = null;

            try
            {
                var list = new List <Host>();

                string query = @"
                    select *
                    from host
                    where status = 1
                    order by id
                ";

                //Create a list to store the result
                //Open connection
                connection = this.OpenConnection();
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();

                    //Read the data and store them in the list
                    while (dataReader.Read())
                    {
                        // ServiceLog.WriteErrorLog("connection_status=" + ((dataReader["connection_status"] + "")));
                        // ServiceLog.WriteErrorLog("allow_send_sms=" + ((dataReader["allow_send_sms"] + "")));
                        list.Add(new Host()
                        {
                            id                = dataReader["id"] + "",
                            name              = dataReader["name"] + "",
                            phone             = dataReader["phone"] + "",
                            url               = dataReader["url"] + "",
                            status            = bool.Parse(dataReader["status"] + ""),
                            connection_status = bool.Parse(dataReader["connection_status"] + ""),
                            allow_send_sms    = bool.Parse(dataReader["allow_send_sms"] + "")
                        });
                    }

                    //close Data Reader
                    dataReader.Close();

                    //close Connection
                    this.CloseConnection(connection);

                    //return list to be displayed
                    return(list);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
                return(new List <Host>());
            }
        }
        private void HostScan(object data)
        {
            // Try to connect to DB
            // var mySql = new MySqlHelper(config.MySql.Server, config.MySql.User, config.MySql.Pass, config.MySql.DBName, config.MySql.SSL);

            Host   input = (Host)data;
            string url   = input.url;

            try
            {
                if (string.IsNullOrEmpty(input.url))
                {
                    ServiceLog.WriteErrorLog("Url is null or empty (Host id: " + input.id + "; Host name: " + input.name + ")");
                    return;
                }

                url = (input.url.Trim('/')) + "/scanner.php?hostid=" + input.id + "&sms=" + (input.allow_send_sms ? "1" : "0");
                // ServiceLog.WriteErrorLog("hot Id: " + input.id + "; input.connection_status: " + input.connection_status +"; status: " + input.status);
                using (var wb = new System.Net.WebClient())
                {
                    wb.DownloadString(url);
                    // Update DB
                    if (!input.connection_status)
                    {
                        mySql.UpdateHostForConnectionIssue(input.id, 1);
                    }

                    if (input.allow_send_sms)
                    {
                        mySql.CreateSmsRecordToSent(input.id, SMSType.GROUP_CONNECTION_RESOLVED);
                    }
                }

                // Finished
                hasScanner[input.id] = true;
            }
            catch (Exception ex)
            {
                // Update DB
                if (input.connection_status)
                {
                    mySql.UpdateHostForConnectionIssue(input.id, 0);
                }
                // Add record
                // ServiceLog.WriteErrorLog("input.allow_send_sms: " + input.allow_send_sms);
                if (input.allow_send_sms)
                {
                    mySql.CreateSmsRecordToSent(input.id, SMSType.CONNECTION_ISSUE_FAILED);
                }

                // Log
                ServiceLog.WriteErrorLog("Error at: " + url);
                ServiceLog.WriteErrorLog(ex);

                // Finished
                hasScanner[input.id] = true;
            }
        }
Example #8
0
        public List <Sms> Select_CheckSMSToInsert(string hostId)
        {
            MySqlConnection connection = null;

            try
            {
                var list = new List <Sms>();

                string query = @"
                    select *
                    from sms
                    where hostId=" + hostId + " and sms_groupId=" + SMSGroup.GROUP_CONNECTION_ISSUE + @"
                    order by id desc
                    limit 1
                ";

                //Create a list to store the result
                //Open connection
                connection = this.OpenConnection();
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();

                    //Read the data and store them in the list
                    while (dataReader.Read())
                    {
                        list.Add(new Sms()
                        {
                            id          = dataReader["id"] + "",
                            hostId      = dataReader["hostId"] + "",
                            deviceId    = dataReader["deviceId"] + "",
                            type        = int.Parse((dataReader["type"] + "") == "" ? "0" : (dataReader["type"] + "")),
                            sent        = bool.Parse(dataReader["sent"] + ""),
                            sms_groupId = int.Parse(dataReader["sms_groupId"] + "")
                        });
                    }

                    //close Data Reader
                    dataReader.Close();

                    //close Connection
                    this.CloseConnection(connection);

                    //return list to be displayed
                    return(list);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
                return(new List <Sms>());
            }
        }
Example #9
0
        public System.Collections.Hashtable GetConfig()
        {
            MySqlConnection connection = null;

            try
            {
                var data = new System.Collections.Hashtable();

                string query = @"
                    select *
                    from config
                ";

                //Create a list to store the result
                //Open connection
                connection = this.OpenConnection();
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();
                    data = new System.Collections.Hashtable();

                    //Read the data and store them in the list
                    while (dataReader.Read())
                    {
                        // ServiceLog.WriteErrorLog("connection_status=" + ((dataReader["connection_status"] + "")));
                        // ServiceLog.WriteErrorLog("allow_send_sms=" + ((dataReader["allow_send_sms"] + "")));
                        data[dataReader["code"] + ""] = dataReader["value"] + "";
                    }

                    //close Data Reader
                    dataReader.Close();

                    //close Connection
                    this.CloseConnection(connection);

                    //return list to be displayed
                    return(data);
                }

                return(null);
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
                return(null);
            }
        }
Example #10
0
        public MySqlHelper(string server, string user, string pass, string dbName, string ssl)
        {
            string myConnectionString;

            myConnectionString = "server={0};uid={1};pwd={2};database={3}";
            if (ssl != "1")
            {
                myConnectionString += ";SslMode=none";
            }

            ConnectionString = string.Format(myConnectionString, server, user, pass, dbName);

            ServiceLog.WriteErrorLog(ConnectionString);
        }
Example #11
0
        /// <summary>
        /// Open conn
        /// </summary>
        /// <returns></returns>
        public MySqlConnection OpenConnection()
        {
            try
            {
                var connection = new MySql.Data.MySqlClient.MySqlConnection();
                connection.ConnectionString = ConnectionString;

                connection.Open();
                return(connection);
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                ServiceLog.WriteErrorLog(ex);
                return(null);
            }
        }
Example #12
0
        /// <summary>
        /// Open conn
        /// </summary>
        /// <returns></returns>
        public bool CloseConnection(MySqlConnection connection)
        {
            try
            {
                if (connection != null && connection.State != ConnectionState.Closed)
                {
                    connection.Close();
                }
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                ServiceLog.WriteErrorLog(ex);
                return(false);
            }

            return(true);
        }
        private void HostUpgrade(object data)
        {
            // Try to connect to DB
            // var mySql = new MySqlHelper(config.MySql.Server, config.MySql.User, config.MySql.Pass, config.MySql.DBName, config.MySql.SSL);

            Host   input = (Host)data;
            string url   = input.url;

            try
            {
                if (string.IsNullOrEmpty(input.url))
                {
                    ServiceLog.WriteErrorLog("Url is null or empty (Host id: " + input.id + "; Host name: " + input.name + ")");
                    return;
                }

                url = (input.url.Trim('/')) + "/upgrade.php?hostid=" + input.id + "&versionid=" + input.upgradeVersion.id + "&version=" + input.upgradeVersion.version + "&localpath=" + config.LocalPathUpgradeJob + "&fileupgrade=" + input.upgradeVersion.uri_file;
                // ServiceLog.WriteErrorLog("hot Id: " + input.id + "; input.connection_status: " + input.connection_status +"; status: " + input.status);
                // ServiceLog.WriteErrorLog("[UPGRADE] URL: " + url);
                using (var wb = new System.Net.WebClient())
                {
                    var dataResp = "<div>URL: " + url + " </div>" + wb.DownloadString(url);
                    // .WriteErrorLog("[UPGRADE] Response: " + dataResp);

                    // Update DB
                    mySql.UpdateUpgradeLog(input.id, dataResp);
                }

                // Finished
                hasUpgrade[input.id] = true;
            }
            catch (Exception ex)
            {
                // Log
                ServiceLog.WriteErrorLog("[UPGRADE] Error at: " + url);
                ServiceLog.WriteErrorLog(ex);

                // Finished
                hasUpgrade[input.id] = true;
            }
        }
Example #14
0
        public void CreateSmsRecordToSent(string hostId, int type)
        {
            MySqlConnection connection = null;
            var             lstSms     = Select_CheckSMSToInsert(hostId);

            if (lstSms != null && lstSms.Count > 0 && lstSms[0].type == type)
            {
                // ServiceLog.WriteErrorLog("Đã tồn tại HostId=" + hostId + "; Type=" + type);
                return;
            }

            // ServiceLog.WriteErrorLog("INSERT INTO HostId=" + hostId + "; Type=" + type);
            string query = "INSERT INTO sms (hostId, sent, type, sms_groupId) VALUES(" + hostId + ",0, " + type + "," + SMSGroup.GROUP_CONNECTION_ISSUE + ");";

            try
            {
                //Open connection
                connection = this.OpenConnection();
                {
                    //create mysql command
                    MySqlCommand cmd = new MySqlCommand();
                    //Assign the query using CommandText
                    cmd.CommandText = query;
                    //Assign the connection using Connection
                    cmd.Connection = connection;

                    //Execute query
                    cmd.ExecuteNonQuery();

                    //close connection
                    this.CloseConnection(connection);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
            }
        }
Example #15
0
        public List <Host> Select_HostToUpgrade(string version)
        {
            MySqlConnection connection = null;

            if (string.IsNullOrEmpty(version))
            {
                version = "''";
            }

            string query = @"
                    select *
                    from host
                    where auto_upgrade=1 and (versionId is null or versionId <> " + version + @")  
                    order by id
                ";

            try
            {
                var list = new List <Host>();

                //Create a list to store the result
                //Open connection
                connection = this.OpenConnection();
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();

                    //Read the data and store them in the list
                    while (dataReader.Read())
                    {
                        // ServiceLog.WriteErrorLog("connection_status=" + ((dataReader["connection_status"] + "")));
                        // ServiceLog.WriteErrorLog("allow_send_sms=" + ((dataReader["allow_send_sms"] + "")));
                        list.Add(new Host()
                        {
                            id                = dataReader["id"] + "",
                            name              = dataReader["name"] + "",
                            phone             = dataReader["phone"] + "",
                            url               = dataReader["url"] + "",
                            status            = bool.Parse(dataReader["status"] + ""),
                            connection_status = bool.Parse(dataReader["connection_status"] + ""),
                            allow_send_sms    = bool.Parse(dataReader["allow_send_sms"] + ""),
                            auto_upgrade      = true,
                            versionId         = dataReader["versionId"] + "",
                            version           = dataReader["version"] + "",
                            last_upgrade      = dataReader["last_upgrade"] + ""
                        });
                    }

                    //close Data Reader
                    dataReader.Close();

                    //close Connection
                    this.CloseConnection(connection);

                    //return list to be displayed
                    return(list);
                }
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                ServiceLog.WriteErrorLog("Query: " + query);
                //close Connection
                this.CloseConnection(connection);
                return(new List <Host>());
            }
        }
Example #16
0
        public UpgradeVersion Select_Active_Version()
        {
            MySqlConnection connection = null;

            try
            {
                var version = new UpgradeVersion();

                string query = @"
                    select *
                    from upgrade_version
                    where active = 1
                    order by id desc
                ";

                //Create a list to store the result
                //Open connection
                connection = this.OpenConnection();
                {
                    //Create Command
                    MySqlCommand cmd = new MySqlCommand(query, connection);
                    //Create a data reader and Execute the command
                    MySqlDataReader dataReader = cmd.ExecuteReader();

                    //Read the data and store them in the list
                    while (dataReader.Read())
                    {
                        // ServiceLog.WriteErrorLog("connection_status=" + ((dataReader["connection_status"] + "")));
                        // ServiceLog.WriteErrorLog("allow_send_sms=" + ((dataReader["allow_send_sms"] + "")));
                        version = new UpgradeVersion()
                        {
                            id         = dataReader["id"] + "",
                            version    = dataReader["version"] + "",
                            uri_file   = dataReader["uri_file"] + "",
                            active     = bool.Parse(dataReader["active"] + ""),
                            createdate = dataReader["createdate"] + ""
                        };

                        break;
                    }

                    //close Data Reader
                    dataReader.Close();

                    //close Connection
                    this.CloseConnection(connection);

                    //return list to be displayed
                    return(version);
                }

                return(null);
            }
            catch (Exception ex)
            {
                ServiceLog.WriteErrorLog(ex);
                //close Connection
                this.CloseConnection(connection);
                return(null);
            }
        }
 private void LogService(string content)
 {
     ServiceLog.WriteErrorLog(content);
 }