//end update order

    /// <summary>
    /// append new title to db
    /// </summary>
    /// <param name="orderid">int32</param>
    /// <param name="newtitle">string</param>
    /// <returns>new record id of title</returns>
    protected Int32 append_title(Int32 orderid, string newtitle)
    {
        Int32 _newid = 0;

        if (!string.IsNullOrEmpty(newtitle))
        {
            //append title with new id
            PublishipAdvanceTitleTable _t = new PublishipAdvanceTitleTable();
            _t.PAOrderID = orderid;
            _t.Title     = newtitle;
            _t.Save();

            //get new id
            _newid = (Int32)_t.GetPrimaryKeyValue();
        }

        return(_newid);
    }
    //end update order

    /// <summary>
    /// append new title to db
    /// </summary>
    /// <param name="orderid">int32</param>
    /// <param name="newtitle">string</param>
    /// <returns>new record id of title</returns>
    protected Int32 append_title(Int32 orderid, string newtitle)
    {
        Int32 _newid = 0;

            if (!string.IsNullOrEmpty(newtitle))
            {
                //append title with new id
                PublishipAdvanceTitleTable _t = new PublishipAdvanceTitleTable();
                _t.PAOrderID = orderid;
                _t.Title = newtitle;
                _t.Save();

                //get new id
                _newid = (Int32)_t.GetPrimaryKeyValue();
            }
       
        return _newid;
    }