public static void AdjustTasksByGUID(string guid, double price) { SatyamTaskTableAccess taskDB = new SatyamTaskTableAccess(); List <SatyamTaskTableEntry> entries = taskDB.getAllEntriesByGUID(guid); taskDB.ClearByJobGUID(guid); /// update the price and the taskparam... foreach (SatyamTaskTableEntry entry in entries) { int taskID = entry.ID; SatyamTask task = JSonUtils.ConvertJSonToObject <SatyamTask>(entry.TaskParametersString); task.jobEntry.amazonHITInformation.Price = price; string newTaskParams = JSonUtils.ConvertObjectToJSon(task); taskDB.AddEntryWithSpecificID(taskID, entry.JobTemplateType, entry.UserID, entry.JobGUID, newTaskParams, entry.JobSubmitTime, price); } taskDB.close(); }