///<summary> /// Opens the connection/transaction for the given connectionString, and closes them when complete ///<summary> public static FR_L5BD_GBwDDfTID_1017_Array Invoke(string ConnectionString, P_L5BD_GBwDDfTID_1017 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(null, null, ConnectionString, Parameter, securityTicket)); }
///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_L5BD_GBwDDfTID_1017_Array Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L5BD_GBwDDfTID_1017 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_L5BD_GBwDDfTID_1017_Array functionReturn = new FR_L5BD_GBwDDfTID_1017_Array(); 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_Get_BillsWithDunningDetails_for_TenantID", ex); } return(functionReturn); }
protected static FR_L5BD_GBwDDfTID_1017_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5BD_GBwDDfTID_1017 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5BD_GBwDDfTID_1017_Array(); //Put your code here var statusParam = new P_L5SH_GSSfGPMaT_1700 { GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EShipmentStatus.Shipped) }; var frStatus = cls_Get_Shipment_Status_for_GlobalPropertyMatchingID_and_TenantID.Invoke(Connection, Transaction, statusParam, securityTicket); Parameter.GetBillsParameter.ShipmentStatusID = frStatus.Result.LOG_SHP_Shipment_StatusID; var bills = cls_Get_AllFilteredBills_for_TenantID.Invoke(Connection, Transaction, Parameter.GetBillsParameter, securityTicket).Result; List <Guid> billHeaderIDs = new List <Guid>(); foreach (var bill in bills) { billHeaderIDs.Add(bill.BIL_BillHeaderID); } P_L5BD_GDDfBHL_1117 getDunningDetailsParameter = new P_L5BD_GDDfBHL_1117(); getDunningDetailsParameter.BillHeaderID_List = billHeaderIDs.ToArray(); getDunningDetailsParameter.DunningLevelID = Parameter.GetDunningDetailsParameter.DunningLevelID; getDunningDetailsParameter.DunningDateFrom = Parameter.GetDunningDetailsParameter.DunningDateFrom; getDunningDetailsParameter.DunningDateTo = Parameter.GetDunningDetailsParameter.DunningDateTo; getDunningDetailsParameter.IsReminded = Parameter.GetDunningDetailsParameter.IsReminded; var dunningDetailsForBills = new List <L5BD_GDDfBHL_1117>(); if (billHeaderIDs.Count > 0) { dunningDetailsForBills = cls_Get_DunningDetails_for_BillHeaderList.Invoke(Connection, Transaction, getDunningDetailsParameter, securityTicket).Result.ToList(); } List <L5BD_GBwDDfTID_1017> billsWithDunningDetails = new List <L5BD_GBwDDfTID_1017>(); foreach (var bill in bills) { L5BD_GBwDDfTID_1017 billWithDunningDetails = new L5BD_GBwDDfTID_1017(); if (dunningDetailsForBills.Where(x => x.BIL_BillHeader_RefID == bill.BIL_BillHeaderID) != null && dunningDetailsForBills.Where(x => x.BIL_BillHeader_RefID == bill.BIL_BillHeaderID).Count() > 0) { billWithDunningDetails.DunningDetails = dunningDetailsForBills.Where(x => x.BIL_BillHeader_RefID == bill.BIL_BillHeaderID).Single(); billWithDunningDetails.Bill = bill; billsWithDunningDetails.Add(billWithDunningDetails); } } returnValue.Result = billsWithDunningDetails.ToArray(); 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_L5BD_GBwDDfTID_1017_Array Invoke(DbConnection Connection, DbTransaction Transaction, P_L5BD_GBwDDfTID_1017 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { return(Invoke(Connection, Transaction, null, Parameter, securityTicket)); }