private void FillDropdownLists()
{
using (Entities1 db = new Entities1())
{
drplvl1.DataSource = db.usp_CatogeriesSelect(null).ToList();
drplvl1.ValueField = "ID";
drplvl1.TextField = "Name";
//drplvl1.append = true;
//--------------------
drptower.DataSource = db.usp_TowersSelect(null).ToList();
drptower.TextField = "Name";
drptower.ValueField = "ID";
//----------------------
drpissue.DataSource = db.usp_CommonIssuesSelect(null);
drpissue.TextField = "Name";
drpissue.ValueField = "ID";
ASPxListBox listBox = drpotheap.FindControl("listBox") as ASPxListBox;
listBox.DataSource = db.usp_ApartmentsSelectByTower(1);
listBox.TextField = "Name";
listBox.ValueField = "APID";
// listBox.Items.("select All",-1);
DataBind();
}
}
private void FillApartments(int Id)
{
using (Entities1 db = new Entities1())
{
drpapartmentnumber.DataSource = db.usp_ApartmentsSelectByTower(Id).ToList();
drpapartmentnumber.ValueField = "ID";
drpapartmentnumber.TextField = "Name";
DataBind();
}
}
private void FillApartments(string name, string tower)
{
using (Entities1 db = new Entities1())
{
Tower tw = db.Towers.Where(x => x.Name == tower).FirstOrDefault();
Apartment ap = db.Apartments.Where(x => x.Name == name && x.TowerID == tw.ID).FirstOrDefault();
drpapartmentnumber.DataSource = db.usp_ApartmentsSelectByTower(tw.ID).ToList();
drpapartmentnumber.ValueField = "ID";
drpapartmentnumber.TextField = "Name";
DataBind();
}
}
private void FillDropdownLists()
{
using (Entities1 db = new Entities1())
{
drplvl1.DataSource = db.usp_CatogeriesSelect(null).ToList();
drplvl1.ValueField = "ID";
drplvl1.TextField = "Name";
drptower.DataSource = db.usp_TowersSelect(null).ToList();
drptower.TextField = "Name";
drptower.ValueField = "ID";
drptechniction.DataSource = db.usp_techniciansSelect(null).ToList();
drptechniction.TextField = "Name";
drptechniction.ValueField = "ID";
ASPxListBox listBox = drpotheap.FindControl("listBox") as ASPxListBox;
listBox.DataSource = db.usp_ApartmentsSelectByTower(1);
listBox.TextField = "Name";
listBox.ValueField = "APID";
DataBind();
}
}
