public int AddEmployee(Employee employee)
{
DA.Employee emp = iMapper.Map <DA.Employee>(employee);
using (DA.PractiseSessionEntities dbEntities = new DA.PractiseSessionEntities())
{
dbEntities.Employees.Add(emp);
dbEntities.SaveChanges();
}
return(emp.EmployeeId);
}
public Employee GetEmployee(int id)
{
Employee employee = null;
using (DA.PractiseSessionEntities dbEntities = new DA.PractiseSessionEntities())
{
var dbEmp = dbEntities.Employees.FirstOrDefault(emp => emp.EmployeeId == id);
if (dbEmp != null)
{
employee = iMapper.Map <Employee>(dbEmp);
}
}
return(employee);
}
public IEnumerable <Employee> GetEmployee()
{
List <Employee> employeeCollection = new List <Employee>();
using (DA.PractiseSessionEntities dbEntities = new DA.PractiseSessionEntities())
{
List <DA.Employee> emp = dbEntities.Employees.ToList();
emp.ForEach(employee =>
{
employeeCollection.Add(iMapper.Map <Employee>(employee));
});
}
return(employeeCollection);
}
public int DeleteEmployee(int id)
{
using (DA.PractiseSessionEntities dbEntities = new DA.PractiseSessionEntities())
{
var emp = dbEntities.Employees.FirstOrDefault(x => x.EmployeeId == id);
if (emp != null)
{
dbEntities.Employees.Remove(emp);
dbEntities.SaveChanges();
}
else
{
return(1);
}
}
return(0);
}
public int UpdateEmployee(int id, Employee employee)
{
using (DA.PractiseSessionEntities dbEntities = new DA.PractiseSessionEntities())
{
DA.Employee emp = dbEntities.Employees.FirstOrDefault(x => x.EmployeeId == id);
if (emp != null)
{
emp.FirstName = employee.FirstName;
emp.LastName = employee.LastName;
emp.Salary = employee.Salary;
emp.Gender = emp.Gender;
dbEntities.SaveChanges();
}
else
{
return(1);
}
}
return(0);
}
