/// <summary>
/// To Bind Attribute set grid
/// </summary>
/// <returns></returns>
public static List <AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
List <AttributeSetBaseInfo> ml;
ml = AspxItemAttrMgntProvider.GetAttributeSetGrid(offset, limit, AttributeSetBindObj, aspxCommonObj);
return(ml);
}
/// <summary>
/// To Bind Attribute set grid
/// </summary>
/// <returns></returns>
public List <AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
List <AttributeSetBaseInfo> 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>("@AttributeSetName", AttributeSetBindObj.AttributeSetName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", AttributeSetBindObj.IsActive));
parameterCollection.Add(new KeyValuePair <string, object>("@UsedInSystem", AttributeSetBindObj.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 <AttributeSetBaseInfo>("dbo.usp_Aspx_AttributeSetGridGetAll", parameterCollection);
return(ml);
}
/// <summary>
/// To Bind Attribute set grid
/// </summary>
/// <returns></returns>
public static List<AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
List<AttributeSetBaseInfo> 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>("@AttributeSetName", AttributeSetBindObj.AttributeSetName));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", AttributeSetBindObj.IsActive));
parameterCollection.Add(new KeyValuePair<string, object>("@UsedInSystem", AttributeSetBindObj.IsSystemUsed));
ml = sqlH.ExecuteAsList<AttributeSetBaseInfo>("dbo.usp_Aspx_AttributeSetGridGetAll", parameterCollection);
return ml;
}
public List<AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<AttributeSetBaseInfo> lstAttrSet = AspxItemAttrMgntController.GetAttributeSetGrid(offset, limit, AttributeSetBindObj, aspxCommonObj);
return lstAttrSet;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// To Bind Attribute set grid
/// </summary>
/// <returns></returns>
public static List <AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
List <AttributeSetBaseInfo> 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>("@AttributeSetName", AttributeSetBindObj.AttributeSetName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", AttributeSetBindObj.IsActive));
parameterCollection.Add(new KeyValuePair <string, object>("@UsedInSystem", AttributeSetBindObj.IsSystemUsed));
ml = sqlH.ExecuteAsList <AttributeSetBaseInfo>("dbo.usp_Aspx_AttributeSetGridGetAll", parameterCollection);
return(ml);
}
/// <summary>
/// To Bind Attribute set grid
/// </summary>
/// <returns></returns>
public static List<AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit, AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
List<AttributeSetBaseInfo> ml;
ml = AspxItemAttrMgntProvider.GetAttributeSetGrid(offset, limit, AttributeSetBindObj, aspxCommonObj);
return ml;
}
/// <summary>
/// To Bind Attribute set grid
/// </summary>
/// <returns></returns>
public List<AttributeSetBaseInfo> GetAttributeSetGrid(int offset, int limit,AttributeSetBindInfo AttributeSetBindObj, AspxCommonInfo aspxCommonObj)
{
List<AttributeSetBaseInfo> 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>("@AttributeSetName", AttributeSetBindObj.AttributeSetName));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", AttributeSetBindObj.IsActive));
parameterCollection.Add(new KeyValuePair<string, object>("@UsedInSystem", AttributeSetBindObj.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<AttributeSetBaseInfo>("dbo.usp_Aspx_AttributeSetGridGetAll", parameterCollection);
return ml;
}