Esempio n. 1
0
        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"));
        }