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