public HttpResponseMessage Put([FromBody] int id, [FromUri] Employee employee)
{
try
{
using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, id + " not found"));
}
else
{
entity.First_Name = employee.First_Name;
entity.Last_Name = employee.Last_Name;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
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 (WebAPI_Tutorial_DatabaseEntities entity = new WebAPI_Tutorial_DatabaseEntities())
{
return(entity.Users.Any(u => u.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && u.Password.Equals(password)));
}
}
//public Employee Get(int id)
//{
// using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
// {
// //return entities.Employees.Find(id);
// return entities.Employees.FirstOrDefault(e => e.ID == id);
// }
//}
public HttpResponseMessage Get(int id)
{
using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
{
//return entities.Employees.Find(id);
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee ID " + id + " not found"));
}
}
}
public HttpResponseMessage Get()
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
{
switch (username.ToLower())
{
case "male":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender == "Male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender == "Female").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
}
// ai ta disi karon amra Get() function k call na kore Emp likhsi. but, code to r Emp() k chine na. tai.
// code chine Get(), GetSomething() k. emon [HttpPut], [HttpPost], [HttpDelete] ase
//[HttpGet]
//public IEnumerable<Employee> amrShonarBangla()
//{
// using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
// {
// return entities.Employees.ToList();
// }
//}
public HttpResponseMessage Get(string gender = "all")
{
using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
{
if (gender.ToLower().Equals("all"))
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList()));
}
else if (gender.ToLower().Equals("male"))
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender.ToLower() == gender).ToList()));
}
else if (gender.ToLower().Equals("female"))
{
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender.ToLower() == gender).ToList()));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, gender + " not found"));
}
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, id + " not found"));
}
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post([FromBody] Employee employee)
{
try
{
using (WebAPI_Tutorial_DatabaseEntities entities = new WebAPI_Tutorial_DatabaseEntities())
{
entities.Employees.Add(employee);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, employee));
//var message = Request.CreateResponse(HttpStatusCode.Created, employee);
//-- nicher ai ta likhle path shoho fixed hoye jabe.. tutorial-7 (09:20)
//message.Headers.Location = new Uri(Request.RequestUri + "/" + employee.ID.ToString());
//return message;
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
