public void UpdateMagentoProductGroupSetting(MagentoProductGroupSetting currentMagentoSetting, MagentoProductGroupSetting compareMagentoSetting, List <string> ignoreProperties)
{
List <string> changes = generateUpdateFields.GetPropertiesForUpdate(compareMagentoSetting, currentMagentoSetting, ignoreProperties);
if (changes.Count > 0)
{
var updateQuery = string.Join(",", changes);
petaPoco.Update <MagentoProductGroupSetting>(string.Format(@"
SET {1}
WHERE MagentoProductGroupSettingID = {0}
", currentMagentoSetting.MagentoProductGroupSettingID, updateQuery));
}
}
public void UpdateContent(Content content)
{
Content currentContent = GetContentByID(content.ProductID, content.ConnectorID);
List <string> listOfIngnoreProperties = generateUpdateProperties.GenerateIgnoreProperties(
new Content(),
x => x.CreatedBy,
x => x.LastModifiedBy,
x => x.LastModificationTime,
x => x.CreationTime);
List <string> listOfChanges = generateUpdateProperties.GetPropertiesForUpdate(content, currentContent, listOfIngnoreProperties);
if (listOfChanges.Count > 0)
{
var updateQuery = string.Join(",", listOfChanges);
petaPoco.Update <Content>(string.Format(@"
SET {2}
WHERE ProductID = {0}
AND ConnectorID = {1}
", content.ProductID, content.ConnectorID, updateQuery));
}
}
public void UpdateMasterGroupMapping(MasterGroupMapping masterGroupMapping)
{
MasterGroupMapping currentMasterGroupMapping = GetMasterGroupMappingByMasterGroupMappingID(masterGroupMapping.MasterGroupMappingID);
StringBuilder changes = new StringBuilder();
List <string> listOfChanges = generateUpdateFields.GetPropertiesForUpdate(masterGroupMapping, currentMasterGroupMapping);
if (masterGroupMapping.ParentMasterGroupMappingID.HasValue && masterGroupMapping.ParentMasterGroupMappingID.Value > 0)
{
if (masterGroupMapping.ParentMasterGroupMappingID != currentMasterGroupMapping.ParentMasterGroupMappingID)
{
changes.Append(string.Format("ParentMasterGroupMappingID = {0}", masterGroupMapping.ParentMasterGroupMappingID));
}
}
if (masterGroupMapping.ConnectorID.HasValue && masterGroupMapping.ConnectorID.Value > 0)
{
if (masterGroupMapping.ConnectorID != currentMasterGroupMapping.ConnectorID)
{
if (!string.IsNullOrEmpty(changes.ToString()))
{
changes.Append(",");
}
changes.Append(string.Format("ConnectorID = {0}", masterGroupMapping.ConnectorID));
}
}
if (masterGroupMapping.ProductGroupID != currentMasterGroupMapping.ProductGroupID)
{
if (!string.IsNullOrEmpty(changes.ToString()))
{
changes.Append(",");
}
changes.Append(string.Format("ProductGroupID = {0}", masterGroupMapping.ProductGroupID));
}
if (masterGroupMapping.SourceMasterGroupMappingID.HasValue && masterGroupMapping.SourceMasterGroupMappingID.Value > 0)
{
if (masterGroupMapping.SourceMasterGroupMappingID != currentMasterGroupMapping.SourceMasterGroupMappingID)
{
if (!string.IsNullOrEmpty(changes.ToString()))
{
changes.Append(",");
}
changes.Append(string.Format("SourceMasterGroupMappingID = {0}", masterGroupMapping.SourceMasterGroupMappingID));
}
}
if (masterGroupMapping.Score.HasValue)
{
if (masterGroupMapping.Score != currentMasterGroupMapping.Score)
{
if (!string.IsNullOrEmpty(changes.ToString()))
{
changes.Append(",");
}
changes.Append(string.Format("Score = {0}", masterGroupMapping.Score));
}
}
if (masterGroupMapping.FlattenHierarchy != currentMasterGroupMapping.FlattenHierarchy)
{
if (!string.IsNullOrEmpty(changes.ToString()))
{
changes.Append(",");
}
changes.Append(string.Format("FlattenHierarchy = {0}", (masterGroupMapping.FlattenHierarchy ? 1 : 0)));
}
if (masterGroupMapping.FilterByParentGroup != currentMasterGroupMapping.FilterByParentGroup)
{
if (!string.IsNullOrEmpty(changes.ToString()))
{
changes.Append(",");
}
changes.Append(string.Format("FilterByParentGroup = {0}", (masterGroupMapping.FilterByParentGroup ? 1 : 0)));
}
if (!string.IsNullOrEmpty(changes.ToString()))
{
petaPoco.Update <MasterGroupMapping>(string.Format(@"
SET {1}
WHERE MasterGroupMappingID = {0}
", masterGroupMapping.MasterGroupMappingID, changes));
}
}