/// <summary>
/// Get Comments on Event.
/// </summary>
/// <param name="eventID"></param>
/// <returns></returns>
public IList <CommentsDTO> GetComments(int eventID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
return(mapCommentEntity2DTO.Map <IList <CommentsDTO> >(db.CommentsEntity.Where(p => p.EventID == eventID).ToList()));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Get User having a particular userID
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public UserDTO GetUser(int userID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
return(mapUserEntity2DTO.Map <UserDTO>(db.UserEntity.Find(userID)));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// View User's Events.
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public IList <EventDTO> ViewMyEventsDAL(int userID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
return(mapEventEntity2DTO.Map <IList <EventDTO> >(db.EventEntity.Where(e => e.UserID == userID).ToList()));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// get Details of Event having given eventID
/// </summary>
/// <param name="eventID"></param>
/// <returns></returns>
public EventDTO GetEventDAL(int eventID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
return(mapEventEntity2DTO.Map <EventDTO>(db.EventEntity.Find(eventID)));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// View All Events for Admin.
/// </summary>
/// <returns></returns>
public IList <EventDTO> AllEventsForAdminDAL()
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
return(mapEventEntity2DTO.Map <IList <EventDTO> >(db.EventEntity.ToList()));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// view All public Events
/// </summary>
/// <returns></returns>
public IList <EventDTO> ViewPublicEvents()
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
return(mapEventEntity2DTO.Map <IList <EventDTO> >(db.EventEntity.Where(e => e.Type == Type.Public).ToList()));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Add a comment to DataBase
/// </summary>
/// <param name="comment"></param>
public CommentsDTO AddCommentDAL(CommentsDTO comment)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
CommentsEntity commentsEntity = mapCommentDTO2Entity.Map <CommentsEntity>(comment);
db.CommentsEntity.Add(commentsEntity);
db.SaveChanges();
return(comment);
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Delete Event.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteEventDAL(int id)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
EventEntity eventEntity = db.EventEntity.Find(id);
db.EventEntity.Remove(eventEntity);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Edit Details of user.
/// </summary>
/// <param name="userDTO"></param>
/// <returns></returns>
public UserDTO EditUser(UserDTO userDTO)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
UserEntity newUserEntity = mapUserDTO2Entity.Map <UserEntity>(userDTO);
UserEntity oldUserEntity = db.UserEntity.Find(newUserEntity.UserID);
db.Entry(oldUserEntity).CurrentValues.SetValues(newUserEntity);
db.SaveChanges();
return(userDTO);
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Edit Event
/// </summary>
/// <param name="eventDTO"></param>
/// <returns></returns>
public EventDTO EditEventDAL(EventDTO eventDTO)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
EventEntity newEventEntity = mapEventDTO2Entity.Map <EventEntity>(eventDTO);
EventEntity oldEventEntity = db.EventEntity.Find(newEventEntity.EventID);
db.Entry(oldEventEntity).CurrentValues.SetValues(newEventEntity);
db.SaveChanges();
return(eventDTO);
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Get Details of User
/// </summary>
/// <param name="userDTO"></param>
/// <returns></returns>
public UserDTO GetUserEntity(UserDTO userDTO)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
UserEntity userEntity = mapUserDTO2Entity.Map <UserEntity>(userDTO);
var user = (from u in db.UserEntity
where (u.EmailID == userEntity.EmailID)
select u).FirstOrDefault();
return(mapUserEntity2DTO.Map <UserDTO>(user));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Create new User
/// </summary>
/// <param name="userDTO"></param>
public UserDTO CreateUser(UserDTO userDTO)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
UserEntity userEntity = mapUserDTO2Entity.Map <UserEntity>(userDTO);
db.UserEntity.Add(userEntity);
db.SaveChanges();
UserEntity user = (from u in db.UserEntity
where (u.EmailID == userEntity.EmailID && u.Password == userEntity.Password)
select u).FirstOrDefault();
return(mapUserEntity2DTO.Map <UserDTO>(user));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// View All Events.
/// </summary>
/// <returns></returns>
public IList <EventDTO> ViewAllEvents(int userID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
IList <EventEntity> userEvents = db.EventEntity.Where(e => e.UserID == userID).ToList();
IList <EventEntity> publicEvents = db.EventEntity.Where(e => e.Type == Type.Public && e.UserID != userID).ToList();
foreach (var item in publicEvents)
{
userEvents.Add(item);
}
return(mapEventEntity2DTO.Map <IList <EventDTO> >(userEvents));
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// Add an Event to DataBase.
/// </summary>
/// <param name="eventDTO"></param>
/// <returns></returns>
public EventDTO AddEvent(EventDTO eventDTO)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
EventEntity eventEntity = mapEventDTO2Entity.Map <EventEntity>(eventDTO);
db.EventEntity.Add(eventEntity);
db.SaveChanges();
EventEntity eventFetch = db.EventEntity.Where(s => (s.Title == eventEntity.Title && s.Starttime == eventEntity.Starttime && s.Location == eventEntity.Location)).FirstOrDefault();
//AddInvitesDAL(eventFetch.EventID, eventEntity.EventInvites);
eventDTO = mapEventEntity2DTO.Map <EventDTO>(eventFetch);
return(eventDTO);
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// populate Event recipients List.
/// </summary>
/// <param name="eventID"></param>
/// <param name="eventInviteList"></param>
public IList <string> AddInvitesDAL(IList <string> invites, int eventID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
foreach (var item in invites)
{
EventInvitesEntity eventInvitesEntity = new EventInvitesEntity
{
EventID = eventID,
EmailID = item
};
db.EventInvitesEntity.Add(eventInvitesEntity);
}
db.SaveChanges();
}
return(invites);
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}
/// <summary>
/// View List of people Invited to Event.
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public IList <EventDTO> ViewEventsInvitedToDAL(int userID)
{
try
{
using (BookReadingEventContext db = new BookReadingEventContext())
{
UserEntity userEntity = db.UserEntity.Where(a => a.UserID == userID).FirstOrDefault();
IList <EventInvitesEntity> invites = db.EventInvitesEntity.Where(e => e.EmailID == userEntity.EmailID).ToList();
IList <EventDTO> eventsInvited = new List <EventDTO>();
foreach (var item in invites)
{
eventsInvited.Add(GetEventDAL(item.EventID));
}
return(eventsInvited);
}
}
catch (Exception)
{
throw new DALException(Resource.DALErrorMessage);
}
}