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));
}
