public BEQuickReports SelectAll()
{
BEQuickReports ds = new BEQuickReports();
DATokens da = new DATokens();
da.SelectAll(ds.tbl_Tokens);
return ds;
}
public BEQuickReports SelectByQuickReportID(int quickReportID)
{
BEQuickReports ds = new BEQuickReports();
DATokens da = new DATokens();
da.SelectByQuickReportID(quickReportID, ds.tbl_Tokens);
return ds;
}
public BEQuickReports SelectByID(int TokenID)
{
BEQuickReports ds = new BEQuickReports();
DATokens da = new DATokens();
da.SelectByID(TokenID.ToString(), ds.tbl_Tokens);
return ds;
}
public BEQuickReports SelectByGeneratedReportID(int generatedReportID)
{
BEQuickReports ds = new BEQuickReports();
DATokens da = new DATokens();
da.SelectByGeneratedReportID(generatedReportID, ds.tbl_Tokens);
return ds;
}
public BEQuickReports SelectByTokenCategoryID(int TokenCategoryID)
{
BEQuickReports ds = new BEQuickReports();
DATokens da = new DATokens();
da.SelectByTokenCategoryID(TokenCategoryID, ds.tbl_Tokens);
return ds;
}
protected void BindQuickReportsList()
{
BPGeneratedReports bp = new BPGeneratedReports();
DSQuickReports = bp.SelectGeneratedReportsByAdminIDQuickReportIDGeneratedReportTypeAndCompanyID(QuickReportID, GeneratedReportType, GlobalCompanyID, Convert.ToInt32(OryxUser.OryxIdentity.MemberID));
DSQuickReports.tbl_GeneratedReports.DefaultView.Sort = "GeneratedReportName";
}
public LinkButtonTemplate(string columnName, int generatedReportID)
{
_ColumnName = columnName;
BPQuickReports bp = new BPQuickReports();
BEQuickReports DSQuickReports = new BEQuickReports();
DSQuickReports = bp.SelectByGeneratedReportID(generatedReportID);
_editPage = ((BEQuickReports.tbl_QuickReportsRow) DSQuickReports.tbl_QuickReports.Rows[0]).EditPage;
_primaryKey = ((BEQuickReports.tbl_QuickReportsRow) DSQuickReports.tbl_QuickReports.Rows[0]).TablePrimaryKey;
}
public BEQuickReports SelectByAdminIDandQuickReportID(int adminID, int quickReportID)
{
BEQuickReports ds = new BEQuickReports();
DAGeneratedReports da = new DAGeneratedReports();
da.SelectByAdminIDandQuickReportID(adminID, quickReportID, ds.tbl_GeneratedReports);
return ds;
}
public void Remove(BEQuickReports.tbl_TokensRow row)
{
Token tkn = GetTokenByTokenID(row.TokenID);
if (tkn != null)
{
this.InnerList.Remove(tkn);
}
}
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;
}
}
public BEQuickReports SelectByCompanyUserIDandQuickReportIDAndCompanyID(int companyUserID, int QuickReportID, int CompanyID)
{
BEQuickReports ds = new BEQuickReports();
DAGeneratedReports da = new DAGeneratedReports();
da.SelectByCompanyUserIDAndQuickReportIDAndCompanyID(companyUserID, QuickReportID, CompanyID, ds.tbl_GeneratedReports);
return ds;
}
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);
}
}
public void Update(BEQuickReports ds)
{
DAGeneratedReportTokens da = new DAGeneratedReportTokens();
da.Update(ds.tbl_GeneratedReportTokens);
}
public BEQuickReports SelectGeneratedReportsByQuickReportIDAndGeneratedReportTypeAndCompanyUserID(int QuickReportID, int GeneratedReportType, int companyUserID)
{
BEQuickReports ds = new BEQuickReports();
DAGeneratedReports da = new DAGeneratedReports();
da.SelectGeneratedReportsByQuickReportIDAndGeneratedReportTypeAndCompanyUserID(QuickReportID, GeneratedReportType, companyUserID, ds.tbl_GeneratedReports);
return ds;
}
public BEQuickReports SelectGeneratedReportsByQuickReportIDAndGeneratedReportType(int QuickReportID, int GeneratedReportType)
{
BEQuickReports ds = new BEQuickReports();
DAGeneratedReports da = new DAGeneratedReports();
da.SelectGeneratedReportsByQuickReportIDAndGeneratedReportType(QuickReportID, GeneratedReportType, ds.tbl_GeneratedReports);
return ds;
}
public BEQuickReports SelectGeneratedReportsByQuickReportID(int QuickReportID)
{
BEQuickReports ds = new BEQuickReports();
DAGeneratedReports da = new DAGeneratedReports();
da.SelectGeneratedReportsByQuickReportID(QuickReportID, ds.tbl_GeneratedReports);
return ds;
}
public Token(BEQuickReports.tbl_TokensRow row, string companyColumnAlias)
{
_TokenID = row.TokenID;
_TokenAlias = row.TokenAlias.Replace('_',' '); //.Replace added, part of bug fix 20090603 - hs;
_CompanyColumnAlias = companyColumnAlias;
_DataType = (QuickReport.DataTypes) row.DataTypeID;
_TokenType = QuickReport.TokenTypes.Regular;
}
private void btnCancel_Click(object sender, System.EventArgs e)
{
if(GeneratedReportType == QuickReport.GeneratedReportTypes.Report)
{
Response.Redirect("BrowseQuickReports.aspx?QuickReportID=" + Convert.ToInt32(QuickReportID));
}
else
{
BPQuickReports bp = new BPQuickReports();
DSQuickReports = bp.SelectByID(QuickReportID);
BEQuickReports.tbl_QuickReportsRow quickReport = DSQuickReports.tbl_QuickReports.FindByQuickReportID(QuickReportID);
Response.Redirect(quickReport.BrowsePage);
}
}
public Token(BEQuickReports.tbl_GeneratedReportTokensRow row, string companyColumnAlias)
{
_TokenID = row.TokenID;
_TokenAlias = row.TokenAlias.Replace('_',' '); //.Replace added, part of bug fix 20090603 - hs;
_CompanyColumnAlias = companyColumnAlias;
_Hidden = (row.TokenType == Convert.ToInt32(QuickReport.TokenTypes.Hidden));
_TokenOrder = row.TokenOrder;
switch(row.TokenSort)
{
case 0:
{
SortBy = false;
SortDirection = "asc";
break;
}
case 1:
{
SortBy = true;
SortDirection = "asc";
break;
}
case 2:
{
SortBy = true;
SortDirection = "desc";
break;
}
}
_DataType = (QuickReport.DataTypes) row.DataTypeID;
_TokenType = (QuickReport.TokenTypes) row.TokenType;
if (! row.IsTokenFilterNull())
{
_Function = row.TokenFilter;
string Expression = row.TokenFilterExpression.Replace("'","").Replace(" AND ","|");
switch(_DataType)
{
case QuickReport.DataTypes.DateTime:
{
if (Function == "between")
{
DateFrom = Convert.ToDateTime(Expression.Split('|')[0]);
DateTo = Convert.ToDateTime(Expression.Split('|')[1]);
}
else
{
SingleDate = Convert.ToDateTime(Expression);
}
break;
}
case QuickReport.DataTypes.Boolean:
{
ActiveValue = Expression;
break;
}
case QuickReport.DataTypes.Integer:
case QuickReport.DataTypes.String:
{
if (Function == "between")
{
strFrom = Expression.Split('|')[0];
strTo = Expression.Split('|')[1];
}
else
{
SingleText = Expression;
}
break;
}
}
}
}
protected void FillAvailableTokens()
{
ddlAvailableTokens.Items.Clear();
if (ddlTokenCategories.SelectedValue != "0")
{
BPTokens bpTokens = new BPTokens();
BEQuickReports dsTokens = new BEQuickReports();
BPCompanyAliases bpAliases = new BPCompanyAliases();
Hashtable aliases = bpAliases.SelectColumnMappings(CompanyID);
dsTokens = bpTokens.SelectByTokenCategoryID(Convert.ToInt32(ddlTokenCategories.SelectedValue));
ListItem item;
foreach (BEQuickReports.tbl_TokensRow row in dsTokens.tbl_Tokens)
{
item = new ListItem();
item.Value = row.TokenID.ToString();
if (!row.LookupAlias)
{
item.Text = row.TokenAlias.Replace('_',' ');
ddlAvailableTokens.Items.Add(item);
}
else
{
string columnName = row.TokenColumns.Replace("|","");
if (aliases.Count > 0 && aliases.ContainsKey(columnName) && aliases[columnName].ToString()!="")
{
item.Text = aliases[columnName].ToString();
ddlAvailableTokens.Items.Add(item);
}
else if (! columnName.StartsWith("ExtraColumn"))
{
item.Text = row.TokenAlias.Replace('_',' ');
ddlAvailableTokens.Items.Add(item);
}
}
}
}
}
private void btnGenerate_Click(object sender, EventArgs e)
{
if (GeneratedReportID == 0)
{
lblError.Visible = true;
}
else
{
if (GeneratedReportType == QuickReport.GeneratedReportTypes.Browse)
{
BPQuickReports bp = new BPQuickReports();
DSQuickReports = bp.SelectByID(QuickReportID);
BEQuickReports.tbl_QuickReportsRow quickReport = DSQuickReports.tbl_QuickReports.FindByQuickReportID(QuickReportID);
Response.Redirect(quickReport.BrowsePage + "?GeneratedReportID=" + GeneratedReportID);
}
else
{
Response.Redirect("ViewReport.aspx?GeneratedReportID=" + GeneratedReportID + "&CompanyID=" + CompanyID);
}
}
}
public BEQuickReports SelectAll()
{
BEQuickReports ds = new BEQuickReports();
DAGeneratedReports da = new DAGeneratedReports();
da.SelectAll(ds.tbl_GeneratedReports);
return ds;
}
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);
}
public void Update(BEQuickReports ds)
{
DATokens da = new DATokens();
da.Update(ds.tbl_Tokens);
}
protected void FillSelectedTokens()
{
if (GeneratedReportID > 0)
{
ddlSelectedTokens.Items.Clear();
BPTokens bpTokens = new BPTokens();
BEQuickReports dsTokens = new BEQuickReports();
BPCompanyAliases bpAliases = new BPCompanyAliases();
Hashtable aliases = bpAliases.SelectColumnMappings(CompanyID);
dsTokens = bpTokens.SelectByGeneratedReportID(GeneratedReportID);
ListItem item;
foreach (BEQuickReports.tbl_TokensRow row in dsTokens.tbl_Tokens)
{
item = new ListItem();
item.Value = row.TokenID.ToString().Replace('_',' ');
if (!row.LookupAlias)
{
item.Text = row.TokenAlias.Replace('_',' '); //.Replace added, part of bug fix 20090603 - hs
}
else
{
string columnName = row.TokenColumns.Replace("|","");
if (aliases.Count > 0 && aliases.ContainsKey(columnName) && aliases[columnName].ToString()!="")
{
item.Text = aliases[columnName].ToString();
}
else
{
item.Text = row.TokenAlias.Replace('_',' ');
}
}
ddlSelectedTokens.Items.Add(item);
SelectedTokens.Value += item.Value + ",";
}
}
}
private void GetQuickReportID()
{
BPQuickReports bp = new BPQuickReports();
DSGeneratedReports = bp.SelectByGeneratedReportID(GeneratedReportID);
if (DSGeneratedReports.tbl_QuickReports.Count > 0)
{
BEQuickReports.tbl_QuickReportsRow row = DSGeneratedReports.tbl_QuickReports[0];
QuickReportID = row.QuickReportID;
// lblTitle.Text = row.GeneratedReportName;
}
}
public void Add(BEQuickReports.tbl_TokensRow row, string companyColumnAlias)
{
Token tkn = new Token(row, companyColumnAlias);
tkn.TokenOrder = this.InnerList.Count + 1;
this.InnerList.Add(tkn);
Sort();
}
private void SaveToken_Click(object sender, EventArgs e)
{
if (txtResult.Text.Length > 0 && txtTokenAlias.Text.Length >0)
{
BPTokens bp = new BPTokens();
BEQuickReports ds = new BEQuickReports();
BEQuickReports.tbl_TokensRow row = ds.tbl_Tokens.Newtbl_TokensRow();
row.TokenAlias = txtTokenAlias.Text;
row.TokenColumns = txtResult.Text;
row.TokenCategoryID = Convert.ToInt32(ddlCategories.SelectedValue);
row.QuickReportID = Convert.ToInt32(ddlTables.SelectedItem.Value);
ds.tbl_Tokens.Rows.Add(row);
bp.Update(ds);
}
else
{
lblError2.Visible = true;
}
}
public void Fill(BEQuickReports.tbl_GeneratedReportTokensDataTable table, Hashtable aliases)
{
this.List.Clear();
string companyColumnAlias = "";
foreach (BEQuickReports.tbl_GeneratedReportTokensRow row in table)
{
if (row.LookupAlias)
{
string columnName = row.TokenColumns.Replace("|","");
if (aliases.Count > 0 && aliases.ContainsKey(columnName) && aliases[columnName].ToString()!="")
{
companyColumnAlias = aliases[columnName].ToString();
}
else
{
companyColumnAlias = row.TokenAlias.Replace('_',' ');
}
}
else
{
companyColumnAlias = "";
}
Token tk = new Token(row, companyColumnAlias);
this.List.Add(tk);
}
Sort();
}
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";
}