public List<AttributeSetGroupAliasInfo> RenameAttributeSetGroupAliasByGroupID(int groupId, string cultureName, string aliasName, int attributeSetId, int storeId, int portalId, bool isActive, bool isModified, string userName)
{
try
{
AttributeSetGroupAliasInfo attributeSetInfoToUpdate = new AttributeSetGroupAliasInfo
{
GroupID = groupId,
CultureName = cultureName,
AliasName = aliasName,
AttributeSetID = attributeSetId,
StoreID = storeId,
PortalID = portalId,
IsActive = isActive,
IsModified = isModified,
UpdatedBy = userName
};
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.RenameAttributeSetGroupAlias(attributeSetInfoToUpdate);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteAttributeByAttributeSetID(int attributeSetId, int groupId, int attributeId, int storeId, int portalId, string userName)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.DeleteAttribute(attributeSetId, groupId, attributeId, storeId, portalId, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateAttributeSetIsActiveByAttributeSetID(int attributeSetId, int storeId, int portalId, string userName, bool isActive)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.UpdateAttributeSetIsActive(attributeSetId, storeId, portalId, userName, isActive);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveUpdateAttributeGroupInfo(int attributeSetId, string groupName, int groupID, string cultureName, string aliasName, int storeId, int portalId, string userName, bool isActive, bool isModified, bool flag)
{
//attributeSetId: 1, groupName: node, groupID: _groupId, cultureName: cultureName, AliasName: node, storeId: _storeId, portalId: _portalId, userName: _userName, isActive: _isActive, isModified: _isModified, flag: _updateFlag
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.UpdateAttributeGroup(attributeSetId, groupName, groupID, cultureName, aliasName, storeId, portalId, userName, isActive, isModified, flag);
}
catch (Exception ex)
{
throw ex;
}
}
public List<AttributeSetGetByAttributeSetIdInfo> GetAttributeSetDetailsByAttributeSetID(int attributeSetId, int storeId, int portalId, string userName, string cultureName)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.GetAttributeSetInfoByAttributeSetID(attributeSetId, storeId, portalId, userName, cultureName);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteAttributeSetByAttributeSetID(int attributeSetId, int storeId, int portalId, string userName)
{
try
{
//AttributeSetInfo attributeSetInfoToInsert = new AttributeSetInfo
//{
// AttributeSetID = attributeSetId,
// StoreID = storeId,
// PortalID = portalId,
// DeletedBy = userName
//};
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.DeleteAttributeSet(attributeSetId, storeId, portalId, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveUpdateAttributeSetInfo(int attributeSetId, int attributeSetBaseId, string attributeSetName, int storeId, int portalId,
bool isActive, bool isModified, string userName, bool flag, string saveString)
{
try
{
AttributeSetInfo attributeSetInfoToInsert = new AttributeSetInfo
{
AttributeSetID = attributeSetId,
AttributeSetBaseID = attributeSetBaseId,
AttributeSetName = attributeSetName,
StoreID = storeId,
PortalID = portalId,
IsActive = isActive,
IsModified = isModified,
UpdatedBy = userName,
AddedBy = userName,
Flag = flag,
SaveString = saveString
};
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.SaveUpdateAttributeSet(attributeSetInfoToInsert);
}
catch (Exception ex)
{
throw ex;
}
}
public int CheckAttributeSetUniqueness(int attributeSetId, string attributeSetName, int storeId, int portalId, bool updateFlag)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.CheckAttributeSetUniqueName(attributeSetId, attributeSetName, storeId, portalId, updateFlag);
}
catch (Exception ex)
{
throw ex;
}
}
public List<AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, string attributeSetName, System.Nullable<bool> isActive, System.Nullable<bool> usedInSystem, int storeId, int portalId, string cultureName, string userName)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.GetAttributeSetGrid(offset, limit, attributeSetName, isActive, usedInSystem, storeId, portalId, cultureName, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<AttributeSetInfo> GetAttributeSetList(int storeId, int portalId)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.GetAttributeSet(storeId, portalId);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveUpdateAttributeInfo(AttributesGetByAttributeIdInfo attributeInfo)
{
try
{
AttributesGetByAttributeIdInfo attributeInfoToInsert = attributeInfo;
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.SaveAttribute(attributeInfoToInsert);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteMultipleAttributesByAttributeID(string attributeIds, int storeId, int portalId, string userName)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.DeleteMultipleAttributes(attributeIds, storeId, portalId, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<AttributesBasicInfo> GetAttributesList(int offset, int limit, string attributeName, System.Nullable<bool> isRequired, System.Nullable<bool> comparable, System.Nullable<bool> isSystem, int storeId, int portalId, string cultureName, string userName)
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.GetItemAttributes(offset, limit, attributeName, isRequired, comparable, isSystem, storeId, portalId, cultureName, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<AttributesValidationTypeInfo> GetAttributesValidationTypeList()
{
try
{
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
return obj.GetAttributesValidationType();
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveUpdateAttributeInfo(int attributeId, string attributeName, int inputTypeID, string defaultValue, int validationTypeID,
System.Nullable<int> length, string aliasName, string aliasToolTip, string aliasHelp, int displayOrder, bool isUnique, bool isRequired, bool isEnableEditor,
bool showInGrid, bool showInSearch, bool showInAdvanceSearch, bool showInComparison, bool isIncludeInPriceRule,
bool isIncludeInPromotions, bool isEnableSorting, bool isUseInFilter, bool isShownInRating, int storeId, int portalId,
bool isActive, bool isModified, string userName, string cultureName, string itemTypes, bool flag, bool isUsedInConfigItem, string saveOptions)
{
try
{
AttributesGetByAttributeIdInfo attributeInfoToInsert = new AttributesGetByAttributeIdInfo
{
AttributeID = attributeId,
AttributeName = attributeName,
InputTypeID = inputTypeID,
DefaultValue = defaultValue,
ValidationTypeID = validationTypeID,
Length = length > 0 ? length : null,
AliasName = aliasName,
AliasToolTip = aliasToolTip,
AliasHelp = aliasHelp,
DisplayOrder = displayOrder,
IsUnique = isUnique,
IsRequired = isRequired,
IsEnableEditor = isEnableEditor,
ShowInGrid = showInGrid,
ShowInSearch = showInSearch,
ShowInAdvanceSearch = showInAdvanceSearch,
ShowInComparison = showInComparison,
IsIncludeInPriceRule = isIncludeInPriceRule,
IsIncludeInPromotions = isIncludeInPromotions,
IsEnableSorting = isEnableSorting,
IsUseInFilter = isUseInFilter,
IsShownInRating = isShownInRating,
StoreID = storeId,
PortalID = portalId,
IsActive = isActive,
IsModified = isModified,
UpdatedBy = userName,
AddedBy = userName,
CultureName = cultureName,
ItemTypes = itemTypes,
Flag = flag,
IsUsedInConfigItem = isUsedInConfigItem,
SaveOptions = saveOptions
};
ItemAttributesManagementSqlProvider obj = new ItemAttributesManagementSqlProvider();
obj.SaveAttribute(attributeInfoToInsert);
}
catch (Exception ex)
{
throw ex;
}
}