private void SaveReportTokens()
{
//update the datagrid so that the information is most up to date.
btnUpdateGrid_Click(null,null);
BEQuickReports.tbl_GeneratedReportTokensRow dr;
BPGeneratedReportTokens bp = new BPGeneratedReportTokens();
bp.DeleteByGeneratedReportID(GeneratedReportID);
foreach (Token tkn in gridDataSource)
{
dr = DSQuickReports.tbl_GeneratedReportTokens.Newtbl_GeneratedReportTokensRow();
dr.GeneratedReportID = GeneratedReportID;
dr.TokenID = tkn.TokenID;
if (tkn.Function != "-1" && tkn.Expression != "")
{
dr.TokenFilter = tkn.Function;
dr.TokenFilterExpression = tkn.Expression;
}
else
{
dr.SetTokenFilterNull();
dr.SetTokenFilterExpressionNull();
}
dr.TokenSort = tkn.ColumnSort;
dr.TokenOrder = tkn.TokenOrder;
dr.DataTypeID = tkn.DataTypeID;
if (ddlLetterColumn.SelectedValue == dr.TokenID.ToString() && ddlLinkColumn.SelectedValue == dr.TokenID.ToString())
{
dr.TokenType = Convert.ToInt32(QuickReport.TokenTypes.LinkLetterColumn);
}
else if (ddlLetterColumn.SelectedValue == dr.TokenID.ToString())
{
dr.TokenType = Convert.ToInt32(QuickReport.TokenTypes.LetterColumn);
}
else if (ddlLinkColumn.SelectedValue == dr.TokenID.ToString())
{
dr.TokenType = Convert.ToInt32(QuickReport.TokenTypes.LinkColumn);
}
else if (tkn.Hidden == true)
{
dr.TokenType = Convert.ToInt32(QuickReport.TokenTypes.Hidden);
}
else
{
dr.TokenType = Convert.ToInt32(QuickReport.TokenTypes.Regular);
}
DSQuickReports.tbl_GeneratedReportTokens.Addtbl_GeneratedReportTokensRow(dr);
}
bp.Update(DSQuickReports);
}
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);
}
