public void LoadDeparture(ListBox s) { using (var conDb = new TrainContex()) { foreach (var item in conDb.TrainTable) { s.Items.Add(item.AdvertisedLocationName); } } }
public void AddTrainStations(string name, ListBox l) { if (name == l.Text) { return; } using (var ctx = new TrainContex()) { var result = (from u in ctx.TrainTable where u.AdvertisedLocationName == name select u).FirstOrDefault(); if (result != null) { return; } if (l.Items.Count < 3) { ctx.TrainTable.Add( new TrainTable { AdvertisedLocationName = name } ); ctx.SaveChanges(); } else { ctx.TrainTable.Add( new TrainTable { AdvertisedLocationName = name } ); ctx.SaveChanges(); var deleteTráinStation = ctx.TrainTable.FirstOrDefault(); ctx.TrainTable.Remove(deleteTráinStation); ctx.SaveChanges(); } } }