public xmlResult decryptXML(string xmlString) { xmlResult xr = new xmlResult(); try { XmlDocument xDoc = new XmlDocument(); xDoc.LoadXml(xmlString); XmlNode xNode = xDoc.DocumentElement; string it = xNode.InnerXml; string decrypted = decrypt(it); xNode.InnerXml = decrypted; xr.success = true; xr.xml = xDoc; } catch (Exception ex) { xr.success = false; xr.exception = ex; } return(xr); }
public glyderLicense getGlyderLicense() { glyderLicense gl = new glyderLicense(); try { xmlResult xr = getLicenseXMLFromGlyderDatabase(); if (xr.success) { //XmlDocument glyderLicenseXML = new XmlDocument(); //glyderLicenseXML.Load("c:\\Glyder.Licensing\\License.xml"); GlyderStateServiceLicense gsl = new GlyderStateServiceLicense(); using (XmlReader reader = new XmlNodeReader(xr.xml)) { var serializer = new XmlSerializer(typeof(glyderLicense), new XmlRootAttribute("GlyderLicense")); gl = (glyderLicense)serializer.Deserialize(reader); } } } catch (Exception ex) { } return(gl); }
public Result createNewLicense(glyderLicense gl) { Result createLicenseRes = new Result(); try { if (ggc.loaded) { xmlResult insertLicenseResult = encryptXML(@"<GlyderLicense> <glyderStateServiceLicense> <applicationID>1</applicationID> <active>" + gl.glyderStateServiceLicense.active.ToString().ToLower() + @"</active> <expirationDate>" + gl.glyderStateServiceLicense.expirationDate.ToString("o") + @"</expirationDate> </glyderStateServiceLicense> <glyderSMILicense> <applicationID>2</applicationID> <active>" + gl.glyderSMILicense.active.ToString().ToLower() + @"</active> <expirationDate>" + gl.glyderSMILicense.expirationDate.ToString("o") + @"</expirationDate> </glyderSMILicense> <glyderWorkflowLicense> <applicationID>3</applicationID> <active>" + gl.glyderWorkflowLicense.active.ToString().ToLower() + @"</active> <expirationDate>" + gl.glyderWorkflowLicense.expirationDate.ToString("o") + @"</expirationDate> </glyderWorkflowLicense> <glyderWorkspaceLicense> <applicationID>4</applicationID> <active>" + gl.glyderWorkspaceLicense.active.ToString().ToLower() + @"</active> <expirationDate>" + gl.glyderWorkspaceLicense.expirationDate.ToString("o") + @"</expirationDate> </glyderWorkspaceLicense> </GlyderLicense>"); if (insertLicenseResult.success) { string createLicenseQuery = "INSERT INTO tblConfigurations (ApplicationID, Version, [Configuration], CustomerGuid) VALUES(0, 0, '" + insertLicenseResult.xml.OuterXml + "', '" + ggc.customerGuid.ToString() + @"')"; using (SqlConnection con = new SqlConnection(glyderConfigurationConnectionstring)) { using (SqlCommand com = new SqlCommand(createLicenseQuery, con)) { con.Open(); createLicenseRes.success = (int)com.ExecuteNonQuery() > 0; con.Close(); } } } } else { createLicenseRes.success = false; createLicenseRes.exception = new Exception("Glyder Global Configuration not found"); } } catch (Exception ex) { createLicenseRes.success = false; createLicenseRes.exception = ex; } return(createLicenseRes); }
public Result updateGlyderLicense(glyderLicense gl) { Result res = new Result(); res.success = false; try { using (var sww = new StringWriter()) { using (XmlWriter writer = XmlWriter.Create(sww)) { var serializer = new XmlSerializer(typeof(glyderLicense), new XmlRootAttribute("GlyderLicense")); serializer.Serialize(writer, gl); string xml = sww.ToString(); // Your XML xmlResult xr = encryptXML(xml); if (xr.success) { string updateQuery = "UPDATE tblConfigurations SET [Configuration] = @config WHERE ApplicationID = 0 AND Version = 0"; using (SqlConnection con = new SqlConnection(glyderConfigurationConnectionstring)) { using (SqlCommand cmd = new SqlCommand(updateQuery, con)) { cmd.Parameters.AddWithValue("@config", xr.xml.OuterXml); con.Open(); if (cmd.ExecuteNonQuery() == 1) { res.success = true; } con.Close(); } } } else { res.exception = xr.exception; } } } } catch (Exception ex) { res.exception = ex; } return(res); }
public xmlResult getLicenseXMLFromGlyderDatabase() { xmlResult xr = new xmlResult(); try { using (SqlConnection con = new SqlConnection(glyderConfigurationConnectionstring)) { string selectQuery = "SELECT Configuration FROM tblConfigurations WHERE [ApplicationID] = 0 AND [CustomerGuid] = '" + ggc.customerGuid.ToString() + "'"; string licenseXMLString = string.Empty; using (SqlCommand com = new SqlCommand(selectQuery, con)) { con.Open(); var licenseXMLObject = com.ExecuteScalar(); con.Close(); if (licenseXMLObject != null) { licenseXMLString = licenseXMLObject.ToString(); } if (!string.IsNullOrWhiteSpace(licenseXMLString)) { xmlResult xmlLicenseResult = decryptXML(licenseXMLString); { if (xmlLicenseResult.success) { xr.success = true; xr.xml = xmlLicenseResult.xml; } } } } } } catch (Exception ex) { xr.exception = ex; xr.success = false; } return(xr); }