}          //list data objects convert into datatable

        public string Cancel_Pick_Order([FromBody] pickZivline line)
        {
            Main   objmain  = new Main();
            string order_no = line.order_no;
            string status   = null;
            int    result   = objmain.Cancel_Pick_Order(order_no);

            if (result > 0)
            {
                status = "Success Cancel Order";
            }
            else
            {
                status = "Unsuccess Cancel Order";
            }
            return(status);
        }
        // notfound case insert a line into database by navion
        public string Insert_Line_By_Navision([FromBody] pickZivline line)         //for navision to insert new pick in database
        {
            Main   objmain   = new Main();
            string navresult = "Unsucces New Line Of This Pick No." + line.pickno;

            try
            {
                int result = objmain.Insert_Pick_Line(line);
                if (result > 0)
                {
                    navresult = "succes New Line Of This Pick No." + line.pickno;
                }
            }
            catch (Exception)
            {
                navresult = "Exception New Line Of This Pick No." + line.pickno;
            }
            return(navresult);//"Pickno:---" + pichead.header.pickno + "Line data_" + pichead.line[0].pickno + "     ---" + pichead.line[1].pickno + "result---" + result +"count==="+ dt.Rows.Count;
        }