public JsonResult All_Pending_pick([FromBody] Bindpickk Pending)
        {
            Main      objmain = new Main();
            DataTable dt      = objmain.allpending_pick(Pending.email, Pending.selectLoc);

            if (dt.Rows.Count == 0)
            {
                dt.Columns.Add("condition", typeof(System.String));
                dt.Columns.Add("Message", typeof(System.String));
                dt.Rows.Add();
                dt.Rows[0]["condition"] = "False";
                dt.Rows[0]["Message"]   = "There is no Pick For You Enjoy :-)";
                return(objmain.DataTableToJsonWithJsonNet(dt));
            }
            return(objmain.DataTableToJsonWithJsonNet(dt));
        }
        //for send data to pick component
        public JsonResult Get_Pick_Detail([FromBody] Bindpickk loc)           //bind pick data by this method
        {
            Main    objmain   = new Main();
            DataSet ds        = new DataSet();
            string  useremail = loc.email.ToString();

            ds = objmain.Get_Pick_Detail(Convert.ToInt32(loc.selectLoc.ToString()), useremail);
            try
            {
                DataColumn pending_pick = new DataColumn();
                pending_pick.ColumnName   = "pending_pick";
                pending_pick.DefaultValue = ds.Tables[1].Rows[0][0].ToString();
                ds.Tables[0].Columns.Add(pending_pick);
            }
            catch (Exception ee)
            {
            }
            return(objmain.DataTableToJsonWithJsonNet(ds.Tables[0]));
        }