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(); } } }
/** * This function gets UserID and QueryOption and returns the TaskID,TaskName, * Status,ElapsedTime of all the tasks that have the given UserID and that they are * in the state of the given QueryOpiton. */ public List<TaskStatus> getWorkDetails(String userID, QueryOption option) { // 1. Instantiate the connection SqlConnection conn = new SqlConnection(SettingsReader.getConnectionString()); SqlDataReader rdr = null; List<TaskStatus> taskDetailsList = new List<TaskStatus>(); try { // 2. Open the connection conn.Open(); SqlCommand cmd; String statusString = ""; switch (option) { case QueryOption.ActiveTasks: statusString = "ACTIVE"; break; case QueryOption.IdleTasks: statusString = "IDLE"; break; case QueryOption.WaitingTasks: statusString = "WAITING"; break; default: statusString = ""; break; } if (option == QueryOption.AllTasks) { cmd = new SqlCommand("SELECT TaskID,TaskName,Status,ElapsedTime from Task WHERE UserID=\'" + userID + "\'", conn); } else { cmd = new SqlCommand("SELECT TaskID,TaskName,Status,ElapsedTime from Task" + " WHERE UserID=\'" + userID + "\' AND Status=\'" + statusString + "\'", conn); } // get query results rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { TaskStatus taskDetails = new TaskStatus(rdr["TaskID"].ToString()); taskDetails.setTaskElapsedTime((long)rdr["ElapsedTime"]); taskDetails.setTaskName((String)rdr["TaskName"]); Status statusOfTask = TaskStatus.convertToStatusObj((String)rdr["Status"]); taskDetails.setTaskStatus(statusOfTask); taskDetailsList.Add(taskDetails); } } } finally { // close the reader if (rdr != null) { rdr.Close(); } // 5. Close the connection if (conn != null) { conn.Close(); } } return taskDetailsList; }
private void createCookie(TaskStatus task) { if (GetCookie("Created") == null) { SetCookie("Created", "T", 1); SetCookie("Records", Convert.ToString(10), 1); if (task != null) { Response.Cookies["resultInfo"]["TID"] = task.getTaskID(); } else { Response.Cookies["resultInfo"]["TID"] = "NONE"; } Response.Cookies["resultInfo"]["Remove"] = Convert.ToString(false); Response.Cookies["resultInfo"]["View"] = Convert.ToString("ALL"); Response.Cookies["resultInfo"]["Order"] = convertOrderToString(Order.NormalOrder); Response.Cookies["resultInfo"]["Page"] = Convert.ToString(0); Response.Cookies["resultInfo"]["numOfResults"] = Convert.ToString(0); } }
/** * changes the task status details for the specified task */ public void changeWorkDetails(TaskStatus status) { _configurationStorageImp.changeWorkDetails(status); }
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); } }
public void Test3() { Console.WriteLine("[] Trying to change an existing task ..."); ConfigurationStorageImp ss = new ConfigurationStorageImp(); TaskStatus status = new TaskStatus("92667983-3cb9-4cb7-8b5b-5febb5db9341"); status.setTaskElapsedTime(39); status.setTaskName("snoop"); status.setTaskStatus(Status.Waiting); ss.changeWorkDetails(status); Console.WriteLine(" - PASSED -"); }