Esempio n. 1
0
        internal void SaveProduct(ParsoProduct product)
        {
            if (String.IsNullOrWhiteSpace(product.ProductName))
            {
                return;
            }

            try
            {
                ParsoEntities entities = new ParsoEntities();
                entities.Product.Add(new Product()
                {
                    CatalogId      = product.CatalogId,
                    Code           = product.ProductId.ToString(),
                    Name           = product.ProductName,
                    OldPrice       = product.OldPrice,
                    Price          = product.Price,
                    PictureUrl     = product.PictureUrl,
                    ProductUrl     = product.ProductDetailUrl,
                    Description    = product.ProductDescription,
                    DiscountDetail = product.DiscountDetail,
                    RecordDate     = DateTime.Now
                });

                entities.SaveChanges();
            }
            catch (DbEntityValidationException ex)
            {
                var errorMessages = ex.EntityValidationErrors
                                    .SelectMany(x => x.ValidationErrors)
                                    .Select(x => x.ErrorMessage);

                // Join the list to a single string.
                var fullErrorMessage = string.Join("; ", errorMessages);

                // Combine the original exception message with the new one.
                var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);

                // Throw a new DbEntityValidationException with the improved exception message.
                throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
            }
            catch (Exception gex)
            {
                // TODO ADD LOGING
            }
        }
Esempio n. 2
0
        internal long SaveCatalog(ParsoCatalog catalog)
        {
            try
            {
                ParsoEntities entities = new ParsoEntities();

                Catalog temp = new Catalog()
                {
                    Name        = catalog.Name,
                    Description = catalog.Description,
                    RecordDate  = DateTime.Now,
                    RootUrl     = catalog.RootUrl,
                    Url         = catalog.Url,
                    BatchId     = catalog.BatchId
                };

                entities.Catalog.Add(temp);
                entities.SaveChanges();
                return(temp.Id);
            }
            catch (DbEntityValidationException ex)
            {
                var errorMessages = ex.EntityValidationErrors
                                    .SelectMany(x => x.ValidationErrors)
                                    .Select(x => x.ErrorMessage);

                // Join the list to a single string.
                var fullErrorMessage = string.Join("; ", errorMessages);

                // Combine the original exception message with the new one.
                var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);

                // Throw a new DbEntityValidationException with the improved exception message.
                throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
            }
            catch (Exception gex)
            {
                // TODO ADD LOGING
                return(-1);
            }
        }