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