protected static FR_L5TS_GWCSTFWCID_1152 Execute(DbConnection Connection, DbTransaction Transaction, P_L5TS_GWCSTFWCID_1152 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5TS_GWCSTFWCID_1152();
//Put your code here
ORM_CMN_BPT_EMP_WorkingContract_SalaryType.Query salaryTypeQuery = new ORM_CMN_BPT_EMP_WorkingContract_SalaryType.Query();
salaryTypeQuery.CMN_BPT_EMP_WorkingContract_RefID = Parameter.CMN_BPT_EMP_WorkingContract_RefID;
salaryTypeQuery.Tenant_RefID = securityTicket.TenantID;
salaryTypeQuery.IsDeleted = false;
var salaryTypes = ORM_CMN_BPT_EMP_WorkingContract_SalaryType.Query.Search(Connection, Transaction, salaryTypeQuery);
List <L5TS_GWCSTFT_1148> resultList = new List <L5TS_GWCSTFT_1148>();
foreach (var salaryType in salaryTypes)
{
L5TS_GWCSTFT_1148 resultItem = new L5TS_GWCSTFT_1148();
resultItem.CMN_BPT_EMP_SalaryTypeID = salaryType.CMN_BPT_EMP_SalaryTypeID;
resultItem.Amount = salaryType.Amount;
resultItem.CMN_BPT_EMP_WorkingContract_RefID = salaryType.CMN_BPT_EMP_WorkingContract_RefID;
resultItem.CMN_BPT_EMP_WorkingContract_SalaryTypeID = salaryType.CMN_BPT_EMP_WorkingContract_SalaryTypeID;
resultList.Add(resultItem);
}
returnValue.Result = new L5TS_GWCSTFWCID_1152();
returnValue.Result.WorkingContractSalaryTypes = resultList.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_L5TS_GWCSTFT_1148_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
var returnStatus = new FR_L5TS_GWCSTFT_1148_Array();
DbCommand command = Connection.CreateCommand();
command.Connection = Connection;
command.Transaction = Transaction;
var commandLocation = "CL5_Plannico_TypesOfSalary.Atomic.Retrieval.SQL.cls_Get_WorkingContract_SalaryTypes_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 <L5TS_GWCSTFT_1148> results = new List <L5TS_GWCSTFT_1148>();
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[] { "CMN_BPT_EMP_WorkingContract_SalaryTypeID", "CMN_BPT_EMP_WorkingContract_RefID", "CMN_BPT_EMP_SalaryTypeID", "Amount" });
while (reader.Read())
{
L5TS_GWCSTFT_1148 resultItem = new L5TS_GWCSTFT_1148();
//0:Parameter CMN_BPT_EMP_WorkingContract_SalaryTypeID of type Guid
resultItem.CMN_BPT_EMP_WorkingContract_SalaryTypeID = reader.GetGuid(0);
//1:Parameter CMN_BPT_EMP_WorkingContract_RefID of type Guid
resultItem.CMN_BPT_EMP_WorkingContract_RefID = reader.GetGuid(1);
//2:Parameter CMN_BPT_EMP_SalaryTypeID of type Guid
resultItem.CMN_BPT_EMP_SalaryTypeID = reader.GetGuid(2);
//3:Parameter Amount of type String
resultItem.Amount = reader.GetDecimal(3);
results.Add(resultItem);
}
}
catch (Exception ex)
{
reader.Close();
throw ex;
}
reader.Close();
//Load all the dictionaries from the datatables
loader.Load();
returnStatus.Result = results.ToArray();
return(returnStatus);
}
