private PFList <PFTask> GetTaskListDatabase()
{
PFList <PFTask> taskList = new PFList <PFTask>();
PFDatabase db = null;
try
{
db = new PFDatabase(DatabasePlatform.SQLServerCE35);
db.ConnectionString = this.ConnectionString;
db.OpenConnection();
DbDataReader rdr = db.RunQueryDataReader(_taskDefinitionsSelectAllSQL, System.Data.CommandType.Text);
while (rdr.Read())
{
string str = rdr["TaskObject"].ToString();
PFTask task = PFTask.LoadFromXmlString(str);
taskList.Add(task);
}
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
if (db != null)
{
if (db.IsConnected)
{
db.CloseConnection();
}
}
}
return(taskList);
}
/// <summary>
/// Creates and initializes an instance of the class by loading a serialized version of the instance from a database record.
/// </summary>
/// <param name="connectionString">Connection parameters for the database.</param>
/// <param name="taskName">Name of the task to retrieve.</param>
/// <returns>Task object.</returns>
public static PFTask LoadFromDatabase(string connectionString, string taskName)
{
string sqlStmt = string.Empty;
PFTask objectInstance = null;
PFTask tempObjectInstance = new PFTask();
PFDatabase db = new PFDatabase(DatabasePlatform.SQLServerCE35);
DbDataReader rdr = null;
string taskDefXml = string.Empty;
db.ConnectionString = connectionString;
db.OpenConnection();
sqlStmt = tempObjectInstance._taskDefinitionsSelectTaskSQL.Replace("<taskname>", taskName);
rdr = db.RunQueryDataReader(sqlStmt, CommandType.Text);
while (rdr.Read())
{
taskDefXml = rdr.GetString(0);
objectInstance = PFTask.LoadFromXmlString(taskDefXml);
break; //should be only one record
}
return(objectInstance);
}
