public PromoterSet Promoters(ColumnSet cs)
{
if (promoters == null || !promotersColumns.Equals(cs))
{
Query q = new Query();
q.NoLock = true;
q.TableElement = Usr.PromoterJoin;
q.QueryCondition = new Q(PromoterUsr.Columns.UsrK, this.K);
q.OrderBy = new OrderBy(Promoter.Columns.Name);
q.Columns = cs;
promoters = new PromoterSet(q);
promotersColumns = cs;
}
return promoters;
}
public PhotoSet PhotosMe(ColumnSet cs, int topRecords)
{
if (photosMe == null)
{
Query q = new Query();
q.QueryCondition = new Q(Usr.Columns.K, this.K);
q.TableElement = Photo.UsrMeJoin;
q.OrderBy = Photo.DateTimeOrder(OrderBy.OrderDirection.Descending);
if (cs != null)
q.Columns = cs;
if (topRecords > 0)
q.TopRecords = topRecords;
photosMe = new PhotoSet(q);
}
return photosMe;
}
public EventSet EventsAttended(ColumnSet cs, int topRecords)
{
if (eventsAttended == null)
{
Query q = new Query();
q.QueryCondition = new Q(Usr.Columns.K, this.K);
q.TableElement = Event.UsrAttendedJoin;
if (cs != null)
q.Columns = cs;
if (topRecords > 0)
q.TopRecords = topRecords;
eventsAttended = new EventSet(q);
}
return eventsAttended;
}
public PlaceSet PlacesVisit(ColumnSet cs, int topRecords)
{
if (placesVisit == null)
{
Query q = new Query();
q.TableElement = Place.UsrVisitJoin;
if (cs != null)
q.Columns = cs;
if (topRecords > 0)
q.TopRecords = topRecords;
q.OrderBy = new OrderBy(Place.Columns.Population, OrderBy.OrderDirection.Descending);
q.QueryCondition = new Q(Usr.Columns.K, this.K);
placesVisit = new PlaceSet(q);
}
return placesVisit;
}
public InvoiceItemSet GetInvoiceItems(ColumnSet columns)
{
Query q = new Query();
q.QueryCondition = new Q(InvoiceItem.Columns.InvoiceK, this.K);
q.Columns = new ColumnSet(InvoiceItem.Columns.CustomData,
InvoiceItem.Columns.Description,
InvoiceItem.Columns.InvoiceK,
InvoiceItem.Columns.ItemProcessed,
InvoiceItem.Columns.K,
InvoiceItem.Columns.KeyData,
InvoiceItem.Columns.Price,
InvoiceItem.Columns.RevenueEndDate,
InvoiceItem.Columns.RevenueStartDate,
InvoiceItem.Columns.Total,
InvoiceItem.Columns.Type,
InvoiceItem.Columns.Vat);
return new InvoiceItemSet(q);
}
/// <summary>
/// This is needed when using Distinct
/// </summary>
/// <param name="overideString"></param>
/// <param name="overrideColumns"></param>
public OrderBy(string overideString, params object[] overrideColumns)
{
this.OverideString = overideString;
ColumnSet c = new ColumnSet(overrideColumns);
allColumns = c.Columns;
}