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; } }
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); }