/// <summary>
/// Gets list of client banks
/// </summary>
/// <param name="bankType">Bank type should be of client type</param>
/// <returns>Returns banks of client type on page load.</returns>
private BankSearchItem[] GetBanks(DataConstants.BankSearchTypes bankType)
{
BankServiceClient bankService = null;
BankSearchItem[] banks = null;
try
{
CollectionRequest collectionRequest = new CollectionRequest();
BankSearchCriteria criteria = new BankSearchCriteria();
criteria.IncludeArchived = false;
criteria.BankSearchTypes = (int)bankType;
bankService = new BankServiceClient();
BankSearchReturnValue returnValue = bankService.BankSearch(_logonSettings.LogonId,
collectionRequest, criteria);
if (returnValue.Success)
{
banks = returnValue.Banks.Rows;
}
else
{
throw new Exception(returnValue.Message);
}
return(banks);
}
catch (System.ServiceModel.EndpointNotFoundException)
{
_lblMessage.Text = DataConstants.WSEndPointErrorMessage;
_lblMessage.CssClass = "errorMessage";
return(banks);
}
catch (Exception ex)
{
_lblMessage.CssClass = "errorMessage";
_lblMessage.Text = ex.Message;
return(banks);
}
finally
{
if (bankService != null)
{
if (bankService.State != System.ServiceModel.CommunicationState.Faulted)
{
bankService.Close();
}
}
}
}
public BankSearchReturnValue BankSearch(HostSecurityToken oHostSecurityToken, CollectionRequest collectionRequest,
BankSearchCriteria criteria)
{
BankSearchReturnValue returnValue = null;
if (Functions.ValidateIWSToken(oHostSecurityToken))
{
oBankService = new BankService();
returnValue = oBankService.BankSearch(Functions.GetLogonIdFromToken(oHostSecurityToken), collectionRequest, criteria);
}
else
{
returnValue = new BankSearchReturnValue();
returnValue.Success = false;
returnValue.Message = "Invalid Token";
}
return(returnValue);
}
/// <summary>
/// Gets list of client banks
/// </summary>
/// <param name="bankType">Bank type should be of client type</param>
/// <returns>Returns banks of client type on page load.</returns>
private BankSearchItem[] GetBanks(DataConstants.BankSearchTypes bankType)
{
BankServiceClient bankService = null;
BankSearchItem[] banks = null;
try
{
CollectionRequest collectionRequest = new CollectionRequest();
BankSearchCriteria criteria = new BankSearchCriteria();
criteria.IncludeArchived = false;
criteria.BankSearchTypes = (int)bankType;
bankService = new BankServiceClient();
BankSearchReturnValue returnValue = bankService.BankSearch(_logonSettings.LogonId,
collectionRequest, criteria);
if (returnValue.Success)
{
banks = returnValue.Banks.Rows;
}
else
{
throw new Exception(returnValue.Message);
}
return banks;
}
catch (System.ServiceModel.EndpointNotFoundException)
{
_lblMessage.Text = DataConstants.WSEndPointErrorMessage;
_lblMessage.CssClass = "errorMessage";
return banks;
}
catch (Exception ex)
{
_lblMessage.CssClass = "errorMessage";
_lblMessage.Text = ex.Message;
return banks;
}
finally
{
if (bankService != null)
{
if (bankService.State != System.ServiceModel.CommunicationState.Faulted)
bankService.Close();
}
}
}
public BankSearchReturnValue BankSearch(Guid logonId, CollectionRequest collectionRequest,
BankSearchCriteria criteria)
{
BankSearchReturnValue returnValue = new BankSearchReturnValue();
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 banks
DataListCreator<BankSearchItem> dataListCreator = new DataListCreator<BankSearchItem>();
// Declare an inline event (annonymous delegate) to read the
// dataset if it is required
dataListCreator.ReadDataSet += delegate(object Sender, ReadDataSetEventArgs e)
{
// TODO: Does not use the crtieria: BankTypeId, Description
e.DataSet = SrvBankLookup.GetBanks(criteria.IncludeArchived, (DataConstants.BankSearchTypes)criteria.BankSearchTypes);
DataTable dt = Functions.SortDataTable(e.DataSet.Tables[0], "bankName");
e.DataSet.Tables.Remove(e.DataSet.Tables[0]);
e.DataSet.Tables.Add(dt);
foreach (DataRow r in e.DataSet.Tables[0].Rows)
{
r["bankName"] = r["bankRef"] + " - " + r["bankName"];
}
};
// Create the data list
returnValue.Banks = dataListCreator.Create(logonId,
// Give the query a name so it can be cached
"BankSearch",
// 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("BankId", "bankID"),
new ImportMapping("BankTypeId", "bankTypeID"),
new ImportMapping("Description", "bankName"),
}
);
}
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;
}
public BankSearchReturnValue BankSearch(Guid logonId, CollectionRequest collectionRequest,
BankSearchCriteria criteria)
{
BankSearchReturnValue returnValue = new BankSearchReturnValue();
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 banks
DataListCreator <BankSearchItem> dataListCreator = new DataListCreator <BankSearchItem>();
// Declare an inline event (annonymous delegate) to read the
// dataset if it is required
dataListCreator.ReadDataSet += delegate(object Sender, ReadDataSetEventArgs e)
{
// TODO: Does not use the crtieria: BankTypeId, Description
e.DataSet = SrvBankLookup.GetBanks(criteria.IncludeArchived, (DataConstants.BankSearchTypes)criteria.BankSearchTypes);
DataTable dt = Functions.SortDataTable(e.DataSet.Tables[0], "bankName");
e.DataSet.Tables.Remove(e.DataSet.Tables[0]);
e.DataSet.Tables.Add(dt);
foreach (DataRow r in e.DataSet.Tables[0].Rows)
{
r["bankName"] = r["bankRef"] + " - " + r["bankName"];
}
};
// Create the data list
returnValue.Banks = dataListCreator.Create(logonId,
// Give the query a name so it can be cached
"BankSearch",
// 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("BankId", "bankID"),
new ImportMapping("BankTypeId", "bankTypeID"),
new ImportMapping("Description", "bankName"),
}
);
}
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);
}
