// PUT api/riders/5
public HttpResponseMessage Put(int id, [FromBody] Rider rider)
{
try
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
var entity = entities.Rider.FirstOrDefault(e => e.Id == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Rider with id = " + id.ToString() + "not found"));
}
else
{
entity.FirstName = rider.FirstName;
entity.LastName = rider.LastName;
entity.Phone_Number = rider.Phone_Number;
entity.Email = rider.Email;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// PUT api/jobs/5
public HttpResponseMessage Put(int id, [FromBody] jobs job)
{
try
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
var entity = entities.jobs.FirstOrDefault(e => e.Id == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Jobs with id = " + id.ToString() + "not found"));
}
else
{
entity.Date_Time = job.Date_Time;
entity.Rider_Id = job.Rider_Id;
entity.Review_Score = job.Review_Score;
entity.Review_Comment = job.Review_Comment;
entity.Completed_At = job.Completed_At;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// GET api/jobs
public HttpResponseMessage Get(string type = "all")
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
switch (type)
{
case "average":
var groupJobs = entities.jobs.GroupBy(t => new { Id = t.Rider_Id })
.Select(g => new
{
Average = g.Average(p => p.Review_Score),
ID = g.Key.Id, Max = g.Max(p => p.Review_Score), BestComment = g.Max(p => p.Review_Comment)
});
var query =
from riders in entities.Rider
join job in groupJobs on riders.Id equals job.ID
select new { Jobs = job, Riders = riders };
return(Request.CreateResponse(HttpStatusCode.OK, query.ToList()));
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.jobs.ToList()));
}
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Page Not Found"));
}
// return null;
}
// GET api/riders
public IEnumerable <Rider> Get()
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
return(entities.Rider.ToList());
}
// return null;
}
// GET api/riders/5
public HttpResponseMessage Get(int id)
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
var entity = entities.Rider.FirstOrDefault(e => e.Id == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Rider with id = " + id.ToString() + "not found"));
}
}
}
// DELETE api/jobs/5
public HttpResponseMessage Delete(int id)
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
var entity = entities.jobs.FirstOrDefault(e => e.Id == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Jobs with id = " + id.ToString() + "not found"));
}
else
{
entities.jobs.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
// POST api/jobs
public HttpResponseMessage Post([FromBody] jobs jobs)
{
try
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
entities.jobs.Add(jobs);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, jobs);
message.Headers.Location = new Uri(Request.RequestUri + jobs.Id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// POST api/riders
public HttpResponseMessage Post([FromBody] Rider rider)
{
try
{
using (RidersDetailsEntities entities = new RidersDetailsEntities())
{
rider.Start_Date = DateTime.Now;
entities.Rider.Add(rider);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, rider);
message.Headers.Location = new Uri(Request.RequestUri + rider.Id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}