public void FillCustomerComboBox()
{
DataTable dt = CustomerServiceBL.CustomerDetails.Ins.GetAllCustomerData();
DevExpress.Web.ASPxEditors.ListEditItem item = new DevExpress.Web.ASPxEditors.ListEditItem("Select All", 0);
CustomerComboBox.DataSource = dt;
CustomerComboBox.TextField = "Name";
CustomerComboBox.ValueField = "ID";
CustomerComboBox.DataBind();
CustomerComboBox.Items.Insert(0, item);
CustomerComboBox.SelectedIndex = 0;
//FillNotesGrid();
}
//end bind dll archive
protected void bind_combos()
{
//company if company is not -1 (WWI employee)
if (Session["user"] != null)
{
Int32 _companyid = (Int32)((UserClass)Page.Session["user"]).CompanyId;
Int32 _officeid = (Int32)((UserClass)Page.Session["user"]).OfficeId;
if (_companyid != -1) //bind contacts for this company
{
//contact names
Query _qry = new Query(Tables.ContactTable, "WWIprov").AddWhere("CompanyID", Comparison.Equals, _companyid).ORDER_BY("ContactName", "asc");
//180811 datareader much faster than loading to datatabble
//ContactTableCollection _contact = new ContactTableCollection();
//_contact.LoadAndCloseReader(_qry.ExecuteReader());
//DataTable _dt = (DataTable)_contact.ToDataTable();
IDataReader _rd = _qry.ExecuteReader();
//this.cboName.DataSource = _dt;
this.cboName.DataSource = _rd;
this.cboName.ValueField = "ContactID";
this.cboName.TextField = "ContactName";
this.cboName.DataBind();
}
else //bind users by office instead
{
//Query _qry = new Query(Tables.EmployeesTable, "WWIprov").AddWhere("OfficeID", Comparison.Equals, _officeid).ORDER_BY("Name", "asc");
//EmployeesTableCollection _employee = new EmployeesTableCollection();
//_employee.LoadAndCloseReader(_qry.ExecuteReader());
//DataTable _dt = (DataTable)_employee.ToDataTable();
//this.cboName.DataSource = _dt;
//this.cboName.ValueField = "EmployeeID";
//this.cboName.TextField = "Name";
//this.cboName.DataBind();
}
//does user have any custom reports?
//Int32 _userid = (Int32)((UserClass)Page.Session["user"]).UserId;
//Query _qr = new Query(Tables.DbQueryLog, "WWIprov").AddWhere("by_contactID", Comparison.Equals, _userid).AddWhere("qry_source", Comparison.Equals, "OTR").ORDER_BY("qry_id", "desc");
//DbQueryLogCollection _reports = new DbQueryLogCollection();
//_reports.LoadAndCloseReader(_qr.ExecuteReader());
//DataTable _dtb = (DataTable)_reports.ToDataTable();
//this.cboName.DataSource = _dtb;
//this.cboName.ValueField = "qry_text";
//this.cboName.TextField = "qry_desc";
//this.cboName.DataBind();
//11/03/2011 append ALL USERS option as 1st item in dropdown
//Code here to populate DropDownList
DevExpress.Web.ASPxEditors.ListEditItem _li = new DevExpress.Web.ASPxEditors.ListEditItem("(All users)", "-1");
this.cboName.Items.Insert(0, _li);
//default to all users
this.cboName.SelectedIndex = 0;
//250112 bind quick filter fields if user is logged in or not
this.ObjectDataSourceFields.SelectMethod = "FetchByActive";
this.ObjectDataSourceFields.DataBind();
}
else
{
//250112 bind quick filter fields if user is logged in or not
this.ObjectDataSourceFields.SelectMethod = "FetchByActiveAnonymous";
this.ObjectDataSourceFields.DataBind();
}
//291111 set a default option for the exporter
//don't need code just set Selected to true for the item you want
}