public void addEmployee(Employee newEmployee)
{
using (practiceAPIEntities list = new practiceAPIEntities())
{
tblEmployee DbObject = new tblEmployee();
DbObject.FirstName = newEmployee.FirstName;
DbObject.LastName = newEmployee.LastName;
DbObject.Gender = newEmployee.Gender;
DbObject.Salary = newEmployee.Salary;
// foreach (var property in DbObject.GetType().GetProperties())
// property.SetValue(DbObject, property.GetValue(newEmployee));
list.tblEmployees.Add(DbObject);
list.SaveChanges();
}
}
public bool deleteEmployee(int id)
{
using (practiceAPIEntities dbinstance = new practiceAPIEntities())
{
var targetItem = dbinstance.tblEmployees.FirstOrDefault(e => e.ID == id);
if (targetItem == null)
{
return(false);
}
else
{
dbinstance.tblEmployees.Remove(targetItem);
dbinstance.SaveChanges();
return(true);
}
}
}
public bool updateEmployee(int id, Employee employee)
{
using (practiceAPIEntities oldObject = new practiceAPIEntities())
{
var oldEmployee = oldObject.tblEmployees.FirstOrDefault(e => e.ID == id);
if (oldEmployee == null)
{
return(false);
}
else
{
oldEmployee.FirstName = employee.FirstName;
oldEmployee.LastName = employee.LastName;
oldEmployee.Salary = employee.Salary;
oldEmployee.Gender = employee.Gender;
oldObject.SaveChanges();
return(true);
}
}
}
