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 -");
}
