public bool DeleteEvent(EventDataModel eventData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
var deleteEvent = context.Events
.SingleOrDefault(e => e.Id == eventData.Id);
bool result = false;
if (deleteEvent != null)
{
// Deleting Invites
var deleteInvites = context.Invites.Where(i => i.EventId == eventData.Id).ToList();
foreach (var invite in deleteInvites)
{
context.Invites.Remove(invite);
context.SaveChanges();
}
// Deleting Comments
var deleteComments = context.Comments.Where(c => c.EventId == eventData.Id).ToList();
foreach (var comment in deleteComments)
{
context.Comments.Remove(comment);
context.SaveChanges();
}
// Deleting Event
context.Events.Remove(deleteEvent);
context.SaveChanges();
result = true;
}
return(result);
}
}
public List <CommentDataModel> GetComments(CommentDataModel commentData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
List <CommentDataModel> listOfComments = null;
var commentsEntityList = context.Comments.Where(c => c.EventId == commentData.EventId).ToList();
if (commentsEntityList != null)
{
listOfComments = new List <CommentDataModel>();
foreach (var comment in commentsEntityList)
{
CommentDataModel commentDataModel = new CommentDataModel();
commentDataModel.Date = (DateTime)comment.Date;
commentDataModel.UserName = comment.UserName;
commentDataModel.UserId = comment.UserId;
commentDataModel.EventId = comment.EventId;
commentDataModel.Comment = comment.Comment1;
listOfComments.Add(commentDataModel);
}
}
return(listOfComments);
}
}
public EventDataModel GetEventDetails(EventDataModel eventData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
var eventDetail = context.Events.Where(e => e.Id == eventData.Id).SingleOrDefault();
EventDataModel eventDataModel = new EventDataModel();
if (eventDetail != null)
{
eventDataModel.Date = eventDetail.Date;
eventDataModel.Description = eventDetail.Description;
eventDataModel.DurationInHours = (int)eventDetail.DurationInHours;
eventDataModel.Id = eventDetail.Id;
eventDataModel.InviteEmails = eventDetail.InviteEmails;
eventDataModel.Location = eventDetail.Location;
eventDataModel.OtherDetails = eventDetail.OtherDetails;
eventDataModel.StartTime = (DateTime)eventDetail.StartTime;
eventDataModel.Title = eventDetail.Title;
eventDataModel.TotalInvites = (int)eventDetail.TotalInvites;
eventDataModel.Type = eventDetail.Type;
eventDataModel.UserId = eventDetail.UserId;
}
return(eventDataModel);
}
}
public UserDataModel CreateUser(UserDataModel userData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
User user = new User();
user.FullName = userData.FullName;
user.Role = userData.Role;
user.Email = userData.Email;
user.Password = userData.Password;
// string Password = userData.Password;
// string Encrypted = EncriptionAndDecription.Encrypt(Password);
// user.Password = Encrypted;
bool isExist = context.Users.Any(u => u.Email == user.Email);
if (!isExist)
{
context.Users.Add(user);
context.SaveChanges();
return(userData);
}
return(null);
}
}
public EventDataModel EditEvent(EventDataModel eventData)
{
List <string> inviteEmails = ConvertInviteEmails(eventData.InviteEmails);
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
Event editEvent = context.Events.SingleOrDefault(e => e.Id == eventData.Id);
if (eventData != null)
{
editEvent.Description = eventData.Description;
editEvent.DurationInHours = (int)eventData.DurationInHours;
editEvent.InviteEmails = eventData.InviteEmails;
editEvent.Location = eventData.Location;
editEvent.OtherDetails = eventData.OtherDetails;
editEvent.StartTime = (DateTime)eventData.StartTime;
editEvent.Title = eventData.Title;
editEvent.Type = eventData.Type;
editEvent.Date = eventData.Date;
}
context.SaveChanges();
int countOfInvites = 0;
if (inviteEmails != null && editEvent.Type != "Private")
{
foreach (string email in inviteEmails)
{
var user = context.Users.Where(u => u.Email == email).SingleOrDefault();
if (user != null)
{
var invite = context.Invites
.SingleOrDefault(i => i.EventId == editEvent.Id && i.UserId == user.Id);
if (invite == null)
{
Invite inviteDetail = new Invite();
inviteDetail.EventId = editEvent.Id;
inviteDetail.UserId = user.Id;
context.Invites.Add(inviteDetail);
context.SaveChanges();
}
countOfInvites++;
}
}
}
editEvent.TotalInvites = countOfInvites;
context.SaveChanges();
eventData.TotalInvites = countOfInvites;
return(eventData);
}
}
public CommentDataModel CreateComments(CommentDataModel commentsData)
{
using (var context = new BookReadingEventsDBEntities())
{
Comment newComment = new Comment();
newComment.Comment1 = commentsData.Comment;
newComment.Date = commentsData.Date;
newComment.EventId = commentsData.EventId;
newComment.UserId = commentsData.UserId;
newComment.UserName = commentsData.UserName;
context.Comments.Add(newComment);
context.SaveChanges();
return(commentsData);
}
}
public List <EventDataModel> GetInvites(InviteDataModel invitesData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
List <EventDataModel> listOfInvites = null;
Event eventModel = new Event();
Invite inviteModel = new Invite();
var invitesEntityList = context.Invites.Where(i => i.UserId == invitesData.UserId).
GroupJoin(context.Events,
i => i.EventId, e => e.Id, (i, eve) => new
{
eventDetail = eve
});
if (invitesEntityList != null)
{
listOfInvites = new List <EventDataModel>();
foreach (var invite in invitesEntityList)
{
EventDataModel eventDataModel = new EventDataModel();
eventDataModel.Date = invite.eventDetail.ElementAt(0).Date;
eventDataModel.Description = invite.eventDetail.ElementAt(0).Description;
eventDataModel.DurationInHours = (int)invite.eventDetail.ElementAt(0).DurationInHours;
eventDataModel.Id = invite.eventDetail.ElementAt(0).Id;
eventDataModel.InviteEmails = invite.eventDetail.ElementAt(0).InviteEmails;
eventDataModel.Location = invite.eventDetail.ElementAt(0).Location;
eventDataModel.OtherDetails = invite.eventDetail.ElementAt(0).OtherDetails;
eventDataModel.StartTime = (DateTime)invite.eventDetail.ElementAt(0).StartTime;
eventDataModel.Title = invite.eventDetail.ElementAt(0).Title;
eventDataModel.TotalInvites = (int)invite.eventDetail.ElementAt(0).TotalInvites;
eventDataModel.Type = invite.eventDetail.ElementAt(0).Type;
eventDataModel.UserId = invite.eventDetail.ElementAt(0).UserId;
listOfInvites.Add(eventDataModel);
}
}
return(listOfInvites);
}
}
public List <EventDataModel> GetUserPastEvents(EventDataModel eventData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
List <EventDataModel> listOfEvents = null;
var eventsEntityList = context.Events.OrderByDescending(e => e.Date)
.Where(e => e.Date < DateTime.Now && e.Type == "Public" ||
(e.Type == "Private" && e.UserId == eventData.UserId && e.Date < DateTime.Now))
.ToList();
if (eventsEntityList != null)
{
listOfEvents = new List <EventDataModel>();
foreach (Event levent in eventsEntityList)
{
EventDataModel eventDataModel = new EventDataModel();
eventDataModel.Date = levent.Date;
eventDataModel.Description = levent.Description;
eventDataModel.DurationInHours = (int)levent.DurationInHours;
eventDataModel.Id = levent.Id;
eventDataModel.InviteEmails = levent.InviteEmails;
eventDataModel.Location = levent.Location;
eventDataModel.OtherDetails = levent.OtherDetails;
eventDataModel.StartTime = (DateTime)levent.StartTime;
eventDataModel.Title = levent.Title;
eventDataModel.TotalInvites = (int)levent.TotalInvites;
eventDataModel.Type = levent.Type;
eventDataModel.UserId = levent.UserId;
listOfEvents.Add(eventDataModel);
}
}
return(listOfEvents);
}
}
public UserDataModel LoginUser(UserDataModel userData)
{
using (var context = new BookReadingEventsDBEntities())
{
context.Database.Log = Logger.Log;
User user = context.Users.SingleOrDefault(u => u.Email == userData.Email);
// string Password = userData.Password;
// string Decrypted = EncriptionAndDecription.Decrypt(Password);
var IsValid = context.Users.SingleOrDefault(u => u.Email == userData.Email && u.Password == userData.Password);
if (IsValid != null)
{
userData.FullName = IsValid.FullName;
userData.Role = IsValid.Role;
userData.Email = IsValid.Email;
userData.Id = IsValid.Id;
return(userData);
}
return(null);
}
}
