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
}
