public HttpResponseMessage Delete(int id)
{
try
{
using (WebAPIDemoEmployeeDBEntities entities = new WebAPIDemoEmployeeDBEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
//If an item is not found, status code '404 Not Found' is returned.
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Employee with Id = " + id.ToString() + " not found to delete"));
}
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
//When the deletion is successful, status code '200 OK' is returned.
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Put(int id, [FromBody] Employee employee)
{
try
{
using (WebAPIDemoEmployeeDBEntities entities = new WebAPIDemoEmployeeDBEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
//When we try to update an employee whose id does not exist,status code '404 Not Found' is returned
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Employee with Id " + id.ToString() + " not found to update"));
}
else
{
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
entities.SaveChanges();
//When the update is successful, status code '200 OK' is returned
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
//Checks if the username and password are valid
public static bool Login(string username, string password)
{
using (WebAPIDemoEmployeeDBEntities entities = new WebAPIDemoEmployeeDBEntities())
{
return(entities.Users.Any(user =>
user.Username.Equals(username, StringComparison.OrdinalIgnoreCase) &&
user.Password == password));
}
}
public HttpResponseMessage Get(int id)
{
using (WebAPIDemoEmployeeDBEntities entities = new WebAPIDemoEmployeeDBEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
//When an item is not found, instead of returning NULL and status code '200 OK', '404 Not Found' status code is
//returned along with a meaningful message such as "Employee with Id 101 not found".
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Employee with Id " + id.ToString() + " not found"));
}
}
}
public HttpResponseMessage Get(string gender = "All")
{
using (WebAPIDemoEmployeeDBEntities entities = new WebAPIDemoEmployeeDBEntities())
{
string username = Thread.CurrentPrincipal.Identity.Name;
switch (username.ToLower())
{
case "male":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.Employees.Where(e => e.Gender.ToLower() == "female").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
}
public HttpResponseMessage Post([FromBody] Employee employee)
{
try
{
using (WebAPIDemoEmployeeDBEntities entities = new WebAPIDemoEmployeeDBEntities())
{
entities.Employees.Add(employee);
entities.SaveChanges();
//When a new item is created, status code is '201 Item is Created'.
//With 201 status code the location i.e URI of the newly created item is also included.
var message = Request.CreateResponse(HttpStatusCode.Created, employee);
message.Headers.Location = new Uri(Request.RequestUri +
employee.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
