public IHttpActionResult Get(int id)
{
DTO_SYS_Var tbl_SYS_Var = BS_SYS_Var.get_SYS_Var(db, id);
if (tbl_SYS_Var == null)
{
return(NotFound());
}
return(Ok(tbl_SYS_Var));
}
public IHttpActionResult Post(DTO_SYS_Var tbl_SYS_Var)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_SYS_Var result = BS_SYS_Var.post_SYS_Var(db, tbl_SYS_Var, Username);
if (result != null)
{
return(CreatedAtRoute("get_SYS_Var", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult Delete(int id)
{
bool check = BS_SYS_Var.check_SYS_Var_Exists(db, id);
if (!check)
{
return(NotFound());
}
bool result = BS_SYS_Var.delete_SYS_Var(db, id, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
return(Conflict());
}
public IHttpActionResult Put(int id, DTO_SYS_Var tbl_SYS_Var)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_SYS_Var.ID)
{
return(BadRequest());
}
bool result = BS_SYS_Var.put_SYS_Var(db, id, tbl_SYS_Var, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
public IQueryable <DTO_SYS_Var> Get()
{
return(BS_SYS_Var.get_SYS_Var(db, QueryStrings));
}
public IQueryable <DTO_SYS_Var> GetByTypeOfVar(int typeOfVar)
{
return(BS_SYS_Var.get_SYS_VarByType(db, typeOfVar));
}
