//============================================================================* // GetLicenses() //============================================================================* protected void GetLicenses() { m_eErrorCode = eErrorCodes.None; cSQL SQL = new cSQL(Server, Database, UserID, Password); string strCommand = String.Format("SELECT * FROM Licenses WHERE ActivationKey = '{0}' AND Name = '{1}' AND Email = '{2}'", m_strKey, m_strName, m_strEmail); SqlDataReader Reader = SQL.ExecuteQuery(strCommand); if (Reader != null) { m_Page.Response.Write(String.Format("GetLicenses: {0:G}<br />\n", (int)cKeyCommand.eErrorCodes.None)); while (Reader.Read()) { m_Page.Response.Write("License:<br />\n"); m_Page.Response.Write(String.Format("Key: {0}<br />\n", Reader["ActivationKey"].ToString())); m_Page.Response.Write(String.Format("Name: {0}<br />\n", Reader["Name"].ToString())); m_Page.Response.Write(String.Format("Email: {0}<br />\n", Reader["Email"].ToString())); m_Page.Response.Write(String.Format("Computer: {0}<br />\n", Reader["Computer"].ToString())); m_Page.Response.Write(String.Format("NIC: {0}<br />\n", Reader["NIC"].ToString())); } } else { m_Page.Response.Write(String.Format("AddLicense: Error {0:G} - {1}", SQL.ErrorCode, SQL.ErrorMessage)); } SQL.Close(); }
//============================================================================* // ErrorString Property //============================================================================* public static string ErrorString(eErrorCodes eErrorCode) { switch (eErrorCode) { case eErrorCodes.None: return("Success"); case eErrorCodes.NotConnected: return("Not Connected"); case eErrorCodes.InvalidCommand: return("Invalid Command"); case eErrorCodes.InvalidKey: return("Invalid Key"); case eErrorCodes.InvalidResponse: return("Invalid Response"); case eErrorCodes.MissingParameter: return("Missing Parameter"); } return("Unknown Error"); }
//============================================================================* // ActivateKey() //============================================================================* protected void ActivateKey() { //----------------------------------------------------------------------------* // Get and verify the input data //----------------------------------------------------------------------------* if (!string.IsNullOrEmpty(m_Page.Request.QueryString["ActivationKey"])) { m_strKey = m_Page.Request.QueryString["ActivationKey"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["UserName"])) { m_strName = m_Page.Request.QueryString["UserName"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["Email"])) { m_strEmail = m_Page.Request.QueryString["Email"]; } //----------------------------------------------------------------------------* // If any data is missing, set the error code //----------------------------------------------------------------------------* if (string.IsNullOrEmpty(m_strKey) || string.IsNullOrEmpty(m_strName) || string.IsNullOrEmpty(m_strEmail)) { m_eErrorCode = eErrorCodes.MissingParameter; return; } }
//============================================================================* // AddLicense() //============================================================================* protected void AddLicense() { m_eErrorCode = eErrorCodes.None; cSQL SQL = new cSQL(Server, Database, UserID, Password); string strCommand = String.Format("INSERT INTO Licenses (ActivationKey, Name, Email) VALUES ('{0}', '{1}', '{2}')", m_strKey, m_strName, m_strEmail); int nCount = SQL.ExecuteCommand(strCommand); m_Page.Response.Write(String.Format("AddLicense: {0:G}\n", SQL.ErrorCode)); }
private static void processErrorCode(string function, eErrorCodes errCode) { switch (errCode) { case eErrorCodes.Success: break; case eErrorCodes.NoAction: break; default: { StringBuilder Message = new StringBuilder(function); Message.Append(": "); Message.Append(errCode.ToString()); print(Message.ToString()); throw new OL490DLLException(Message.ToString()); } } }
//============================================================================* // Execute() //============================================================================* public void Execute() { //----------------------------------------------------------------------------* // Get and verify the input data //----------------------------------------------------------------------------* if (!string.IsNullOrEmpty(m_Page.Request.QueryString["Command"])) { m_strCommand = m_Page.Request.QueryString["Command"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["Key"])) { m_strKey = m_Page.Request.QueryString["Key"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["Name"])) { m_strName = m_Page.Request.QueryString["Name"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["Email"])) { m_strEmail = m_Page.Request.QueryString["Email"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["ComputerName"])) { m_strComputerName = m_Page.Request.QueryString["ComputerName"]; } if (!string.IsNullOrEmpty(m_Page.Request.QueryString["NIC"])) { m_strNIC = m_Page.Request.QueryString["NIC"]; } //----------------------------------------------------------------------------* // If any data is missing, set the error code //----------------------------------------------------------------------------* m_eErrorCode = eErrorCodes.None; if (string.IsNullOrEmpty(m_strKey) || string.IsNullOrEmpty(m_strName) || string.IsNullOrEmpty(m_strEmail) || string.IsNullOrEmpty(m_strCommand)) { m_eErrorCode = eErrorCodes.MissingParameter; return; } //----------------------------------------------------------------------------* // Execute the Command //----------------------------------------------------------------------------* switch (Command) { case eCommands.Activate: ActivateKey(); break; case eCommands.AddLicense: AddLicense(); break; case eCommands.GetLicenses: GetLicenses(); break; case eCommands.ValidateLicense: ValidateLicense(); break; default: m_eErrorCode = eErrorCodes.InvalidCommand; break; } }
//============================================================================* // ValidateLicense() //============================================================================* protected void ValidateLicense() { m_eErrorCode = eErrorCodes.InvalidKey; }