/// <summary>
        /// To Save Attribute Set
        /// </summary>
        /// <returns></returns>
        public static int SaveUpdateAttributeSet(AttributeSetInfo attributeSetInfoToInsert, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
                parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", attributeSetInfoToInsert.AttributeSetID));
                parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetBaseID", attributeSetInfoToInsert.AttributeSetBaseID));
                parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetName", attributeSetInfoToInsert.AttributeSetName));
                parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", attributeSetInfoToInsert.IsActive));
                parameterCollection.Add(new KeyValuePair <string, object>("@IsModified", attributeSetInfoToInsert.IsModified));

                parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
                parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
                parameterCollection.Add(new KeyValuePair <string, object>("@UserName", attributeSetInfoToInsert.AddedBy));
                parameterCollection.Add(new KeyValuePair <string, object>("@UpdateFlag", attributeSetInfoToInsert.Flag));
                parameterCollection.Add(new KeyValuePair <string, object>("@SaveString", attributeSetInfoToInsert.SaveString));
                parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
                SQLHandler sqlH = new SQLHandler();
                return(sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeSetAddUpdate", parameterCollection, "@AttributeSetIDOut"));
            }
            catch (Exception e)
            {
                throw e;
            }
        }
 /// <summary>
 /// To Save Attribute Set
 /// </summary>
 /// <returns></returns>
 public static int SaveUpdateAttributeSet(AttributeSetInfo attributeSetInfoToInsert, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         return(AspxItemAttrMgntProvider.SaveUpdateAttributeSet(attributeSetInfoToInsert, aspxCommonObj));
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 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;
     }
 }
        /// <summary>
        /// To Save Attribute Set
        /// </summary>
        /// <returns></returns>
        public int SaveUpdateAttributeSet(AttributeSetInfo attributeSetInfoToInsert)
        {
            try
            {
                List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
                parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", attributeSetInfoToInsert.AttributeSetID));
                parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetBaseID", attributeSetInfoToInsert.AttributeSetBaseID));
                parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetName", attributeSetInfoToInsert.AttributeSetName));
                parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", attributeSetInfoToInsert.IsActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@IsModified", attributeSetInfoToInsert.IsModified));

                parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", attributeSetInfoToInsert.StoreID));
                parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", attributeSetInfoToInsert.PortalID));
                parameterCollection.Add(new KeyValuePair<string, object>("@UserName", attributeSetInfoToInsert.AddedBy));
                parameterCollection.Add(new KeyValuePair<string, object>("@UpdateFlag", attributeSetInfoToInsert.Flag));
                parameterCollection.Add(new KeyValuePair<string, object>("@SaveString", attributeSetInfoToInsert.SaveString));
                SQLHandler sqlH = new SQLHandler();
                return sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeSetAddUpdate", parameterCollection, "@AttributeSetIDOut");

            }
            catch (Exception e)
            {
                throw e;
            }
        }
 public int SaveUpdateAttributeSetInfo(AttributeSetInfo attributeSetObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         int retValue = AspxItemAttrMgntController.SaveUpdateAttributeSet(attributeSetObj, aspxCommonObj);
         return retValue;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// To Save Attribute Set
 /// </summary>
 /// <returns></returns>
 public static int SaveUpdateAttributeSet(AttributeSetInfo attributeSetInfoToInsert, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         return AspxItemAttrMgntProvider.SaveUpdateAttributeSet(attributeSetInfoToInsert, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }