protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5TI_TI_1134 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Bool(); var init = ORM_APP_Initialization.Query.Search(Connection, Transaction, new ORM_APP_Initialization.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Application_RefID = Parameter.AppID }).SingleOrDefault(); if (init == null) { init = new ORM_APP_Initialization() { Tenant_RefID = securityTicket.TenantID, Application_RefID = Parameter.AppID, APP_InitializationID = Guid.NewGuid(), Initialization_StartedAtDate = DateTime.Now, Version = "1.0" }; } var DBLanguages = cls_Get_All_Languages.Invoke(Connection, Transaction, securityTicket).Result; var communitiy = new ORM_HEC_CMT_Community() { HEC_CMT_CommunityID = Guid.NewGuid(), Tenant_RefID = securityTicket.TenantID, IsCommunityOperatedByThisTenant = true, CommunityServicesBaseURL = string.Empty, HealthcareCommunityITL = Guid.NewGuid().ToString() }; communitiy.Save(Connection, Transaction); var tenantMembershipType = new ORM_HEC_CMT_Community_OfferedMembershipType() { Tenant_RefID = securityTicket.TenantID, IsAvailableFor_Tenants = true, HEC_CMT_Community_OfferedMembershipTypeID = Guid.NewGuid(), HealthcareCommunityOfferedMembershipTypesITL = Guid.NewGuid().ToString(), OfferedMembershipType_DisplayName = "Tenant Membership Type", Community_RefID = communitiy.HEC_CMT_CommunityID }; tenantMembershipType.Save(Connection, Transaction); var personMembershipType = new ORM_HEC_CMT_Community_OfferedMembershipType() { Tenant_RefID = securityTicket.TenantID, IsAvailableFor_Doctors = true, HEC_CMT_Community_OfferedMembershipTypeID = Guid.NewGuid(), HealthcareCommunityOfferedMembershipTypesITL = Guid.NewGuid().ToString(), OfferedMembershipType_DisplayName = "Person Membership Type", Community_RefID = communitiy.HEC_CMT_CommunityID }; personMembershipType.Save(Connection, Transaction); var communityRoles = Enum.GetValues(typeof(ECommunityRole)); foreach (ECommunityRole role in communityRoles) { DMCommunityRoles.Get_CommunityRole_for_GlobalPropertyMatchingID(Connection, Transaction, EnumUtils.GetEnumDescription(role), communitiy.HEC_CMT_CommunityID, securityTicket); } init.Initialiaztion_CompletedAtDate = DateTime.Now; init.IsInitializationComplete = true; init.Save(Connection, Transaction); return(returnValue); #endregion UserCode }
///<summary> /// Invokes the method for the given Connection, and Transaction, leaving them open/not commited if no exceptions occured ///<summary> public static FR_Bool Invoke(DbConnection Connection, DbTransaction Transaction, P_L5TI_TI_1134 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_Bool Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L5TI_TI_1134 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_Bool functionReturn = new FR_Bool(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw new Exception("Exception occured in method cls_TenantInitialization", ex); } return(functionReturn); }
///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_Bool Invoke(string ConnectionString, P_L5TI_TI_1134 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }