/// <summary>
/// Saves New Product
/// </summary>
/// <param name="request"></param>
/// <param name="context"></param>
/// <param name="trackingGuid"></param>
/// <returns></returns>
public async Task <Tagge.Common.Models.ProductResponse> Save(Tagge.Common.Models.ProductRequest request, Guid trackingGuid)
{
var response = new Tagge.Common.Models.ProductResponse();
var companyId = context.Security.GetCompanyId();
long id = 0;
IG2000.Data.Utilities.Logging.LogTrackingEvent($"Beginning Product save by user {context.Security.GetEmail()},", "Save Product", LT319.Common.Utilities.Constants.TrackingStatus.Active, context, trackingGuid);
try
{
// MongoDB Settings
var database = context.MongoDbSettings.Value.Databases.FirstOrDefault(x => x.Name == "DeathStar");
string collectionName = database.Collections.FirstOrDefault(x => x.Name == "PC_Product").Name;
// Get MongoDB
var db = context.Database;
var productCollection = db.GetCollection <Deathstar.Data.Models.PC_Product>(collectionName);
var counterCollection = db.GetCollection <Deathstar.Data.Models.Counter>("Counters");
// filter
var filter = Builders <Deathstar.Data.Models.Counter> .Filter.Eq(x => x.Id, "product_id");
var update = Builders <Deathstar.Data.Models.Counter> .Update.Inc("Seq", 1);
// Word
var dbProduct = new Deathstar.Data.Models.PC_Product();
// Check to see if the Sku is a duplicate
await CheckForDuplicateSkus(request.Sku, companyId.ToString(), productCollection, context, trackingGuid);
// Validate Status
await _typeModel.ValidateStatusType(request.Status, trackingGuid);
// Validate Type
await _typeModel.ValidateProductType(request.Type, trackingGuid);
// Validate Tracking Method
await _typeModel.ValidateTrackingMethodType(request.TrackingMethod, trackingGuid);
// Check to see if the tracking method is set to products if it is make sure no variants are sent in as well
if (request.TrackingMethod.ToLower() == "product" && request.Variants != null && request.Variants.Count > 0)
{
string reason = $"The Tracking Method is set to Product, which does not allow for variants.";
IG2000.Data.Utilities.Logging.LogTrackingEvent($"{reason}", $"Status Code: {Microsoft.AspNetCore.Http.StatusCodes.Status400BadRequest}", LT319.Common.Utilities.Constants.TrackingStatus.Error, context, trackingGuid);
throw new HttpResponseException()
{
StatusCode = Microsoft.AspNetCore.Http.StatusCodes.Status400BadRequest, ReasonPhrase = reason
};
}
// Get Id
id = counterCollection.FindOneAndUpdate(filter, update).Seq;
// Convert request to Product
dbProduct.ConvertToDatabaseObject(companyId.ToString(), request);
// Units
if (request.Units != null && request.Units.Count > 0)
{
dbProduct.Units = await _unitModel.Save(id, request.Units, trackingGuid);
}
// Save Kit
if (request.Kit != null)
{
dbProduct.Kit = await _kitModel.Save(id, "PC_Kit", request.Kit, trackingGuid);
}
// Category Assignment
if (request.Categories != null && request.Categories.Count > 0)
{
dbProduct.Categories = await _categoryAssignmentModel.Save(context, id, request.Categories, dbProduct.Categories, trackingGuid);
}
// Options
if (request.Options != null && request.Options.Count > 0)
{
dbProduct.Options = await _optionModel.Save(id, request.Options, trackingGuid);
}
// Save Alternate Ids
if (request.AlternateIds != null && request.AlternateIds.Count > 0)
{
dbProduct.AlternateIds = await _alternateIdModel.SaveOrUpdate(context, id, dbProduct.Sku, "PC_ProductAlternateId", request.AlternateIds, new List <Deathstar.Data.Models.PC_AlternateId>(), dbProduct, trackingGuid);
}
// Custom Fields
if (request.CustomFields != null && request.CustomFields.Count > 0)
{
////dbProduct.CustomFields = await _customFieldModel.SaveGenericCustomField(request.CustomFields, "PC_Product", id.ToString(), trackingGuid);
}
// Add Id
dbProduct.Id = id;
// Add Created By & Timestamp
dbProduct.CreatedBy = context.Security.GetEmail();
dbProduct.CreatedDateTime = DateTimeOffset.Now.ToString("yyyy/MM/dd HH:mm:ss.fff zzz");
// Insert
await productCollection.InsertOneAsync(dbProduct);
// Building the Response
response = dbProduct.ConvertToResponse(companyId.ToString(), context.Database);
// If the product doesnt save then this will not be hit
// Inventory
if (request.Inventory != null && request.Inventory.Count > 0)
{
response.Inventory = new List <Common.Models.InventoryResponse>();
foreach (var inventoryRequest in request.Inventory)
{
response.Inventory.Add(await _inventoryModel.Save(inventoryRequest, "PC_Product", id.ToString(), trackingGuid));
}
}
// Variant
if (request.Variants != null && request.Variants.Count > 0)
{
response.Variants = new List <Common.Models.ProductVariantResponse>();
foreach (var variantRequest in request.Variants)
{
response.Variants.Add(await _variantModel.Save(variantRequest, dbProduct, trackingGuid));
}
}
// ExternalIds
if (request.ExternalIds != null && request.ExternalIds.Count > 0)
{
response.ExternalIds = await _externalIdModel.SaveOrUpdateGenericExternalId(request.ExternalIds, "PC_Product", id.ToString(), trackingGuid);
}
IG2000.Data.Utilities.Logging.LogTrackingEvent($"Product (id: {dbProduct.Id}, sku: {dbProduct.Sku}) successfully saved.", "Save Product", LT319.Common.Utilities.Constants.TrackingStatus.Complete, context, trackingGuid);
// Build the Webhook event
var whRequest = new Sheev.Common.Models.WebhookResponse()
{
CompanyId = companyId.ToString(),
Type = "Product",
Scope = "product/created",
Id = response.Id.ToString()
};
// Trigger the Webhook event
await _webHookModel.FireWebhookEvent(whRequest, context, trackingGuid);
return(response);
}
catch (HttpResponseException webEx)
{
IG2000.Data.Utilities.Logging.LogTrackingEvent($"Product (sku: {request.Sku}) failed to save! Reason: {webEx.ReasonPhrase}", $"Status Code: {webEx.StatusCode}", LT319.Common.Utilities.Constants.TrackingStatus.Complete, context, trackingGuid);
await RollbackProduct(id);
throw;
}
catch (Exception ex)
{
IG2000.Data.Utilities.Logging.LogTrackingEvent($"See logs for additional details", "Failed", LT319.Common.Utilities.Constants.TrackingStatus.Error, context, trackingGuid);
IG2000.Data.Utilities.ErrorLogger.Report(ex.Message, "CatalogModel.SaveProduct()", context, trackingGuid, System.Diagnostics.EventLogEntryType.Error);
await RollbackProduct(id);
throw new HttpResponseException()
{
StatusCode = Microsoft.AspNetCore.Http.StatusCodes.Status500InternalServerError, ReasonPhrase = ex.Message
};
}
}
/// <summary>
/// Updates a Product by Product Id
/// </summary>
/// <param name="id">Product Id</param>
/// <param name="request">Product Request</param>
/// <param name="context">Database context see ContextModel.cs</param>
/// <param name="trackingGuid"></param>
/// <returns></returns>
public async Task <Tagge.Common.Models.ProductResponse> Update(long id, Tagge.Common.Models.ProductRequest request, Guid trackingGuid)
{
var response = new Tagge.Common.Models.ProductResponse();
var companyId = context.Security.GetCompanyId();
IG2000.Data.Utilities.Logging.LogTrackingEvent($"Beginning a product update by user {context.Security.GetEmail()}", "Update Product", LT319.Common.Utilities.Constants.TrackingStatus.Active, context, trackingGuid);
try
{
// MongoDB Settings
var database = context.MongoDbSettings.Value.Databases.FirstOrDefault(x => x.Name == "DeathStar");
string collectionName = database.Collections.FirstOrDefault(x => x.Name == "PC_Product").Name;
// Get MongoDB
var db = context.Database;
var productCollection = db.GetCollection <Deathstar.Data.Models.PC_Product>(collectionName);
// Word
var dbProduct = new Deathstar.Data.Models.PC_Product();
// Validate Status
await _typeModel.ValidateStatusType(request.Status, trackingGuid);
// Validate Type
await _typeModel.ValidateProductType(request.Type, trackingGuid);
// Validate Tracking Method
await _typeModel.ValidateTrackingMethodType(request.TrackingMethod, trackingGuid);
// Convert to DB Object
dbProduct.ConvertToDatabaseObject(companyId.ToString(), request);
// Check for empty collections and null them
dbProduct.CheckForEmptyCollections();
// Add Updated By & Timestamp
dbProduct.UpdatedBy = context.Security.GetEmail();
dbProduct.UpdatedDateTime = DateTimeOffset.Now.ToString("yyyy/MM/dd HH:mm:ss.fff zzz");
// Filters - note always start with the company id
var filters = Builders <Deathstar.Data.Models.PC_Product> .Filter.Eq(x => x.DV_CompanyId, companyId.ToString());
filters = filters & Builders <Deathstar.Data.Models.PC_Product> .Filter.Eq(x => x.Id, id);
filters = filters & Builders <Deathstar.Data.Models.PC_Product> .Filter.Eq(x => x.IsActive, true);
var dbExistingProduct = await productCollection.FindAsync(filters).Result.FirstOrDefaultAsync();
if (dbExistingProduct == null)
{
string reason = $"Product not found for Id: {id}. Use Post to create a new product.";
IG2000.Data.Utilities.Logging.LogTrackingEvent($"{reason}", $"Status Code: {Microsoft.AspNetCore.Http.StatusCodes.Status404NotFound}", LT319.Common.Utilities.Constants.TrackingStatus.Error, context, trackingGuid);
throw new HttpResponseException()
{
StatusCode = Microsoft.AspNetCore.Http.StatusCodes.Status404NotFound, ReasonPhrase = reason
};
}
// Units
if (request.Units != null && request.Units.Count > 0)
{
dbProduct.Units = await _unitModel.Save(id, request.Units, trackingGuid);
}
// Save Kit
if (request.Kit != null)
{
dbProduct.Kit = await _kitModel.SaveOrUpdate(id, "PC_Kit", dbExistingProduct.Kit, request.Kit, trackingGuid);
}
// Category Assignment
if (request.Categories != null && request.Categories.Count > 0)
{
dbProduct.Categories = await _categoryAssignmentModel.Save(context, id, request.Categories, dbExistingProduct.Categories, trackingGuid);
}
// Options
if (request.Options != null && request.Options.Count > 0)
{
dbProduct.Options = await _optionModel.Save(id, request.Options, trackingGuid);
}
// Save Alternate Ids
if (request.AlternateIds != null && request.AlternateIds.Count > 0)
{
dbProduct.AlternateIds = await _alternateIdModel.SaveOrUpdate(context, id, dbExistingProduct.Sku, "PC_ProductAlternateId", request.AlternateIds, dbExistingProduct.AlternateIds, dbProduct, trackingGuid);
}
// Custom Fields
if (request.CustomFields != null && request.CustomFields.Count > 0)
{
////dbProduct.CustomFields = await _customFieldModel.SaveOrUpdateGenericCustomFields(request.CustomFields, dbExistingProduct.CustomFields, "PC_Product", id.ToString(), trackingGuid);
}
var serializerSettings = new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore,
DefaultValueHandling = DefaultValueHandling.Ignore
};
var update = new BsonDocument()
{
{ "$set", BsonDocument.Parse(JsonConvert.SerializeObject(dbProduct, serializerSettings)) }
};
// Update database record
await productCollection.UpdateOneAsync(filters, update);
// Convert To Response
response = dbProduct.ConvertToResponse(companyId.ToString(), context.Database);
// Inventory
if (request.Inventory != null && request.Inventory.Count > 0)
{
// Initialize the response subcollection
response.Inventory = new List <Common.Models.InventoryResponse>();
foreach (var inventoryRequest in request.Inventory)
{
response.Inventory.Add(await _inventoryModel.SaveOrUpdate(inventoryRequest, "PC_Product", id.ToString(), trackingGuid));
}
}
// Variant
if (request.Variants != null && request.Variants.Count > 0)
{
// Set the id back in the dbProduct
// Its set to 0 for the serializer above to ignore it and not add a new id field in when saving to mongo
dbProduct.Id = id;
// Initialize the response subcollection
response.Variants = new List <Common.Models.ProductVariantResponse>();
foreach (var variantRequest in request.Variants)
{
response.Variants.Add(await _variantModel.SaveOrUpdate(variantRequest, dbProduct, trackingGuid));
}
}
// ExternalIds
if (request.ExternalIds != null && request.ExternalIds.Count > 0)
{
response.ExternalIds = await _externalIdModel.SaveOrUpdateGenericExternalId(request.ExternalIds, "PC_Product", id.ToString(), trackingGuid);
}
// Add Id
response.Id = id;
// Build the Webhook event
var whRequest = new Sheev.Common.Models.WebhookResponse()
{
CompanyId = companyId.ToString(),
Type = "Product",
Scope = "product/updated",
Id = response.Id.ToString()
};
// Trigger the Webhook event
await _webHookModel.FireWebhookEvent(whRequest, context, trackingGuid);
return(response);
}
catch (HttpResponseException webEx)
{
IG2000.Data.Utilities.Logging.LogTrackingEvent($"Product (sku: {request.Sku}) failed to update! Reason: {webEx.ReasonPhrase}", $"Status Code: {webEx.StatusCode}", LT319.Common.Utilities.Constants.TrackingStatus.Error, context, trackingGuid);
throw;
}
catch (Exception ex)
{
IG2000.Data.Utilities.Logging.LogTrackingEvent($"See logs for additional details", "Failed", LT319.Common.Utilities.Constants.TrackingStatus.Error, context, trackingGuid);
IG2000.Data.Utilities.ErrorLogger.Report(ex.Message, "CatalogModel.UpdateProduct()", context, trackingGuid, System.Diagnostics.EventLogEntryType.Error);
throw new HttpResponseException()
{
StatusCode = Microsoft.AspNetCore.Http.StatusCodes.Status500InternalServerError, ReasonPhrase = ex.Message
};
}
}
/// <summary>
/// Converts the request to a database object
/// </summary>
/// <param name="companyId"></param>
/// <param name="request"></param>
public void ConvertToDatabaseObject(string companyId, Tagge.Common.Models.ProductRequest request)
{
// Properties
DV_CompanyId = companyId;
Name = request.Name;
Sku = request.Sku;
Description = request.Description;
DefaultPrice = request.DefaultPrice == null ? 0 : (decimal)request.DefaultPrice;
MSRP = request.MSRP;
SalePrice = request.SalePrice;
TaxClass = request.TaxClass;
Barcode = request.Barcode;
Unit = request.Unit;
AllowDiscounts = request.AllowDiscounts;
AllowBackorders = request.AllowBackorders;
InStockThreshold = request.InStockThreshold;
TrackingMethod = request.TrackingMethod;
Type = request.Type;
Status = request.Status;
Width = request.Width;
Height = request.Height;
Depth = request.Depth;
Weight = request.Weight;
IsActive = true;
// Kit
if (request.Kit != null)
{
Kit.ConvertToDatabaseObject(request.Kit);
}
// Variants - Managed in PC_ProductVariant
// Inventory - Managed in PC_Inventory
// Categories - Managed in PC_Category
// Options
if (request.Options != null)
{
foreach (var option in request.Options)
{
var dbOption = new PC_Option();
dbOption.ConvertToDatabaseObject(option);
Options.Add(dbOption);
}
}
// Units
if (request.Units != null)
{
foreach (var unit in request.Units)
{
var dbUnit = new PC_ProductUnit();
dbUnit.ConvertToDatabaseObject(unit);
Units.Add(dbUnit);
}
}
// AlternateIds
if (request.AlternateIds != null)
{
foreach (var alternateId in request.AlternateIds)
{
var dbAlternateId = new PC_AlternateId();
dbAlternateId.ConvertToDatabaseObject(alternateId);
AlternateIds.Add(dbAlternateId);
}
}
// Custom Fields - Managed in PC_CustomField
// ExternalIds - Managed in PC_ExternalId
}
