/// <summary>
/// List requests
/// </summary>
/// <param name="StatusIn"></param>
/// <returns></returns>
public static List <ProcessRequest> List(ProcessRequest.StatusValue StatusIn)
{
var result = new List <ProcessRequest>();
var checktype = " WHERE [Status] = '" + StatusIn.ToString() + "'";
if (StatusIn == ProcessRequest.StatusValue.ALL)
{
checktype = "";
}
using (var connection = new SqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
FieldString() +
" FROM [ProcessRequest] " +
checktype
);
using (var command = new SqlCommand(
commandString, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
var _ProcessRequest = new ProcessRequest();
ProcessRequest.LoadFromReader(_ProcessRequest, reader);
// Load Arguments
//
_ProcessRequest.argumentList = ProcessRequestArguments.List(_ProcessRequest.UID);
result.Add(_ProcessRequest);
}
}
}
}
return(result);
}
