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;
}
}
}
}
}
