private void SetDataSource() { CreateLetterSearch(); bool isUnauthorized = false; if (_searchFilter == Localization.GetString("All")) { _searchFilter = ""; } else if (_searchFilter == Localization.GetString("Unauthorized")) { _searchFilter = ""; isUnauthorized = true; } //Get the list of vendors from the database var totalRecords = 0; var vendorController = new VendorController(); int portal = Globals.IsHostTab(PortalSettings.ActiveTab.TabID) ? Null.NullInteger : PortalId; if (String.IsNullOrEmpty(_searchFilter)) { grdVendors.DataSource = vendorController.GetVendors(portal, isUnauthorized, grdVendors.CurrentPageIndex, grdVendors.PageSize, ref totalRecords); grdVendors.VirtualItemCount = totalRecords; } else { if (_searchField == "email") { grdVendors.DataSource = vendorController.GetVendorsByEmail(_searchFilter, portal, grdVendors.CurrentPageIndex, grdVendors.PageSize, ref totalRecords); grdVendors.VirtualItemCount = totalRecords; } else { grdVendors.DataSource = vendorController.GetVendorsByName(_searchFilter, portal, grdVendors.CurrentPageIndex, grdVendors.PageSize, ref totalRecords); grdVendors.VirtualItemCount = totalRecords; } } }
private void BindData( string SearchText, string SearchField ) { CreateLetterSearch(); //Localize the Headers Localization.LocalizeDataGrid( ref grdVendors, this.LocalResourceFile ); if( SearchText == Localization.GetString( "All" ) ) { strFilter = ""; } else if( SearchText == Localization.GetString( "Unauthorized" ) ) { strFilter = ""; } else { strFilter = SearchText; } // Get the list of vendors from the database int PageSize = Convert.ToInt32( ddlRecordsPerPage.SelectedItem.Value ); int TotalRecords = 0; VendorController objVendors = new VendorController(); int Portal; if( PortalSettings.ActiveTab.ParentId == PortalSettings.SuperTabId ) { Portal = Null.NullInteger; } else { Portal = PortalId; } if( strFilter == "" ) { if( SearchText == Localization.GetString( "Unauthorized" ) ) { grdVendors.DataSource = objVendors.GetVendors( Portal, true, CurrentPage - 1, PageSize, ref TotalRecords ); } else { grdVendors.DataSource = objVendors.GetVendors( Portal, false, CurrentPage - 1, PageSize, ref TotalRecords ); } } else { if( SearchField == "email" ) { grdVendors.DataSource = objVendors.GetVendorsByEmail( strFilter, Portal, CurrentPage - 1, PageSize, ref TotalRecords ); } else { grdVendors.DataSource = objVendors.GetVendorsByName( strFilter, Portal, CurrentPage - 1, PageSize, ref TotalRecords ); } } grdVendors.DataBind(); ctlPagingControl.TotalRecords = TotalRecords; ctlPagingControl.PageSize = PageSize; ctlPagingControl.CurrentPage = CurrentPage; string strQuerystring = String.Empty; if( ddlRecordsPerPage.SelectedIndex != 0 ) { strQuerystring = "PageRecords=" + ddlRecordsPerPage.SelectedValue; } if( !String.IsNullOrEmpty(strFilter) ) { strQuerystring += "&filter=" + strFilter; } ctlPagingControl.QuerystringParams = strQuerystring; ctlPagingControl.TabID = TabId; }