public void addComment(Comment comment)
{
using (var context = new EventsDBEntities())
{
context.Comments.Add(comment);
context.SaveChanges();
}
}
public int createEvent(Event bookEvent, string username)
{
using (var context = new EventsDBEntities())
{
bookEvent.UserId = getUserId(username);
context.Events.Add(bookEvent);
context.SaveChanges();
return(bookEvent.EventId);
};
}
//Register the user into the database for the given details
public int SignUp(User model)
{
using (var context = new EventsDBEntities())
{
context.Users.Add(model);
UserRolesMapping addRole = new UserRolesMapping();
addRole.UserId = model.UserId;
addRole.RoleId = 2;
context.UserRolesMappings.Add(addRole);
context.SaveChanges();
return(model.UserId);
}
}
public void editEvent(Event eventEntity)
{
using (var context = new EventsDBEntities())
{
var requiredEvent = context.Events.Where(events => events.EventId == eventEntity.EventId).FirstOrDefault();
requiredEvent.Title = eventEntity.Title;
requiredEvent.StartTime = eventEntity.StartTime;
requiredEvent.InviteByEmail = eventEntity.InviteByEmail;
requiredEvent.OtherDetails = eventEntity.InviteByEmail;
requiredEvent.TypeOfEvent = eventEntity.TypeOfEvent;
requiredEvent.Description = eventEntity.Description;
requiredEvent.EventDate = eventEntity.EventDate;
requiredEvent.ModifyDate = DateTime.Now;
context.SaveChanges();
}
}
public JsonResult DeleteEvent(int eventID)
{
bool status = false;
using (EventsDBEntities db = new EventsDBEntities())
{
var v = db.Events.Where(a => a.EventId.Equals(eventID)).FirstOrDefault();
if (v != null)
{
db.Events.Remove(v);
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveEvent(Event evt)
{
bool status = false;
using (EventsDBEntities db = new EventsDBEntities())
{
if (evt.EndAt != null && evt.StartAt.Value.TimeOfDay == new TimeSpan(0, 0, 0) &&
evt.EndAt.Value.TimeOfDay == new TimeSpan(0, 0, 0))
{
evt.IsFullDay = true;
}
else
{
evt.IsFullDay = false;
}
if (evt.EventId > 0)
{
var v = db.Events.Where(a => a.EventId.Equals(evt.EventId)).FirstOrDefault();
if (v != null)
{
v.Title = evt.Title;
v.Description = evt.Description;
v.StartAt = evt.StartAt;
v.EndAt = evt.EndAt;
v.IsFullDay = evt.IsFullDay;
}
}
else
{
db.Events.Add(evt);
}
db.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
