public IActionResult Delete(string id)
{
Customer dataBaseCustomer = new CustomerSC().GetCustomerById(id);
if (dataBaseCustomer == null)
{
return(NotFound());
}
try
{
new CustomerSC().DeleteCustomer(dataBaseCustomer);
}
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 Put(string id, [FromBody] CustomerContactInfoPutDTO modifiedCustomer)
{
Customer dataBaseCustomer = new CustomerSC().GetCustomerById(id);
if (dataBaseCustomer == null)
{
return(NotFound());
}
try
{
//TODO: Check if it is possible to pass the dataBaseCustomer insted of the id.
new CustomerSC().UpdateCustomer(id, modifiedCustomer);
}
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 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 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 Delete(int id)
{
Product dataBaseProduct = new ProductSC().GetProductById(id);
if (dataBaseProduct == null)
{
return(NotFound());
}
try
{
new ProductSC().DeleteProduct(dataBaseProduct);
}
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 Put(int id, [FromBody] ProductBasicInfoPutDTO modifiedProduct)
{
Product dataBaseProduct = new ProductSC().GetProductById(id);
if (dataBaseProduct == null)
{
return(NotFound());
}
try
{
//TODO: Check if it is possible to pass the dataBaseProduct insted of the id.
new ProductSC().UpdateProduct(id, modifiedProduct);
}
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] CustomerContactInfoPostDTO newCustomer)
{
string id;
try
{
id = new CustomerSC().AddNewCustomer(newCustomer);
}
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));
}
private Task HandleExceptionAsync(HttpContext context, Exception exception)
{
string message;
context.Response.ContentType = "application/json";
if (ExceptionTypes.IsSqlException(exception))
{
context.Response.StatusCode = StatusCodes.Status409Conflict;
message = "There has been a conflict with the DataBase. Check Northwind's documentation and try again.";
}
else
{
context.Response.StatusCode = StatusCodes.Status500InternalServerError;
message = "An unexcpected error ocurred.";
}
return(context.Response.WriteAsync(new ErrorDetails()
{
StatusCode = context.Response.StatusCode,
Message = message
}.ToString()));
}
