public void searchutesubmit_click(Object sender, EventArgs e)
{
StringBuilder sqlString = new StringBuilder("SELECT ACCOUNT.UID, (ISNULL(ACCOUNT.SURNAME,'')+' '+ISNULL(ACCOUNT.NAME,'')+' ('+ISNULL(OFFICES.OFFICE,'')+')') AS DESCRIZIONE ");
sqlString.AppendFormat("FROM ACCOUNT LEFT OUTER JOIN OFFICES ON ACCOUNT.OFFICEID=OFFICES.ID WHERE (ACCOUNT.NAME LIKE '%{0}%' ", SearchUser.Text);
sqlString.AppendFormat("OR ACCOUNT.SURNAME LIKE '%{0}%') ORDER BY SURNAME,NAME ASC", SearchUser.Text);
OfficeUsers.DataTextField = "descrizione";
OfficeUsers.DataValueField = "uid";
OfficeUsers.DataSource = DatabaseConnection.CreateDataset(sqlString.ToString());
OfficeUsers.DataBind();
SetAccount(GroupValue.Value);
}
public void Offices_SelectedIndexChanged(Object sender, EventArgs e)
{
if (((DropDownList)sender).SelectedIndex != 0)
{
OfficeUsers.DataTextField = "descrizione";
OfficeUsers.DataValueField = "uid";
string sqlString = "SELECT ACCOUNT.UID, (ACCOUNT.SURNAME+' '+ACCOUNT.NAME+' ('+OFFICES.OFFICE+')') AS DESCRIZIONE ";
sqlString += "FROM ACCOUNT INNER JOIN OFFICES ON ACCOUNT.OFFICEID=OFFICES.ID WHERE ACCOUNT.OFFICEID=" + int.Parse(Offices.SelectedItem.Value) + " ORDER BY SURNAME,NAME ASC";
OfficeUsers.DataSource = DatabaseConnection.CreateDataset(sqlString);
OfficeUsers.DataBind();
}
else
{
OfficeUsers.Items.Clear();
}
}
