static public purchased_ticket BuyTicket(user userToPurchase, ticket ticket)
{
var user = (from u in db.users
where u.userid == userToPurchase.userid
select u).Single();
purchased_ticket pt = new purchased_ticket();
if (ticket.condition == "annual")
{
DateTime DT = new DateTime();
DT.AddYears(DateTime.Today.Year);
DT.AddMonths(12);
DT.AddDays(31);
pt.expires = DT;
}
pt.ticketid = ticket.ticketid;
pt.paid = ticket.price;
pt.userid = user.userid;
user.purchased_tickets.Add(pt);
db.SubmitChanges();
return(pt);
}
static public void RemoveTicket(purchased_ticket pt)
{
var ticket = (from t in db.purchased_tickets
where t.purchaseid == pt.purchaseid
select t).Single();
if (ticket.attended_events.Count != 0)
{
ticket.used = 1;
db.SubmitChanges();
}
else
{
db.purchased_tickets.DeleteOnSubmit(ticket);
db.SubmitChanges();
}
}
static public void QuickTicketUser(user user, ticket ticket, events events)
{
attended_event ae = new attended_event();
purchased_ticket pt = new purchased_ticket();
ae.attended = 1;
ae.eventid = events.eventid;
var editingUser = (from u in db.users
where u.userid == user.userid
select u).Single();
pt.userid = user.userid;
pt.ticketid = ticket.ticketid;
pt.paid = ticket.price;
pt.used = 1;
pt.attended_events.Add(ae);
editingUser.purchased_tickets.Add(pt);
db.SubmitChanges();
}
public UserTicket(user u, purchased_ticket pt)
{
user = u;
purchasedTicket = pt;
}
public UserTicket()
{
user = new user();
purchasedTicket = new purchased_ticket();
}
public AttendanceInfo(attended_event ae, purchased_ticket pt)
{
attendedEvent = ae;
purchasedTicket = pt;
}
