public void DeleteEmployee(int id)
{
using (var db = new CRUDDBEntities())
{
var empToDelete = db.Employees.FirstOrDefault(x => x.EmployeeID == id);
if (empToDelete != null)
{
db.Employees.Remove(empToDelete);
db.SaveChanges();
}
}
}
public EmployeeModel GetEmployeeByID(int id)
{
using (var db = new CRUDDBEntities())
{
//create a Mapper
Mapper.Initialize(cfg => cfg.CreateMap <Employee, EmployeeModel>());
var tempEmp = db.Employees.FirstOrDefault(x => x.EmployeeID == id);
//Map the source to the destination
var model = Mapper.Map <Employee, EmployeeModel>(tempEmp);
return(model);
}
}
public List <EmployeeModel> GetEmployeeList()
{
using (var db = new CRUDDBEntities())
{
// var TempList = new List<Employee>();
var resultList = db.Employees.ToList();
//inititalizing the mapper
Mapper.Initialize(cfg => cfg.CreateMap <Employee, EmployeeModel>());
//Mapping List<Source> to List<Destination>
var TempList = Mapper.Map <List <Employee>, List <EmployeeModel> >(resultList);
return(TempList);
}
}
public void InsertEmployee(EmployeeModel model)
{
using (var db = new CRUDDBEntities())
{
var empToAdd = db.Employees.FirstOrDefault(x => x.EmployeeID == model.EmployeeID);
if (empToAdd != null)
{
empToAdd.EmployeeID = model.EmployeeID;
empToAdd.Age = model.Age;
empToAdd.Salary = model.Salary;
empToAdd.Name = model.Name;
empToAdd.Position = model.Position;
db.Entry(empToAdd).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public void UpdateEmployee(EmployeeModel model)
{
using (var db = new CRUDDBEntities())
{
var EmpToEdit = db.Employees.FirstOrDefault(x => x.EmployeeID == model.EmployeeID);
if (EmpToEdit != null)
{
EmpToEdit.EmployeeID = model.EmployeeID;
EmpToEdit.Age = model.Age;
EmpToEdit.Salary = model.Salary;
EmpToEdit.Position = model.Position;
EmpToEdit.Name = model.Name;
db.Entry(EmpToEdit).State = EntityState.Modified;
db.SaveChanges();
}
}
}