public bool LendMedia(LentMediaDto lentMedia)
{
using (var db = CreateConnection())
{
db.Open();
var lendMediaItem = db.Execute(@"INSERT INTO [dbo].[LentMedia]
([MediaId]
,[LendeeName]
,[MediaConditionId]
,[DateLent]
,[Notes])
VALUES
(@MediaId
,@LendeeName
,@MediaConditionId
,@DateLent
,@Notes)", lentMedia);
var markItemAsLent = 0;
if (lendMediaItem == 1)
{
markItemAsLent = db.Execute(@"UPDATE Media
SET IsLentOut = 1
WHERE Id = @id", new
{
id = lentMedia.MediaId
});
}
return(lendMediaItem == 1 && markItemAsLent == 1);
}
}
public HttpResponseMessage LendMediaItem(LentMediaDto lentMedia)
{
var mediaRepository = new MediaRepository();
var getSingleItem = mediaRepository.GetSingleItem(lentMedia.MediaId);
lentMedia.MediaConditionId = getSingleItem.MediaConditionId;
var lentMediaRepository = new LentMediaRepository();
var lendMedia = lentMediaRepository.LendMedia(lentMedia);
if (lendMedia)
{
return(Request.CreateResponse(HttpStatusCode.Created));
}
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Could not lend Media item at this time, try again later"));
}
