// PUT api/Users/5
public HttpResponseMessage Puttb_etl_valid_user(int id, tb_etl_valid_user tb_etl_valid_user)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != tb_etl_valid_user.UserId)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(tb_etl_valid_user).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
// GET api/Users/5
public tb_etl_valid_user Gettb_etl_valid_user(int id)
{
tb_etl_valid_user tb_etl_valid_user = db.tb_etl_valid_user.Find(id);
if (tb_etl_valid_user == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(tb_etl_valid_user);
}
// POST api/Users
public HttpResponseMessage Posttb_etl_valid_user(tb_etl_valid_user tb_etl_valid_user)
{
if (ModelState.IsValid)
{
db.tb_etl_valid_user.Add(tb_etl_valid_user);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, tb_etl_valid_user);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = tb_etl_valid_user.UserId }));
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
// DELETE api/Users/5
public HttpResponseMessage Deletetb_etl_valid_user(int id)
{
tb_etl_valid_user tb_etl_valid_user = db.tb_etl_valid_user.Find(id);
if (tb_etl_valid_user == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
db.tb_etl_valid_user.Remove(tb_etl_valid_user);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, tb_etl_valid_user));
}
