public ContractResponse updateContract(ContractRequest _request)
{
ContractResponse response = new ContractResponse();
using (var conn = createConnection())
{
conn.Open();
try
{
using (var cmd = new NpgsqlCommand(new SQLStatements().updateContract(_request), conn))
using (var reader = cmd.ExecuteReader())
{
response = validateDBTransaction(reader, _request.Id);
}
}
catch (Exception e)
{
var resp = new HttpResponseMessage(HttpStatusCode.BadRequest);
resp.Content = new StringContent(e.Message);
throw new HttpResponseException(resp);
}
}
return(response);
}
private ContractResponse validateDBTransaction(NpgsqlDataReader reader, int contractId)
{
ContractResponse response = new ContractResponse();
if (reader.HasRows)
{
response.isSuccessful = true;
}
else
{
var resp = new HttpResponseMessage(HttpStatusCode.BadRequest);
throw new HttpResponseException(resp);
}
return(response);
}
