// GET: api/Users
public ArrayList Get()
{
// return new string[] { "value1", "value2" };
UsersSql db = new UsersSql();
return(db.getUsers());
}
// POST: api/User
public HttpResponseMessage Post([FromBody] User user)
{
UsersSql db = new UsersSql();
long id;
id = db.postUser(user);
user.Id = (int)id;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created);
response.Headers.Location = new Uri(Request.RequestUri, String.Format("user/{0}", id));
return(response);
}
// GET: api/Users/5
// public String Get(int id)
public User Get(int id)
{
UsersSql db = new UsersSql();
User user = db.getUser(id);
// user.Id = id;
// user.Lastname = "World";
// user.Firstname = "Hello";
// return "value";
return(user);
}
// DELETE: api/Users/5
// public void Delete(int id)
public HttpResponseMessage Delete(int id)
{
UsersSql db = new UsersSql();
bool deleteSuccess = false;
HttpResponseMessage response;
deleteSuccess = db.deleteUser(id);
if (deleteSuccess)
{
response = Request.CreateResponse(HttpStatusCode.NoContent);
}
else
{
response = Request.CreateResponse(HttpStatusCode.NotFound);
}
return(response);
}
// PUT: api/Users/5
// public void Put(int id, [FromBody]User value)
public HttpResponseMessage Put(int id, [FromBody] User user)
{
UsersSql db = new UsersSql();
bool updateSuccess = false;
HttpResponseMessage response;
updateSuccess = db.putUser(id, user);
if (updateSuccess)
{
response = Request.CreateResponse(HttpStatusCode.NoContent);
}
else
{
response = Request.CreateResponse(HttpStatusCode.NotFound);
}
return(response);
}
public UsersBL(string connectionString)
{
_users = new UsersSql(connectionString);
}
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.Sql(UsersSql.RemoveRoleSql(RoleNames.Technician));
migrationBuilder.Sql(UsersSql.RemoveRoleSql(RoleNames.Liner));
}
