/// <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; } }
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; } }