protected static FR_L5BK_GBFBID_1447 Execute(DbConnection Connection, DbTransaction Transaction, P_L5BK_GBFBID_1447 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5BK_GBFBID_1447();
returnValue.Result = new L5BK_GBFBID_1447();
ORM_ACC_BNK_Banks.Query bankQuery = new ORM_ACC_BNK_Banks.Query();
bankQuery.ACC_BNK_BankID = Parameter.ACC_BNK_BankID;
bankQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_ACC_BNK_Banks> banks = ORM_ACC_BNK_Banks.Query.Search(Connection, Transaction, bankQuery);
if (banks.Count == 0)
{
return(null);
}
else
{
L5BK_GBFT_1318 bank = new L5BK_GBFT_1318();
bank.ACC_BNK_BankID = banks[0].ACC_BNK_BankID;
bank.BankName = banks[0].BankName;
bank.BankNumber = banks[0].BankNumber;
bank.BICCode = banks[0].BICCode;
bank.Country_RefID = banks[0].Country_RefID;
bank.RoutingNumber = banks[0].RoutingNumber;
returnValue.Result.Bank = bank;
}
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5BK_GBFT_1318_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
var returnStatus = new FR_L5BK_GBFT_1318_Array();
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
var commandLocation = "CL5_Plannico_Banks.Atomic.Retrieval.SQL.cls_Get_Banks_For_Tenant.sql";
command.CommandText = new System.IO.StreamReader(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(commandLocation)).ReadToEnd();
CSV2Core_MySQL.Support.DBSQLSupport.SetParameter(command, "ticket", securityTicket);
command.CommandTimeout = QueryTimeout;
List <L5BK_GBFT_1318> results = new List <L5BK_GBFT_1318>();
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(Connection, Transaction);
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
try
{
reader.SetOrdinals(new string[] { "ACC_BNK_BankID", "BankName", "Country_ISOCode_Alpha2", "BICCode", "RoutingNumber", "BankNumber", "BankLocationComment" });
while (reader.Read())
{
L5BK_GBFT_1318 resultItem = new L5BK_GBFT_1318();
//0:Parameter ACC_BNK_BankID of type Guid
resultItem.ACC_BNK_BankID = reader.GetGuid(0);
//1:Parameter BankName of type String
resultItem.BankName = reader.GetString(1);
//2:Parameter Country_ISOCode_Alpha2 of type String
resultItem.Country_ISOCode_Alpha2 = reader.GetString(2);
//3:Parameter BICCode of type String
resultItem.BICCode = reader.GetString(3);
//4:Parameter RoutingNumber of type String
resultItem.RoutingNumber = reader.GetString(4);
//5:Parameter BankNumber of type String
resultItem.BankNumber = reader.GetString(5);
//6:Parameter BankLocationComment of type String
resultItem.BankLocationComment = reader.GetString(6);
results.Add(resultItem);
}
}
catch (Exception ex)
{
reader.Close();
throw new Exception("Exception occured durng data retrieval in method cls_Get_Banks_For_Tenant", ex);
}
reader.Close();
//Load all the dictionaries from the datatables
loader.Load();
returnStatus.Result = results.ToArray();
return(returnStatus);
}
protected static FR_L5BK_GBFBID_1447 Execute(DbConnection Connection, DbTransaction Transaction, P_L5BK_GBFBID_1447 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5BK_GBFBID_1447();
returnValue.Result = new L5BK_GBFBID_1447();
ORM_ACC_BNK_Bank.Query bankQuery = new ORM_ACC_BNK_Bank.Query();
bankQuery.ACC_BNK_BankID = Parameter.ACC_BNK_BankID;
bankQuery.Tenant_RefID = securityTicket.TenantID;
bankQuery.IsDeleted = false;
List <ORM_ACC_BNK_Bank> banks = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery);
if (banks == null || banks.Count == 0)
{
returnValue.Result = null;
}
else
{
L5BK_GBFT_1318 bank = new L5BK_GBFT_1318();
bank.ACC_BNK_BankID = banks[0].ACC_BNK_BankID;
bank.BankName = banks[0].BankName;
bank.BankNumber = banks[0].BankNumber;
bank.BICCode = banks[0].BICCode;
bank.RoutingNumber = banks[0].RoutingNumber;
bank.BankLocationComment = banks[0].BankLocationComment;
returnValue.Result.Bank = bank;
ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query();
countryQuery.CMN_CountryID = banks[0].Country_RefID;
countryQuery.IsDeleted = false;
countryQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_Country> countries = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery);
if (countries.Count != 0)
{
bank.Country_ISOCode_Alpha2 = countries[0].Country_ISOCode_Alpha2;
}
}
//Put your code here
return(returnValue);
#endregion UserCode
}
