public IHttpActionResult GetAllEntries()
{
IList <EntryViewModel> entries = null;
using (errorkbEntryEntities entities = new errorkbEntryEntities())
{
entries = entities.entries.Select(e => new EntryViewModel()
{
id = e.e_id,
timestamp = e.timestamp,
title = e.title,
description = e.description,
status = e.status,
user = e.user,
solution = e.solution,
category = e.category,
catdesc = e.catdesc
}
).ToList <EntryViewModel>();
}
if (entries.Count == 0)
{
return(NotFound());
}
return(Ok(entries));
}
public IHttpActionResult PutNewEntry(int id, string tit, string desc, string stat, string username, string solution, string category, string catdesc)
{
using (errorkbEntryEntities entities = new errorkbEntryEntities())
{
var existingEntry = entities.entries.Where(s => s.e_id == id).FirstOrDefault();
if (existingEntry != null)
{
existingEntry.title = tit;
existingEntry.description = desc;
existingEntry.status = stat;
existingEntry.user = username;
existingEntry.solution = solution;
existingEntry.category = category;
existingEntry.catdesc = catdesc;
entities.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok());
}
}
public IHttpActionResult PostNewEntry(string tit, string desc, string stat, string username, string solution, string category, string catdesc)
{
using (errorkbEntryEntities entities = new errorkbEntryEntities())
{
if (stat == "open" || stat == "closed")
{
if (category == "product" || category == "process")
{
entities.entries.Add(new entry()
{
title = tit,
description = desc,
status = stat,
user = username,
solution = solution,
category = category,
catdesc = catdesc
});
entities.SaveChanges();
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, "Any object"));
}
else
{
return(Content(HttpStatusCode.BadRequest, "Any object"));
}
}
}
public IHttpActionResult DeleteEntry(int id)
{
using (errorkbEntryEntities entities = new errorkbEntryEntities())
{
var entry = entities.entries.Where(s => s.e_id == id).FirstOrDefault();
if (entry != null)
{
entities.Entry(entry).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
return(Ok());
}
return(NotFound());
}
}
