using System; using System.Collections.Generic; using System.Data; using System.Data.Entity; using System.Data.Entity.Infrastructure; using System.Linq; using System.Net; using System.Net.Http; using System.Threading.Tasks; using System.Web.Http; using System.Web.Http.Description; using Projects.Models; namespace Projects.Controllers.api { [AllowCrossSiteJson] public class ProjectsController : ApiController { private ProjectsDBEntities db = new ProjectsDBEntities(); // GET: api/Projects public IQueryable GetProjects() { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; return db.Projects; } // GET: api/Projects/5 [ResponseType(typeof(Project))] public async Task GetProject(int id) { Project project = await db.Projects.FindAsync(id); if (project == null) { return NotFound(); } return Ok(project); } // PUT: api/Projects/5 [ResponseType(typeof(void))] public async Task PutProject(int id, Project project) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != project.id) { return BadRequest(); } db.Entry(project).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProjectExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); } // POST: api/Projects [ResponseType(typeof(Project))] public async Task PostProject(Project project) { if (!ModelState.IsValid) { return BadRequest(ModelState); } db.Projects.Add(project); await db.SaveChangesAsync(); return CreatedAtRoute("DefaultApi", new { id = project.id }, project); } // DELETE: api/Projects/5 [ResponseType(typeof(Project))] public async Task DeleteProject(int id) { Project project = await db.Projects.FindAsync(id); if (project == null) { return NotFound(); } db.Projects.Remove(project); await db.SaveChangesAsync(); return Ok(project); } protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); } private bool ProjectExists(int id) { return db.Projects.Count(e => e.id == id) > 0; } } }