public List <Location> ListLocation() { using (var LocationDBContext = new WorkScheduleDBContext()) { return(LocationDBContext.Locations.ToList()); } }
public List <Employee> getEmployeeList(int id) { using (var context = new WorkScheduleDBContext()) { var data = from Employee in context.Employees where Employee.EmployeeID == id select Employee; return(data.ToList()); } }
public void DeleteEmployeeInfo(Employee Entities) { using (var context = new WorkScheduleDBContext()) { var existingvalue = context.Employees.Find(Entities.EmployeeID); context.Employees.Remove(existingvalue); context.SaveChanges(); } }
public void UpdateEmployeeInfo(Employee Entities) { using (var context = new WorkScheduleDBContext()) { var updating = context.Employees.Attach(Entities); var matchingWithExistingValues = context.Entry <Employee>(updating); matchingWithExistingValues.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public List <DropDwonListPOCOs> getDropDwonList() { using (var context = new WorkScheduleDBContext()) { var data = from EmployeeSkill in context.EmployeeSkills select new DropDwonListPOCOs { ID = EmployeeSkill.EmployeeID, Descripotion = EmployeeSkill.Skill.Description }; return(data.ToList()); } }
public List <EmployeeSkillPOCOs> getEmployeeSkillPOCOs() { using (var context = new WorkScheduleDBContext()) { var result = from employeeskill in context.EmployeeSkills orderby employeeskill.Employee.LastName select new EmployeeSkillPOCOs() { Skill = employeeskill.Skill.Description, Name = employeeskill.Employee.LastName + ", " + employeeskill.Employee.FirstName, Phone = employeeskill.Employee.HomePhone, Level = employeeskill.Level.ToString(), YOE = employeeskill.YearsOfExperience }; return(result.ToList()); }; }
public List <EmployeeMenu> getReportEmployeeMenu() { using (var context = new WorkScheduleDBContext()) { var list = from employee in context.Employees orderby employee.EmployeeID select new EmployeeMenu { EmployeeID = employee.EmployeeID, Name = employee.FirstName + " " + employee.LastName, HomePhone = employee.HomePhone, Active = employee.Active }; return(list.ToList()); } }
public List <SkillDTO> ListEmployees() { using (var context = new WorkScheduleDBContext()) { var result = from Skill in context.Skills orderby Skill.Description where Skill.Description.EndsWith("Journeyman") select new SkillDTO { Description = Skill.Description, Employees = from EmployeeSkill in Skill.EmployeeSkills orderby EmployeeSkill.YearsOfExperience descending select new EmployeeDTO { Name = EmployeeSkill.Employee.FirstName + " " + EmployeeSkill.Employee.LastName, //Level = EmployeeSkill.Level.ToString(), YearsExperience = EmployeeSkill.YearsOfExperience } }; return(result.ToList()); } }
public void AddEmployeeInfo(Employee Entities) { using (var context = new WorkScheduleDBContext()) { var adding = context.Employees.Add(Entities); context.SaveChanges(); } }
public void AddLocationInfo(Location Entities) { using (var context = new WorkScheduleDBContext()) { var adding = context.Locations.Add(Entities); context.SaveChanges(); } }
public List <Employee> ListEmployee() { using (WorkScheduleDBContext EmployeeDBContext = new WorkScheduleDBContext()) { return(EmployeeDBContext.Employees.ToList()); } }