public ActionResult Create([Bind(Include = "Id,EventTitle,Abstract,EventDescription,StartDate,EndDate,Location,Url,Price,EventGroupTitle,EventGroupName,EventTypeOne")] CalendarEvent calendarevent) { if (ModelState.IsValid) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { try { calendarevent.CreatedDateTime = DateTime.UtcNow; calendarevent.LastUpdateDateTime = DateTime.UtcNow; calendarevent.IsDeleted = false; db.CalendarEvents.Add(calendarevent); db.SaveChanges(); return(Content("Event has been created successfully!")); } catch (Exception ex) { return(Content("There is problem in saving the event. Please try again.")); } } } else { return(View(calendarevent)); } }
// PUT api/Event/5 public IHttpActionResult PutCalendarEvent(int id, CalendarEvent calendarevent) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != calendarevent.Id) { return(BadRequest()); } using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities()) { try { eventOrganizerEntities.Entry(calendarevent).State = EntityState.Modified; eventOrganizerEntities.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CalendarEventExists(id)) { return(NotFound()); } else { throw; } } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { CalendarEvent calendarevent = db.CalendarEvents.Find(id); db.CalendarEvents.Remove(calendarevent); db.SaveChanges(); } return(RedirectToAction("Index")); }
private bool DeleteTitleType(int Id) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { var item = db.EventTypeOnes.Where(x => x.Id == Id).FirstOrDefault(); if (item != null) { item.IsDeleted = true; db.SaveChanges(); } } return(false); }
public ActionResult Edit([Bind(Include = "Id,EventTitle,Abstract,EventDescription,StartDate,EndDate,Location,Url,Price,EventGroupTitle,EventGroupName,EventTypeOne,CreatedDateTime,LastUpdateDateTime,IsDeleted")] CalendarEvent calendarevent) { if (ModelState.IsValid) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { db.Entry(calendarevent).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(calendarevent)); }
public IHttpActionResult PostCalendarEvent(CalendarEvent calendarevent) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities()) { eventOrganizerEntities.CalendarEvents.Add(calendarevent); eventOrganizerEntities.SaveChanges(); } return(CreatedAtRoute("DefaultApi", new { id = calendarevent.Id }, calendarevent)); }
private void EditTitleType(string titleType, int id) { if (!string.IsNullOrEmpty(titleType)) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { var item = db.EventTypeOnes.Where(x => x.Id == id).FirstOrDefault(); db.Usp_UpdateCalendarEvents(titleType, item.EventTypeName, (int)Purpose.EditType); if (item != null) { item.EventTypeName = titleType; db.SaveChanges(); } } } }
private void EditGroupTitle(string groupTitle, int id) { if (!string.IsNullOrEmpty(groupTitle)) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { var item = db.EventGroupTitles.Where(x => x.Id == id).FirstOrDefault(); db.Usp_UpdateCalendarEvents(groupTitle, item.Title, (int)Purpose.EditGroupTitle); if (item != null) { item.Title = groupTitle; db.SaveChanges(); } } } }
private void AddTitleType(string name) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { var item = db.EventTypeOnes.Where(x => x.EventTypeName == name).FirstOrDefault(); if (item == null) { EventTypeOne obj = new EventTypeOne(); obj.EventTypeName = name; obj.IsDeleted = false; obj.CreatedDateTime = DateTime.UtcNow; obj.LastUpdateDateTime = DateTime.UtcNow; db.EventTypeOnes.Add(obj); db.SaveChanges(); } } }
public IHttpActionResult DeleteCalendarEvent(int id) { CalendarEvent calendarevent; using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities()) { calendarevent = eventOrganizerEntities.CalendarEvents.Find(id); if (calendarevent == null) { return(NotFound()); } else { eventOrganizerEntities.CalendarEvents.Remove(calendarevent); eventOrganizerEntities.SaveChanges(); } } return(Ok(calendarevent)); }
private void AddGroupName(string name) { if (!string.IsNullOrEmpty(name)) { using (EventOrganizerEntities db = new EventOrganizerEntities()) { var item = db.EventGroupNames.Where(x => x.GroupName == name).FirstOrDefault(); if (item == null) { EventGroupName obj = new EventGroupName(); obj.GroupName = name; obj.IsDeleted = false; obj.CreatedDateTime = DateTime.UtcNow; obj.LastUpdateDateTime = DateTime.UtcNow; db.EventGroupNames.Add(obj); db.SaveChanges(); } } } }