protected void BrowseSelector_Bind() { BPGeneratedReports bp = new BPGeneratedReports(); ddlBrowseSelect.DataSource = bp.SelectGeneratedReportsByQuickReportIDAndGeneratedReportTypeAndCompanyUserID(QuickReportID, Convert.ToInt32(QuickReport.GeneratedReportTypes.Browse), OryxUser.OryxIdentity.MemberID); // ddlBrowseSelect.DataSource = bp.SelectByCompanyUserIDandQuickReportIDAndCompanyID(OryxUser.OryxIdentity.MemberID,QuickReportID, CompanyID).tbl_GeneratedReports; ddlBrowseSelect.DataTextField = "GeneratedReportName"; ddlBrowseSelect.DataValueField = "GeneratedReportID"; ddlBrowseSelect.DataBind(); //DO no need this line if there is already a default report but as is for the orders index cannot create one. ddlBrowseSelect.Items.Insert(0,new ListItem("Default", "-1")); }
protected void BindQuickReportsList() { BPGeneratedReports bp = new BPGeneratedReports(); DSQuickReports = bp.SelectGeneratedReportsByQuickReportIDAndGeneratedReportTypeAndCompanyUserID(QuickReportTableID, GeneratedReportType, OryxUser.OryxIdentity.MemberID); //filter out all but the the ones this user made. DSQuickReports.tbl_GeneratedReports.DefaultView.Sort = "GeneratedReportName"; }
protected void BrowseSelector_Bind() { ddlBrowseSelect.Items.Clear(); BPGeneratedReports bp = new BPGeneratedReports(); ddlBrowseSelect.DataSource = bp.SelectGeneratedReportsByQuickReportIDAndGeneratedReportTypeAndCompanyUserID(QuickReportID, Convert.ToInt32(QuickReport.GeneratedReportTypes.Browse), OryxUser.OryxIdentity.MemberID); // ddlBrowseSelect.DataSource = bp.SelectByCompanyUserIDandQuickReportID(OryxUser.OryxIdentity.MemberID,QuickReportID).tbl_GeneratedReports; ddlBrowseSelect.DataTextField = "GeneratedReportName"; ddlBrowseSelect.DataValueField = "GeneratedReportID"; ddlBrowseSelect.DataBind(); }