// Get all the employees added on page load.
public JsonResult getAll()
{
using (AngularCRUDEntities dataContext = new AngularCRUDEntities())
{
var employeeList = dataContext.M_Employee.ToList();
return(Json(employeeList, JsonRequestBehavior.AllowGet));
}
}
public IEnumerable <Employee> GetEmployees()
{
using (AngularCRUDEntities objEntity = new AngularCRUDEntities())
{
var result = objEntity.Employees.ToList();
return(result);
}
}
// Get Specific employee by their ID.
public JsonResult getEmployeeByNo(string EmpNo)
{
using (AngularCRUDEntities dataContext = new AngularCRUDEntities())
{
int no = Convert.ToInt32(EmpNo);
var employeeList = dataContext.M_Employee.Find(no);
return(Json(employeeList, JsonRequestBehavior.AllowGet));
}
}
public bool AddEmployee(Employee objEmployee)
{
using (AngularCRUDEntities objEntity = new AngularCRUDEntities())
{
objEntity.Employees.Add(objEmployee);
objEntity.Entry(objEmployee).State = EntityState.Added;
objEntity.SaveChanges();
return(true);
}
}
public bool DeleteEmployee(int objEmployeeId)
{
using (AngularCRUDEntities objEntity = new AngularCRUDEntities())
{
Employee objEmployee = objEntity.Employees.Where(emp => emp.EmployeeID == objEmployeeId).SingleOrDefault();
objEntity.Employees.Remove(objEmployee);
objEntity.Entry(objEmployee).State = EntityState.Deleted;
objEntity.SaveChanges();
return(true);
}
}
// Add new employee to db.
public string AddEmployee(M_Employee Emp)
{
if (Emp != null)
{
using (AngularCRUDEntities dataContext = new AngularCRUDEntities())
{
dataContext.M_Employee.Add(Emp);
dataContext.SaveChanges();
return("Employee Updated");
}
}
else
{
return("Invalid Employee");
}
}
public bool EditEmployee(Employee objEmployee)
{
using (AngularCRUDEntities objEntity = new AngularCRUDEntities())
{
Employee objOriginalEmployee = objEntity.Employees.Where(emp => emp.EmployeeID == objEmployee.EmployeeID).SingleOrDefault();
objOriginalEmployee.FirstName = objEmployee.FirstName;
objOriginalEmployee.LastName = objEmployee.LastName;
objOriginalEmployee.EmpCode = objEmployee.EmpCode;
objOriginalEmployee.Position = objEmployee.Position;
objOriginalEmployee.Office = objEmployee.Office;
objEntity.Entry(objEmployee).State = EntityState.Deleted;
objEntity.Entry(objOriginalEmployee).State = EntityState.Modified;
objEntity.SaveChanges();
return(true);
}
}
// Delete Specific employee by their ID.
public string DeleteEmployee(M_Employee Emp)
{
if (Emp != null)
{
using (AngularCRUDEntities dataContext = new AngularCRUDEntities())
{
int no = Convert.ToInt32(Emp.Id);
var employeeList = dataContext.M_Employee.Where(x => x.Id == no).FirstOrDefault();
dataContext.M_Employee.Remove(employeeList);
dataContext.SaveChanges();
return("Employee Deleted");
}
}
else
{
return("Invalid Employee");
}
}
public Employee GetEmployee(int id)
{
Employee objEmployee;
using (AngularCRUDEntities objEntity = new AngularCRUDEntities())
{
if (id <= 0)
{
throw new Exception("Id cannot be less than zero");
}
objEmployee = objEntity.Employees.Where(emp => emp.EmployeeID == id).FirstOrDefault();
if (objEmployee == null)
{
throw new TargetParameterCountException("Employee Does not Exist");
}
}
return(objEmployee);
}
// Update Specific employee by their ID.
public string UpdateEmployee(M_Employee Emp)
{
if (Emp != null)
{
using (AngularCRUDEntities dataContext = new AngularCRUDEntities())
{
int no = Convert.ToInt32(Emp.Id);
var employeeList = dataContext.M_Employee.Where(x => x.Id == no).FirstOrDefault();
employeeList.name = Emp.name;
employeeList.mobileno = Emp.mobileno;
employeeList.email = Emp.email;
dataContext.SaveChanges();
return("Employee Updated");
}
}
else
{
return("Invalid Employee");
}
}
