private void DeleteStore(AgencyControlUC para)
{
Agency store= new Agency();
int id = int.Parse(para.txtID.Text);
store = (Agency)DataProvider.Instance.DB.Agencies.Where(x => x.ID == id).First();
store.IsDelete = true;
DataProvider.Instance.DB.Agencies.AddOrUpdate(store);
DataProvider.Instance.DB.SaveChanges();
this.HomeWindow.stkStore_Store.Children.Remove(para);
}
private void LoadListAgency()
{
this.HomeWindow.stkStore_Store.Children.Clear();
string query = "SELECT * FROM AGENCY WHERE ISDELETE = 0";
this.ListStores = DataProvider.Instance.DB.Agencies.SqlQuery(query).ToList();
foreach (Agency agency in ListStores)
{
AgencyControlUC item = new AgencyControlUC();
item.txtID.Text = agency.ID.ToString();
item.txtName.Text = agency.Name;
item.txtPhone.Text = agency.PhoneNumber;
item.txtSpecies.Text = agency.TypeOfAgency.ToString();
item.txtAddress.Text = agency.Address;
item.txtDistrict.Text = agency.District;
item.txtDebt.Text = SeparateThousands(agency.Debt.ToString());
item.Height = 45;
this.HomeWindow.stkStore_Store.Children.Add(item);
}
}
