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);
}
}
