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)); }