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")); }