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