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