public IEnumerable <Ticket> GetAll()
{
using (Ticket_DbContext context = new Ticket_DbContext())
{
return(context.Tickets.AsNoTracking().ToList());
}
}
public Ticket GetById(int id)
{
using (Ticket_DbContext context = new Ticket_DbContext())
{
return(context.Tickets.AsNoTracking().FirstOrDefault(t => t.Id == id));
}
}
public void Delete(int id)
{
using (Ticket_DbContext context = new Ticket_DbContext())
{
context.Tickets.Remove(context.Tickets.Find(id));
context.SaveChanges();
}
}
public int Create(Ticket obj)
{
using (Ticket_DbContext context = new Ticket_DbContext())
{
context.Tickets.Add(obj);
context.SaveChanges();
return(obj.Id);
}
}
public void Update(Ticket obj)
{
using (Ticket_DbContext context = new Ticket_DbContext())
{
Ticket old_ticket = context.Tickets.Find(obj.Id);
old_ticket.EventName = obj.EventName;
old_ticket.Price = obj.Price;
context.SaveChanges();
}
}
