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