///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_MD_GAIwPID_1629 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_MD_GAIwPID_1629 functionReturn = new FR_MD_GAIwPID_1629(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, 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_Get_Account_Information_with_PracticeID", ex); } return(functionReturn); }
protected static FR_MD_GAIwPID_1629 Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_MD_GAIwPID_1629(); returnValue.Result = new MD_GAIwPID_1629(); returnValue.Result.AccountInformation = new MD_GAI_1617(); var data = cls_Get_Account_Information.Invoke(Connection, Transaction, securityTicket).Result; returnValue.Result.AccountInformation = data; if (data.group_id == "mm.docconect.doc.app.group") { var is_doctor = !data.role.Contains("practice"); if (is_doctor) { var medical_practice = cls_Get_PracticeID_for_Doctor_BusinessParticipantID.Invoke(Connection, Transaction, new P_CAS_GPIDfDBPTID_1205() { BusinessParticipantID = data.CMN_BPT_BusinessParticipantID }, securityTicket).Result; var hec_doctorQuery = new ORM_HEC_Doctor.Query(); hec_doctorQuery.IsDeleted = false; hec_doctorQuery.Tenant_RefID = securityTicket.TenantID; hec_doctorQuery.BusinessParticipant_RefID = data.CMN_BPT_BusinessParticipantID; var hec_doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, hec_doctorQuery).Single(); returnValue.Result.DoctorID = hec_doctor.HEC_DoctorID; returnValue.Result.PracticeID = medical_practice.practice_id; returnValue.Result.PracticeName = medical_practice.practice_name; } else { var medical_practice = cls_Get_Case_PracticeData_for_PracticeBptID.Invoke(Connection, Transaction, new P_CAS_GCPDfPBptID_1248() { PracticeBptID = data.CMN_BPT_BusinessParticipantID }, securityTicket).Result; returnValue.Result.PracticeID = medical_practice.id; returnValue.Result.PracticeName = medical_practice.name; } } return(returnValue); #endregion UserCode }