private void LoadReports()
{
BPQuickReports bp = new BPQuickReports();
ddlReports.DataSource = bp.SelectAll();
ddlReports.DataMember = "tbl_QuickReports";
ddlReports.DataTextField = "QuickReportAlias";
ddlReports.DataValueField = "QuickReportID";
ddlReports.DataBind();
ddlReports.Items.Insert(0,new ListItem("All Reports","0"));
}
private void LoadTables()
{
ddlTables.Items.Clear();
BPQuickReports bp = new BPQuickReports();
if (ddlReports.SelectedValue == "0")
{
//ddlTables.DataSource = bp.SelectAll();
}
else
{
ddlTables.DataSource = bp.SelectByID(Convert.ToInt32(ddlReports.SelectedValue));
}
ddlTables.DataMember = "tbl_QuickReports";
ddlTables.DataTextField = "TableName";
ddlTables.DataValueField = "QuickReportID";
ddlTables.DataBind();
ddlTables.Items.Insert(0,new ListItem("Select Table","0"));
}
private void btnCancel_Click(object sender, System.EventArgs e)
{
if(GeneratedReportType == QuickReport.GeneratedReportTypes.Report)
{
Response.Redirect("BrowseQuickReports.aspx?QuickReportID=" + Convert.ToInt32(QuickReportID));
}
else
{
BPQuickReports bp = new BPQuickReports();
DSQuickReports = bp.SelectByID(QuickReportID);
BEQuickReports.tbl_QuickReportsRow quickReport = DSQuickReports.tbl_QuickReports.FindByQuickReportID(QuickReportID);
Response.Redirect(quickReport.BrowsePage);
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (GeneratedReportID == 0)
{
lblError.Visible = true;
}
else
{
if (GeneratedReportType == QuickReport.GeneratedReportTypes.Browse)
{
BPQuickReports bp = new BPQuickReports();
DSQuickReports = bp.SelectByID(QuickReportID);
BEQuickReports.tbl_QuickReportsRow quickReport = DSQuickReports.tbl_QuickReports.FindByQuickReportID(QuickReportID);
Response.Redirect(quickReport.BrowsePage + "?GeneratedReportID=" + GeneratedReportID);
}
else
{
Response.Redirect("ViewReport.aspx?GeneratedReportID=" + GeneratedReportID + "&CompanyID=" + CompanyID);
}
}
}
private void GetQuickReportID()
{
DataSet ds;
BPQuickReports bp = new BPQuickReports();
string PageName = Request.ServerVariables["script_name"];
PageName = PageName.Substring(PageName.LastIndexOf('/') + 1);
ds = bp.SelectQuickReportIdByBrowsePage(PageName);
switch (ds.Tables[0].Rows.Count)
{
case 0:
break;
case 1:
QuickReportID = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
break;
default:
break;
}
}
public LinkButtonTemplate(string columnName, int generatedReportID)
{
_ColumnName = columnName;
BPQuickReports bp = new BPQuickReports();
BEQuickReports DSQuickReports = new BEQuickReports();
DSQuickReports = bp.SelectByGeneratedReportID(generatedReportID);
_editPage = ((BEQuickReports.tbl_QuickReportsRow) DSQuickReports.tbl_QuickReports.Rows[0]).EditPage;
_primaryKey = ((BEQuickReports.tbl_QuickReportsRow) DSQuickReports.tbl_QuickReports.Rows[0]).TablePrimaryKey;
}
private void GetQuickReportID()
{
BPQuickReports bp = new BPQuickReports();
DSGeneratedReports = bp.SelectByGeneratedReportID(GeneratedReportID);
if (DSGeneratedReports.tbl_QuickReports.Count > 0)
{
BEQuickReports.tbl_QuickReportsRow row = DSGeneratedReports.tbl_QuickReports[0];
QuickReportID = row.QuickReportID;
// lblTitle.Text = row.GeneratedReportName;
}
}
