示例#1
0
        /// <summary>
        /// Will update the offer in the database. Sets the ModifiedDate audit column.
        /// </summary>
        /// <param name="offer">the offer to update</param>
        /// <returns>true if successfully updated, false otherwise</returns>
        public bool UpdateOffer(OfferDTO offer)
        {
            var success = false;

            try
            {
                if (offer != null)
                {
                    var existing = context.Offer.Where(o => o.OfferId == offer.OfferId).SingleOrDefault();

                    if (existing != null && this.productService.Exists(offer.ProductId))
                    {
                        existing.ProductId     = offer.ProductId;
                        existing.Description   = offer.Description;
                        existing.Price         = offer.Price;
                        existing.NumberOfTerms = offer.NumberOfTerms;
                        existing.DateModified  = DateTime.Now;
                        existing.IsActive      = offer.IsActive;
                        context.SaveChanges();
                        success = true;
                    }
                }
            }
            catch (Exception ex)
            {
                logger.LogError("Failed to add offer.", ex);
                success = false;
            }

            return(success);
        }
示例#2
0
        /// <summary>
        /// Will create a new offer in the database.
        /// </summary>
        /// <param name="offer">the offer to create</param>
        /// <returns>the id if successfully added, -1 otherwise</returns>
        public int CreateOffer(OfferDTO offer)
        {
            var offerId = -1;

            try
            {
                // Make sure the offer is passed in and has a valid foreign key before adding.
                if (offer != null && this.productService.Exists(offer.ProductId))
                {
                    var newOffer = new Offer()
                    {
                        ProductId     = offer.ProductId,
                        Description   = offer.Description,
                        Price         = offer.Price,
                        NumberOfTerms = offer.NumberOfTerms,
                        DateCreated   = DateTime.Now,
                        DateModified  = null,
                        IsActive      = offer.IsActive
                    };

                    context.Offer.Add(newOffer);

                    context.SaveChanges();
                    offerId = newOffer.OfferId;
                }
            }
            catch (Exception ex)
            {
                logger.LogError("Failed to create offer.", ex);
                offerId = -1;
            }

            return(offerId);
        }