public IActionResult GetPage([PositiveInteger] int requestedPage) { const int elementsPerPage = 10; // Cálculo de las Páginas. int lastPage = new EmployeeSC().CalculateLastPage(elementsPerPage); Pagination <EmployeePersonalInfoDTO> response = new(requestedPage, lastPage); if (lastPage == 0) { return(Ok(response)); } // Selección de la página solicitada. IQueryable <Employee> dbEmployees = new EmployeeSC() .GetPage(elementsPerPage, (int)response.CurrentPage); // Materialización de los registros. List <EmployeePersonalInfoDTO> employees = BaseSC .MaterializeIQueryable <Employee, EmployeePersonalInfoDTO>(dbEmployees); // Los registros se añaden a la respuesta. response.ResponseList = employees; return(Ok(response)); }
public IActionResult Delete(int id) { Employee dataBaseEmployee = new EmployeeSC().GetEmployeeById(id); if (dataBaseEmployee == null) { return(NotFound()); } try { new EmployeeSC().DeleteEmployee(dataBaseEmployee); } catch (Exception ex) when(ExceptionTypes.IsSqlException(ex)) { string message = SqlExceptionMessages.GetCustomSqlExceptionMessage(ex.InnerException as SqlException); if (message != null) { return(Conflict(message)); } throw; } return(NoContent()); }
public IActionResult Post([FromBody] EmployeePersonalInfoPostDTO newEmployee) { // Se añade un registro y se obtiene el id con el que se registró. int id = new EmployeeSC().AddNewEmployee(newEmployee); return(Created("GET " + Request.Path.Value + "/" + id, new { Id = id })); }
public IActionResult GetPage(int requestedPage) { const int elementsPerPage = 10; if (requestedPage < 1) { return(BadRequest($"{nameof(requestedPage)} must be at least 1.")); } // Calculate Pages int lastPage = new EmployeeSC().CalculateLastPage(elementsPerPage); Pagination <EmployeePersonalInfoDTO> response = new(requestedPage, lastPage); if (lastPage == 0) { return(Ok(response)); } // Get Selected Page IQueryable <Employee> dbEmployees = new EmployeeSC().GetPage(elementsPerPage, (int)response.CurrentPage); List <EmployeePersonalInfoDTO> employees = BaseSC.MaterializeIQueryable <Employee, EmployeePersonalInfoDTO>(dbEmployees); // Attach elements of the page to the response response.ResponseList = employees; return(Ok(response)); }
public IActionResult Put(int id, [FromBody] EmployePersonalInfoPutDTO modifiedEmployee) { Employee dataBaseEmployee = new EmployeeSC().GetEmployeeById(id); if (dataBaseEmployee == null) { return(NotFound()); } try { //TODO: Check if it is possible to pass the dataBaseEmployee insted of the id. new EmployeeSC().UpdateEmployee(id, modifiedEmployee); } catch (Exception ex) when(ExceptionTypes.IsSqlException(ex.InnerException)) { string message = SqlExceptionMessages.GetCustomSqlExceptionMessage(ex as SqlException); if (message != null) { return(Conflict(message)); } throw; } return(NoContent()); }
public IActionResult GetAll() { IQueryable <Employee> dbEmployees = new EmployeeSC().GetAllEmployees(); List <EmployeePersonalInfoDTO> employees = BaseSC.MaterializeIQueryable <Employee, EmployeePersonalInfoDTO>(dbEmployees); return(Ok(employees)); }
public IActionResult Get([PositiveInteger] int id) { // Obtiene el empleado de la Base de Datos. Employee dbEmployee = new EmployeeSC().GetEmployeeById(id); // Genera un modelo con la información del empleado obtenido. EmployeePersonalInfoDTO employee = new(dbEmployee); return(Ok(employee)); }
public IActionResult GetAll() { // Se obtienen todos los registros. IQueryable <Employee> dbEmployees = new EmployeeSC().GetAllEmployees(); // Se materialzian. List <EmployeePersonalInfoDTO> employees = BaseSC .MaterializeIQueryable <Employee, EmployeePersonalInfoDTO>(dbEmployees); return(Ok(employees)); }
public List <EmployeeModel> Get() { var employees = new EmployeeSC().GetAllEmployees().Select(s => new EmployeeModel { IdNumber = s.EmployeeId, Name = s.FirstName, FamilyName = s.LastName }).ToList(); return(employees); }
public IActionResult Put(int id, [FromBody] EmployeePersonalInfoDTO modifiedEmployee) { try { using (NorthwindContext dbContext = new()) { EmployeeSC.UpdateEmployee(dbContext, id, modifiedEmployee); } return(Ok()); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IActionResult Delete(int id) { try { using (NorthwindContext dbContext = new()) { EmployeeSC.DeleteEmployee(dbContext, id); } return(Ok()); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IActionResult Get() { List <EmployeePersonalInfoDTO> employees = new(); using (NorthwindContext dbContext = new()) { IQueryable <Employee> dbEmployees = EmployeeSC.GetAllEmployees(dbContext).AsNoTracking(); foreach (Employee dbEmployee in dbEmployees) { employees.Add(new EmployeePersonalInfoDTO(dbEmployee)); } ; } return(Ok(employees)); }
public IActionResult Post([FromBody] EmployeePersonalInfoDTO newEmployee) { int id; try { using (NorthwindContext dbContext = new()) { id = EmployeeSC.AddNewEmployee(dbContext, newEmployee); } return(Ok("Registered Id: " + id)); } catch (Exception ex) { return(InternalServerError(ex)); } }
public EmployeeModel Get(int id) { var employee = new EmployeeSC().GetEmployeeById(id); var employeeModel = new EmployeeModel(); try { employeeModel.IdNumber = employee.EmployeeId; employeeModel.Name = employee.FirstName; employeeModel.FamilyName = employee.LastName; } catch { employeeModel.IdNumber = null; employeeModel.Name = ""; employeeModel.FamilyName = ""; } return(employeeModel); }
public IActionResult Get(int id) { if (id < 1) { return(BadRequest($"{nameof(id)} must be at least 1.")); } // Get Employee from Database Employee dbEmployee = new EmployeeSC().GetEmployeeById(id); if (dbEmployee == null) { return(NotFound()); } EmployeePersonalInfoDTO employee = new(dbEmployee); return(Ok(employee)); }
public EmployeeModel Get(int id) { var employee = new EmployeeSC().GetEmployeeById(id); var employeeModel = new EmployeeModel(); try // Como el metodo GetEmployeerById devuelve un null si no lo encuentra se puso en un try catch { // ya que el EmployeeModel no acepta datos nulos employeeModel.IdNumber = employee.EmployeeId; employeeModel.Name = employee.FirstName; employeeModel.FamilyName = employee.LastName; } catch { employeeModel.IdNumber = null; employeeModel.Name = ""; employeeModel.FamilyName = ""; } return(employeeModel); }
public IActionResult Get(int id) { try { EmployeePersonalInfoDTO employee; using (NorthwindContext dbContext = new()) { Employee dbEmployee = EmployeeSC.GetEmployeeById(dbContext, id); employee = new(dbEmployee); } return(Ok(employee)); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IActionResult Post([FromBody] EmployePersonalInfoPostDTO newEmployee) { int id; try { id = new EmployeeSC().AddNewEmployee(newEmployee); } catch (Exception ex) when(ExceptionTypes.IsSqlException(ex)) { string message = SqlExceptionMessages.GetCustomSqlExceptionMessage(ex.InnerException as SqlException); if (message != null) { return(Conflict(message)); } throw; } return(Created("GET " + Request.Path.Value + "/" + id, id)); }
public List <Employee> Get() { var employees = new EmployeeSC().GetAllEmployees().ToList(); return(employees); }
public void Post([FromBody] EmployeeModel newEmployee) { var employee = new EmployeeSC(); employee.AddEmployee(newEmployee); }
public static void Ejercicio() { var output = new EmployeeSC().GetEmployees(); Console.WriteLine(output); }