public IHttpActionResult GetCustomers()
{
var db = new EmployeeDBEntities1();
var customers = db.Customers.ToList();
return(Ok(customers));
}
public IEnumerable <Employee> Get()
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
return(entities.Employees.ToList());
}
}
public Employee Get(string code)
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
return(entities.Employees.FirstOrDefault(e => e.code == code));
}
}
public HttpResponseMessage GetEmployees()
{
try
{
EmployeeDBEntities1 context = new EmployeeDBEntities1();
var employees = context.Employees.ToList();
List <EmployeeModel> list = new List <EmployeeModel>();
foreach (var item in employees)
{
EmployeeModel emp = new EmployeeModel();
emp.Id = item.Id;
emp.FirstName = item.FirstName;
emp.LastName = item.LastName;
emp.Email = item.Email;
emp.Gender = item.Gender;
emp.Country = item.Country.Name;
emp.State = item.State.Name;
emp.City = item.City.Name;
emp.Department = item.Department.Name;
emp.DateOfBirth = item.DateOfBirth;
emp.DateOfJoining = item.DateOfJoining;
emp.IsActive = item.IsActive;
emp.Role = item.RoleMaster.Name;
emp.Phone = item.Phone;
list.Add(emp);
}
return(Request.CreateResponse((employees != null && employees.Count > 0) ? HttpStatusCode.OK : HttpStatusCode.NoContent, list.OrderByDescending(x => x.Id)));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage GetCities(int stateId)
{
try
{
EmployeeDBEntities1 context = new EmployeeDBEntities1();
var cities = context.Cities.Where(x => x.StateId == stateId).ToList();
List <CityModel> lst = new List <CityModel>();
if (cities != null && cities.Count > 0)
{
foreach (var item in cities)
{
CityModel sm = new CityModel()
{
Id = item.Id, Name = item.Name
};
lst.Add(sm);
}
}
return(Request.CreateResponse(HttpStatusCode.OK, lst));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
//[Route("authenticate")]
public IHttpActionResult AuthenticateUser([FromBody] LoginRequest request)
{
EmployeeDBEntities1 context = new EmployeeDBEntities1();
var loginResponse = new LoginResponse();
LoginRequest loginrequest = new LoginRequest {
};
loginrequest.Username = request.Username.ToLower();
loginrequest.Password = request.Password;
IHttpActionResult response;
HttpResponseMessage responseMsg = new HttpResponseMessage();
bool isUsernamePasswordValid = false;
if (request != null)
{
isUsernamePasswordValid = context.Users.Any(u => u.Username == request.Username && u.Password == request.Password);
}
// if credentials are valid
if (isUsernamePasswordValid)
{
string token = createToken(loginrequest.Username);
//return the token
return(Ok <string>(token));
}
else
{
// if credentials are not valid send unauthorized status code in response
loginResponse.responseMsg.StatusCode = HttpStatusCode.Unauthorized;
response = ResponseMessage(loginResponse.responseMsg);
return(response);
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + " not found to delete"));
}
else
{
entities.Employees.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Put(int id, [FromBody] Employee employee)
{
try
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id = " + id.ToString() + " has no record "));
}
else
{
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public EmployeeController()
{
if (_employeeDBEntities == null)
{
EmployeeDBEntities1 employeeDBEntities = new EmployeeDBEntities1();
_employeeDBEntities = employeeDBEntities;
}
}
public IHttpActionResult DeleteCustomer(int id)
{
var db = new EmployeeDBEntities1();
var customer = new Customer {
Id = id
};
db.Customers.Attach(customer);
db.Customers.Remove(customer);
db.SaveChanges();
return(Ok(id));
}
public HttpResponseMessage GetRoles()
{
try
{
EmployeeDBEntities1 context = new EmployeeDBEntities1();
var countries = context.RoleMasters.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, countries));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage LoadEmployeeById(int id)
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
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 with id: " + id.ToString() + " not found"));
}
}
}
public IHttpActionResult SaveCustomer(Customer customer)
{
if (customer.Id > 0)
{
var db = new EmployeeDBEntities1();
var dbCustomer = db.Customers.FirstOrDefault(x => x.Id == customer.Id);
dbCustomer.Name = customer.Name;
dbCustomer.Address = customer.Address;
dbCustomer.Phone = customer.Phone;
db.SaveChanges();
}
else
{
var db = new EmployeeDBEntities1();
db.Customers.Add(customer);
db.SaveChanges();
}
return(Ok(customer.Id));
}
public HttpResponseMessage GetEmployeeById(int id)
{
try
{
EmployeeDBEntities1 context = new EmployeeDBEntities1();
var employees = context.Employees.Where(emp => emp.Id == id).FirstOrDefault();
if (employees == null)
{
return(Request.CreateResponse(HttpStatusCode.NoContent, string.Format("No Employee with Id = {0} found", id)));
}
else
{
EmployeeModel employee = new EmployeeModel()
{
Id = employees.Id,
FirstName = employees.FirstName,
LastName = employees.LastName,
Email = employees.Email,
Gender = employees.Gender,
Country = employees.Country.Name,
State = employees.State.Name,
City = employees.City.Name,
Department = employees.Department.Name,
DateOfBirth = employees.DateOfBirth,
DateOfJoining = employees.DateOfJoining,
IsActive = employees.IsActive,
Role = employees.RoleMaster.Name,
Phone = employees.Phone,
CountryId = employees.CountryId,
StateId = employees.StateId,
CityId = employees.CityId,
DepartmentId = employees.DepartmentId,
RoleType = employees.RoleType
};
return(Request.CreateResponse(HttpStatusCode.OK, employee));
// return Request.CreateResponse(HttpStatusCode.NoContent);
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage Post([FromBody] Employee employee)
{
try
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
entities.Employees.Add(employee);
entities.SaveChanges();
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));
}
}
public HttpResponseMessage LoadEmployee(string gender = "All")
{
using (EmployeeDBEntities1 entities = new EmployeeDBEntities1())
{
switch (gender.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList()));
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.CreateErrorResponse(HttpStatusCode.BadRequest,
"Value for gender must All, Male or Female " + gender + " is invalid "));
}
}
}
