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