//data insert section
private void btntsave_Click(object sender, EventArgs e)
{
DboTrainsEntities1 entit = new DboTrainsEntities1();
string stationName = textBox1.Text.ToString();
//array created
string[] InsertArray = new string[1];
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
//set value to array
InsertArray[0] = stationName;
//retrive data from array and insert to database
for (int J = 0; J < InsertArray.Length; J++)
{
TbStation PTE = new TbStation();
PTE.Name = InsertArray[J];
entit.TbStations.Add(PTE);
entit.SaveChanges();
}
stopwatch.Stop();
TimeSpan ts = stopwatch.Elapsed;
//show spending times
Lblinsert.Text = " Data Insert Time: " + stopwatch.ElapsedMilliseconds + " Ms";
textBox1.Text = "";
}
//open minimum connecters algorithm app
private void btnmincon_Click(object sender, EventArgs e)
{
DboTrainsEntities1 entit = new DboTrainsEntities1();
var cc = (from p in entit.TbStations
select new
{
id = p.id,
name = p.Name
});
var vv = cc.ToList();
List <TbStation> v = new List <TbStation>();
foreach (var val in vv)
{
TbStation s = new TbStation();
s.id = val.id;
s.Name = val.name;
v.Add(s);
}
var cc2 = (from p in entit.Tbdistances
select new
{
id = p.id,
station1 = p.station1Id,
station2 = p.station2id,
distance = p.distance
});
var vv2 = cc2.ToList();
List <Tbdistance> v1 = new List <Tbdistance>();
foreach (var val in vv2)
{
Tbdistance s1 = new Tbdistance();
s1.id = val.id;
s1.station1Id = val.station1;
s1.station2id = val.station2;
s1.distance = val.distance;
v1.Add(s1);
}
Form1 f = new Form1(v1, v);
f.Show();
}
