blob: eadd9109fcc4f0477b589c9c69ee07a08a4923fd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
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.Web.Http;
using System.Web.Http.Description;
using HousingWebApi;
namespace HousingWebApi.Controllers
{
public class ApartmentChangesController : ApiController
{
private DataModel db = new DataModel();
// GET: api/ApartmentChanges
public IQueryable<ApartmentChange> GetApartmentChanges()
{
return db.ApartmentChanges;
}
[Route("api/ApartmentChangesByid/{id}")]
public IQueryable<ApartmentChange> GetApartmentChangesByid(int id)
{
var changetlist = from change in db.ApartmentChanges
where (change.ApartmentId == id)
orderby change.ChangeId descending
select change;
return changetlist;
}
// GET: api/ApartmentChanges/5
[ResponseType(typeof(ApartmentChange))]
public IHttpActionResult GetApartmentChange(int id)
{
ApartmentChange apartmentChange = db.ApartmentChanges.Find(id);
if (apartmentChange == null)
{
return NotFound();
}
return Ok(apartmentChange);
}
// PUT: api/ApartmentChanges/5
[ResponseType(typeof(void))]
public IHttpActionResult PutApartmentChange(int id, ApartmentChange apartmentChange)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != apartmentChange.ChangeId)
{
return BadRequest();
}
db.Entry(apartmentChange).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ApartmentChangeExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
// POST: api/ApartmentChanges
[ResponseType(typeof(ApartmentChange))]
public IHttpActionResult PostApartmentChange(ApartmentChange apartmentChange)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
db.ApartmentChanges.Add(apartmentChange);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (ApartmentChangeExists(apartmentChange.ChangeId))
{
return Conflict();
}
else
{
throw;
}
}
return CreatedAtRoute("DefaultApi", new { id = apartmentChange.ChangeId }, apartmentChange);
}
// DELETE: api/ApartmentChanges/5
[ResponseType(typeof(ApartmentChange))]
public IHttpActionResult DeleteApartmentChange(int id)
{
ApartmentChange apartmentChange = db.ApartmentChanges.Find(id);
if (apartmentChange == null)
{
return NotFound();
}
db.ApartmentChanges.Remove(apartmentChange);
db.SaveChanges();
return Ok(apartmentChange);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
private bool ApartmentChangeExists(int id)
{
return db.ApartmentChanges.Count(e => e.ChangeId == id) > 0;
}
}
}
|