public DataTable dialogServerInsert(String sqlEvent, String IDEventData = "") { const String KEY = "79B8242B-22A1-4AE8-B52B-D6A298B17AE2"; switch (sqlEvent) { case "SEVER_START_MESSAGE": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_OPEN @KEY = '" + KEY + "'")); case "SERVER_NEW_CUSTOMER": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_dialog_NEW_USER_LOGIN @KEY = '" + KEY + "', @CustAppID = 8,"+ IDEventData)); case "SERVER_COMPLAINT": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_NEW_COMPLAINT @KEY = '" + KEY + "', " + IDEventData)); case "SERVER_COMPLAINT_DEG": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_NEW_COMPLAINT_DEG @KEY = '" + KEY + "', " + IDEventData)); case "SERVER_PASS_CHANGE": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_CHANGE_PASS @KEY = '" + KEY + "', " + IDEventData)); case "SERVER_RESTART_PC": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_RESTART_PC @KEY = '" + KEY + "', " + IDEventData)); } return(null); }
public DataTable dialogServerInsert(String sqlEvent, String IDEventData = "") { const String KEY = "C8D918DB-296E-4105-A652-87A0B4BA3A65"; switch (sqlEvent) { case "SEVER_START_MESSAGE": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_OPEN @KEY = '" + KEY + "'")); case "SERVER_NEW_CUSTOMER": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_dialog_New_Login @KEY = '', " + IDEventData)); case "SERVER_COMPLAINT": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_NEW_COMPLAINT @KEY = '" + KEY + "', " + IDEventData)); case "SERVER_PASS_CHANGE": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_CHANGE_PASS @KEY = '" + KEY + "', " + IDEventData)); case "SERVER_RESTART_PC": return(sqlMessageServer.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_RESTART_PC @KEY = '" + KEY + "', " + IDEventData)); } return(null); }
private String dialogOpenServer() { try { if (dialogServerSearchPort() != "") { const String KEY = "79B8242B-22A1-4AE8-B52B-D6A298B17AE2"; SqlConfigClass sqlMessageServerDataTable = new SqlConfigClass(); DataTable dt = sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_OPEN @KEY = '" + KEY + "'"); DataRow dr = dt.Rows[0]; if (dr["SUCCES"].ToString() == "1") { _dialogServerSerialPort.Write("AT+CMGF=1\r"); System.Threading.Thread.Sleep(500); _dialogServerSerialPort.Write("AT+CMGS=\"+" + dr["AdminNumber"].ToString() + "\"\r"); System.Threading.Thread.Sleep(1000); _dialogServerSerialPort.Write("Server is started at " + DateTime.Now.ToString("h:mm:ss tt") + " on " + DateTime.Today.ToString("D") + "\r\rDialog Access Network Planning, \rWestern North Region." + (char)(26)); System.Threading.Thread.Sleep(1000); _dialogServerSerialPort.Close(); } return(_truePortName); } } catch (SqlException) { _dialogServerSerialPort.Close(); MessageBox.Show("The Sql Server can't be opened. Check the internet connection and try again.", "Sql Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(""); } catch (Exception) { _dialogServerSerialPort.Close(); MessageBox.Show("The message server serial port can't be opened. Check the com port and try again.", "Port Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(""); } _dialogServerSerialPort.Close(); MessageBox.Show("The message server serial port can't be opened. Check the com port and try again.", "Port Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(""); }
public DataTable dialogServerInsert(String sqlEvent, String IDEventData = "") { switch (sqlEvent) { case "LOAD_APPLICATION": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_dialog_LOAD_APP_KEY @KEY ='" + IDEventData + "'")); case "LOGIN_USER_EXISTS": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_dialog_LOAD_LOGIN_APP_USER @APPUSER ='******'")); case "CREATE_APPLICATION_KEY": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_dialog_SAVE_APP_KEY " + IDEventData)); case "TAB_LOAD_CUSTOMER_SMS": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_CUSTOMER_SMS @KEY ='" + IDEventData + "'")); case "TAB_LOAD_CUSTOMER_NET": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_CUSTOMER_NET @KEY ='" + IDEventData + "'")); case "TAB_LOAD_CUSTOMER_SEARCH": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_CUSTOMER_SEARCH " + IDEventData)); case "TAB_LOAD_CUSTOMER_SELECT": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("_sp_view_dialog_TAB_LOAD_CUSTOMER_SELECT " + IDEventData)); case "TAB_LOAD_SMSCOMPLAINT": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_SMSCOMPLAINT")); case "TAB_LOAD_COMPLAINT_SELECT": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_COMPLAINT_SELECT @CompID ='" + IDEventData + "'")); case "TAB_LOAD_COMPLAINT_BITWEEN": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_SITES_BITWEEN " + IDEventData + "")); case "TAB_LOAD_NETCOMPLAINT": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_NETCOMPLAINT")); case "TAB_LOAD_DIALOG_SITES": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_SITES")); case "TAB_LOAD_DIALOG_SITES_LIKE_AM": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'AM%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_AN": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'AN%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_BA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'BA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_BD": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'BD%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_CM": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'CM%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_GA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'GA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_GM": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'GM%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_HA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'HA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_KA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'KA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_KE": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'KE%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_KI": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'KI%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_KL": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'KL%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_KU": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'KU%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_MA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'MA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_MO": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'MO%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_MR": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'MR%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_MT": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'MT%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_MU": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'MU%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_NU": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'NU%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_PO": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'PO%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_PU": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'PU%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_RA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'RA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_TR": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'TR%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_SITES_LIKE_VA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo._view_dialog_TAB_LOAD_DIALOG_SITES_LIKE WHERE SiteID LIKE 'VA%' ORDER BY Modified DESC")); case "TAB_LOAD_DIALOG_ANTENNA": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_ANTENNA " + IDEventData)); case "TAB_LOAD_DIALOG_SECTOR_LIKE_GSM": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_SECTOR_LIKE_GSM @SiteID = '" + IDEventData + "'")); case "TAB_LOAD_DIALOG_SECTOR_LIKE_DCS": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_SECTOR_LIKE_DCS @SiteID = '" + IDEventData + "'")); case "TAB_LOAD_DIALOG_SECTOR_LIKE_3G": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_SECTOR_LIKE_3G @SiteID = '"+ IDEventData + "'")); case "TAB_LOAD_DIALOG_SECTOR_LIKE_4G": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_view_dialog_TAB_LOAD_DIALOG_SECTOR_LIKE_4G @SiteID = '"+ IDEventData + "'")); case "TAB_LOAD_OTHER_SITES": return(sqlMessageServerDataTable.dialogServerSendMessagePublic("SELECT * FROM dbo.dialog_Customer WHERE CustName = 'Customer'")); } return(null); }
private Boolean dialogOpenServer() { if (dialogServerSearchPort()) { InitializePort(); _dialogMessageServerSerialPort.PortName = _truePortName; _dialogMessageServerSerialPort.Open(); if (_dialogMessageServerSerialPort.IsOpen) { try { const String KEY = "C8D918DB-296E-4105-A652-87A0B4BA3A65"; SqlConfigClass sqlMessageServerDataTable = new SqlConfigClass(); DataTable dt = sqlMessageServerDataTable.dialogServerSendMessagePublic("EXECUTE _sp_DIALOG_SMS_SERVER_OPEN @KEY = '" + KEY + "'"); DataRow dr = dt.Rows[0]; if (dr["SUCCES"].ToString() == "1") { _dialogMessageServerSerialPort.Write("AT+CMGF=1\r"); System.Threading.Thread.Sleep(300); _dialogMessageServerSerialPort.Write("AT+CMGS=\"+" + dr["AdminNumber"].ToString() + "\"\r"); System.Threading.Thread.Sleep(500); _dialogMessageServerSerialPort.Write("Server is started at " + DateTime.Now.ToString("h:mm:ss tt") + " on " + DateTime.Today.ToString("D") + "\r\rDialog Access Network Planning, \rWestern North Region." + (char)(26)); System.Threading.Thread.Sleep(1000); _dialogMessageServerSerialPort.Write("AT+CMGF=1\r"); System.Threading.Thread.Sleep(150); _dialogMessageServerSerialPort.Write("AT+CMGD=?\r"); System.Threading.Thread.Sleep(1000); _dialogMessageServerSerialPort.Close(); return(true); } else if (dr["SUCCES"].ToString() == "0" || dr["ERROR"].ToString() == "1") { _dialogMessageServerSerialPort.Close(); _IsTruePortOK = false; _PortMessage = "401:\r\r" + dr["MESSAGE"].ToString(); return(false); } else { _dialogMessageServerSerialPort.Close(); _IsTruePortOK = false; _PortMessage = "402:\r\r" + "The Sql Server can't be opened. Check the internet connection and try again."; return(false); } } catch (Exception) { _dialogMessageServerSerialPort.Close(); _IsTruePortOK = false; _PortMessage = "403:\r\r" + "The message server serial port can't be opened. Check the com port and try again. The GSM SIM 800A COM Port Warning.!"; return(false); } } else { _dialogMessageServerSerialPort.Close(); _IsTruePortOK = false; _PortMessage = "404:\r\r" + "The message server serial port can't be opened. Check the com port and try again. The GSM SIM 800A COM Port Warning.!"; return(false); } } else { _dialogMessageServerSerialPort.Close(); _IsTruePortOK = false; _PortMessage = "405:\r\r" + "The message server serial port can't be opened. Check the com port and try again. The GSM SIM 800A COM Port Warning.!"; return(false); } }