public HttpResponseMessage returnedPrestamo(HttpRequestMessage request, [FromBody] PrestamoReq body)
{
try
{
int result = con.Cnn.Execute(@"UPDATE [dbo].[Prestamo] SET
[Devuelto] = GETDATE()
WHERE [IdLector] = @idLector
AND [IdLibro] = @idLibro" , new
{
idLector = body.IdLector,
idLibro = body.IdLibro
}, commandType: CommandType.Text);
if (result > 0)
{
GenericResponse response = new GenericResponse();
response.HttpCode = 200;
response.Message = "Success";
return(Request.CreateResponse <IResponse>(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Something went wrong"));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Something went wrong"));
}
}
public HttpResponseMessage addPrestamo(HttpRequestMessage request, [FromBody] PrestamoReq nuevoPrestamo)
{
try
{
int result = con.Cnn.Execute(@"INSERT INTO [dbo].[Prestamo]
([IdLector],[IdLibro],[FechaPrestamo],[FechaDevolucion] ) VALUES
(@idLector
,@idLibro
,@fechaPrestamo
,@fechaDevolucion)" , new
{
idLector = nuevoPrestamo.IdLector,
idLibro = nuevoPrestamo.IdLibro,
fechaPrestamo = nuevoPrestamo.FechaPrestamo,
fechaDevolucion = nuevoPrestamo.FechaDevolucion
}, commandType: CommandType.Text);
if (result > 0)
{
GenericResponse response = new GenericResponse();
response.HttpCode = 200;
response.Message = "Success";
return(Request.CreateResponse <IResponse>(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Something went wrong"));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Something went wrong"));
}
}
