private void getInfoLoading() { Dispatcher.Invoke(() => { string[] arrayprod; List <ProdactionSet> prodactions; List <KlientsSet> klients; UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities(); prodactions = ukrzaliznutsaDBEntities.ProdactionSet.ToList(); klients = ukrzaliznutsaDBEntities.KlientsSet.ToList(); listcontragent.ItemsSource = klients.Select(x => x.NameKlient).ToArray(); arrayprod = prodactions.Select(x => x.ProdactionName).ToArray(); listprodact.ItemsSource = arrayprod; }); }
public void setTicket(string user, string number, string pointstart, string pointend, string typevagon, string price, byte[] photoload, byte[] arrayread, string marshrute) { UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities(); TicketSet ticket = new TicketSet { User = user, Number = number, PointStart = pointstart, PointEnd = pointend, TypeVagon = typevagon, Price = price, Photo = photoload, Information = arrayread, Marshrute = marshrute }; ukrzaliznutsaDBEntities.TicketSet.Add(ticket); ukrzaliznutsaDBEntities.SaveChanges(); }
private void LoadOrder() { Dispatcher.Invoke(() => { try { UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities(); orders = ukrzaliznutsaDBEntities.OrderSet.ToList(); Number.ItemsSource = orders.Select(x => x.Number); PointStart.ItemsSource = orders.Select(x => x.PointStart); PointEnd.ItemsSource = orders.Select(x => x.PointEnd); TypeTrain.ItemsSource = orders.Select(x => x.TypeVagon); orderloadgrid.ItemsSource = orders.Select(x => new { x.Number, x.PointStart, x.ContragentFrom, x.PointEnd, x.ContragentTo, x.TypeVagon, x.PriceOfOrder, x.Marshrute }); } catch (Exception exp) { MessageBox.Show(exp.ToString(), "Warning", MessageBoxButton.OK, MessageBoxImage.Error); } }); }