public JArray GetAllEventsbyID(int id) { tevent eventfound = db.tevents.Find(id); if (eventfound == null) { BadRequest(); } var selectedAll = from s in db.tevents where s.eventID == id select s; List <tevent> eventList = selectedAll.ToList(); JArray array = new JArray(); foreach (var elist in eventList) { JObject obj = new JObject(); obj["eventid"] = elist.eventID; obj["ename"] = elist.ename; obj["edate"] = elist.scheduledOn; obj["edes"] = elist.edescription; obj["userid"] = elist.userID; array.Add(obj); } return(array); }
public IHttpActionResult PutEventTable(int id, tevent eventTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != eventTable.eventID) { return(BadRequest()); } db.Entry(eventTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EventTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostEventTable(tevent eventTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tevents.Add(eventTable); try { db.SaveChanges(); } catch (DbUpdateException) { if (EventTableExists(eventTable.eventID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = eventTable.eventID }, eventTable)); }
public IHttpActionResult updateEvent(int id, tevent ev) { var entity = db.tevents.FirstOrDefault(e => e.eventID == id); entity.ename = ev.ename; entity.edescription = ev.edescription; entity.scheduledOn = ev.scheduledOn; entity.userID = entity.userID; db.SaveChanges(); return(Ok()); }
public IHttpActionResult DeleteEventTable(int id) { tevent eventTable = db.tevents.Find(id); if (eventTable == null) { return(NotFound()); } db.tevents.Remove(eventTable); db.SaveChanges(); return(Ok(eventTable)); }
public string fetchpast(int eventid) { var todaydate = DateTime.Now; tevent eventfound = db.tevents.Find(eventid); if (eventfound == null) { return(null); } else { var upcomingEvents = (from s in db.tevents where s.scheduledOn < todaydate && s.eventID == eventid orderby s.scheduledOn ascending select s.ename).FirstOrDefault(); return(upcomingEvents); } }