public int getTicketNumbers(int ShowID)
{
TicketAppDB db = DataBaseSingleton.Instance;
int ticketNumber = db.Shows.Find(ShowID).TicketNumber;
return(ticketNumber);
}
public int getCountTickets(int showID)
{
TicketAppDB db = DataBaseSingleton.Instance;
var sql = "SELECT COUNT(*) FROM dbo.Tickets WHERE ShowID = " + showID;
int currentTicketNumber = db.Database.SqlQuery <int>(sql).First();
return(currentTicketNumber);
}
public IQueryable <Ticket> getTickets(string searchString)
{
TicketAppDB db = DataBaseSingleton.Instance;
var data = from t in db.Tickets select t;
if (!String.IsNullOrEmpty(searchString))
{
data = data.Where(m => m.ShowID.ToString().Contains(searchString));
}
return(data);
}
public List <SelectListItem> getShowsID()
{
TicketAppDB db = DataBaseSingleton.Instance;
var ShowIDs = new List <int>();
var sql2 = from s in db.Shows orderby s.ID select s.ID;
ShowIDs.AddRange(sql2.Distinct());
List <SelectListItem> list2 = new List <SelectListItem>();
foreach (var show in ShowIDs)
{
list2.Add(new SelectListItem()
{
Value = show.ToString(), Text = show.ToString()
});
}
return(list2);
}
public List <SelectListItem> getShows()
{
TicketAppDB db = DataBaseSingleton.Instance;
var ShowList = new List <string>();
var sql = from s in db.Shows orderby s.ID select s.Title;
ShowList.AddRange(sql.Distinct());
List <SelectListItem> list = new List <SelectListItem>();
foreach (var show in ShowList)
{
list.Add(new SelectListItem()
{
Value = show, Text = show
});
}
return(list);
}
public object checkSeat(int showID, int row, int number)
{
TicketAppDB db = DataBaseSingleton.Instance;
var sql2 = "SELECT Number FROM dbo.Tickets WHERE ShowID = " + showID + " AND Row = " + row + " AND Number = " + number;
int tester;
try
{
tester = db.Database.SqlQuery <int>(sql2).First();
}
catch (Exception)
{
return(null);
}
return(tester);
}
