public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
bool isUnique = AspxItemAttrMgntProvider.CheckUniqueName(attrbuteUniqueObj, aspxCommonObj);
return(isUnique);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// To Bind grid
/// </summary>
/// <returns></returns>
public static List<AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
{
List<AttributesBasicInfo> ml;
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair<string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeName", attrbuteBindObj.AttributeName));
parameterCollection.Add(new KeyValuePair<string, object>("@IsRequired", attrbuteBindObj.IsRequired));
parameterCollection.Add(new KeyValuePair<string, object>("@Comparable", attrbuteBindObj.ShowInComparison));
parameterCollection.Add(new KeyValuePair<string, object>("@IsSystem", attrbuteBindObj.IsSystemUsed));
ml = sqlH.ExecuteAsList<AttributesBasicInfo>("dbo.usp_Aspx_AttributesGetAll", parameterCollection);
return ml;
}
//---------------- Added for unique name check ---------------------
public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attrbuteUniqueObj.AttributeName));
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeID", attrbuteUniqueObj.AttributeID));
bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique");
return(isUnique);
}
catch (Exception e)
{
throw e;
}
}
//---------------- Added for unique name check ---------------------
public bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attrbuteUniqueObj.AttributeName));
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeID", attrbuteUniqueObj.AttributeID));
parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
return(sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique"));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// To Bind grid
/// </summary>
/// <returns></returns>
public List<AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
//(int portalID, int userModuleID, string cultureName)
{
List<AttributesBasicInfo> ml;
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair<string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeName", attrbuteBindObj.AttributeName));
parameterCollection.Add(new KeyValuePair<string, object>("@IsRequired", attrbuteBindObj.IsRequired));
parameterCollection.Add(new KeyValuePair<string, object>("@Comparable", attrbuteBindObj.ShowInComparison));
parameterCollection.Add(new KeyValuePair<string, object>("@IsSystem", attrbuteBindObj.IsSystemUsed));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
//parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
ml = sqlH.ExecuteAsList<AttributesBasicInfo>("dbo.usp_Aspx_AttributesGetAll", parameterCollection);
return ml;
}
/// <summary>
/// To Bind grid
/// </summary>
/// <returns></returns>
public List <AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
//(int portalID, int userModuleID, string cultureName)
{
List <AttributesBasicInfo> ml;
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attrbuteBindObj.AttributeName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsRequired", attrbuteBindObj.IsRequired));
parameterCollection.Add(new KeyValuePair <string, object>("@Comparable", attrbuteBindObj.ShowInComparison));
parameterCollection.Add(new KeyValuePair <string, object>("@IsSystem", attrbuteBindObj.IsSystemUsed));
parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
//parameterCollection.Add(new KeyValuePair<string, object>("@UserName", userName));
ml = sqlH.ExecuteAsList <AttributesBasicInfo>("dbo.usp_Aspx_AttributesGetAll", parameterCollection);
return(ml);
}
/// <summary>
/// To Bind grid
/// </summary>
/// <returns></returns>
public static List <AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
{
List <AttributesBasicInfo> ml;
ml = AspxItemAttrMgntProvider.GetItemAttributes(offset, limit, attrbuteBindObj, aspxCommonObj);
return(ml);
}
public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeName", attrbuteUniqueObj.AttributeName));
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeID", attrbuteUniqueObj.AttributeID));
bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique");
return isUnique;
}
catch (Exception e)
{
throw e;
}
}
public List<AttributesBasicInfo> GetAttributesList(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<AttributesBasicInfo> lstAttrBasic = AspxItemAttrMgntController.GetItemAttributes(offset, limit, attrbuteBindObj, aspxCommonObj);
return lstAttrBasic;
}
catch (Exception e)
{
throw e;
}
}
public bool CheckUniqueAttributeName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
bool isUnique = AspxItemAttrMgntController.CheckUniqueName(attrbuteUniqueObj, aspxCommonObj);
return isUnique;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// To Bind grid
/// </summary>
/// <returns></returns>
public static List <AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
{
List <AttributesBasicInfo> ml;
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@AttributeName", attrbuteBindObj.AttributeName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsRequired", attrbuteBindObj.IsRequired));
parameterCollection.Add(new KeyValuePair <string, object>("@Comparable", attrbuteBindObj.ShowInComparison));
parameterCollection.Add(new KeyValuePair <string, object>("@IsSystem", attrbuteBindObj.IsSystemUsed));
ml = sqlH.ExecuteAsList <AttributesBasicInfo>("dbo.usp_Aspx_AttributesGetAll", parameterCollection);
return(ml);
}
/// <summary>
/// To Bind grid
/// </summary>
/// <returns></returns>
public static List<AttributesBasicInfo> GetItemAttributes(int offset, int limit, AttributeBindInfo attrbuteBindObj, AspxCommonInfo aspxCommonObj)
{
List<AttributesBasicInfo> ml;
ml = AspxItemAttrMgntProvider.GetItemAttributes(offset,limit,attrbuteBindObj,aspxCommonObj);
return ml;
}
//---------------- Added for unique name check ---------------------
public static bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
bool isUnique = AspxCommonProvider.CheckUniqueName(attrbuteUniqueObj, aspxCommonObj);
return isUnique;
}
catch (Exception e)
{
throw e;
}
}
//---------------- Added for unique name check ---------------------
public bool CheckUniqueName(AttributeBindInfo attrbuteUniqueObj, AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeName", attrbuteUniqueObj.AttributeName));
parameterCollection.Add(new KeyValuePair<string, object>("@AttributeID", attrbuteUniqueObj.AttributeID));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_AttributeUniquenessCheck", parameterCollection, "@IsUnique");
}
catch (Exception ex)
{
throw ex;
}
}