public List <FieldPreValueSource> GetAllPrevalueSources()
{
List <FieldPreValueSource> l = new List <FieldPreValueSource>();
string sql = "SELECT * From UFPrevalueSources ORDER BY name ASC";
IRecordsReader rr = sqlHelper.ExecuteReader(sql);
while (rr.Read())
{
FieldPreValueSource pv = FieldPreValueSource.CreateFromDataReader(rr);
pv.Settings = settings.GetSettings(pv.Id);
l.Add(pv);
}
rr.Dispose();
return(l);
}
public List <Workflow> GetActiveWorkFlows()
{
string sql = "SELECT * from UFworkflows where Active = 1 ORDER by Name ASC";
IRecordsReader rr = sqlHelper.ExecuteReader(sql);
List <Workflow> l = new List <Workflow>();
while (rr.Read())
{
Workflow wf = Workflow.CreateFromDataReader(rr);
wf.Settings = settings.GetSettings(wf.Id);
//if the type is missing, it will deactivate, the type will be missing if 3rd party dll is gone
//this way we avoid non-existing workflows from trying to execute
//the UI should reflect it this.
if (wf.Active)
{
l.Add(wf);
}
}
rr.Dispose();
return(l);
}
