// Ticket History area:
public WebReply TicketHistory()
{
//Id,TicketId,Body,Added,updated,deleted
SQLDetective s = Sys.GetSectionSQL("Ticket History", "TicketHistory", this.ViewGuid);
Weblist w = new Weblist(Sys);
WebReply wr = w.GetWebList(s.GenerateQuery(), "Ticket History", "tickethistory", "Body", "TicketHistory", this, false);
return(wr);
}
public WebReply PictureList()
{
SQLDetective s = Sys.GetSectionSQL("Picture List", "Picture", string.Empty);
if (WhereClause.Length > 0)
{
s.WhereClause = WhereClause;
}
else
{
s.WhereClause = "Picture.Organization='" + Sys.Organization.ToString() + "' and Picture.Deleted=0 and Picture.ParentID = '" + this.ParentID.ToString() + "'";
}
string sql = s.GenerateQuery();
Weblist w = new Weblist(Sys);
WebReply wr = w.GetWebList(sql, "Picture List", "Picture List", "", "Picture", this, false);
return(wr);
}
public WebReply DocumentList()
{
SQLDetective s = Sys.GetSectionSQL("Document List", "Documents", string.Empty);
// If they are coming in from the search page
if (WhereClause.Length > 0)
{
s.WhereClause = WhereClause;
}
else
{
s.WhereClause = "Documents.Organization='" + Sys.Organization.ToString() + "' and Documents.deleted=0 and Documents.ParentID = '" + this.ParentID.ToString() + "'";
}
string sql = s.GenerateQuery();
Weblist w = new Weblist(Sys);
WebReply wr = w.GetWebList(sql, "Document List", "Document List", "", "Documents", this, false);
return(wr);
}
public WebReply TicketList()
{
//Produces a web list of Tickets assigned to the current user
SQLDetective s = Sys.GetSectionSQL("Ticket List", "Ticket", string.Empty);
// If they are coming in from the search page
if (WhereClause.Length > 0)
{
s.WhereClause = WhereClause;
}
else
{
if (ParentID == "")
{
ParentID = Sys.Organization.ToString();
}
s.WhereClause = "AssignedTo='" + Sys.UserGuid.ToString() + "' and Ticket.deleted=0 and Ticket.ParentID = '" + this.ParentID.ToString() + "'";
}
string sql = s.GenerateQuery();
Weblist w = new Weblist(Sys);
WebReply wr = w.GetWebList(sql, "My Tickets", "Ticket List", "", "Ticket", this, false);
return(wr);
}