private void ReLoad3Stores(HomeWindow para, List<Agency> listStores, int pageNumber) { para.grdStoreFisrt.Children.Clear(); para.grdStoreSecond.Children.Clear(); para.grdStoreThird.Children.Clear(); string query = "SELECT * FROM AGENCY WHERE ISDELETE = 0"; this.ListStores = DataProvider.Instance.DB.Agencies.SqlQuery(query).ToList(); //hiển thị ds theo phân trang(number page) for (int i = 0; i < 3; i++) { int pos = (pageNumber - 1) * 3 + i; if (pos == this.ListStores.Count) break; int typeA = int.Parse(ListStores[pos].TypeOfAgency.ToString()); TypeOfAgency type = (TypeOfAgency)DataProvider.Instance.DB.TypeOfAgencies.Where(x => x.ID == typeA).First(); StoreControlUC uc = new StoreControlUC(); uc.Height = 350; uc.Width = 280; uc.txbID.Text = ListStores[pos].ID.ToString(); uc.AgencyName.Text = ListStores[pos].Name.ToString(); uc.txbAgencyPhone.Text = ListStores[pos].PhoneNumber.ToString(); uc.txbAgencyDate.Text = ListStores[pos].CheckIn.Value.ToShortDateString(); uc.txbAgencyPosition.Text = ListStores[pos].Address.ToString(); uc.txbAgencyType.Text = type.Name.ToString(); switch (i) { case 0: para.grdStoreFisrt.Children.Add(uc); break; case 1: para.grdStoreSecond.Children.Add(uc); break; case 2: para.grdStoreThird.Children.Add(uc); break; } } }
private void SearchAgency(HomeWindow para) { if (para.grdListStore_Store.Visibility == Visibility.Visible) { foreach (AgencyControlUC control in HomeWindow.stkStore_Store.Children) { if (!control.txtName.Text.ToLower().Contains(this.HomeWindow.txtSearchAgency.Text)) { control.Visibility = Visibility.Collapsed; } else { control.Visibility = Visibility.Visible; } } } else { int loadPos = 0; int i = 0; int pos = 0; string query = "SELECT * FROM AGENCY WHERE ISDELETE = 0"; this.ListStores = DataProvider.Instance.DB.Agencies.SqlQuery(query).ToList(); if (String.IsNullOrEmpty(this.HomeWindow.txtSearchAgency.Text)) { Load3Stores(para, this.ListStores, PageNumber); } else { para.grdStoreFisrt.Children.Clear(); para.grdStoreSecond.Children.Clear(); para.grdStoreThird.Children.Clear(); //hiển thị ds theo phân trang(number page) while (i < 3) { for (pos = loadPos; pos < this.ListStores.Count; pos++) { if (this.ListStores[pos].Name.ToLower().Contains(this.HomeWindow.txtSearchAgency.Text.ToLower())) { i++; loadPos = pos + 1; int typeA = int.Parse(ListStores[pos].TypeOfAgency.ToString()); TypeOfAgency type = (TypeOfAgency)DataProvider.Instance.DB.TypeOfAgencies.Where(x => x.ID == typeA).First(); StoreControlUC uc = new StoreControlUC(); uc.Height = 350; uc.Width = 280; uc.txbID.Text = ListStores[pos].ID.ToString(); uc.AgencyName.Text = ListStores[pos].Name.ToString(); uc.txbAgencyPhone.Text = ListStores[pos].PhoneNumber.ToString(); uc.txbAgencyDate.Text = ListStores[pos].CheckIn.Value.ToShortDateString(); uc.txbAgencyPosition.Text = ListStores[pos].Address.ToString(); uc.txbAgencyType.Text = type.Name.ToString(); switch (i - 1) { case 0: para.grdStoreFisrt.Children.Add(uc); break; case 1: para.grdStoreSecond.Children.Add(uc); break; case 2: para.grdStoreThird.Children.Add(uc); break; } } } if (pos == this.ListStores.Count) { break; } } } } }