private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
using (PlanetContext P = new PlanetContext())
{
Planet WhatVel = PlanetsList[comboBox1.SelectedIndex];
out_speed.Text = WhatVel.CalcFirtCosmVel().ToString("F2") + ", М/С";
planet_name.Text = WhatVel.Name;
planet_mass.Text = WhatVel.Mass.ToString();
planet_radius.Text = WhatVel.Radius.ToString();
textBox1.Text = WhatVel.CalcSecndCosmVel().ToString("F2") + ", М/С";
}
}
private void button3_MouseClick(object sender, MouseEventArgs e)
{
using (PlanetContext P = new PlanetContext())
{
Planet p = P.Planets.ToList()[comboBox1.SelectedIndex];
planet_name.Text = p.Name;
planet_mass.Text = p.Mass.ToString();
planet_radius.Text = p.Radius.ToString();
if (planet_name.Text != null && planet_mass.Text != null && planet_radius.Text != null)
{
p.Name = planet_name.Text;
double m;
double.TryParse(planet_mass.Text, out m);
p.Mass = m;
double.TryParse(planet_radius.Text, out m);
p.Radius = m;
}
P.SaveChanges();
}
}
private void button2_Click(object sender, EventArgs e)
{
using (PlanetContext P = new PlanetContext())
{
double.TryParse(planet_mass.Text, out double mass);
double.TryParse(planet_radius.Text, out double rad);
Planet PlanetNew = new Planet()
{
Id = (P.Planets.Count() + 1),
Name = planet_name.Text,
Mass = mass,
Radius = rad
};
P.Planets.Add(PlanetNew);
if (checkBox1.Checked == true)
{
P.SaveChanges();
comboBox1.Items.Add(PlanetNew.Name);
PlanetsList.Add(PlanetNew);
}
}
}
private void button1_MouseClick(object sender, MouseEventArgs e)
{
string connectionString = @"data source=DESKTOP-63OB1FE\MSSWL;Initial Catalog=PAL;Integrated Security=True;";
string sqlExpression = $"DELETE FROM Planets WHERE Name = '{comboBox1.SelectedItem.ToString()}'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand(sqlExpression, connection);
cmd.ExecuteNonQuery();
comboBox1.SelectedIndex -= 1;
}
using (PlanetContext PC = new PlanetContext())
{
PlanetsList = new List <Planet>();
List <Planet> PlanetsListNow = PC.Planets.ToList();
comboBox1.Items.Clear();
for (int i = 0; PC.Planets.ToList().Count() - 1 > PlanetsList.Count(); i++)
{
PlanetsList.Add(PlanetsListNow[i]);
comboBox1.Items.Add(PlanetsListNow[i].Name);
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
Planet Mercyriy = new Planet
{
Id = 1,
Name = "Mercyriy",
Radius = 24397000,
Mass = 3.33 * Math.Pow(10.0, 23.0)
};
Planet Venera = new Planet
{
Id = 2,
Name = "Venera",
Radius = 6051000,
Mass = 4.86 * Math.Pow(10.0, 24)
};
Planet Ertch = new Planet
{
Id = 3,
Name = "Ertch",
Radius = 6371000,
Mass = 5.972 * Math.Pow(10.0, 24)
};
Planet Mars = new Planet
{
Id = 4,
Name = "Mars",
Radius = 3396000,
Mass = 6.417 * Math.Pow(10.0, 23.0)
};
Planet Ypiter = new Planet
{
Id = 5,
Name = "Ypiter",
Radius = 69911000,
Mass = 1.89 * Math.Pow(10, 27)
};
Planet Saturn = new Planet
{
Id = 6,
Name = "Saturn",
Radius = 58388000,
Mass = 5.68 * Math.Pow(10, 26)
};
Planet Uran = new Planet
{
Id = 7,
Name = "Uran",
Radius = 25559000,
Mass = 8.681 * Math.Pow(10, 26)
};
Planet Neptun = new Planet
{
Id = 8,
Name = "Neptun",
Radius = 24662000,
Mass = 1.024 * Math.Pow(10, 26)
};
using (PlanetContext PC = new PlanetContext())
{
temp1 = new Planet[] { Mercyriy, Venera, Ertch, Mars, Ypiter, Saturn, Uran, Neptun };
if (PC.Planets.ToList().Count < 8)
{
PC.Planets.AddRange(temp1);
PC.SaveChanges();
}
PlanetsList = new List <Planet>();
List <Planet> PlanetsListNow = PC.Planets.ToList();
for (int i = 0; PC.Planets.ToList().Count() > PlanetsList.Count(); i++)
{
PlanetsList.Add(PlanetsListNow[i]);
}
}
foreach (Planet p in PlanetsList)
{
comboBox1.Items.Add(p.Name);
}
}
