private async void ApplyFilter(object sender, EventArgs e) { ProductListProperty.IsLoading = true; try { if (HolderFilter.IsVisible) { ShowFilter(null, null); } ProductListProperty.PropertiesFilter.UserId = AppStatics.UserID != -1 ? AppStatics.UserID : 0; var responseProductsFiltered = await new Services.HttpExtension <List <BLL.M.Mobile.Product> >().Post("Category/GetFullSearchCategories", ProductListProperty.PropertiesFilter); if (responseProductsFiltered != null) { if (responseProductsFiltered.Count == 0) { ProductListProperty.PropertiesFilter.CurrentPage--; } Device.BeginInvokeOnMainThread(() => { ButNext.IsVisible = responseProductsFiltered?.Count == ProductListProperty.PropertiesFilter.PageSize; ButPrevious.IsVisible = ProductListProperty.PropertiesFilter.CurrentPage > 0; }); if (responseProductsFiltered.Count > 0) { ProductListProperty.Products = responseProductsFiltered == null ? null : new ObservableCollection <BLL.M.Mobile.Product>(responseProductsFiltered); Device.BeginInvokeOnMainThread(() => ListViewProduct.ScrollTo(ProductListProperty.Products.FirstOrDefault(), ScrollToPosition.Start, false)); } else { await DisplayAlert("", MultiLanguage.MLResource.NoMoreItem, MultiLanguage.MLResource.Ok); } } else { ProductListProperty.PropertiesFilter.CurrentPage--; } } catch (Exception ex) { if (Xamarin.Essentials.Connectivity.NetworkAccess != Xamarin.Essentials.NetworkAccess.Internet) { await App._nav.DisplayAlert(MultiLanguage.MLResource.InternetConnectionTitle, MultiLanguage.MLResource.InternetConnectionMessage, MultiLanguage.MLResource.Ok); } else #if DEBUG { await App._nav.DisplayAlert(MultiLanguage.MLResource.Error, ex.ToString(), MultiLanguage.MLResource.Ok); } #elif RELEASE { await App._nav.DisplayAlert(MultiLanguage.MLResource.Error, MultiLanguage.MLResource.FailedMessage, MultiLanguage.MLResource.Ok); } #endif } ProductListProperty.IsLoading = false; }
private void LoadData() { using (SqlConnection sqlConn = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { sqlConn.Open(); cmd.Connection = sqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "getAllProducts"; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ListViewProduct.DataSource = dt; ListViewProduct.DataBind(); } } }
protected void LinkButtonItem_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)(sender); int id = Convert.ToInt32(btn.CommandArgument.ToString()); using (SqlConnection sqlConn = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { sqlConn.Open(); cmd.Connection = sqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "getProductByCateId"; cmd.Parameters.Add(new SqlParameter("@cateId", id)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ListViewProduct.DataSource = dt; ListViewProduct.DataBind(); } } }
protected void btnSearch_Click(object sender, EventArgs e) { if (txtNameProduct.Text.Trim() != null || txtNameProduct.Text.Trim().Count() > 0) { string name = txtNameProduct.Text.Trim(); using (SqlConnection sqlConn = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand()) { sqlConn.Open(); cmd.Connection = sqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "findProductByName"; cmd.Parameters.Add(new SqlParameter("@name", name)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ListViewProduct.DataSource = dt; ListViewProduct.DataBind(); } } } }
private void PreviousListProduct(object sender, EventArgs e) { ListViewProduct.ScrollTo(ListViewProduct.Header, ScrollToPosition.Start, false); ProductListProperty.PropertiesFilter.CurrentPage--; ApplyFilter(null, null); }