Пример #1
0
        /// <summary>
        /// GetFreightDetailByMasterID
        /// </summary>
        /// <param name="pintFreightMasterID"></param>
        /// <returns></returns>
        /// <author>Trada</author>
        /// <date>Tuesday, Feb 28 2006</date>

        public DataSet GetFreightDetailByMasterID(int pintFreightMasterID)
        {
            DataSet             dstFreightDetail    = new DataSet();
            cst_FreightDetailDS dscst_FreightDetail = new cst_FreightDetailDS();

            dstFreightDetail = dscst_FreightDetail.GetFreightDetailByMasterID(pintFreightMasterID);
            return(dstFreightDetail);
        }
Пример #2
0
        /// <summary>
        /// GetReturnToVendorDetail
        /// </summary>
        /// <param name="pintReturnToVendorMasterID"></param>
        /// <returns></returns>
        /// <author>Trada</author>
        /// <date>Thursday, July 6 2006</date>

        public DataSet GetReturnToVendorDetail(int pintReturnToVendorMasterID)
        {
            DataSet             dstReturnToVendor = new DataSet();
            cst_FreightDetailDS dsFreightDetail   = new cst_FreightDetailDS();

            dstReturnToVendor = dsFreightDetail.GetReturnToVendorByMasterID(pintReturnToVendorMasterID);
            foreach (DataRow drow in dstReturnToVendor.Tables[0].Rows)
            {
                drow[IV_AdjustmentTable.ADJUSTMENTID_FLD] = DBNull.Value;
            }
            return(dstReturnToVendor);
        }
Пример #3
0
        /// <summary>
        /// DeleteMasterAndDetail
        /// </summary>
        /// <param name="pintMasterID"></param>
        /// <author>Trada</author>
        /// <date>Tuesday, Feb 28 2006</date>

        public void DeleteMasterAndDetail(int pintMasterID, DataSet pdstDetail)
        {
            foreach (DataRow drow in pdstDetail.Tables[0].Rows)
            {
                if (drow.RowState != DataRowState.Deleted)
                {
                    drow.Delete();
                }
            }
            cst_FreightDetailDS dsFreightDetail = new cst_FreightDetailDS();

            dsFreightDetail.UpdateDataSet(pdstDetail);
            cst_FreightMasterDS dsFreightMaster = new cst_FreightMasterDS();

            dsFreightMaster.Delete(pintMasterID);
        }
Пример #4
0
        /// <summary>
        /// AddAndReturnID
        /// </summary>
        /// <param name="pobjMasterVO"></param>
        /// <param name="pdstDetail"></param>
        /// <returns></returns>
        /// <author>Trada</author>
        /// <date>Monday, Feb 27 2006</date>

        public int AddAndReturnID(cst_FreightMasterVO pobjMasterVO, DataSet pdstDetail)
        {
            int intMasterID = 0;
            cst_FreightMasterDS dscst_FreightMaster = new cst_FreightMasterDS();

            intMasterID = dscst_FreightMaster.AddAndReturnID(pobjMasterVO);
            //save detail
            foreach (DataRow drow in pdstDetail.Tables[0].Rows)
            {
                if (drow.RowState == DataRowState.Deleted)
                {
                    continue;
                }
                drow[cst_FreightDetailTable.FREIGHTMASTERID_FLD] = intMasterID;
            }
            cst_FreightDetailDS dscst_FreightDetail = new cst_FreightDetailDS();

            //Update dataset
            dscst_FreightDetail.UpdateDataSet(pdstDetail);
            return(intMasterID);
        }
Пример #5
0
        /// <summary>
        /// UpdateMasterAndDetail
        /// </summary>
        /// <param name="pobjMasterVO"></param>
        /// <param name="pdstDetail"></param>
        /// <author>Trada</author>
        /// <date>Tuesday, Feb 28 2006</date>

        public void UpdateMasterAndDetail(cst_FreightMasterVO pobjMasterVO, DataSet pdstDetail)
        {
            cst_FreightMasterDS dsFreightMaster = new cst_FreightMasterDS();
            cst_FreightDetailDS dsFreightDetail = new cst_FreightDetailDS();

            if (pobjMasterVO.FreightMasterID > 0)
            {
                foreach (DataRow drow in pdstDetail.Tables[0].Rows)
                {
                    if (drow.RowState == DataRowState.Deleted)
                    {
                        continue;
                    }
                    if (int.Parse(drow[cst_FreightMasterTable.FREIGHTMASTERID_FLD].ToString()) == 0)
                    {
                        drow[cst_FreightMasterTable.FREIGHTMASTERID_FLD] = pobjMasterVO.FreightMasterID;
                    }
                }
            }
            //Update master
            dsFreightMaster.Update(pobjMasterVO);
            //Update Detail
            dsFreightDetail.UpdateDataSet(pdstDetail);
        }
Пример #6
0
        /// <summary>
        /// Get Additional Charge (including Freight, Import Tax, Credit Note, Debit Note)
        /// </summary>
        /// <param name="pintCCNID">CCN</param>
        /// <param name="pdtmFromDate">From Date</param>
        /// <param name="pdtmToDate">To Date</param>
        /// <returns></returns>

        public DataTable GetAdditionalCharge(int pintCCNID, DateTime pdtmFromDate, DateTime pdtmToDate)
        {
            cst_FreightDetailDS dsFreight = new cst_FreightDetailDS();

            return(dsFreight.ListAll(pintCCNID, pdtmFromDate, pdtmToDate));
        }