protected static FR_CAS_CGR_1400 Execute(DbConnection connection, DbTransaction transaction, P_CAS_CGR_1400 parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_CAS_CGR_1400();
            returnValue.Result = new CAS_CGR_1400();
            Thread.CurrentThread.CurrentCulture   = CultureInfo.GetCultureInfo("de-DE");
            Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE");
            string   downloadURL    = "";
            Guid     prev_case_id   = Guid.Empty;
            DateTime DateForElastic = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local);
            var      cases          = cls_Generate_Report.Invoke(connection, transaction, new P_CAS_GR_1608()
            {
            }, securityTicket, parameter.ShowOnlyAok).Result.cases.ToList();

            List <Documents> documentList = new List <Documents>();
            if (cases.Count() > 0)
            {
                Documents documentExcel = new Documents();
                // documentExcel.documentName = "ExcelReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");

                if (parameter.ShowOnlyAok.HasValue)
                {
                    if (parameter.ShowOnlyAok.Value == true)
                    {
                        documentExcel.documentName = "AokReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
                    }
                    else
                    {
                        documentExcel.documentName = "!AokReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
                    }
                }
                else
                {
                    documentExcel.documentName = "ExcelReport" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm");
                }

                documentExcel.documentOutputLocation = GenerateReportCases.CreateCaseXlsReport(cases, documentExcel.documentName);
                documentExcel.mimeType = UtilMethods.GetMimeType(documentExcel.documentOutputLocation);
                documentExcel.receiver = "MM";
                documentList.Add(documentExcel);
                foreach (var item in documentList)
                {
                    MemoryStream ms               = new MemoryStream(File.ReadAllBytes(item.documentOutputLocation));
                    byte[]       byteArrayFile    = ms.ToArray();
                    var          _providerFactory = ProviderFactory.Instance;
                    var          documentProvider = _providerFactory.CreateDocumentServiceProvider();
                    var          uploadedFrom     = HttpContext.Current.Request.UserHostAddress;
                    Guid         documentID       = documentProvider.UploadDocument(byteArrayFile, item.documentOutputLocation, securityTicket.SessionTicket, uploadedFrom);
                    downloadURL = documentProvider.GenerateDownloadLink(documentID, securityTicket.SessionTicket, true, true);


                    P_ARCH_UD_1326 parameterDoc = new P_ARCH_UD_1326();
                    parameterDoc.DocumentID   = documentID;
                    parameterDoc.Mime         = UtilMethods.GetMimeType(item.documentName + ".xlsx");
                    parameterDoc.DocumentName = item.documentName;
                    parameterDoc.DocumentDate = DateForElastic;
                    parameterDoc.Receiver     = "MM";
                    parameterDoc.Description  = "Vollständiger Bericht";
                    cls_Upload_Report.Invoke(connection, transaction, parameterDoc, securityTicket);
                }
            }

            returnValue.Result.DownloadURL = downloadURL;
            return(returnValue);

            #endregion UserCode
        }
 ///<summary>
 /// Invokes the method for the given connection and transaction, leaving them open/not committed if no exceptions occurred
 ///<summary>
 public static FR_CAS_CGR_1400 Invoke(DbConnection connection, DbTransaction transaction, P_CAS_CGR_1400 parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
 {
     return(Invoke(connection, transaction, null, parameter, securityTicket));
 }
        ///<summary>
        /// Method Invocation of wrapper classes
        ///<summary>
        protected static FR_CAS_CGR_1400 Invoke(DbConnection connection, DbTransaction transaction, string connectionString, P_CAS_CGR_1400 parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            var cleanupConnection  = connection == null;
            var cleanupTransaction = transaction == null;

            var functionReturn = new FR_CAS_CGR_1400();

            try
            {
                if (cleanupConnection)
                {
                    connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(connectionString);
                    connection.Open();
                }
                if (cleanupTransaction)
                {
                    transaction = connection.BeginTransaction();
                }

                functionReturn = Execute(connection, transaction, parameter, securityTicket);

                #region Cleanup Connection/Transaction
                //Commit the transaction
                if (cleanupTransaction)
                {
                    transaction.Commit();
                }
                //Close the connection
                if (cleanupConnection)
                {
                    connection.Close();
                }
                #endregion
            }
            catch (Exception ex)
            {
                try
                {
                    if (cleanupTransaction)
                    {
                        transaction?.Rollback();
                    }
                }
                catch
                {
                    // ignored
                }

                try
                {
                    if (cleanupConnection)
                    {
                        connection?.Close();
                    }
                }
                catch
                {
                    // ignored
                }

                throw new Exception("Exception occurred in method cls_Create_Report_for_All_Cases", ex);
            }
            return(functionReturn);
        }
 ///<summary>
 /// Opens the connection/transaction for the given connectionString, and closes them when complete
 ///<summary>
 public static FR_CAS_CGR_1400 Invoke(string connectionString, P_CAS_CGR_1400 parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
 {
     return(Invoke(null, null, connectionString, parameter, securityTicket));
 }