protected void ddlPropertyID_SelectedIndexChanged(object sender, EventArgs e) { string searchString = "Where 1=1 " + (ddlStatus.SelectedValue == "All" ? "" : "and AL_Resident.ExtraField10='" + ddlStatus.SelectedValue + "'"); if (ddlPropertyID.SelectedIndex != 0) { searchString += " And AL_Resident.ExtraField1 = " + ddlPropertyID.SelectedValue; } searchString += " order by AL_Property.PropertyID, AL_Resident.Name"; List <Resident> searchResult = new List <Resident>(); searchResult = ResidentManager.SearchResidents(searchString); lblCount.Text = " (" + searchResult.Count.ToString() + ") "; LinkPermissionChecking(searchResult); gvResident.DataSource = searchResult; gvResident.DataBind(); LoadGridColor(); }
private void showResidentGrid() { string searchString = "Where " + (ddlStatus.SelectedValue == "All" ? "" : "AL_Resident.ExtraField10='" + ddlStatus.SelectedValue + "' and") + " AL_Resident.ExtraField1 in ('0" + (getLogin().ExtraField3 == "" ? "" : "','" + getLogin().ExtraField3.Replace(",", "','")) + "')"; if (Request.QueryString["SearchKey"] != null && hfHasSearchDone.Value == "0") { hfHasSearchDone.Value = "1"; searchString += " and AL_Resident.Address like '%" + Request.QueryString["SearchKey"] + "%' or AL_Resident.Name like '%" + Request.QueryString["SearchKey"] + "%' "; } searchString += " order by AL_Property.PropertyID, AL_Resident.Name"; List <Resident> searchResult = new List <Resident>(); searchResult = ResidentManager.SearchResidents(searchString); lblCount.Text = " (" + searchResult.Count.ToString() + ") "; LinkPermissionChecking(searchResult); gvResident.DataSource = searchResult; gvResident.DataBind(); LoadGridColor(); }