public List <City> cityList()
{
List <City> cityList = new List <City>();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
cityList = db.Cities.ToList();
}
return(cityList);
}
public Employee EmployeeById(int employeeId)
{
Employee employee = new Employee();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
employee = db.Employees.Where(x => x.EmployeeId == employeeId).FirstOrDefault();
}
return(employee);
}
public List <Employee> employeeList()
{
List <Employee> employeeList = new List <Employee>();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
employeeList = db.Employees.ToList();
}
return(employeeList);
}
public List <Department> departmentList()
{
List <Department> departmentList = new List <Department>();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
departmentList = db.Departments.ToList();
}
return(departmentList);
}
public List <State> stateList()
{
List <State> stateList = new List <State>();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
stateList = db.States.ToList();
}
return(stateList);
}
public void DeleteEmployee(int employeeId)
{
Employee emp = new Employee();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
emp = db.Employees.Where(x => x.EmployeeId == employeeId).FirstOrDefault();
db.Employees.Remove(emp);
db.SaveChanges();
}
}
public void SaveEmployee(CustomEmployee model)
{
Employee emp = new Employee();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
emp.FirstName = model.FirstName;
emp.LastName = model.LastName;
emp.BirthDate = model.BirthDate;
emp.Gender = model.Gender;
emp.Salary = model.Salary;
emp.FkCityId = model.FkCityId;
emp.FkStateId = model.FkStateId;
emp.FkDepartmentId = model.FkDepartmentId;
emp.IsActive = model.IsActive;
emp.Photo = "~/Images/" + model.user_image.FileName;
db.Employees.Add(emp);
db.SaveChanges();
}
}
public void EditEmployee(CustomEmployee model)
{
Employee emp = new Employee();
using (EmployeeTestEntities db = new EmployeeTestEntities())
{
emp = db.Employees.Where(x => x.EmployeeId == model.EmployeeId).FirstOrDefault();
emp.FirstName = model.FirstName;
emp.LastName = model.LastName;
emp.BirthDate = model.BirthDate;
emp.Gender = model.Gender;
emp.Salary = model.Salary;
emp.FkCityId = model.FkCityId;
emp.FkStateId = model.FkStateId;
emp.FkDepartmentId = model.FkDepartmentId;
emp.IsActive = model.IsActive;
emp.Photo = "~/Images/" + model.user_image.FileName;
db.Entry(emp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}