///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_L3SC_GSCwQfI_1731_Array Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L3SC_GSCwQfI_1731 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_L3SC_GSCwQfI_1731_Array functionReturn = new FR_L3SC_GSCwQfI_1731_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_ShelfContent_with_Quantities_for_Inventory", ex); } return(functionReturn); }
protected static FR_L3SC_GSCwQfI_1731_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3SC_GSCwQfI_1731 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3SC_GSCwQfI_1731_Array(); //Put your code here List <L3SC_GSCwQfI_1731> resultData = new List <L3SC_GSCwQfI_1731>(); if (Parameter.ShelfIDList != null && Parameter.ShelfIDList.Count() > 0) { var basicData = cls_Get_ShelfContentInventarData.Invoke(Connection, Transaction, new P_L3SC_GSCID_1711() { ShelfIDList = Parameter.ShelfIDList }, securityTicket).Result; if (basicData != null && basicData.Count() > 0) { var quantities = cls_Get_StockQuantity_Current_and_Free_for_ShelfContentIDList.Invoke(Connection, Transaction, new P_L3SC_GSQCaFfSC_1707() { ShelfContentIDList = basicData.Select(x => x.LOG_WRH_Shelf_ContentID).ToArray() }, securityTicket).Result; var shelfPaths = cls_Get_ShelfPath_for_ShelfIDList.Invoke(Connection, Transaction, new P_L3WH_GSPfSL_1443() { ShelfIDs = Parameter.ShelfIDList }, securityTicket).Result; foreach (var row in basicData) { L3SC_GSCwQfI_1731 stockItem = new L3SC_GSCwQfI_1731(); stockItem.ProductAndVariantData = row; stockItem.StockQuantities = quantities.SingleOrDefault(x => x.LOG_WRH_Shelf_ContentID == row.LOG_WRH_Shelf_ContentID); var path = shelfPaths.SingleOrDefault(x => x.LOG_WRH_ShelfID == row.Shelf_RefID); if (path != null) { stockItem.StockUnitPath = String.Format("{0}-{1}-{2}-{3}", path.WarehouseCode, path.AreaCode, path.RackCode, path.ShelfCode); } resultData.Add(stockItem); } } } returnValue.Result = resultData.ToArray(); return(returnValue); #endregion UserCode }