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