public HttpResponseMessage DeleteEmployee(int id)
{
try
{
using (EmpEntities entities = new EmpEntities())
{
var employee = entities.employees.FirstOrDefault(x => x.id == id);
if (employee != null)
{
entities.employees.Remove(employee);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK, "Deleteed Successfully!!");
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Emp not found :" + id));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage EditEmployee(int id, [FromBody] employee emp)
{
try
{
using (EmpEntities entities = new EmpEntities())
{
var eachEmployee = entities.employees.FirstOrDefault(x => x.id == id);
if (eachEmployee != null)
{
eachEmployee.id = emp.id;
eachEmployee.ename = emp.ename;
eachEmployee.dept_id = emp.dept_id;
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully!!");
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Emp not found :" + id));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public List <Emp> GetEmployees(EmployeeModel emp)
{
EmpEntities entities = new EmpEntities();
return((from c in entities.Emps.Take(10)
where c.EmpName.StartsWith(emp.Name) || string.IsNullOrEmpty(emp.Name)
select c).ToList());
}
public employee Get()
{
EmpEntities entities = new EmpEntities();
var employees = entities.employees.FirstOrDefault();
var msg = Request.CreateResponse(HttpStatusCode.Accepted, employees);
return(employees);
}
//[BasicAuthentication]
// [Authorize]
public HttpResponseMessage GetEmployee()
{
EmpEntities entities = new EmpEntities();
var employees = entities.employees.ToList();
var msg = Request.CreateResponse(HttpStatusCode.Accepted, employees);
return(msg);
}
public static bool Login(string username, string password)
{
using (EmpEntities entities = new EmpEntities())
{
return(entities.Users.Any(user =>
user.Username.Equals(username, StringComparison.OrdinalIgnoreCase) &&
user.Password == password));
}
}
public HttpResponseMessage PostEmployee([FromBody] employee emp)
{
try
{
using (EmpEntities entities = new EmpEntities())
{
entities.employees.Add(emp);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, emp);
message.Headers.Location = new Uri(Request.RequestUri + emp.id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public employee GetEmployeeById(int id)
{
EmpEntities entities = new EmpEntities();
return(entities.employees.FirstOrDefault(x => x.id == id));
}
