private void btnSale_Click(object sender, RoutedEventArgs e) { FirstGrid.Dispatcher.Invoke(() => { var constr = ConfigurationManager.ConnectionStrings["constr"].ToString(); var dataContext = new TicketDataContext(constr); var newTicket = new Ticket { Id = Guid.NewGuid(), FirstName = txtFirstName.Text, SecondName = txtSecondName.Text, Source = (from c in dataContext.Cities where c.City1 == comboBoxSource.Text select c.Id).First(), Destination = (from c in dataContext.Cities where c.City1 == comboBoxDestination.Text select c.Id).First(), Class = comboBoxClass.Text, DateDeparture = (DateTime)dateDeparture.SelectedDate, DateArrival = dateArrival.SelectedDate, Way = rbTo.IsChecked == true ? (byte)0 : (byte)1, Price = decimal.Parse(txtPrice.Text, CultureInfo.InvariantCulture), //Currency = listBoxPrice.SelectedItem.ToString() }; dataContext.Tickets.InsertOnSubmit(newTicket); dataContext.SubmitChanges(); }); #region comment //var connection = new SqlConnection(constr); //connection.Open(); //var comand = connection.CreateCommand(); //comand.CommandText = // $"INSERT INTO Bilet(FirstName, LastName, Source, Destination, Class, Way, DateOne, DateTwo, Price) " + // $"VALUES('{txtFirstName.Text}'," + // $"'{txtSecondName.Text}'," + // $" (SELECT Id FROM Gorod WHERE CityName = '{comboBoxSource.Text}'), " + // $"(SELECT Id FROM Gorod WHERE CityName = '{comboBoxDestination.Text}')," + // $" '{comboBoxClass.Text}'," + // $" {(rbTo.IsChecked == true ? 0 : 1)}," + // $"'{(dateDeparture.DisplayDate.ToString(@"yyyy-MM-dd HH:mm:ss"))}','{(rbTo.IsChecked == true ? null : (dateArrival.DisplayDate.ToString(@"yyyy-MM-dd HH:mm:ss")))}'," + // $"{(Int16.Parse(txtPrice.Text))})"; //comand.ExecuteNonQuery(); //comand.CommandText = // $"SELECT b.FirstName, b.LastName, G.CityName, G.CityName,b.Class, b.Way, b.DateOne, b.DateTwo, b.Price " + // $"FROM Bilet b, Gorod G, Gorod Gd WHERE b.Source=G.Id AND b.Destination = Gd.Id"; //var reader = comand.ExecuteReader(); //string str = String.Empty; //int i = 0; //while (reader.Read()) //{ // for (int i = 0; i < 9; i++) // { // str += reader.GetName(i) + ": " + reader[i] + Environment.NewLine; // i++; // } //} //MessageBox.Show(str, "Information", MessageBoxButton.OK, MessageBoxImage.Information); //connection.Close(); #endregion }
private void TabTickets_MouseEnter(object sender, MouseEventArgs e) { new Thread(() => { var connstr = ConfigurationManager.ConnectionStrings["connstring"].ToString(); var dataContext = new TicketDataContext(connstr); var res = from t in dataContext.Tickets select new { t.FirstName, t.SecondName, FromName = t.City.Name, DstName = t.City1.Name, t.Class, t.Price, t.Date1, t.Date2 }; TicketsGrid.Dispatcher.Invoke(() => { TicketsGrid.ItemsSource = res; }); }).Start(); }
private void btnInsert_Click(object sender, RoutedEventArgs e) { var constr = ConfigurationManager.ConnectionStrings["constr"].ToString(); var dataContext = new TicketDataContext(constr); new Thread(() => { var res = (from c in dataContext.Tickets select new { c.FirstName, c.SecondName, Source = c.City.City1, Destination = c.City1.City1, c.DateDeparture, c.DateArrival, c.Class, c.Price, }); dataGrid.Dispatcher.Invoke(() => { dataGrid.ItemsSource = res; }); }).Start(); }
private void btnCreate_Click(object sender, RoutedEventArgs e) { if (tbFName.Text.Length == 0) { message("First Name is empty!"); return; } if (tbSName.Text.Length == 0) { message("Second name is empty!"); return; } if (tbPassp.Text.Length == 0) { message("Passport is empty!"); return; } gridFirst.Dispatcher.Invoke(() => { var connstr = ConfigurationManager.ConnectionStrings["connstring"].ToString(); var dataContext = new TicketDataContext(connstr); var ticket = new Ticket { Id = Guid.NewGuid(), FirstName = tbFName.Text, SecondName = tbSName.Text, Src = (from c in dataContext.Cities where c.Name == cbFrom.SelectionBoxItem.ToString() select c.Id).First(), Dst = (from c in dataContext.Cities where c.Name == cbTo.SelectionBoxItem.ToString() select c.Id).First(), Way = rbTrip.IsChecked == true ? (byte)0 : (byte)1, Class = cbClass.Text, Date1 = (DateTime)DepDate.SelectedDate, Date2 = RetDate.SelectedDate }; dataContext.Tickets.InsertOnSubmit(ticket); dataContext.SubmitChanges(); }); #region coment //var connect = SqlConn(); //connect.Open(); //var command = connect.CreateCommand(); //command.CommandText = $"INSERT INTO [dbo].[Ticket] " + // $"(FirstName, SecondName, Src, Dst, " + // $"Class, Way, Date1, Date2, Price) VALUES (" + // $"'{tbFName.Text}'," + // $"'{tbSName.Text}'," + // $"(SELECT (Id) FROM [dbo].[City] WHERE (Name='{cbFrom.Text}'))," + // $"(SELECT (Id) FROM [dbo].[City] WHERE (Name='{cbTo.Text}'))," + // $"'{cbClass.Text}'," + // $"{rt}," + // $"'{DepDate.DisplayDate:yyyy-MM-dd HH:mm:ss}'," + // $"'{RetDate.DisplayDate:yyyy-MM-dd HH:mm:ss}'," + // $"200)"; //if (command.ExecuteNonQuery()>0) // message("Done!"); //connect.Close(); #endregion }