public void changeWorkDetails(TaskStatus status) { SqlConnection conn = new SqlConnection(SettingsReader.getConnectionString()); String myStatus=TaskStatus.convertToStatusString(status.getTaskStatus()); try { conn.Open(); String cmdtxt = "UPDATE Task SET TaskName=\'" + status.getTaskName() + "\' ,Status =\'" + myStatus + "\' ,ElapsedTime =\'" + status.getTaskElapsedTime() + "\' WHERE TaskID = \'" + status.getTaskID() + "\'"; SqlCommand cmd = new SqlCommand(cmdtxt, conn); cmd.CommandText = cmdtxt; cmd.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close(); } } }
protected void putTaskSettings(TaskStatus task) { Label2.Text = task.getTaskName().Trim(); Constraints limits = StorageSystem.getInstance().getRestrictions(task.getTaskID()); TextBox1.Text = limits.getAllowedDepth().ToString(); bool paramsAllowed = limits.isParametrizationAllowed(); if (paramsAllowed == true) DropDownList1.SelectedIndex = 1; else DropDownList1.SelectedIndex = 0; ListBox2.Items.Clear(); List<string> crawlNetworks = limits.getCrawlList(); foreach (string net in crawlNetworks) { ListBox2.Items.Add(net); } ListBox3.Items.Clear(); List<string> restrictNetworks = limits.getRestrictionList(); foreach (string net in restrictNetworks) { ListBox3.Items.Add(net); } }