public IHttpActionResult GetActionResult()
{
Entities db = new Entities();
List <Countries> countries_list = db.Countries.ToList();
List <Cities> cities_list = db.Cities.ToList();
List <ski_jumpers> jumpers_list = db.ski_jumpers.ToList();
List <ski_jumping_hills> hills_list = db.ski_jumping_hills.ToList();
List <ski_jumps> jumps_list = db.ski_jumps.ToList();
var query = from jump in jumps_list
join jumper in jumpers_list on jump.JumperID equals jumper.JumperID into TR1
from jumper in TR1.DefaultIfEmpty()
join hill in hills_list on jump.JumpinhHillID equals hill.JumpingHillID into TR2
from hill in TR2.DefaultIfEmpty()
join ci in cities_list on hill.CityID equals ci.CityID into TR3
from ci in TR3.DefaultIfEmpty()
join c in countries_list on jumper.CountryID equals c.CountryID into TR4
from c in TR4.DefaultIfEmpty()
join co in countries_list on hill.CountryID equals co.CountryID into TR5
from co in TR5.DefaultIfEmpty()
select new JumpsResult
{
GetJumpersCountries = c,
GetHillsCountries = co,
GetCities = ci,
GetJumpers = jumper,
GetJumps = jump,
GetHills = hill
};
return(Ok(query));
}
private void Button3_Click(object sender, EventArgs e)
{
double RP1, RP2, TR3;
try
{
RP1 = double.Parse(textBox6.Text);
RP2 = double.Parse(textBox7.Text);
}
catch
{
MessageBox.Show("INPUT ERROR");
RP1 = 0.0;
RP2 = 0.0;
}
TR3 = 1.0 / ((1.0 / RP1) + (1.0 / RP2));
MessageBox.Show(TR3.ToString());
}
