private void BindLists()
{
DListDocType.DataSource = DALC.GetDataTable("ID,Name,Series,CONCAT(Name,' (',Series,') ') as DocNumber", "DocumentTypes", "");
DListDocType.DataValueField = "ID";
DListDocType.DataTextField = "DocNumber";
DListDocType.DataBind();
DListDocType.Items.Insert(0, new ListItem("--", "-1"));
DListEyeColor.DataSource = DALC.GetDataTable("ID,Name", "Colors", "Order By [Priority] asc, Name asc");
DListEyeColor.DataBind();
DListEyeColor.Items.Insert(0, new ListItem("--", "-1"));
DListHairColor.DataSource = DListEyeColor.DataSource;
DListHairColor.DataBind();
DListHairColor.Items.Insert(0, new ListItem("--", "-1"));
DListCountries.DataSource = DALC.GetDataTable("ID,Name", "Countries", "");
DListCountries.DataBind();
DListCountries.Items.Insert(0, new ListItem("--", "-1"));
DListBirthRegistraionCountry.DataSource = DListCountries.DataSource;
DListBirthRegistraionCountry.DataBind();
DListBirthRegistraionCountry.Items.Insert(0, new ListItem("--", "-1"));
RListAdoptionPersonsStatus.DataSource = DALC.GetDataTable("ID,Name", "AdoptionPersonsStatus", "");
RListAdoptionPersonsStatus.DataBind();
RListAdoptionPersonsStatus.SelectedIndex = 0;
DListChildFirstRegistrationPlace.DataSource = DALC.GetDataTable("ID,Name", "AdoptionOrganizations", "Where AdoptionOrganizationsTypesID=20");
DListChildFirstRegistrationPlace.DataBind();
DListChildFirstRegistrationPlace.Items.Insert(0, new ListItem("- İcra Hakimiyyəti -", "-1"));
}
private void BindList()
{
DataTable DtContent = DALC.GetDataTable("*", "Contents", "Where ID=1");
LtrContentTitle.Text = DtContent._Rows("Title");
LtrContentText.Text = DtContent._Rows("ContentText");
DListOrganizations.DataSource = DALC.GetDataTable("ID,Name", "AdoptionOrganizations", "Where AdoptionOrganizationsTypesID=20");
DListOrganizations.DataBind();
DListOrganizations.Items.Insert(0, new ListItem("- İcra Hakimiyyəti -", "-1"));
DListEyeColor.DataSource = DALC.GetDataTable("ID,Name", "Colors", "");
DListEyeColor.DataBind();
DListEyeColor.Items.Insert(0, new ListItem("- Göz rəngi -", "-1"));
DListHairColor.DataSource = DALC.GetDataTable("ID,Name", "Colors", "");
DListHairColor.DataBind();
DListHairColor.Items.Insert(0, new ListItem("- Saç rəngi -", "-1"));
}
