public IEnumerable <EmployeeData> Get()
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
return(entities.EmployeeDatas.ToList());
}
}
public void SyncUsers()
{
usersToAdd = new List <Employee>();
usersToEdit = new List <Employee>();
using (EmployeeDataEntities db = new EmployeeDataEntities())
{
dbUsers = db.Employees.ToList();
}
var locations = new List <string> {
"LDAP://Domain/OU=Users,OU=AU_TebOM01,OU=BIT,DC=corp1,DC=ad-is,DC=net",
};
empProvider.ClearDictionaries();
locations.ForEach(l => sync(l));
//add user values and update both dicts. remove from dbUsers
empProvider.AddUsers(usersToAdd);
//edit user values and update both dicts. remove from dbUsers
empProvider.EditUsers(usersToEdit);
//change status for users that are still remaining in dbUsers to "Not Available"
empProvider.ChangeUserStatus(dbUsers, UserStatus.NotAvailable);
}
public Emp Get(int id)
{
using (EmployeeDataEntities ed = new EmployeeDataEntities())
{
return(ed.Emps.FirstOrDefault(e => e.EmployeeId == id));
}
}
public IEnumerable <Emp> Get()
{
using (EmployeeDataEntities ed = new EmployeeDataEntities())
{
return(ed.Emps.ToList());
}
}
public HttpResponseMessage LoadEmployeeByID(int id)
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
var entity = entities.EmployeeDatas.FirstOrDefault(emp => emp.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] Emp e)
{
try
{
using (EmployeeDataEntities ed = new EmployeeDataEntities())
{
ed.Emps.Add(e);
ed.SaveChanges();
var msg = Request.CreateResponse(HttpStatusCode.Created, e);
msg.Headers.Location = new Uri(Request.RequestUri + e.EmployeeId.ToString());
return(msg);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage POST([FromBody] EmployeeData employee)
{
try
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
entities.EmployeeDatas.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 Put(int id, [FromBody] Emp emp)
{
using (EmployeeDataEntities ed = new EmployeeDataEntities())
{
var entity = ed.Emps.FirstOrDefault(e => e.EmployeeId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee Id =" + id.ToString()));
}
else
{
entity.Name = emp.Name;
entity.Age = emp.Age;
entity.Salary = emp.Salary;
entity.Designation = emp.Designation;
ed.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
public HttpResponseMessage Get(string gender)
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
//string username = Thread.CurrentPrincipal.Identity.Name;
switch (gender.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.EmployeeDatas.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK, entities.EmployeeDatas.Where(emp => emp.Gender.ToLower() == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK, entities.EmployeeDatas.Where(emp => emp.Gender.ToLower() == "female").ToList()));
default:
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Value for gender must be male, female, or all " + gender + " is invalid"));
}
}
}
public HttpResponseMessage LoadEmployee()
{
try
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
var entity = entities.EmployeeDatas.ToList();
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is no data in DB"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PUT([FromBody] int id, [FromUri] EmployeeData employee)
{
try
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
var entity = entities.EmployeeDatas.FirstOrDefault(emp => emp.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID: " + id.ToString() + " Not found."));
}
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 HttpResponseMessage Delete(int id)
{
try
{
using (EmployeeDataEntities entities = new EmployeeDataEntities())
{
var entity = entities.EmployeeDatas.FirstOrDefault(emp => emp.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID: " + id.ToString() + " not found to delete."));
}
else
{
entities.EmployeeDatas.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (EmployeeDataEntities ed = new EmployeeDataEntities())
{
var entity = ed.Emps.FirstOrDefault(e => e.EmployeeId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee Id =" + id.ToString()));
}
else
{
ed.Emps.Remove(ed.Emps.FirstOrDefault(e => e.EmployeeId == id));
ed.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Index()
{
EmployeeDataEntities db = new EmployeeDataEntities();
return(View(db.employees.ToList()));
}
public EmployeeData Get(int id)
{
EmployeeDataEntities entities = new EmployeeDataEntities();
return(entities.EmployeeDatas.FirstOrDefault(emp => emp.ID == id));
}
