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();
}
public AddTrainsInfoWindow()
{
InitializeComponent();
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
lokomotives = ukrzaliznutsaDBEntities.LokomotiveSet.ToList();
vagonTypes = ukrzaliznutsaDBEntities.VagonTypeSet.ToList();
typeLocomotives = ukrzaliznutsaDBEntities.TypeLocomotiveSet.ToList();
Locomotive.ItemsSource = lokomotives.Select(x => new { x.Name, x.Type, x.Velocity });
TypeVagon.ItemsSource = vagonTypes.Select(x => new { x.Type });
TypeLocomotive.ItemsSource = typeLocomotives.Select(x => new { x.Type });
LocomotivePowerEngine.ItemsSource = lokomotives.Select(x => new { x.PowerEngin });
Type type = typeof(AddTrainsInfoWindow);
Trace.WriteLine(type.Name);
}
private void setTrainInfo()
{
Dispatcher.Invoke(() =>
{
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
TrainsInfoSet trains = new TrainsInfoSet
{
Length = Length.Text,
Locomotive = Locomotive.SelectedItem.ToString(),
LocomotivePowerEngine = LocomotivePowerEngine.SelectedItem.ToString(),
Number = Number.Text,
TypeLocomotive = TypeLocomotive.SelectedItem.ToString(),
TypeVagon = TypeVagon.SelectedItem.ToString(),
Photo = photoload,
PDF = arrayread
};
ukrzaliznutsaDBEntities.TrainsInfoSet.Add(trains);
ukrzaliznutsaDBEntities.SaveChanges();
});
}
public CreateTicketWindow()
{
InitializeComponent();
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
users = ukrzaliznutsaDBEntities.UsersSet.ToList();
marshrutes = ukrzaliznutsaDBEntities.MarshrutesSet.ToList();
trains = ukrzaliznutsaDBEntities.TrainsInfoSet.ToList();
user.ItemsSource = users.Select(x => x.Name).ToArray();
number.ItemsSource = marshrutes.Select(x => x.NumberTrain).ToArray();
pointstart.ItemsSource = marshrutes.Select(x => x.PointStart).ToArray();
pointend.ItemsSource = marshrutes.Select(x => x.PointEnd).ToArray();
typevagon.ItemsSource = trains.Select(x => x.TypeVagon).ToArray();
Marshrute.ItemsSource = marshrutes.Select(x => new { x.NumberTrain, x.PointStart, x.PointEnd, x.TypeTrain, x.TypeVagon });
Type type = typeof(CreateOrderWindow);
Trace.WriteLine(type.Name);
}
public AddContragentWindow()
{
InitializeComponent();
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
List <ProdactionSet> prodactions;
List <VagonTypeSet> vagons;
List <UsersSet> users;
prodactions = ukrzaliznutsaDBEntities.ProdactionSet.ToList();
vagons = ukrzaliznutsaDBEntities.VagonTypeSet.ToList();
users = ukrzaliznutsaDBEntities.UsersSet.ToList();
Prodaction.ItemsSource = prodactions.AsParallel().Select(x => x.ProdactionName).ToArray();
VagonType.ItemsSource = vagons.AsParallel().Select(x => x.Type).ToArray();
user.ItemsSource = users.AsParallel().Select(x => x.Name).ToArray();
Type type = typeof(AddContragentWindow);
Trace.WriteLine(type);
}
private void setMarshrute()
{
Dispatcher.Invoke(() =>
{
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
MarshrutesSet marshrutes = new MarshrutesSet
{
NumberTrain = NumberTrain.Text,
PointStart = PointStart.SelectedItem.ToString(),
PointEnd = PointEnd.SelectedItem.ToString(),
Locomotive = Locomotive.SelectedItem.ToString(),
TypeLocomotive = TypeLocomotive.SelectedItem.ToString(),
TypeTrain = TypeTrain.SelectedItem.ToString(),
TypeVagon = TypeVagon.SelectedItem.ToString(),
Photo = photoload,
PDF = arrayread
};
ukrzaliznutsaDBEntities.MarshrutesSet.Add(marshrutes);
ukrzaliznutsaDBEntities.SaveChanges();
});
}
public CreateMarshrute()
{
InitializeComponent();
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
List <NaselennuyPunktSet> naselennuyPunkts;
List <TrainsInfoSet> trains;
List <TypeLocomotiveSet> typeLocomotives;
List <LokomotiveSet> lokomotives;
naselennuyPunkts = ukrzaliznutsaDBEntities.NaselennuyPunktSet.ToList();
PointStart.ItemsSource = naselennuyPunkts.Select(x => new { x.NamePunkt });
PointEnd.ItemsSource = naselennuyPunkts.Select(x => new { x.NamePunkt });
trains = ukrzaliznutsaDBEntities.TrainsInfoSet.ToList();
TypeTrain.ItemsSource = trains.Select(x => new { x.Number, x.Locomotive, x.Length, x.TypeVagon });
typeLocomotives = ukrzaliznutsaDBEntities.TypeLocomotiveSet.ToList();
TypeLocomotive.ItemsSource = typeLocomotives.Select(x => new { x.Type });
lokomotives = ukrzaliznutsaDBEntities.LokomotiveSet.ToList();
Locomotive.ItemsSource = lokomotives.Select(x => new { x.Name, x.Type, x.Velocity, x.PowerEngin });
NumberTrain.ItemsSource = trains.AsParallel().Select(x => new { x.Number });
TypeVagon.ItemsSource = trains.AsParallel().Select(x => x.TypeVagon).ToArray();
Trace.WriteLine(this);
}
private void Save()
{
Dispatcher.Invoke(() =>
{
try
{
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
KlientsSet klients = new KlientsSet
{
NameKlient = NameKlient.Text,
Prodaction = Prodaction.SelectedItem.ToString(),
VagonType = VagonType.SelectedItem.ToString(),
User = user.SelectedItem.ToString()
};
ukrzaliznutsaDBEntities.KlientsSet.Add(klients);
ukrzaliznutsaDBEntities.SaveChanges();
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
});
}
private void Btn_Set_Click(object sender, RoutedEventArgs e)
{
UkrzaliznutsaDBEntities ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
OrderSet order = new OrderSet
{
User = User.SelectedItem.ToString(),
Number = Number.SelectedItem.ToString(),
ContragentFrom = ContragentFrom.SelectedItem.ToString(),
ContragentTo = ContragentTo.SelectedItem.ToString(),
TypeVagon = TypeVadon.SelectedItem.ToString(),
PointStart = PointStart.SelectedItem.ToString(),
PointEnd = PointEnd.SelectedItem.ToString(),
PriceOfOrder = PriceOfOrder.Text,
Photo = photoload,
OrderPhoto = orderphoto,
InformationOfOrder = arrayread,
Marshrute = Marshrute.SelectedItem.ToString(),
AllInformation = Informationoforder.Text,
ProdactionInformation = Prodaction.Text
};
ukrzaliznutsaDBEntities.OrderSet.Add(order);
ukrzaliznutsaDBEntities.SaveChanges();
}
public Locomotive()
{
ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
Trace.WriteLine(this);
}
public Marshrutes()
{
ukrzaliznutsaDBEntities = new UkrzaliznutsaDBEntities();
Trace.WriteLine(this);
}
