public Order GetOrder()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
var order = db.Orders.SingleOrDefault(t => t.Id == OrderId);
return(order);
}
public Ref_Competition GetCompetition()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
Ref_Competition competition = db.Ref_Competition.SingleOrDefault(m => m.Id == CompetitionId);
return(competition);
}
public Ticket_Game GetTicketGame()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
var tg = db.Ticket_Game.SingleOrDefault(t => t.Id == Ticket_Game_Id);
return(tg);
}
public Game GetGame()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
var game = GetTicketGames().ElementAt(0).GetGame();
return(game);
}
public Game GetGame()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
var game = db.Games.SingleOrDefault(t => t.Id == GameId);
return(game);
}
public Ticket GetTicket()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
var ticket = db.Tickets.SingleOrDefault(t => t.Id == TicketId);
return(ticket);
}
public List <Ticket_Game> GetAllUnsoldTickets()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
string query = "SELECT * FROM dbo.Ticket_Game WHERE sold = 0 and dbo.Ticket_Game.GameId = " + Id + "; ";
var ticketsInDb = db.Database.SqlQuery <Ticket_Game>(query).ToList();
return(ticketsInDb);
}
public List <Ticket_Game> GetAllAssignedTickets()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
string query = "SELECT * FROM dbo.Ticket JOIN dbo.Ticket_Game ON dbo.Ticket.Id = dbo.Ticket_Game.TicketId WHERE dbo.Ticket_Game.GameId = " + Id + "; ";
var ticketsInDb = db.Database.SqlQuery <Ticket_Game>(query).ToList();
return(ticketsInDb);
}
public List <Ticket_Game> GetAllAssignedGamesByCompetition(int competitionId)
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
string query = "SELECT * FROM dbo.Game JOIN dbo.Ticket_Game ON dbo.Game.Id = dbo.Ticket_Game.GameId WHERE dbo.Ticket_Game.TicketId = " + Id + " and " + "dbo.Game.CompetitionId = " + competitionId + ";";
var gamesInDb = db.Database.SqlQuery <Ticket_Game>(query).ToList();
return(gamesInDb);
}
public List <Ticket_Game> GetAllUnsoldTicketsCategorized(int categoryId)
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
string query = "SELECT * FROM dbo.Ticket JOIN dbo.Ticket_Game ON dbo.Ticket.Id = dbo.Ticket_Game.TicketId WHERE dbo.Ticket_Game.Sold=0 and dbo.Ticket_Game.GameId = " + Id + " and " + "dbo.Ticket.CategoryId = " + categoryId + ";";
var ticketsInDb = db.Database.SqlQuery <Ticket_Game>(query).ToList();
return(ticketsInDb);
}
public List <Ticket_Game> GetTicketGames()
{
WebAssignmentDbContext db = new WebAssignmentDbContext();
string query = "SELECT Ticket_Game_Id FROM dbo.Order_Ticket_Game Where OrderId = " + Id + ";";
var tgids = db.Database.SqlQuery <int>(query).ToList();
List <Ticket_Game> tglist = new List <Ticket_Game>();
foreach (int id in tgids)
{
Ticket_Game tg = db.Ticket_Game.Single(m => m.Id == id);
tglist.Add(tg);
}
return(tglist);
}