public ParameterSystemObjectCollection GetAll()
{
ParameterSystemObjectCollection parameters = new ParameterSystemObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendOrderBy(ParameterSystemObject.KEYNAME, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
parameters = ParameterSystemConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(parameters);
}
public ParameterSystemObject GetByKeyName(string keyName)
{
ParameterSystemObjectCollection parameters = new ParameterSystemObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(ParameterSystemObject.KEYNAME, keyName, QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
builder.AppendOrderBy(ParameterSystemObject.KEYNAME, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
parameters = ParameterSystemConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
if (parameters.Count > 0)
{
return(parameters[0]);
}
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(null);
}