public async Task <IHttpActionResult> UpdateFESearchRequest(int id, FESearchRequest fESearchRequest)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != fESearchRequest.ID)
{
return(BadRequest());
}
using (var db = new FEMainDBContext()) {
db.Entry(fESearchRequest).State = EntityState.Modified;
try {
await db.SaveChangesAsync();
} catch (DbUpdateConcurrencyException) {
if (!FESearchRequestExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IEnumerable <FESearchRequest> GetFESearchRequests()
{
IEnumerable <FESearchRequest> sReqs = null;
using (var db = new FEMainDBContext()) {
sReqs = db.FESearchRequests;
}
return(sReqs);
}
public async Task <IHttpActionResult> PostFEExecution(FEExecution fEExecution)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var db = new FEMainDBContext()) {
db.FEExecutions.Add(fEExecution);
await db.SaveChangesAsync();
}
return(CreatedAtRoute("DefaultApi", new { id = fEExecution.ID }, fEExecution));
}
public IEnumerable <FEExecution> GetFEExecutions(int searchRequestID)
{
IEnumerable <FEExecution> executionsOfSReq = null;
using (var db = new FEMainDBContext()) {
executionsOfSReq = db.FEExecutions
.Where(exec => exec.SearchRequestID == searchRequestID)
.Include(exec => exec.TheResults)
.OrderByDescending(exec => exec.FinishedOn)
.ToList();
}
return(executionsOfSReq);
}
public async Task <IHttpActionResult> UpdateFESearchRequestStatus(int id, Status newStatus)
{
FESearchRequest oldSearchRequest = null;
using (var db = new FEMainDBContext()) {
oldSearchRequest = await db.FESearchRequests.FindAsync(id);
if (oldSearchRequest == null)
{
return(NotFound());
}
oldSearchRequest.TheStatus = newStatus;
}
return(await UpdateFESearchRequest(id, oldSearchRequest));
}
public async Task <IHttpActionResult> GetFESearchRequest(int id)
{
FESearchRequest fESearchRequest = null;
using (var db = new FEMainDBContext()) {
fESearchRequest = db.FESearchRequests
.Where(sReq => sReq.ID == id)
.Include(sReq => sReq.TheLatestExecution.TheResults)
.First();
}
if (fESearchRequest == null)
{
return(NotFound());
}
return(Ok(fESearchRequest));
}
public IEnumerable <FESearchRequest> GetFESearchRequests(string userID)
{
IEnumerable <FESearchRequest> searchRequestsByUser = null;
using (var db = new FEMainDBContext()) {
try {
searchRequestsByUser = db.FESearchRequests
.Where(sReq => sReq.TheUserID == userID)
.Include(sReq => sReq.TheLatestExecution.TheResults)
.ToList();
return(searchRequestsByUser);
} catch {
}
}
return(searchRequestsByUser);
}
/*
* protected override void Dispose(bool disposing) {
* if(disposing) {
* db.Dispose();
* }
* base.Dispose( disposing );
* }
*/
private bool FESearchRequestExists(int id)
{
using (var db = new FEMainDBContext()) {
return(db.FESearchRequests.Count(e => e.ID == id) > 0);
}
}
