public async void GetData()
{
List <string> lst1 = null;
await Task.Run(() => lst1 = BaseDataBase.GetAllStringsWithAll("select distinct NeedType from FamilyNeed"));
cmboNeedType.ItemsSource = lst1;
}
public StaOrphan()
{
InitializeComponent();
cmboImpeding.ItemsSource = BaseDataBase.GetAllStringsWithAll("select distinct impedingType from impeding");
cmboHealth.ItemsSource = BaseDataBase.GetAllStringsWithAll("select Distinct HealthSituation from OrphanHealth");
}
public async void GetData()
{
await DBMain.UpdateAllPregnant();
List <string> lst1, lst2, lst3, lst4, lst5, lst6, lst7, lst8;
lst1 = lst2 = lst3 = lst4 = lst5 = lst6 = lst7 = lst8 = null;
await Task.Run(() =>
{
lst1 = BaseDataBase.GetAllStringsWithAll("select distinct job from (select Job from Parent Union select Job from FamilyPerson) x where ISNULL(Job,'') <> '' order by Job");
lst2 = BaseDataBase.GetAllStringsWithAll("select distinct HealthStatus from (select HealthStatus from Parent Union select HealthStatus from FamilyPerson) x WHERE ISNULL(HealthStatus,'') <> '' order by HealthStatus");
lst3 = BaseDataBase.GetAllStringsWithAll("select distinct StudyStatus from (select StudyStatus from Parent Union select StudyStatus from FamilyPerson) x where Isnull(StudyStatus,'') <> '' order by StudyStatus");
lst4 = BaseDataBase.GetAllStringsWithAll("select distinct HouseSection from House where ISNULL(HouseSection,'') <> '' order by HouseSection");
lst5 = BaseDataBase.GetAllStringsWithAll("select distinct HouseStreet from House where isnull(HouseStreet,'') <> '' order by HouseStreet");
lst6 = BaseDataBase.GetAllStringsWithAll("select distinct OldAddress from House x where ISNULL(OldAddress,'') <> '' order by OldAddress");
lst7 = BaseDataBase.GetAllStringsWithAll("select distinct impededType from (select impededType from Parent Union select impededType from FamilyPerson) x where ISNULL(impededType,'') <> '' order by impededType");
lst8 = BaseDataBase.GetAllStringsWithAll("select distinct RelationShip from (select 'أب' RelationShip Union select 'أم' Union (select RelationShip from FamilyPerson)) x where ISNULL(RelationShip,'') <> '' order by RelationShip");
});
cmboJob.ItemsSource = lst1;
cmboHealthStatus.ItemsSource = lst2;
cmboStudyStatus.ItemsSource = lst3;
cmboHouseSection.ItemsSource = lst4;
cmboHouseStreet.ItemsSource = lst5;
cmboOldAddress.ItemsSource = lst6;
cmboImpedeType.ItemsSource = lst7;
cmboRelationShip.ItemsSource = lst8;
}
public FamilyMainControl()
{
InitializeComponent();
bw.WorkerSupportsCancellation = true;
bw.RunWorkerCompleted += bw_RunWorkerCompleted;
bw.DoWork += bw_DoWork;
cmboSector.ItemsSource = BaseDataBase.GetAllStringsWithAll("select Name from Sector");
var ilst = Inventory.AllInventories;
ilst.Insert(0, new Inventory()
{
ID = 0, Name = "الكل"
});
cmboInventory.ItemsSource = ilst;
}
public async void GetData()
{
List <string> lst1 = null, lst2 = null, lst3 = null, lst4 = null;
await Task.Run(() =>
{
lst1 = House.GetHouseSectionsWithAll;
lst2 = House.GetHouseStreetsWithAll;
lst3 = House.GetOldAddressesWithAll;
lst4 = SystemData.GetFamilyTypes;
lst4.Insert(0, "الكل");
});
cmboHouseSection.ItemsSource = lst1;
cmboHouseStreet.ItemsSource = lst2;
cmboOldAddress.ItemsSource = lst3;
cmboSector.ItemsSource = BaseDataBase.GetAllStringsWithAll("Select Name from Sector");
cmboFamilyType.ItemsSource = lst4;
}
public async void GetData()
{
List <string> lst1 = null, lst2 = null, lst3 = null, lst4 = null, lst5 = null, lst6 = null, lst7 = null;
await Task.Run(() =>
{
lst1 = BaseDataBase.GetAllStringsWithAll("select distinct Name Presenter from [Order] inner join Users on LastUserID = Users.ID");
lst2 = BaseDataBase.GetAllStringsWithAll("select distinct [Source] from Item");
lst3 = BaseDataBase.GetAllStringsWithAll("select distinct [ItemType] from Item");
lst4 = BaseDataBase.GetAllStringsWithAll("select [Name] from Item");
lst5 = BaseDataBase.GetAllStringsWithAll("select Name from Sector");
lst4.Add("عائلة خاصة");
lst6 = BaseDataBase.GetAllStringsWithAll("select Name from Inventory");
lst7 = House.GetHouseSectionsWithAll;
});
cmboPresenter.ItemsSource = lst1;
cmboSource.ItemsSource = lst2;
cmboSupportType.ItemsSource = lst3;
cmboSupportName.ItemsSource = lst4;
cmboSector.ItemsSource = lst5;
cmboInventory.ItemsSource = lst6;
cmboHouseSection.ItemsSource = lst7;
}
