private void LoadLookups()
    {
        GOVERNORATE gov = new GOVERNORATE();
        gov.LoadAll();

        uiDropDownListGov.DataSource = gov.DefaultView;
        uiDropDownListGov.DataTextField = GOVERNORATE.ColumnNames.DESCR;
        uiDropDownListGov.DataValueField = GOVERNORATE.ColumnNames.CD;
        uiDropDownListGov.DataBind();
        uiDropDownListGov.Items.Insert(0, new ListItem("---"));
        uiDropDownListGov.SelectedIndex = 0;

        uiDropDownListMachineGov.DataSource = gov.DefaultView;
        uiDropDownListMachineGov.DataTextField = GOVERNORATE.ColumnNames.DESCR;
        uiDropDownListMachineGov.DataValueField = GOVERNORATE.ColumnNames.CD;
        uiDropDownListMachineGov.DataBind();
        uiDropDownListMachineGov.Items.Insert(0, new ListItem("---"));
        uiDropDownListMachineGov.SelectedIndex = 0;

        CIVIL_OFFICE pol = new CIVIL_OFFICE();
        pol.LoadAll();
        uiDropDownListCivil.DataSource = pol.DefaultView;
        uiDropDownListCivil.DataTextField = POLICE_STATION.ColumnNames.DESCR;
        uiDropDownListCivil.DataValueField = POLICE_STATION.ColumnNames.CD;
        uiDropDownListCivil.DataBind();
        uiDropDownListCivil.Items.Insert(0, new ListItem("---"));
        uiDropDownListCivil.SelectedIndex = 0;

        uiDropDownListMachineCivil.DataSource = pol.DefaultView;
        uiDropDownListMachineCivil.DataTextField = POLICE_STATION.ColumnNames.DESCR;
        uiDropDownListMachineCivil.DataValueField = POLICE_STATION.ColumnNames.CD;
        uiDropDownListMachineCivil.DataBind();
        uiDropDownListMachineCivil.Items.Insert(0, new ListItem("---"));
        uiDropDownListMachineCivil.SelectedIndex = 0;

        health_office obj = new health_office();
        obj.LoadAll();
        uiDropDownListHealthOffice.DataSource = obj.DefaultView;
        uiDropDownListHealthOffice.DataTextField = health_office.ColumnNames.HEALTHDESCR;
        uiDropDownListHealthOffice.DataValueField = health_office.ColumnNames.HEALTHCD;
        uiDropDownListHealthOffice.DataBind();
        uiDropDownListHealthOffice.Items.Insert(0, new ListItem("---"));
        uiDropDownListHealthOffice.SelectedIndex = 0;

        uiDropDownListMachineHealthOffice.DataSource = obj.DefaultView;
        uiDropDownListMachineHealthOffice.DataTextField = health_office.ColumnNames.HEALTHDESCR;
        uiDropDownListMachineHealthOffice.DataValueField = health_office.ColumnNames.HEALTHCD;
        uiDropDownListMachineHealthOffice.DataBind();
        uiDropDownListMachineHealthOffice.Items.Insert(0, new ListItem("---"));
        uiDropDownListMachineHealthOffice.SelectedIndex = 0;
    }
 private void loadAllCivil()
 {
     CIVIL_OFFICE civil = new CIVIL_OFFICE();
     civil.LoadAll();
     drpCivil.DataTextField = CIVIL_OFFICE.ColumnNames.DESCR;
     drpCivil.DataValueField = CIVIL_OFFICE.ColumnNames.CD;
     drpCivil.DataSource = civil.DefaultView;
     drpCivil.DataBind();
     drpCivil.Items.Insert(0, new ListItem("اختر ادارة", "-1"));
 }