public IEnumerable <Event> GetAllEvents() { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { return(dataContext.GetAllEvents()); } }
public IEnumerable <EventDTO> GetEventsByBook(string title) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { List <EventDTO> toReturn = new List <EventDTO>(); Book book = dataContext.GetBook(title); List <Event> listEvent = new List <Event>(); if (book != null) { foreach (Event helloEvent in dataContext.GetAllEvents()) { if (helloEvent.book == book.book_ID) { listEvent.Add(helloEvent); } } foreach (Event e in listEvent) { toReturn.Add(ToDTO(e)); } return(toReturn); } return(toReturn); } }
public IEnumerable <EventDTO> GetEventDTOs() { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { List <EventDTO> toReturn = new List <EventDTO>(); foreach (Event e in dataContext.GetAllEvents()) { toReturn.Add(ToDTO(e)); } return(toReturn); } }
public Event GetEvent(int eventID) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { foreach (Event e in dataContext.GetAllEvents()) { if (e.event_ID == eventID) { return(e); } } return(null); } }
public IEnumerable <Event> GetEventByUserData(string name, string surname) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { List <Event> toBeReturned = new List <Event>(); Reader r = dataContext.GetReader(name, surname); if (r != null) { foreach (Event e in dataContext.GetAllEvents()) { if (e.reader == r.reader_ID) { toBeReturned.Add(e); } } } return(toBeReturned); } }
public IEnumerable <Event> GetEventsForBookByBookTitle(string title) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { Book b = dataContext.GetBook(title); List <Event> toBeReturned = new List <Event>(); if (b != null) { foreach (Event e in dataContext.GetAllEvents()) { if (e.book == b.book_ID) { toBeReturned.Add(e); } } } return(toBeReturned); } }
public bool DeleteEvent(int eventID) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { Event gotIt = null; foreach (Event e in dataContext.GetAllEvents()) { if (e.event_ID == eventID) { gotIt = e; } } if (gotIt != null) { dataContext.DeleteEvent(eventID); return(true); } return(false); } }
public bool UpdateEvent(int ID, int userID, int bookID, DateTime when, bool is_Returning) { using (LinqLibraryDataContext dataContext = new LinqLibraryDataContext()) { Event gotIt = null; foreach (Event e in dataContext.GetAllEvents()) { if (e.event_ID == ID) { gotIt = e; } } if (gotIt != null) { dataContext.UpdateBook(ID, bookID); dataContext.UpdateTime(ID, when); dataContext.UpdateUser(ID, userID); dataContext.UpdateState(ID); return(true); } return(false); } }