private static List <ORM_TMS_PRO_ProjectMember> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_TMS_PRO_ProjectMember> 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_ProjectMember>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "TMS_PRO_ProjectMemberID", "Project_RefID", "USR_Account_RefID", "ProjectMember_Type_RefID", "IsOwner", "Creation_Timestamp", "IsDeleted", "Tenant_RefID", "ChargingLevel_RefID" });
while (reader.Read())
{
ORM_TMS_PRO_ProjectMember item = new ORM_TMS_PRO_ProjectMember();
//0:Parameter TMS_PRO_ProjectMemberID of type Guid
item.TMS_PRO_ProjectMemberID = reader.GetGuid(0);
//1:Parameter Project_RefID of type Guid
item.Project_RefID = reader.GetGuid(1);
//2:Parameter USR_Account_RefID of type Guid
item.USR_Account_RefID = reader.GetGuid(2);
//3:Parameter ProjectMember_Type_RefID of type Guid
item.ProjectMember_Type_RefID = reader.GetGuid(3);
//4:Parameter IsOwner of type Boolean
item.IsOwner = reader.GetBoolean(4);
//5:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(5);
//6:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(6);
//7:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(7);
//8:Parameter ChargingLevel_RefID of type Guid
item.ChargingLevel_RefID = reader.GetGuid(8);
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_L3PM_SPMCL_1400 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
//Put your code here
CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember();
if (Parameter.ProjectMemberID != Guid.Empty)
{
item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
TMS_PRO_ProjectMemberID = Parameter.ProjectMemberID
}).SingleOrDefault();
}
item.ChargingLevel_RefID = Parameter.ProjectMemberChargingLevel;
return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectMemberID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3PM_CPMT_1704 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_ProjectMember();
if (Parameter.ProjectMemberID != Guid.Empty)
{
item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
TMS_PRO_ProjectMemberID = Parameter.ProjectMemberID
}).Single();
}
item.ProjectMember_Type_RefID = Parameter.ProjectMemberTypeID;
return(new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectMemberID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2PR_SPMfPID_1341 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
foreach (var userID in Parameter.User_IDsToRemoveFromProject)
{
//ORM_TMS_PRO_ProjectMember projectMember = new ORM_TMS_PRO_ProjectMember();
var projectMembers = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query()
{
USR_Account_RefID = userID,
Project_RefID = Parameter.ProjectID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
foreach (var projectMember in projectMembers)
{
projectMember.IsDeleted = true;
projectMember.Save(Connection, Transaction);
}
}
foreach (var userID in Parameter.User_IDsToAddToProject)
{
ORM_TMS_PRO_ProjectMember projectMember = new ORM_TMS_PRO_ProjectMember();
projectMember = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember();
projectMember.TMS_PRO_ProjectMemberID = Guid.NewGuid();
projectMember.USR_Account_RefID = userID;
projectMember.Project_RefID = Parameter.ProjectID;
projectMember.IsDeleted = false;
projectMember.Tenant_RefID = securityTicket.TenantID;
projectMember.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_L6PR_SPM_1040 Execute(DbConnection Connection, DbTransaction Transaction, P_L6PR_SPM_1040 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6PR_SPM_1040();
//Put your code here
var item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember();
L6PR_SPM_1040 addedRemovedProjectMemberInfo = new L6PR_SPM_1040();
List <ORM_TMS_PRO_ProjectMember> removedProjectMembers = new List <ORM_TMS_PRO_ProjectMember>();
List <ORM_TMS_PRO_ProjectMember> newProjectMembers = new List <ORM_TMS_PRO_ProjectMember>();
if (Parameter.Project_IDs_to_Remove_Project_Members.ToList().Count() != 0)
{
foreach (var project in Parameter.Project_IDs_to_Remove_Project_Members.ToList())
{
if (project != Guid.Empty)
{
item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Project_RefID = project,
USR_Account_RefID = Parameter.User_ID
}).Single();
item.IsDeleted = true;
item.Save(Connection, Transaction);
removedProjectMembers.Add(item);
}
}
}
if (Parameter.Project_IDs_to_Add_Project_Members.ToList().Count() != 0)
{
foreach (var project in Parameter.Project_IDs_to_Add_Project_Members.ToList())
{
if (project != Guid.Empty)
{
item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember();
item = ORM_TMS_PRO_ProjectMember.Query.Search(Connection, Transaction, new ORM_TMS_PRO_ProjectMember.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Project_RefID = project,
USR_Account_RefID = Parameter.User_ID
}).SingleOrDefault();
if (item == null)
{
item = new CL1_TMS_PRO.ORM_TMS_PRO_ProjectMember();
item.TMS_PRO_ProjectMemberID = Guid.NewGuid();
item.USR_Account_RefID = Parameter.User_ID;
item.Project_RefID = project;
item.IsDeleted = false;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
newProjectMembers.Add(item);
}
}
}
}
addedRemovedProjectMemberInfo.RemovedProjectMembers = removedProjectMembers.ToArray();
addedRemovedProjectMemberInfo.AddedProjectMembers = newProjectMembers.ToArray();
returnValue.Result = addedRemovedProjectMemberInfo;
return(returnValue);
#endregion UserCode
}
