public AttributeItemCollection FetchAll()
{
AttributeItemCollection coll = new AttributeItemCollection();
Query qry = new Query(AttributeItem.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
/// <summary>
/// Loads the attribute items.
/// </summary>
private void LoadAttributeItems()
{
int attributeId = 0;
int.TryParse(lblAttributeId.Text, out attributeId);
AttributeItemCollection attributeItemCollection = new AttributeItemCollection().Where(AttributeItem.Columns.AttributeId, Comparison.Equals, attributeId).OrderByAsc("SortOrder").Load();
dgAttributeItems.DataSource = attributeItemCollection;
dgAttributeItems.ItemDataBound += new DataGridItemEventHandler(dgAttributeItems_ItemDataBound);
dgAttributeItems.Columns[0].HeaderText = LocalizationUtility.GetText("hdrEdit");
dgAttributeItems.Columns[1].HeaderText = LocalizationUtility.GetText("hdrMove");
dgAttributeItems.Columns[2].HeaderText = LocalizationUtility.GetText("hdrName");
dgAttributeItems.Columns[3].HeaderText = LocalizationUtility.GetText("hdrAdjustment");
dgAttributeItems.Columns[4].HeaderText = LocalizationUtility.GetText("hdrSkuSuffix");
dgAttributeItems.Columns[5].HeaderText = LocalizationUtility.GetText("hdrDelete");
dgAttributeItems.DataBind();
if (attributeItemCollection.Count > 0)
{
ImageButton lbUp = dgAttributeItems.Items[0].Cells[1].FindControl("lbUp") as ImageButton;
if (lbUp != null)
{
lbUp.Visible = false;
}
ImageButton lbDown = dgAttributeItems.Items[dgAttributeItems.Items.Count - 1].Cells[1].FindControl("lbDown") as ImageButton;
if (lbDown != null)
{
lbDown.Visible = false;
}
}
}
/// <summary>
/// Fetches the selected attribute item.
/// </summary>
/// <param name="attributeId">The attribute id.</param>
/// <param name="skuSuffix">The sku suffix.</param>
/// <returns></returns>
public AttributeItem FetchSelectedAttributeItem(int attributeId, string skuSuffix)
{
Query query = new Query(Store.AttributeItem.Schema).
AddWhere(Store.AttributeItem.Columns.AttributeId, attributeId).
AddWhere(Store.AttributeItem.Columns.SkuSuffix, skuSuffix);
IDataReader reader = query.ExecuteReader();
AttributeItemCollection attributeItemCollection = new AttributeItemCollection();
attributeItemCollection.LoadAndCloseReader(reader);
if(attributeItemCollection.Count > 0) {
return attributeItemCollection[0];
}
else {
return null;
}
}
public AttributeItemCollection FetchByQuery(Query qry)
{
AttributeItemCollection coll = new AttributeItemCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public AttributeItemCollection FetchByID(object AttributeItemId)
{
AttributeItemCollection coll = new AttributeItemCollection().Where("AttributeItemId", AttributeItemId).Load();
return coll;
}
/// <summary>
/// Loads the attribute items.
/// </summary>
private void LoadAttributeItems()
{
int attributeId = 0;
int.TryParse(lblAttributeId.Text, out attributeId);
AttributeItemCollection attributeItemCollection = new AttributeItemCollection().Where(AttributeItem.Columns.AttributeId, Comparison.Equals, attributeId).OrderByAsc("SortOrder").Load();
dgAttributeItems.DataSource = attributeItemCollection;
dgAttributeItems.ItemDataBound += new DataGridItemEventHandler(dgAttributeItems_ItemDataBound);
dgAttributeItems.Columns[0].HeaderText = LocalizationUtility.GetText("hdrEdit");
dgAttributeItems.Columns[1].HeaderText = LocalizationUtility.GetText("hdrMove");
dgAttributeItems.Columns[2].HeaderText = LocalizationUtility.GetText("hdrName");
dgAttributeItems.Columns[3].HeaderText = LocalizationUtility.GetText("hdrAdjustment");
dgAttributeItems.Columns[4].HeaderText = LocalizationUtility.GetText("hdrSkuSuffix");
dgAttributeItems.Columns[5].HeaderText = LocalizationUtility.GetText("hdrDelete");
dgAttributeItems.DataBind();
if(attributeItemCollection.Count > 0) {
ImageButton lbUp = dgAttributeItems.Items[0].Cells[1].FindControl("lbUp") as ImageButton;
if(lbUp != null) {
lbUp.Visible = false;
}
ImageButton lbDown = dgAttributeItems.Items[dgAttributeItems.Items.Count - 1].Cells[1].FindControl("lbDown") as ImageButton;
if(lbDown != null) {
lbDown.Visible = false;
}
}
}
