private void btnDelete_Click(object sender, EventArgs e) { BEQuickReports ds = new BEQuickReports(); BPGeneratedReports bpMain = new BPGeneratedReports(); BPGeneratedReportTokens bpTokens = new BPGeneratedReportTokens(); ds = bpMain.SelectByID(GeneratedReportID); ds.Merge(bpTokens.SelectByGeneratedReportID(GeneratedReportID)); ds.Relations.Add("Rel1",ds.tbl_GeneratedReports.Columns["GeneratedReportID"],ds.tbl_GeneratedReportTokens.Columns["GeneratedReportID"]); ds.EnforceConstraints = true; ds.tbl_GeneratedReports.FindByGeneratedReportID(GeneratedReportID).Delete(); bpMain.Update(ds); bpTokens.Update(ds); btnCancel_Click(null,null); }
private bool SaveBaseReport() { if (txtReportAlias.Text == "") { lblError2.Visible=true; return false; } else { lblError2.Visible = false; DSQuickReports = new BEQuickReports(); BEQuickReports.tbl_GeneratedReportsRow reportRow; BPGeneratedReports bpReport = new BPGeneratedReports(); if (GeneratedReportID == 0) { reportRow = DSQuickReports.tbl_GeneratedReports.Newtbl_GeneratedReportsRow(); reportRow.DateCreated = DateTime.Now; reportRow.CreatedByCompanyUserID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID); } else { DSQuickReports = bpReport.SelectAll(); reportRow = DSQuickReports.tbl_GeneratedReports.FindByGeneratedReportID(GeneratedReportID); } reportRow.QuickReportID = QuickReportID; reportRow.GeneratedReportType = Convert.ToInt32(GeneratedReportType); reportRow.GeneratedReportName = txtReportAlias.Text; reportRow.GeneralReport = Convert.ToBoolean(Convert.ToInt32(ddlVisibility.SelectedValue)); reportRow.GeneratedReportActive = true; reportRow.DateModified = DateTime.Now; reportRow.ModifiedByAdminID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID); reportRow.CompanyID = CompanyID; if (GeneratedReportID == 0) { DSQuickReports.tbl_GeneratedReports.Rows.Add(reportRow); } bpReport.Update(DSQuickReports); GeneratedReportID = reportRow.GeneratedReportID; return true; } }
protected void BrowseSelector_Bind() { BPGeneratedReports bp = new BPGeneratedReports(); ddlBrowseSelect.DataSource = bp.SelectGeneratedReportsByAdminIDQuickReportIDGeneratedReportTypeAndCompanyID(QuickReportID, 1, GlobalCompanyID, Convert.ToInt32(OryxUser.OryxIdentity.MemberID)).tbl_GeneratedReports; ddlBrowseSelect.DataTextField = "GeneratedReportName"; ddlBrowseSelect.DataValueField = "GeneratedReportID"; ddlBrowseSelect.DataBind(); //DO no need this line if there is already a default report ddlBrowseSelect.Items.Insert(0,new ListItem("Default", "-1")); }
private void FillTextBoxes() { if (GeneratedReportID != 0) { BPCompanyAliases bpAliases = new BPCompanyAliases(); Hashtable aliases = bpAliases.SelectColumnMappings(CompanyID); BPGeneratedReports bp = new BPGeneratedReports(); BPGeneratedReportTokens bpGRT = new BPGeneratedReportTokens(); BEQuickReports ds = new BEQuickReports(); ds = bp.SelectByID(GeneratedReportID); ds.Merge(bpGRT.SelectByGeneratedReportID(GeneratedReportID)); BEQuickReports.tbl_GeneratedReportsRow report = ds.tbl_GeneratedReports.FindByGeneratedReportID(GeneratedReportID); txtReportAlias.Text = report.GeneratedReportName; if (ddlVisibility.Items.FindByValue(Convert.ToInt32(report.GeneralReport).ToString()) != null) { ddlVisibility.SelectedValue = Convert.ToInt32(report.GeneralReport).ToString(); } QuickReportID = report.QuickReportID; GeneratedReportType = (QuickReport.GeneratedReportTypes) report.GeneratedReportType; gridDataSource.Fill(ds.tbl_GeneratedReportTokens, aliases); } }
protected void BindQuickReportsList() { BPGeneratedReports bp = new BPGeneratedReports(); DSQuickReports = bp.SelectGeneratedReportsByAdminIDQuickReportIDGeneratedReportTypeAndCompanyID(QuickReportID, GeneratedReportType, GlobalCompanyID, Convert.ToInt32(OryxUser.OryxIdentity.MemberID)); DSQuickReports.tbl_GeneratedReports.DefaultView.Sort = "GeneratedReportName"; }
private void GetNewDataSet() { BPGeneratedReports bp = new BPGeneratedReports(); dsBrowseGrid = bp.GenerateReport(Convert.ToInt32(GeneratedReportID), Convert.ToInt32(ddlCompanies.SelectedValue)); dsBrowseGrid.Tables[0].TableName = "Data"; dsBrowseGrid.Tables[1].TableName = "Info"; // ActiveColumn = dsBrowseGrid.Tables["Info"].Rows[0]["ActiveColumn"].ToString(); LetterColumn = dsBrowseGrid.Tables["Info"].Rows[0]["LetterColumn"].ToString(); LinkColumn = dsBrowseGrid.Tables["Info"].Rows[0]["LinkColumn"].ToString(); BuildGrid(); dgBrowseGrid.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue); dgBrowseGrid.GroupingPageSize = dgBrowseGrid.PageSize; BindDataGrid(); }
private void GetNewDataSet() { BPGeneratedReports bp = new BPGeneratedReports(); dsBrowseGrid = bp.GenerateReport(Convert.ToInt32(GeneratedReportID),Convert.ToInt32(ddlCompanies.SelectedValue)); dsBrowseGrid.Tables[0].TableName = "Data"; dsBrowseGrid.Tables[1].TableName = "Info"; DataRow[] tmpRow = dsBrowseGrid.Tables["Info"].Select("TokenType=" + Convert.ToInt32(QuickReport.TokenTypes.LetterColumn) + " or TokenType=" + Convert.ToInt32(QuickReport.TokenTypes.LinkLetterColumn)); if (tmpRow.Length > 0) { LetterColumn = tmpRow[0]["TokenAlias"].ToString(); } else { LetterColumn = ""; } tmpRow = dsBrowseGrid.Tables["Info"].Select("TokenType=" + Convert.ToInt32(QuickReport.TokenTypes.LinkColumn) + " or TokenType=" + Convert.ToInt32(QuickReport.TokenTypes.LinkLetterColumn)); if (tmpRow.Length > 0) { LinkColumn = tmpRow[0]["TokenAlias"].ToString(); } else { LinkColumn = ""; } ActiveColumn = "InternalOrderCurrent"; BuildGrid(); dgBrowseGrid.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue); dgBrowseGrid.GroupingPageSize = dgBrowseGrid.PageSize; BindDataGrid(); }
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.SelectedIndex = -1; ddlBrowseSelect.Items.Clear(); BPGeneratedReports bp = new BPGeneratedReports(); ddlBrowseSelect.DataSource = bp.SelectGeneratedReportsByAdminIDQuickReportIDGeneratedReportTypeAndCompanyID(QuickReportID, 1, GlobalCompanyID, Convert.ToInt32(OryxUser.OryxIdentity.MemberID)).tbl_GeneratedReports; ddlBrowseSelect.DataTextField = "GeneratedReportName"; ddlBrowseSelect.DataValueField = "GeneratedReportID"; ddlBrowseSelect.DataBind(); ListItem tmpItem = ddlBrowseSelect.Items.FindByValue(GeneratedReportID.ToString()); if (tmpItem == null) { ddlBrowseSelect.Items[0].Selected = true; } else { tmpItem.Selected = true; } GeneratedReportID = Convert.ToInt32(ddlBrowseSelect.SelectedValue); }
private void GetNewDataSet() { BPGeneratedReports bp = new BPGeneratedReports(); dsBrowseGrid = bp.GenerateReport(Convert.ToInt32(GeneratedReportID),Convert.ToInt32(ddlCompanies.SelectedValue)); dsBrowseGrid.Tables[0].TableName = "Data"; dsBrowseGrid.Tables[1].TableName = "Info"; // ActiveColumn = dsBrowseGrid.Tables["Info"].Rows[0]["ActiveColumn"].ToString(); LetterColumn = dsBrowseGrid.Tables["Info"].Rows[0]["LetterColumn"].ToString(); LinkColumn = dsBrowseGrid.Tables["Info"].Rows[0]["LinkColumn"].ToString(); foreach (DataColumn dc in dsBrowseGrid.Tables["Data"].Columns) { if (dc.ColumnName.ToLower().StartsWith("internal") == true) { dc.ColumnMapping = MappingType.Hidden; } } BuildGrid(); dgBrowseGrid.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue); dgBrowseGrid.GroupingPageSize = dgBrowseGrid.PageSize; BindDataGrid(); }
protected void BrowseSelector_Bind() { ddlBrowseSelect.Items.Clear(); BPGeneratedReports bp = new BPGeneratedReports(); ddlBrowseSelect.DataSource = bp.SelectByAdminIDandQuickReportID(OryxUser.OryxIdentity.MemberID,QuickReportID).tbl_GeneratedReports; ddlBrowseSelect.DataTextField = "GeneratedReportName"; ddlBrowseSelect.DataValueField = "GeneratedReportID"; ddlBrowseSelect.DataBind(); }
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 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(); }