public HttpResponseMessage Put(int ID, [FromBody] tblEmployee emp)
{
try
{
using (TestingDBEntities entities = new TestingDBEntities())
{
var entity = entities.tblEmployees.FirstOrDefault(e => e.Id == ID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Entity with Id" + ID.ToString() + "not found"));
}
else
{
entity.Id = emp.Id;
entity.Name = emp.Name;
entity.Salary = emp.Salary;
entity.Gender = emp.Gender;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <Employee> GetAllEmployee()
{
using (TestingDBEntities ent = new TestingDBEntities())
{
return(ent.Employees.ToList());
}
}
public HttpResponseMessage Delete(int ID)
{
try
{
using (TestingDBEntities entities = new TestingDBEntities())
{
var entity = entities.tblEmployees.FirstOrDefault(e => e.Id == ID);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + ID.ToString() + "Not found"));
}
else
{
entities.tblEmployees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public static bool Login(string username, string password)
{
using (TestingDBEntities objEntities = new TestingDBEntities())
{
return(objEntities.Users.Any(user => user.UserName.Equals(username, StringComparison.OrdinalIgnoreCase) &&
user.UserPwd == password));
}
}
public HttpResponseMessage Get(int id)
{
using (TestingDBEntities entities = new TestingDBEntities())
{
var entity = entities.tblEmployees.FirstOrDefault(e => e.Id == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + "Not found"));
}
}
}
public HttpResponseMessage Post([FromBody] tblEmployee emp)
{
try
{
TestingDBEntities entitites = new TestingDBEntities();
entitites.tblEmployees.Add(emp);
entitites.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, emp);
message.Headers.Location = new Uri(Request.RequestUri + emp.Id.ToString());
return(message);
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public HttpResponseMessage Get(string gender = "All")
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (TestingDBEntities objentities = new TestingDBEntities())
{
switch (username.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, objentities.tblEmployees.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK, objentities.tblEmployees.Where(e => e.Gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK, objentities.tblEmployees.Where(e => e.Gender.ToLower() == "female").ToList()));
default:
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Value for Gender must ALL or male or Female" + gender + "invalid"));
}
}
}
