private static List<ORM_TMS_PRO_Members_2_RightPackage> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List<ORM_TMS_PRO_Members_2_RightPackage> 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_TMS_PRO_Members_2_RightPackage>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "AssignmentID","ACC_RightsPackage_RefID","ProjectMember_RefID","Creation_Timestamp","IsDeleted","Tenant_RefID" });
while (reader.Read())
{
ORM_TMS_PRO_Members_2_RightPackage item = new ORM_TMS_PRO_Members_2_RightPackage();
//0:Parameter AssignmentID of type Guid
item.AssignmentID = reader.GetGuid(0);
//1:Parameter ACC_RightsPackage_RefID of type Guid
item.ACC_RightsPackage_RefID = reader.GetGuid(1);
//2:Parameter ProjectMember_RefID of type Guid
item.ProjectMember_RefID = reader.GetGuid(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 ex;
}
return items;
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2RP_SM2RP_1318 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var item = new CL1_TMS_PRO.ORM_TMS_PRO_Members_2_RightPackage();
if (Parameter.AssignmentID != Guid.Empty)
{
item = ORM_TMS_PRO_Members_2_RightPackage.Query.Search(Connection, Transaction, new ORM_TMS_PRO_Members_2_RightPackage.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
AssignmentID = Parameter.AssignmentID
}).SingleOrDefault();
}
if (Parameter.AssignmentID == Guid.Empty)
{
item.AssignmentID = Guid.NewGuid();
item.Tenant_RefID = securityTicket.TenantID;
}
if (Parameter.isDeleted == true)
{
item.IsDeleted = true;
}
if (Parameter.ProjectMemberID != Guid.Empty)
{
item.ProjectMember_RefID = Parameter.ProjectMemberID;
}
if (Parameter.RightsPackageID != Guid.Empty)
{
item.ACC_RightsPackage_RefID = Parameter.RightsPackageID;
}
return(new FR_Guid(item.Save(Connection, Transaction), item.AssignmentID));
#endregion UserCode
}
