/// <summary>
/// Search Promotion
/// </summary>
private void SearchPromotions()
{
DataView dv = new DataView();
if (ViewState["PromotionsList"]!=null)
{
dv = new DataView(ViewState["PromotionsList"] as DataTable);
}
else
{
ZNode.Libraries.Admin.PromotionAdmin couponbind = new ZNode.Libraries.Admin.PromotionAdmin();
DataSet ds = couponbind.GetAllPromotions().ToDataSet(false);
string filterQuery = "";
dv = new DataView(ds.Tables[0]);
dv.Sort = "displayorder asc";
# region Create row filter query
if (ddlDiscountTypes.SelectedValue != "0")
{
filterQuery = "DiscountTypeId = " +ddlDiscountTypes.SelectedValue + " and ";
}
if (txtStartDate.Text.Trim().Length > 0 && txtEndDate.Text.Trim().Length == 0)
{
filterQuery = "StartDate >= '" + txtStartDate.Text.Trim() + "' and ";
}
else if (txtEndDate.Text.Trim().Length > 0 && txtStartDate.Text.Trim().Length == 0)
{
filterQuery = "EndDate <='" + txtEndDate.Text.Trim() + "' and ";
}
else if(txtStartDate.Text.Trim().Length > 0 && txtEndDate.Text.Trim().Length > 0)
{
filterQuery = "StartDate >= '" + txtStartDate.Text.Trim() + "' and EndDate <='" + txtEndDate.Text.Trim() + "' and ";
}
if (txtName.Text.Trim().Length > 0)
filterQuery += "Name like '%" + txtName.Text.Trim() + "%' and ";
if (txtAmount.Text.Trim().Length > 0)
filterQuery += "Discount >= " + txtAmount.Text.Trim() + " and ";
if (CouponCode.Text.Trim().Length > 0)
filterQuery += "CouponCode like '%" + CouponCode.Text.Trim() + "%' and ";
#endregion
//if filter query has conditition, if any
if (filterQuery.Length > 0)
{
//Apply filter
dv.RowFilter = filterQuery + "description like '%'";
}
ViewState.Add("PromotionsList", dv.ToTable());
}
uxGrid.DataSource = dv;
uxGrid.DataBind();
}
// Bind data to grid
private void BindGridData()
{
ZNode.Libraries.Admin.PromotionAdmin couponbind = new ZNode.Libraries.Admin.PromotionAdmin();
DataSet ds = couponbind.GetAllPromotions().ToDataSet(false);
DataView dv = new DataView(ds.Tables[0]);
dv.Sort = "displayorder asc";
uxGrid.DataSource = dv;
uxGrid.DataBind();
}