private static List <ORM_ACC_PAY_Condition> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_ACC_PAY_Condition> items;
try
{
managedConnection.set(connectionString, connection, transaction);
var loader = new CSV2Core_MySQL.Dictionaries.MultiTable.Loader.DictionaryLoader(managedConnection.getConnection(), managedConnection.getTransaction());
DbCommand command = managedConnection.manage(query.CreateSelectQuery(TableName));
query.SetParameters(command);
items = new List <ORM_ACC_PAY_Condition>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "ACC_PAY_ConditionID", "PaymentCondition_Name_DictID", "MaximumPaymentTreshold_InDays", "Creation_Timestamp", "IsDeleted", "Tenant_RefID" });
while (reader.Read())
{
ORM_ACC_PAY_Condition item = new ORM_ACC_PAY_Condition();
//0:Parameter ACC_PAY_ConditionID of type Guid
item.ACC_PAY_ConditionID = reader.GetGuid(0);
//1:Parameter PaymentCondition_Name of type Dict
item.PaymentCondition_Name = reader.GetDictionary(1);
loader.Append(item.PaymentCondition_Name, TableName);
//2:Parameter MaximumPaymentTreshold_InDays of type int
item.MaximumPaymentTreshold_InDays = reader.GetInteger(2);
//3:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(3);
//4:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(4);
//5:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(5);
item.Status_IsAlreadySaved = true;
item.Status_IsDirty = false;
items.Add(item);
}
reader.Close();
loader.Load();
managedConnection.commit();
}
catch (Exception ex)
{
managedConnection.rollback();
throw;
}
return(items);
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2AP_SPD_1628 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new CL1_ACC_PAY.ORM_ACC_PAY_Condition();
if (Parameter.ACC_PAY_ConditionID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.ACC_PAY_ConditionID);
if (result.Status != FR_Status.Success || item.ACC_PAY_ConditionID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDelete == true)
{
if (Parameter.ACC_PAY_ConditionID != Guid.Empty)
{
var detailsQuery = new ORM_ACC_PAY_Condition_Detail.Query();
detailsQuery.IsDeleted = false;
detailsQuery.Conditions_RefID = Parameter.ACC_PAY_ConditionID;
ORM_ACC_PAY_Condition_Detail.Query.SoftDelete(Connection, Transaction, detailsQuery);
}
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_PAY_ConditionID));
}
if (Parameter.ACC_PAY_ConditionID == Guid.Empty)
{
item.ACC_PAY_ConditionID = Guid.NewGuid();
item.Tenant_RefID = securityTicket.TenantID;
}
item.PaymentCondition_Name = Parameter.PaymentCondition_Name;
item.MaximumPaymentTreshold_InDays = Parameter.MaximumPaymentTreshold_InDays;
return(new FR_Guid(item.Save(Connection, Transaction), item.ACC_PAY_ConditionID));
#endregion UserCode
}
