public void BindContactTitle(DropDownList _ddlContactTitles) { ContactServiceClient contactService = null; try { contactService = new ContactServiceClient(); CollectionRequest collectionRequest = new CollectionRequest(); collectionRequest.StartRow = 0; TitleSearchCriteria titleCriteria = new TitleSearchCriteria(); TitleSearchReturnValue titleReturnValue = contactService.TitleSearch(_logonSettings.LogonId, collectionRequest, titleCriteria); if (titleReturnValue.Title != null) { _ddlContactTitles.DataSource = titleReturnValue.Title.Rows; _ddlContactTitles.DataTextField = "TitleId"; _ddlContactTitles.DataValueField = "TitleId"; _ddlContactTitles.DataBind(); } AddDefaultToDropDownList(_ddlContactTitles); } catch (Exception ex) { throw ex; } finally { if (contactService != null) { if (contactService.State != System.ServiceModel.CommunicationState.Faulted) contactService.Close(); } } }
private void buildSearchCriteria() { if (_searchCriteria == null) { _searchCriteria = new TitleSearchCriteria(); } if (_refreshSearch) { _searchCriteria = new TitleSearchCriteria(); _searchCriteria.Title = getNullableString(titleTextBox.Text.Trim()); _searchCriteria.MARCBibID = getNullableString(bibidTextBox.Text.Trim()); int id; _searchCriteria.TitleID = null; if (titleidTextBox.Text.Trim().Length > 0) { bool idExists = int.TryParse(titleidTextBox.Text.Trim(), out id); if (idExists) { _searchCriteria.TitleID = id; } } } _searchCriteria.OrderBy = _orderBy; _searchCriteria.SortOrder = _sortOrder; _searchCriteria.PageSize = Math.Abs(pagingUserControl.StartIndex - pagingUserControl.EndIndex) + 1; _searchCriteria.StartRow = pagingUserControl.StartIndex; }
/// <summary> /// Binds title dropdownlist control /// </summary> private void BindTitleDropDown() { ContactServiceClient contactService = null; try { contactService = new ContactServiceClient(); CollectionRequest collectionRequest = new CollectionRequest(); collectionRequest.StartRow = 0; TitleSearchCriteria titleCriteria = new TitleSearchCriteria(); TitleSearchReturnValue titleReturnValue = contactService.TitleSearch(_logonSettings.LogonId, collectionRequest, titleCriteria); if (titleReturnValue.Title != null) { _ddlTitle.DataSource = titleReturnValue.Title.Rows; _ddlTitle.DataTextField = "TitleId"; _ddlTitle.DataValueField = "TitleId"; _ddlTitle.DataBind(); } // Adds "Select" at zero index of dropdownlist control. AddDefaultToDropDownList(_ddlTitle); } catch (Exception ex) { throw ex; } finally { if (contactService.State != System.ServiceModel.CommunicationState.Faulted) { contactService.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { HtmlLink cssLnk = new HtmlLink(); cssLnk.Attributes.Add("rel", "stylesheet"); cssLnk.Attributes.Add("type", "text/css"); cssLnk.Href = "http://jqueryui.com/latest/themes/base/ui.all.css"; Page.Header.Controls.Add(cssLnk); ControlGenerator.AddScriptControl(Page.Master.Page.Header.Controls, "http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"); ControlGenerator.AddScriptControl(Page.Master.Page.Header.Controls, "http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.1/jquery-ui.js"); if (IsPostBack) { if (ViewState["SearchCriteria"] != null) { _searchCriteria = (TitleSearchCriteria)ViewState["SearchCriteria"]; _isExactSearch = (bool)ViewState["IsExactSearch"]; _orderBy = (TitleSearchOrderBy)ViewState["OrderBy"]; _sortOrder = (SortOrder)ViewState["SortOrder"]; } pagingUserControl.Visible = true; } else { pagingUserControl.Visible = false; BHLProvider bp = new BHLProvider(); CustomGenericList <Institution> institutions = bp.InstituationSelectAll(); listInstitutions.DataSource = institutions; listInstitutions.DataBind(); } String redirect = Request.QueryString["redir"] as String; if (redirect != null) { if (redirect.ToLower() == "p") { litHeader.Text = "Pagination"; liImport.Visible = false; divImport.Visible = false; HyperLinkField linkField = (HyperLinkField)gvwResults.Columns[2]; linkField.NavigateUrl = "/Admin/Paginator.aspx"; linkField.DataNavigateUrlFormatString = "/Admin/Paginator.aspx?TitleID={0}"; _redirectUrl = "/Admin/Paginator.aspx?TitleID="; } } errorControl.Visible = false; Page.SetFocus(titleTextBox); Page.Title = "BHL Admin - Title Search"; }
/// <summary> /// Get a list of titles that match the search criteria /// </summary> /// <param name="oHostSecurityToken">HostSecurityToken obtained when security provider of IWS is called</param> /// <param name="collectionRequest">Information about the collection being requested.</param> /// <param name="criteria">Title search criteria</param> /// <returns></returns> public TitleSearchReturnValue TitleSearch(HostSecurityToken oHostSecurityToken, CollectionRequest collectionRequest, TitleSearchCriteria criteria) { TitleSearchReturnValue returnValue = null; if (Functions.ValidateIWSToken(oHostSecurityToken)) { oContactService = new ContactService(); returnValue = oContactService.TitleSearch(Functions.GetLogonIdFromToken(oHostSecurityToken), collectionRequest, criteria); } else { returnValue = new TitleSearchReturnValue(); returnValue.Success = false; returnValue.Message = "Invalid Token"; } return(returnValue); }
public static int TitleSearchCount(SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleSearchCriteria tsc) { SqlConnection connection = CustomSqlHelper.CreateConnection( CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleSearchCount", connection, transaction, CustomSqlHelper.CreateInputParameter("TitleID", SqlDbType.Int, null, true, tsc.TitleID), CustomSqlHelper.CreateInputParameter("MARCBibID", SqlDbType.NVarChar, 50, true, tsc.MARCBibID), CustomSqlHelper.CreateInputParameter("Title", SqlDbType.NVarChar, 255, true, tsc.Title))) { using (CustomSqlHelper <int> helper = new CustomSqlHelper <int>()) { CustomGenericList <int> k = helper.ExecuteReader(command); return(k[0]); } } }
public static CustomGenericList <Title> TitleSearch(SqlConnection sqlConnection, SqlTransaction sqlTransaction, TitleSearchCriteria tsc) { SqlConnection connection = CustomSqlHelper.CreateConnection( CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection); SqlTransaction transaction = sqlTransaction; using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleSearchPaging", connection, transaction, CustomSqlHelper.CreateInputParameter("TitleID", SqlDbType.Int, null, true, tsc.TitleID), CustomSqlHelper.CreateInputParameter("MARCBibID", SqlDbType.NVarChar, 50, true, tsc.MARCBibID), CustomSqlHelper.CreateInputParameter("Title", SqlDbType.NVarChar, 255, true, tsc.Title), CustomSqlHelper.CreateInputParameter("StartRow", SqlDbType.BigInt, null, false, tsc.StartRow), CustomSqlHelper.CreateInputParameter("PageSize", SqlDbType.Int, null, false, tsc.PageSize), CustomSqlHelper.CreateInputParameter("OrderBy", SqlDbType.Int, null, false, (int)tsc.OrderBy * (tsc.SortOrder == SortOrder.Ascending ? 1 : -1)))) { using (CustomSqlHelper <Title> helper = new CustomSqlHelper <Title>()) { return(helper.ExecuteReader(command)); } } }
/// <summary> /// Gets the title values for the drop down list.. /// </summary> private void GetTitles() { ContactServiceClient contactService = null; try { contactService = new ContactServiceClient(); CollectionRequest collectionRequest = new CollectionRequest(); TitleSearchCriteria searchCriteria = new TitleSearchCriteria(); TitleSearchReturnValue returnValue = contactService.TitleSearch(_logonId, collectionRequest, searchCriteria); if (returnValue.Success) { _ddlTitle.DataSource = returnValue.Title.Rows; _ddlTitle.DataTextField = "TitleId"; _ddlTitle.DataValueField = "TitleId"; _ddlTitle.DataBind(); } else { throw new Exception(returnValue.Message); } } catch (Exception ex) { throw ex; } finally { if (contactService != null) { if (contactService.State != System.ServiceModel.CommunicationState.Faulted) { contactService.Close(); } } } }
private string TitleSearch(int titleId, String title) { try { TitleSearchCriteria criteria = new TitleSearchCriteria(); if (titleId != 0) { criteria.TitleID = titleId; } criteria.Title = title + '%'; criteria.StartRow = 1; criteria.PageSize = 10000; criteria.OrderBy = TitleSearchOrderBy.Title; criteria.SortOrder = SortOrder.Ascending; CustomGenericList <Title> titles = new BHLProvider().TitleSearchPaging(criteria); JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(titles)); } catch { return(null); } }
/// <summary> /// Gets the title values for the drop down list.. /// </summary> private void GetTitles() { ContactServiceClient contactService = null; try { contactService = new ContactServiceClient(); CollectionRequest collectionRequest = new CollectionRequest(); TitleSearchCriteria searchCriteria = new TitleSearchCriteria(); TitleSearchReturnValue returnValue = contactService.TitleSearch(_logonId, collectionRequest, searchCriteria); if (returnValue.Success) { _ddlTitle.DataSource = returnValue.Title.Rows; _ddlTitle.DataTextField = "TitleId"; _ddlTitle.DataValueField = "TitleId"; _ddlTitle.DataBind(); } else { throw new Exception(returnValue.Message); } } catch (Exception ex) { throw ex; } finally { if (contactService != null) { if (contactService.State != System.ServiceModel.CommunicationState.Faulted) contactService.Close(); } } }
/// <summary> /// Get a list of titles that match the search criteria /// </summary> /// <param name="logonId">Logon id obtained when logging on to the logon service.</param> /// <param name="collectionRequest">Information about the collection being requested.</param> /// <param name="criteria">Title search criteria</param> /// <returns></returns> public TitleSearchReturnValue TitleSearch(Guid logonId, CollectionRequest collectionRequest, TitleSearchCriteria criteria) { TitleSearchReturnValue returnValue = new TitleSearchReturnValue(); try { // Get the logged on user from the current logons and add their // ApplicationSettings the list of concurrent sessions. Host.LoadLoggedOnUser(logonId); try { Functions.RestrictRekoopIntegrationUser(UserInformation.Instance.DbUid); switch (UserInformation.Instance.UserType) { case DataConstants.UserType.Staff: case DataConstants.UserType.Client: case DataConstants.UserType.ThirdParty: // Can do everything break; default: throw new Exception("Access denied"); } // Create a data list creator for a list of titles DataListCreator<TitleSearchItem> dataListCreator = new DataListCreator<TitleSearchItem>(); // Declare an inline event (annonymous delegate) to read the dataset dataListCreator.ReadDataSet += delegate(object Sender, ReadDataSetEventArgs e) { e.DataSet = SrvTitleLookup.GetTitles(criteria.IncludeArchived); DataTable dt = Functions.SortDataTable(e.DataSet.Tables[0], "Title"); e.DataSet.Tables.Remove(e.DataSet.Tables[0]); e.DataSet.Tables.Add(dt); }; // Create the data list returnValue.Title = dataListCreator.Create(logonId, // Give the query a name so it can be cached "TitleSearch", // Tell it the query criteria used so if the cache is accessed // again it knows if it is the same query criteria.ToString(), collectionRequest, // Import mappings to map the dataset row fields to the data // list entity properties new ImportMapping[] { new ImportMapping("TitleId", "Title") } ); } finally { // Remove the logged on user's ApplicationSettings from the // list of concurrent sessions Host.UnloadLoggedOnUser(); } } catch (System.Data.SqlClient.SqlException) { returnValue.Success = false; returnValue.Message = Functions.SQLErrorMessage; } catch (Exception Ex) { returnValue.Success = false; returnValue.Message = Ex.Message; } return returnValue; }
/// <summary> /// Binds title dropdownlist control /// </summary> private void BindTitleDropDown() { ContactServiceClient contactService = null; try { contactService = new ContactServiceClient(); CollectionRequest collectionRequest = new CollectionRequest(); collectionRequest.StartRow = 0; TitleSearchCriteria titleCriteria = new TitleSearchCriteria(); TitleSearchReturnValue titleReturnValue = contactService.TitleSearch(_logonSettings.LogonId, collectionRequest, titleCriteria); if (titleReturnValue.Title != null) { _ddlTitle.DataSource = titleReturnValue.Title.Rows; _ddlTitle.DataTextField = "TitleId"; _ddlTitle.DataValueField = "TitleId"; _ddlTitle.DataBind(); } // Adds "Select" at zero index of dropdownlist control. AddDefaultToDropDownList(_ddlTitle); } catch (Exception ex) { throw ex; } finally { if (contactService.State != System.ServiceModel.CommunicationState.Faulted) contactService.Close(); } }
/// <summary> /// Get a list of titles that match the search criteria /// </summary> /// <param name="oHostSecurityToken">HostSecurityToken obtained when security provider of IWS is called</param> /// <param name="collectionRequest">Information about the collection being requested.</param> /// <param name="criteria">Title search criteria</param> /// <returns></returns> public TitleSearchReturnValue TitleSearch(HostSecurityToken oHostSecurityToken, CollectionRequest collectionRequest, TitleSearchCriteria criteria) { TitleSearchReturnValue returnValue = null; if (Functions.ValidateIWSToken(oHostSecurityToken)) { oContactService = new ContactService(); returnValue = oContactService.TitleSearch(Functions.GetLogonIdFromToken(oHostSecurityToken), collectionRequest, criteria); } else { returnValue = new TitleSearchReturnValue(); returnValue.Success = false; returnValue.Message = "Invalid Token"; } return returnValue; }
public int TitleSearchCount(TitleSearchCriteria criteria) { return(TitleDAL.TitleSearchCount(null, null, criteria)); }
public CustomGenericList <Title> TitleSearchPaging(TitleSearchCriteria criteria) { return(TitleDAL.TitleSearch(null, null, criteria)); }