private void btn_generate_Click(object sender, EventArgs e) { DataSet dts; dataAccess.connectToDDBB(ProjectName); dts = dataAccess.getByQuery("SELECT * FROM InnerEncryption WHERE idPlanet = " + idOwnPlanet, ProjectName); if (dts.Tables[0].Rows.Count == 0) { return; } string InnerEncryptionCode = dts.Tables[0].Rows[0]["ValidationCode"].ToString(); CspParameters cspp = new CspParameters(); string keyName = InnerEncryptionCode; cspp.KeyContainerName = keyName; rsa = new RSACryptoServiceProvider(cspp); string publicKey = rsa.ToXmlString(false); rsa.PersistKeyInCsp = false; rsa.Clear(); dts = dataAccess.getByQuery("INSERT INTO PlanetKeys(idPlanet, XMLKey) VALUES(" + idOwnPlanet + ", '" + publicKey + "')", ProjectName); }
private void frm_spaceship_Load(object sender, EventArgs e) { lbl_networkstatus.Visible = false; tbx_pubkey.Enabled = false; DataSet dts; dataAccess.connectToDDBB(ProjectName); dts = dataAccess.getByQuery("SELECT * FROM Planets ORDER BY DescPlanet ASC", "Planets", ProjectName); cbx_selectplanet.DisplayMember = "DescPlanet"; cbx_selectplanet.ValueMember = "idPlanet"; cbx_selectplanet.DataSource = dts.Tables["Planets"]; dts = dataAccess.getByQuery("SELECT * FROM DeliveryData ORDER BY CodeDelivery ASC", "DeliveryData", ProjectName); cbx_codedelivery.DisplayMember = "CodeDelivery"; cbx_codedelivery.ValueMember = "idDeliveryData"; cbx_codedelivery.DataSource = dts.Tables["DeliveryData"]; dts = dataAccess.getByQuery("SELECT * FROM DeliveryData ORDER BY CodeDelivery ASC", "DeliveryData", ProjectName); cbx_deliverydate.DisplayMember = "DeliveryDate"; cbx_deliverydate.ValueMember = "idDeliveryData"; cbx_deliverydate.DataSource = dts.Tables["DeliveryData"]; }
private void btn_selectspaceship_Click(object sender, EventArgs e) { G8_DataAccess.DataAccess dataAccess = new G8_DataAccess.DataAccess(); DataSet dts; dataAccess.connectToDDBB(projectName); spaceshipCode = tbx_spaceshipname.Text; dts = dataAccess.getByQuery("SELECT * FROM SpaceShips WHERE CodeSpaceShip = '" + spaceshipCode + "'", "Spaceships", projectName); spaceshipIdSelected = dts.Tables[0].Rows[0]["idSpaceShip"].ToString(); spaceshipIP = dts.Tables[0].Rows[0]["IPSpaceShip"].ToString(); spaceshipPort1 = dts.Tables[0].Rows[0]["PortSpaceShip"].ToString(); spaceshipPort2 = dts.Tables[0].Rows[0]["PortSpaceship1"].ToString(); this.Hide(); new frm_spaceship().Show(); }