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 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();
}
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"];
}
