public void Reinitialize()
{
DQManager = new DataQueryManager(Type, ViewID);
LoadView();
SetPageColSpan();
this.Visible = true;
}
protected void Reload()
{
DataQueryManager DataQueryManager = new DataQueryManager(Type, ViewID);
var usableFields = DataQueryManager.GetAllFields();
ddlFilterColumn.DataSource = usableFields.OrderBy(r => r.Text);
ddlFilterColumn.DataBind();
lnkAdd.Visible = ShowAdd;
}
protected void LoadView(AdminDataQuery query)
{
DQManager = new DataQueryManager(Type, ViewID);
DataTableSchema = DQManager.GetSchema();
ddlFields.Items.Clear();
ddlFields.Items.Add(new ListItem("Add a new Column", String.Empty));
ddlFields.DataSource = DQManager.usableFields;
ddlFields.DataBind();
Columns = DQManager.GetSchema().Count();
dpMain.PageSize = _ItemsPerPage;
SetPageColSpan();
rptHeader.DataSource = DataTableSchema;
rptHeader.DataBind();
if (DataSet != null)
{
var items = (from p in DataSet
select p).ToArray();
if (items.Any() && !(items.First() is ListOrderItem))
{
CanOrder = false;
}
IEnumerable <ListData> data = FormData();
data = FilterDownForMail(data);
IsDataEmpty = !data.Any();
lvItems.DataSource = data.ToList();
lvItems.DataBind();
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
DQManager = new DataQueryManager(Type, ViewID);
DQManager.IncludeDataReference = rbMailOut.Checked || rbEmail.Checked;
CSVExport.GenericExport(DQManager.GetSchema(), FilterDownForMail(FormData()), Response, DQManager.GetDataTable().TableReference);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session[SessionView] != null)
{
ddlChangeView.SelectedValue = (string)Session[SessionView];
}
if (ddlChangeView.SelectedValue == "-1")
{
ViewID = ((AdminPage)Page).AdminUser.ID;
}
else
{
ViewID = DefaultviewID;
}
}
else
{
ViewID = Convert.ToInt32(ddlChangeView.SelectedValue);
}
DQManager = new DataQueryManager(Type, ViewID);
ddlChangeView.Visible = ShowCustomisation;
ddlFields.Visible = ShowCustomisation;
pnlQueryManager.Visible = ShowCustomisation;
db = ((AdminPage)Page).db;
btnExport.EventHandler = btnExport_Click;
btnExport.Visible = _ShowExport;
ucDataQuery.Type = Type;
ucDataQuery.ReloadContainer = ReloadFilters;
if (!Page.IsPostBack && Type != null)
{
rbMailOut.Checked = Request.QueryString["mailout"] == Boolean.TrueString;
rbEmail.Checked = Request.QueryString["emailing"] == Boolean.TrueString;
chkGroupByRelationship.Checked = Request.QueryString["groupbyrel"] == Boolean.TrueString;
chkGroupByAddress.Checked = Request.QueryString["groupbyaddress"] == Boolean.TrueString;
if (!String.IsNullOrEmpty(Request.QueryString["query"]))
{
RePopulateQueriesList();
var query = Request.QueryString["query"];
ddlExistingQueries.SelectedValue = Request.QueryString["query"];
UpdateCurrentQuery(Request.QueryString["query"]);
}
ReloadFilters(sender, e);
LoadView();
RePopulateQueriesList();
}
this.Visible = Type != null;
pnlCustomQuery.Visible = ParsedViaQuery;
// pnlCustomQuery.Visible = ((AdminPage)Page).AdminUser.IsMasterAdmin;
}
