protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DPFT_DPN_1100 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new CL1_TMS_PRO.ORM_TMS_PRO_Project();
if (Parameter.TMS_PRO_ProjectID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.TMS_PRO_ProjectID);
if (result.Status != FR_Status.Success || item.TMS_PRO_ProjectID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
returnValue = new FR_Guid(item.Save(Connection, Transaction), item.TMS_PRO_ProjectID);
ORM_TMS_PRO_Project.Query query = new ORM_TMS_PRO_Project.Query();
query.TMS_PRO_ProjectID = item.TMS_PRO_ProjectID;
item.IsDeleted = true;
ORM_TMS_PRO_Project.Query.SoftDelete(Connection, Transaction, query);
#region Delete ORM_TMS_PRO_BusinessTask
ORM_TMS_PRO_BusinessTask.Query ORM_TMS_PRO_BusinessTaskquery = new ORM_TMS_PRO_BusinessTask.Query();
ORM_TMS_PRO_BusinessTaskquery.Project_RefID = Parameter.TMS_PRO_ProjectID;
ORM_TMS_PRO_BusinessTaskquery.IsArchived = false;
ORM_TMS_PRO_BusinessTaskquery.IsDeleted = false;
ORM_TMS_PRO_BusinessTask.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BusinessTaskquery);
#endregion
#region Delete ORM_TMS_PRO_BusinessTaskPackage
ORM_TMS_PRO_BusinessTaskPackage.Query ORM_TMS_PRO_BusinessTaskPackagequery = new ORM_TMS_PRO_BusinessTaskPackage.Query();
ORM_TMS_PRO_BusinessTaskPackagequery.Project_RefID = Parameter.TMS_PRO_ProjectID;
ORM_TMS_PRO_BusinessTaskPackagequery.IsDeleted = false;
ORM_TMS_PRO_BusinessTaskPackage.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BusinessTaskPackagequery);
#endregion
#region Delete ORM_TMS_PRO_ProjectMember
var ORM_TMS_PRO_ProjectMemberquery = new ORM_TMS_PRO_ProjectMember.Query();
ORM_TMS_PRO_ProjectMemberquery.IsDeleted = true;
ORM_TMS_PRO_ProjectMemberquery.Project_RefID = Parameter.TMS_PRO_ProjectID;
ORM_TMS_PRO_ProjectMember.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_ProjectMemberquery);
#endregion
#region Delete ORM_TMS_PRO_BussinessTask_2_Feature
var ORM_TMS_PRO_BussinessTask_2_Featurequery = new ORM_TMS_PRO_BusinessTask_2_Feature.Query();
ORM_TMS_PRO_BussinessTask_2_Featurequery.Feature_RefID = Parameter.TMS_PRO_ProjectID;
ORM_TMS_PRO_BussinessTask_2_Featurequery.IsDeleted = true;
ORM_TMS_PRO_BusinessTask_2_Feature.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_BussinessTask_2_Featurequery);
#endregion
#region Delete ORM_TMS_PRO_Features
var ORM_TMS_PRO_Featuresquery = new ORM_TMS_PRO_Feature.Query();
ORM_TMS_PRO_Featuresquery.TMS_PRO_FeatureID = Parameter.TMS_PRO_ProjectID;
ORM_TMS_PRO_Featuresquery.IsDeleted = true;
ORM_TMS_PRO_Feature.Query.SoftDelete(Connection, Transaction, ORM_TMS_PRO_Featuresquery);
#endregion
#region Delete ORM_TMS_DeveloperTasks
var ORM_TMS_Developertaskquery = new ORM_TMS_PRO_DeveloperTask.Query();
ORM_TMS_Developertaskquery.TMS_PRO_DeveloperTaskID = Parameter.TMS_PRO_ProjectID;
ORM_TMS_Developertaskquery.IsDeleted = true;
ORM_TMS_PRO_DeveloperTask.Query.SoftDelete(Connection, Transaction, ORM_TMS_Developertaskquery);
#endregion
return(returnValue);
#endregion UserCode
}
private static List <ORM_TMS_PRO_Project> Search(Query query, string connectionString, DbConnection connection, DbTransaction transaction)
{
CSV2Core.Core.Interfaces.IManagedConnection managedConnection = new CSV2Core_MySQL.MySQLManagedConnection();
List <ORM_TMS_PRO_Project> 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_Project>();
var reader = new CSV2Core_MySQL.Support.DBSQLReader(command.ExecuteReader());
reader.SetOrdinals(new string[] { "TMS_PRO_ProjectID", "ProjectCode", "DefaultLanguage_RefID", "DOC_Structure_Header_RefID", "Name_DictID", "Description_DictID", "Status_RefID", "IsArchived", "CreatedByAccount_RefID", "BillingCurrency_RefID", "Default_CostCenter_RefID", "Color", "Creation_Timestamp", "Tenant_RefID", "IsDeleted" });
while (reader.Read())
{
ORM_TMS_PRO_Project item = new ORM_TMS_PRO_Project();
//0:Parameter TMS_PRO_ProjectID of type Guid
item.TMS_PRO_ProjectID = reader.GetGuid(0);
//1:Parameter ProjectCode of type String
item.ProjectCode = reader.GetString(1);
//2:Parameter DefaultLanguage_RefID of type Guid
item.DefaultLanguage_RefID = reader.GetGuid(2);
//3:Parameter DOC_Structure_Header_RefID of type Guid
item.DOC_Structure_Header_RefID = reader.GetGuid(3);
//4:Parameter Name of type Dict
item.Name = reader.GetDictionary(4);
loader.Append(item.Name, TableName);
//5:Parameter Description of type Dict
item.Description = reader.GetDictionary(5);
loader.Append(item.Description, TableName);
//6:Parameter Status_RefID of type Guid
item.Status_RefID = reader.GetGuid(6);
//7:Parameter IsArchived of type Boolean
item.IsArchived = reader.GetBoolean(7);
//8:Parameter CreatedByAccount_RefID of type Guid
item.CreatedByAccount_RefID = reader.GetGuid(8);
//9:Parameter BillingCurrency_RefID of type Guid
item.BillingCurrency_RefID = reader.GetGuid(9);
//10:Parameter Default_CostCenter_RefID of type Guid
item.Default_CostCenter_RefID = reader.GetGuid(10);
//11:Parameter Color of type String
item.Color = reader.GetString(11);
//12:Parameter Creation_Timestamp of type DateTime
item.Creation_Timestamp = reader.GetDate(12);
//13:Parameter Tenant_RefID of type Guid
item.Tenant_RefID = reader.GetGuid(13);
//14:Parameter IsDeleted of type Boolean
item.IsDeleted = reader.GetBoolean(14);
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);
}
