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); }
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); }
// 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 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 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); } }
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 (DbEntityValidationException e) { StringBuilder sb = new StringBuilder(); foreach (var eve in e.EntityValidationErrors) { sb.Append(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { sb.Append(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } return Content(sb.ToString()); } catch (Exception ex) { //return Content(ex.Message.ToString()); return Content("There is problem in saving the event. Please try again."); } } } else { return View(calendarevent); } }
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 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 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; }
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(); } } }
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(); } } } }