C# Query.updateId方法代码示例

        public void run() {
            try {
                // Login
                string token = Query.login("[email protected]", "demobiz");
                Query query = new Query(token);

                // 1. Select All Contacts
                JSONObject[] items = query.select(Contact.TABLE, null);
                foreach (JSONObject item in items) {
                    // get Contact object from Json for easy record values manipulation
                    Contact contact = Contact.fromJson(item);
                    Console.WriteLine("Name: " + contact.name + ", email:" + contact.email + ", mobile: " + contact.mobile);
                }

                // 2. Create a new contact
                Contact newContact = new Contact();
                newContact.id = "MyUniqueId";
                newContact.name = "John Smith";
                newContact.email = "[email protected]";
                newContact.mobile = "6979 0486";
                newContact.jobtitle = "CTO";

                query.insert(Contact.TABLE, newContact.toJson());

                // Verify that the contact has been correctly inserted by selecting it again
                JSONObject obj = query.selectId(Contact.TABLE, newContact.id);
                if (obj != null) {
                    Console.WriteLine("Contact: " + obj.ToString());
                }

                // 3. Update Contact
                Contact updatedContact = new Contact();
                updatedContact.mobile = "111111";
                query.updateId(Contact.TABLE, newContact.id, updatedContact.toJson());

                // Verify that the contact has been correctly updated
                obj = query.selectId(Contact.TABLE, newContact.id);
                if (obj != null) {
                    Console.WriteLine("Contact Mobile:" + obj.getString("mobile"));
                }

                // 4. Delete Contact
                query.deleteId(Contact.TABLE, newContact.id);
                // Verify that the contact has been correctly updated
                obj = query.selectId(Contact.TABLE, newContact.id);
                if (obj == null) {
                    Console.WriteLine("Contact has been deleted");
                }
            } catch (Exception e) {
                Console.WriteLine("Error:" + e.Message);
            }
        }

        public void run() {
            try {
                // Login
                string token = Query.login("[email protected]", "demobiz");
                Query query = new Query(token);

                // 1. Start a batch operation
                query.beginBatch();
                for (var i = 1; i < 5; i++) {
                    // 2. Create a new contact
                    Contact contact = new Contact();
                    contact.id = "JOHN_ID" + i;
                    contact.name = "John " + i;
                    contact.email = "John" + i + "@gmail.com";
                    // this add the insert query to the internal batch query buffer
                    query.insert(Contact.TABLE, contact.toJson());
                }
                // this performs one HTTPS web service call and executes all previous queries
                query.commitBatch();

                // 2. Now Batch Update the Records
                query.beginBatch();
                for (var i = 1; i < 5; i++) {
                    Contact updatedValues = new Contact();
                    updatedValues.email = "john" + i + "@yahoo.com";
                    query.updateId(Contact.TABLE, "JOHN_ID" + i, updatedValues.toJson());
                }
                query.commitBatch();

                // 3. Now Batch Delete the Records
                query.beginBatch();
                for (var i = 1; i < 5; i++) {
                    query.deleteId(Contact.TABLE, "JOHN_ID" + i);
                }
                query.commitBatch();
            } catch (Exception e) {
                Console.WriteLine("Error:" + e.Message);
            }
        }

        public void run() {
            try {
                // Login
                string token = Query.login("[email protected]", "demobiz");
                Query query = new Query(token);

                // 3. Returns all Assets with no geocode
                JSONObject where = new JSONObject();
                where.put("geo", "");
                JSONObject[] assets = query.select("Assets.assets", where);
                foreach (JSONObject obj in assets) {
                    Console.WriteLine(obj.ToString());
                }

                // Update the first asset with a geo location
                JSONObject firstAsset = (assets.Length > 0) ? assets[0] : null;
                if (firstAsset != null) {
                    JSONObject asset = new JSONObject();
                    asset.put("geo", "51.522020,-0.122198");
                    query.updateId("assets.assets", firstAsset.getString("id"), asset);
                }

                // Insert a new Asset
                JSONObject newAsset = new JSONObject();
                newAsset.put("id", "69794");
                newAsset.put("name", "My Assset");
                newAsset.put("model", "Fiat");
                newAsset.put("geo", "48.858238, 2.347918");
                newAsset.put("serialnumber", "69493949658TYH");
                newAsset.putDate("purchasedate", DateTime.Now);
                newAsset.put("purchaseprice", 12.4f);
                newAsset.put("manufacturer", "Foxconn");
                newAsset.put("geo", "48.858238,2.347918");
                query.insert("assets.assets", newAsset);

            } catch (Exception e) {
                Console.WriteLine(e.Message);
            }
        }

        public void run() {
            string token = Query.login("[email protected]", "demobiz");
            Query query = new Query(token);

            // 1. insert one job
            Job newjob = new Job();
            newjob.id = "ID1";
            newjob.status = Job.OPEN;
            newjob.name = "Maintain Air Conditining";
            newjob.note = "Verify gaz pressure";
            newjob.duedate = DateTime.Now.AddHours(2);
            newjob.owner = "John"; // if you want to assign a Job, set the Upvise user Display name here
            newjob.street = "1 infinite Loop";
            newjob.city = "Cupertino";
            newjob.zipcode = "";
            newjob.country = "USA";
            newjob.geo = "12,3.444"; // set the coordinates for the job
            newjob.priority = Job.HIGHPRIORITY; // High priority

            // set some custom fields values
            newjob.setCustomField("F1", "WATER");
            newjob.setCustomField("F2", "12");

            query.insert(Job.TABLE, newjob.toJson());

            // 2. Update the existing job and mark it complete
            Job updatedValues = new Job();
            updatedValues.status = Job.COMPLETED;
            updatedValues.checkout = DateTime.Now;
            updatedValues.checkoutnote = "Aircon is leaking, requirews further fixing";

            query.updateId(Job.TABLE, "ID1", updatedValues.toJson());

            // 3. Select All Completed Jobs
            JSONObject where = new JSONObject();
            where.put("status", Job.COMPLETED);
            JSONObject[] completedJobs = query.select(Job.TABLE, where);
            foreach (JSONObject obj in completedJobs) {
                Job job = Job.fromJson(obj);

                Console.Write("Checkout note: " + job.checkoutnote);
                Console.Write("Custom Field 1: " + job.getCustomField("F1"));
                Console.Write("Custom Field 2: " + job.getCustomField("F2"));
                
                // Download all photos for the Job
                File[] files = query.selectFiles(Job.TABLE, job.id);
                foreach (File file in files) {
                    if (file.mime == "image/jpeg") {
                        byte[] content = query.downloadFile(file.id);
                        string filename = @"c:\temp\" + file.name + ".jpeg";
                        System.IO.File.WriteAllBytes(filename, content);
                    }
                }

                // Get All forms for the Job
                JSONObject formWhere = new JSONObject();
                formWhere.put("linkedid", job.id);
                JSONObject[] forms = query.select(Form.TABLE, formWhere);
                foreach (JSONObject formObj in forms) {
                    Form form = Form.fromJson(formObj, query);
                    Console.WriteLine("Form : " + formObj.ToString());
                }
            }

            // 4. Delete completed Jobs in batch mode
            query.beginBatch();
            foreach (JSONObject obj in completedJobs) {
                string jobid = obj.getString("id");
                query.deleteId(Job.TABLE, jobid);
            }
            query.commitBatch();
        }

        public void run() {
            try {
                // Login
                string token = Query.login("[email protected]", "demobiz");
                Console.WriteLine("Login OK");

                // Create an instance of hte query class
                Query query = new Query(token);

                // Select all open tasks from the "Tasks.tasks" table 
                // You can go to your Upvise web account in the Task app and create some tasks first
                JSONObject where = new JSONObject();
                where.put("status", 0);
                JSONObject[] tasks = query.select("Tasks.tasks", where);
                Console.WriteLine("Found " + tasks.Length + " open tasks in this database");
                foreach (JSONObject task in tasks) {
                    Console.WriteLine("Task ID: " + task.getString("id"));
                    Console.WriteLine("Name: " + task.getString("name"));
                    Console.WriteLine("Due Date: " + task.getDate("duedate"));
                    Console.WriteLine("Owner: " + task.getString("owner"));
                    Console.WriteLine("Status:" + task.getInt("status"));
                }

                // Create a bunch of tasks using Batch operation
                Console.WriteLine("Creating 10 new tasks...");
                query.beginBatch();
                for (int i = 0; i < 10; i ++) {
                    JSONObject task = new JSONObject();
                    task.put("id", "TASKID_" + i);
                    task.put("name", "My Task " + i);
                    task.put("owner", "John");
                    task.put("status", 0);
                    task.putDate("duedate", DateTime.Now.AddDays(2));

                    query.insert("Tasks.tasks", task);
                }
                query.commitBatch();
                
                // update All open John's Tasks and mark them complete (status=1)
                where.put("owner", "John");
                where.put("status", 0);
                JSONObject[] myTasks = query.select("Tasks.tasks", where);
                Console.WriteLine("found " + myTasks.Length  + " open tasks for John");
                // Start a new batch operation to group all updates into one HTTPS request for best performance
                query.beginBatch();
                foreach(JSONObject task in myTasks) {
                    string id = task.getString("id");
                    JSONObject values = new JSONObject();
                    values.putDate("duedate", DateTime.Now);
                    values.put("status", 1);
                    query.updateId("Tasks.tasks", id, values);
                }
                query.commitBatch();
                Console.WriteLine("Updated the tasks to Complete");

                // Now Get All John's completed Tasks, export them in a file and delete them
                where.put("owner", "John");
                where.put("status", 1);
                JSONObject[] completedTasks = query.select("Tasks.tasks", where);
                Console.WriteLine("found " + completedTasks.Length + " completed tasks for John");

                StringBuilder buffer = new StringBuilder();
                // Start a new batch operation
                query.beginBatch();
                foreach (JSONObject task in completedTasks) {
                    string id = task.getString("id");
                    // Add the task data in the buffer
                    buffer.AppendLine(task.ToString());
                    query.deleteId("Tasks.tasks", id);

                }
                query.commitBatch();
                Console.WriteLine("Deleted completed tasks for John");
                // Save the file to disk
                System.IO.File.WriteAllText(@"C:\\temp\completedTasks.txt", buffer.ToString());
                
            } catch (Exception e) {
                Console.WriteLine("Error:" + e.Message);
            }
        }