private void ValidateBtn_Click(object sender, RoutedEventArgs e)
{
if (QuantityTxtBox.Text != "0" && QuantityTxtBox.Text != String.Empty && TotalPriceTxtBlock.Text != String.Empty)
{
using (var context = new CircusDataContext())
{
Ticket newTicket = new Ticket();
newTicket.ShowName = SelectedShow.Name;
newTicket.TicketPrice = SelectedShow.TicketPrice;
newTicket.StartTime = SelectedEvent.StartTime;
newTicket.EndTime = SelectedEvent.EndTime;
context.Add(newTicket);
Order newOrder = new Order();
newOrder.Quantity = Convert.ToInt32(QuantityTxtBox.Text);
newOrder.OrderPrice = Convert.ToDouble(TotalPriceTxtBlock.Text);
newOrder.OrderDate = DateTime.Now;
newOrder.Ticket = newTicket;
context.Add(newOrder);
context.SaveChanges();
}
MessageBox.Show("Your ticket(s) is(are) sent to your mailbox");
this.Close();
}
else
{
MessageBox.Show("If you want to buy tickets please insert a valid quantity number (not \"0\") and click OK to get the total price");
}
}
public static List <Show> DisplayAllShows()
{
using (var context = new CircusDataContext())
{
var defaultList = (from s in context.Show
select s).ToList();
return(defaultList);
}
}
public static List <Order> GetAllOrders()
{
using (var context = new CircusDataContext())
{
var ordersList = (from o in context.Order
select o).ToList();
return(ordersList);
}
}
public static Show GetShowFromEvent(Event oneEvent)
{
using (var context = new CircusDataContext())
{
var show = (from s in context.Show
join se in context.ShowEvent
on s.Id equals se.ShowId
where se.EventId == oneEvent.Id
select s).FirstOrDefault();
return(show);
}
}
/*public static dynamic GetShowInfoAndTroupeNameFromShow(Show show)
* {
* using (var context = new CircusDataContext())
* {
* var shopInfoWithTroupeName = (from s in context.Show
* join t in context.Troupe
* on s.Troupe.Id equals t.Id
* where s.Troupe.Id == show.Id
* select new { s.Name, s.Description,troupeName=t.Name }).ToList();
* return shopInfoWithTroupeName;
*
* List<EditionInfos> editionInfosLine = editionList.Select(s => new EditionInfos
* {
* EditionId = s.EditionId.ToString(),
* EditionNumber = s.EditionNumber.ToString(),
* PublicationDate = s.PublicationDate.ToString("MM/dd/yyyy"),
* MagazineName = s.Name.ToString(),
* }).ToList();
* return editionInfosLine;
* }
* } */
public static List <Event> GetEventListFromShow(Show show)
{
using (var context = new CircusDataContext())
{
var eventlist = (from e in context.Event
join se in context.ShowEvent
on e.Id equals se.EventId
where se.ShowId == show.Id
select e).ToList();
return(eventlist);
}
}
public static Troupe GetTroupeFromShow(Show show)
{
using (var context = new CircusDataContext())
{
var troupe = (from s in context.Show
join t in context.Troupe
on s.Troupe.Id equals t.Id
where t.Id == show.Id
select t).FirstOrDefault();
return(troupe);
}
}