Example #1
0
        // 2014.10.17 MadhuVenkat K Modified SQL statement for CR#65002-Changing From Site in Shipment Processing.
        // 2014.10.18 MadhuVenkat K Modified SQL statement for CR#64905-App crashes when we process multi BOL
        // 2014.11.25 MadhuVenkat K Modified SQL statement for CR#65604 - Application is updating null for Supplier Code/ Supply Point in the BOLHdr for shipments created from iPAD app.

        /// <summary>
        /// Function to return list of BOL item
        /// </summary>
        /// <param name="customerID">Customer ID</param>
        /// <param name="sysTrxNo">SysTrxNo</param>
        /// <param name="sysTrxLine">sysTrxLine</param>
        /// <param name="session">session object</param>
        /// <returns>list of BOL item</returns>
        public static List <DAL.BOLItemRow> GetUpdatedBolItem(String customerID, Decimal sysTrxNo, Int32 sysTrxLine, ISession session, String VersionNo = "")
        {
            BOLItemTableAdapter ta = new BOLItemTableAdapter();

            ta.CurrentConnection = session;
            return(ta.GetUpdatedData(customerID, sysTrxNo, sysTrxLine).ToList());
        }
Example #2
0
        /// <summary>
        /// UpdateBolItem
        /// Function to update the BOL item records
        /// </summary>
        /// <param name="shipDocSysTrxNo">Shipment doc system transaction number</param>
        /// <param name="shipDocSysTrxLine">Shipment doc system transaction line</param>
        /// <param name="id">Id</param>
        /// <param name="session">Session object</param>
        public static void UpdateBolItem(Decimal?shipDocSysTrxNo, Int32?shipDocSysTrxLine, Guid id, ISession session, String VersionNo = "")
        {
            BOLItemTableAdapter ta = new BOLItemTableAdapter();

            ta.CurrentConnection = session;
            // 2014.03.31 Ramesh M Added modified SQL statement to support multi line item of ship doc
            ta.UpdateQuery(shipDocSysTrxNo, shipDocSysTrxLine, id);
        }