protected void btnbind_Click(object sender, ImageClickEventArgs e)
{
if (ddlOption.SelectedIndex != 0)
{
string condition = string.Empty;
if (ddlOption.SelectedIndex == 1)
{
condition = "convert(" + ddlFieldName.SelectedValue + ",System.String)='" + txtValue.Text.Trim() + "'";
}
else if (ddlOption.SelectedIndex == 2)
{
condition = "convert(" + ddlFieldName.SelectedValue + ",System.String) Like '" + txtValue.Text.Trim() + "%'";
}
else
{
condition = "convert(" + ddlFieldName.SelectedValue + ",System.String) like '%" + txtValue.Text.Trim() + "%'";
}
DataView view = new DataView((DataTable)Session["DtProduct"], condition, "", DataViewRowState.CurrentRows);
lblTotalRecord.Text = Resources.Attendance.Total_Records + " : " + (view.ToTable()).Rows.Count.ToString() + "";
GridProduct.DataSource = view.ToTable();
GridProduct.DataBind();
Session["DtFilter"] = view.ToTable();
btnbind.Focus();
}
}
protected void GridProduct_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridProduct.PageIndex = e.NewPageIndex;
GridProduct.DataSource = (DataTable)Session["DtFilter"];
GridProduct.DataBind();
AllPageCode();
GridProduct.BottomPagerRow.Focus();
}
private void FillProductGrid()
{
DataTable dtproduct = ObjInvProductMaster.GetProductMasterTrueAll(StrCompId.ToString());
GridProduct.DataSource = dtproduct;
GridProduct.DataBind();
Session["DtFilter"] = dtproduct;
Session["DtProduct"] = dtproduct;
lblTotalRecord.Text = Resources.Attendance.Total_Records + " : " + dtproduct.Rows.Count;
}
private void FillProductGrid()
{
DataTable dtproduct = new DataView(ObjInvProductMaster.GetProductMasterTrueAll(StrCompId.ToString()), "ItemType='A' or ItemType='K' ", "", DataViewRowState.CurrentRows).ToTable();
GridProduct.DataSource = dtproduct;
GridProduct.DataBind();
Session["DtProduct"] = dtproduct;
Session["DtFilter"] = dtproduct;
lblTotalRecord.Text = Resources.Attendance.Total_Records + " : " + dtproduct.Rows.Count;
AllPageCode();
}
protected void Page_Load(object sender, EventArgs e)
{
int ProductID = CommonLogic.QueryStringUSInt("productid");
if (ProductID > 0 && !IsPostBack)
{
grdProducts = new List <GridProduct>();
GridProduct gp = new GridProduct(ProductID);
grdProducts.Add(gp);
grd.Datasource = grdProducts;
}
else
{
grdProducts = GridProduct.GetProducts(true);
grd.Datasource = grdProducts;
}
}
public IHttpActionResult GetProducts(GridProduct model)
{
using (WebDemoEntities db = new WebDemoEntities())
{
var products = db.Products.Where(x => x.CategoryID == model.CategoryStatus);
//lọc theo giá
switch (model.PriceStatus)
{
case (int)PriceStatus.Max3:
products = products.Where(x => x.Price <= 3000000);
break;
case (int)PriceStatus.Min3:
products = products.Where(x => x.Price > 3000000);
break;
}
//sắp xếp
switch (model.SortStatus)
{
case (int)SortStatus.SortNew:
products = products.OrderByDescending(x => x.CreatedDate);
break;
case (int)SortStatus.SortPrice:
products = products.OrderByDescending(x => x.Price);
break;
}
//phân trang
products = products.Skip(model.CurrentPage * model.Pagesize + 1).Take(model.Pagesize);
JsonResultProduct json = new JsonResultProduct
{
list = products.Select(x => x.CopyObjectProduct()).ToArray()
};
return(Json(new { data = json }));
}
}
protected void DetailsView1_itemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
GridProduct.DataBind();
}
protected void GridProduct_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridProduct.DataSource = (DataTable)Session["DtFilter"];
GridProduct.DataBind();
GridProduct.Focus();
}
/// <summary>
/// Retrieve only enabled products from last screen
/// </summary>
/// <param name="navegationParams_"></param>
private void GetListEnabledTypedSale(List<ConsultarProdutoHabilitadoClienteProdutoDTO> _products)
{
ObservableCollection<GridProduct> list = new ObservableCollection<GridProduct>();
ListEnabledTypedSaleItens = new ObservableCollection<GridProduct>();
var listProducts = _products.Where(x => x.IndicadorVendaDigitada == true && x.IndicadorVendaDigitadaHabilitada==false);
foreach (var item in listProducts)
{
GridProduct product = new GridProduct();
product.CodigoProduto = item.CodigoProduto;
product.IndicaAcao = INDICAACAO;
product.LineChecked = true;
product.NomeBandeira = item.NomeBandeira;
product.NomeProduto = item.NomeProduto;
product.CodigoBandeira = item.CodigoBandeira;
list.Add(product);
}
ListEnabledTypedSaleItens = list;
}
