public JsonResult getAll() { using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities()) { var employeeList = dataContext.Employees.ToList(); return(Json(employeeList, JsonRequestBehavior.AllowGet)); } }
public JsonResult getEmployeeByNo(string EmpNo) { using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities()) { int no = Convert.ToInt32(EmpNo); var employeeList = dataContext.Employees.Find(no); return(Json(employeeList, JsonRequestBehavior.AllowGet)); } }
public string AddEmployee(Employee Emp) { if (Emp != null) { using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities()) { dataContext.Employees.Add(Emp); dataContext.SaveChanges(); return("Employee Updated"); } } else { return("Invalid Employee"); } }
public string DeleteEmployee(Employee emp) { if (emp != null) { using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities()) { int no = Convert.ToInt32(emp.Id); var employeeList = dataContext.Employees.Where(x => x.Id == no).FirstOrDefault(); dataContext.Employees.Remove(employeeList); dataContext.SaveChanges(); return("Employee Deleted"); } } else { return("Invalid Employee"); } }
public string UpdateEmployee(Employee emp) { if (emp != null) { using (EMPDatabaseEntities dataContext = new EMPDatabaseEntities()) { int no = Convert.ToInt32(emp.Id); var employeeList = dataContext.Employees.Where(x => x.Id == no).FirstOrDefault(); employeeList.name = emp.name; employeeList.mobile_no = emp.mobile_no; employeeList.email = emp.email; dataContext.SaveChanges(); return("Employee Updated"); } } else { return("Invalid Employee"); } }