public UnknownObject GetUnknownByEmail(string email)
{
UnknownObject unknown = new UnknownObject();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendWhereString(UnknownObject.EMAIL, email, QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
DataSet result = this.ExecuteDataSet(builder.Query, false);
if (result.Tables[0].Rows.Count > 0)
{
unknown = UnknownConvertor.UnknownRowToObject(result.Tables[0].Rows[0]);
}
else
{
return(null);
}
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(unknown);
}
public static TaskPeopleObject TaskPeopleRowToObject(DataRow taskPeople)
{
TaskPeopleObject obj = new TaskPeopleObject();
try
{
if (taskPeople != null)
{
obj.TpeopID = RowFunctions.GetValueFromRowToGuid(taskPeople, TaskPeopleObject.TPEOP_ID, true, DataRowVersion.Current);
obj.Employee = EmployeeConvertor.EmployeeRowToObject(taskPeople, EmployeeObject.TABLE);
obj.Supplier = SupplierConvertor.SupplierRowToObject(taskPeople);
obj.Customer = CustomerConvertor.CustomerRowToObject(taskPeople);
obj.Unknown = UnknownConvertor.UnknownRowToObject(taskPeople);
obj.Assignee = RowFunctions.GetValueFromRowToBoolean(taskPeople, TaskPeopleObject.ASSIGNEE, true, DataRowVersion.Current);
obj.Reporter = RowFunctions.GetValueFromRowToBoolean(taskPeople, TaskPeopleObject.REPORTER, true, DataRowVersion.Current);
obj.Task = TaskConvertor.TaskRowToObject(taskPeople);
return(obj);
}
obj = null;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return(obj);
}
public UnknownObjectCollection GetAll()
{
UnknownObjectCollection unknowns = new UnknownObjectCollection();
QueryBuilder builder;
try
{
builder = new QueryBuilder();
builder.Append(this.BaseQuery(false, 0));
builder.AppendOrderBy(UnknownObject.EMAIL, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
unknowns = UnknownConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(unknowns);
}
