Example #1
0
        /// <summary>
        /// To update, add  Attribute Group
        /// </summary>
        /// <returns></returns>
        public void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
                parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", attributeSaveObj.AttributeSetID));
                parameterCollection.Add(new KeyValuePair <string, object>("@GroupName", attributeSaveObj.GroupName));
                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", aspxCommonObj.UserName));
                parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", attributeSaveObj.IsActive));
                parameterCollection.Add(new KeyValuePair <string, object>("@IsModified", attributeSaveObj.IsModified));
                parameterCollection.Add(new KeyValuePair <string, object>("@GroupID", attributeSaveObj.GroupID));
                parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
                parameterCollection.Add(new KeyValuePair <string, object>("@AliasName", attributeSaveObj.AliasName));
                parameterCollection.Add(new KeyValuePair <string, object>("@UpdateFlag", attributeSaveObj.Flag));

                SQLHandler sqlH = new SQLHandler();
                sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeGroupAddUpdate", parameterCollection);
            }
            catch (Exception e)
            {
                throw e;
            }
        }
 /// <summary>
 /// Check unique Attribute set name
 /// </summary>
 /// <returns></returns>
 public static int CheckAttributeSetUniqueName(AttributeSaveInfo checkUniqueAttrSet, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         return(AspxItemAttrMgntProvider.CheckAttributeSetUniqueName(checkUniqueAttrSet, aspxCommonObj));
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// To update, add  Attribute Group
 /// </summary>
 /// <returns></returns>
 public static void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         AspxItemAttrMgntProvider.UpdateAttributeGroup(attributeSaveObj, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static void DeleteAttribute(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         AspxItemAttrMgntProvider.DeleteAttribute(deleteGroupObj, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static void DeleteAttributeSetGroup(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", deleteGroupObj.AttributeSetID));
         parameterCollection.Add(new KeyValuePair <string, object>("@GroupID", deleteGroupObj.GroupID));
         parameterCollection.Add(new KeyValuePair <string, object>("@DeletedBy", aspxCommonObj.UserName));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("dbo.usp_Aspx_DeleteAttributeSetGroupByAttributeSetID", parameterCollection);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// Check unique Attribute set name
 /// </summary>
 /// <returns></returns>
 public static int CheckAttributeSetUniqueName(AttributeSaveInfo checkUniqueAttrSet, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", checkUniqueAttrSet.AttributeSetID));
         parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetName", checkUniqueAttrSet.AttributeSetName));
         parameterCollection.Add(new KeyValuePair <string, object>("@IsEdit", checkUniqueAttrSet.Flag));
         parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
         SQLHandler sqlH = new SQLHandler();
         return(sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeSetUniquenessCheck", parameterCollection, "@AttributeSetCount"));
     }
     catch (Exception e)
     {
         throw e;
     }
 }
Example #7
0
 public void DeleteAttributeSetGroup(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
         parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", deleteGroupObj.AttributeSetID));
         parameterCollection.Add(new KeyValuePair <string, object>("@GroupID", deleteGroupObj.GroupID));
         parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
         parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
         parameterCollection.Add(new KeyValuePair <string, object>("@DeletedBy", aspxCommonObj.UserName));
         parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("dbo.usp_Aspx_DeleteAttributeSetGroupByAttributeSetID", parameterCollection);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// To update, add  Attribute Group
 /// </summary>
 /// <returns></returns>
 public static void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair <string, object>("@AttributeSetID", attributeSaveObj.AttributeSetID));
         parameterCollection.Add(new KeyValuePair <string, object>("@GroupName", attributeSaveObj.GroupName));
         parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", attributeSaveObj.IsActive));
         parameterCollection.Add(new KeyValuePair <string, object>("@IsModified", attributeSaveObj.IsModified));
         parameterCollection.Add(new KeyValuePair <string, object>("@GroupID", attributeSaveObj.GroupID));
         parameterCollection.Add(new KeyValuePair <string, object>("@AliasName", attributeSaveObj.AliasName));
         parameterCollection.Add(new KeyValuePair <string, object>("@UpdateFlag", attributeSaveObj.Flag));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeGroupAddUpdate", parameterCollection);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public int CheckAttributeSetUniqueness(AttributeSaveInfo checkUniqueAttrSet, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         int retValue = AspxItemAttrMgntController.CheckAttributeSetUniqueName(checkUniqueAttrSet, aspxCommonObj);
         return retValue;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// Check unique Attribute set name
 /// </summary>
 /// <returns></returns>
 public static int CheckAttributeSetUniqueName(AttributeSaveInfo checkUniqueAttrSet, AspxCommonInfo aspxCommonObj)
 {
     try
     {
        return AspxItemAttrMgntProvider.CheckAttributeSetUniqueName(checkUniqueAttrSet, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// To update, add  Attribute Group
 /// </summary>
 /// <returns></returns>
 public static void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         AspxItemAttrMgntProvider.UpdateAttributeGroup(attributeSaveObj, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static void DeleteAttribute(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", deleteGroupObj.AttributeSetID));
         parameterCollection.Add(new KeyValuePair<string, object>("@GroupID", deleteGroupObj.GroupID));
         parameterCollection.Add(new KeyValuePair<string, object>("@AttributeID", deleteGroupObj.AttributeID));
         parameterCollection.Add(new KeyValuePair<string, object>("@DeletedBy", aspxCommonObj.UserName));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("dbo.usp_Aspx_DeleteAttributeByAttributeSetID", parameterCollection);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// To update, add  Attribute Group
 /// </summary>
 /// <returns></returns>
 public static void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", attributeSaveObj.AttributeSetID));
         parameterCollection.Add(new KeyValuePair<string, object>("@GroupName", attributeSaveObj.GroupName));
         parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", attributeSaveObj.IsActive));
         parameterCollection.Add(new KeyValuePair<string, object>("@IsModified", attributeSaveObj.IsModified));
         parameterCollection.Add(new KeyValuePair<string, object>("@GroupID", attributeSaveObj.GroupID));
         parameterCollection.Add(new KeyValuePair<string, object>("@AliasName", attributeSaveObj.AliasName));
         parameterCollection.Add(new KeyValuePair<string, object>("@UpdateFlag", attributeSaveObj.Flag));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeGroupAddUpdate", parameterCollection);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 /// <summary>
 /// Check unique Attribute set name
 /// </summary>
 /// <returns></returns>
 public static int CheckAttributeSetUniqueName(AttributeSaveInfo checkUniqueAttrSet, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", checkUniqueAttrSet.AttributeSetID));
         parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetName", checkUniqueAttrSet.AttributeSetName));
         parameterCollection.Add(new KeyValuePair<string, object>("@IsEdit", checkUniqueAttrSet.Flag));
         parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
         SQLHandler sqlH = new SQLHandler();
         return sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeSetUniquenessCheck", parameterCollection, "@AttributeSetCount");
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public void DeleteAttributeByAttributeSetID(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         AspxItemAttrMgntController.DeleteAttribute(deleteGroupObj, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public void DeleteAttributeSetGroup(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
         parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", deleteGroupObj.AttributeSetID));
         parameterCollection.Add(new KeyValuePair<string, object>("@GroupID", deleteGroupObj.GroupID));
         parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
         parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
         parameterCollection.Add(new KeyValuePair<string, object>("@DeletedBy", aspxCommonObj.UserName));
         parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
         SQLHandler sqlH = new SQLHandler();
         sqlH.ExecuteNonQuery("dbo.usp_Aspx_DeleteAttributeSetGroupByAttributeSetID", parameterCollection);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static void DeleteAttribute(AttributeSaveInfo deleteGroupObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         AspxItemAttrMgntProvider.DeleteAttribute(deleteGroupObj, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public void SaveUpdateAttributeGroupInfo(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         AspxItemAttrMgntController.UpdateAttributeGroup(attributeSaveObj, aspxCommonObj);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        /// <summary>
        /// To update, add  Attribute Group
        /// </summary>
        /// <returns></returns>
        public void UpdateAttributeGroup(AttributeSaveInfo attributeSaveObj, AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
                parameterCollection.Add(new KeyValuePair<string, object>("@AttributeSetID", attributeSaveObj.AttributeSetID));
                parameterCollection.Add(new KeyValuePair<string, object>("@GroupName", attributeSaveObj.GroupName));
                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", aspxCommonObj.UserName));
                parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", attributeSaveObj.IsActive));
                parameterCollection.Add(new KeyValuePair<string, object>("@IsModified", attributeSaveObj.IsModified));
                parameterCollection.Add(new KeyValuePair<string, object>("@GroupID", attributeSaveObj.GroupID));
                parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
                parameterCollection.Add(new KeyValuePair<string, object>("@AliasName", attributeSaveObj.AliasName));
                parameterCollection.Add(new KeyValuePair<string, object>("@UpdateFlag", attributeSaveObj.Flag));

                SQLHandler sqlH = new SQLHandler();
                sqlH.ExecuteNonQuery("dbo.usp_Aspx_AttributeGroupAddUpdate", parameterCollection);
            }
            catch (Exception e)
            {
                throw e;
            }
        }