protected void btnSave_Click(object sender, EventArgs e)
{
ReportTablesSchema original_reportTablesSchema = new ReportTablesSchema();
reportsManager = new ReportsManager(this);
reportTablesSchema = new ReportTablesSchema();
if (reportTablesSchemaId != 0)
{
original_reportTablesSchema = reportsManager.GetTableSchema(reportTablesSchemaId);
reportTablesSchema.CopyPropertiesFrom(original_reportTablesSchema);
}
reportTablesSchema.Name = txtName.Text;
reportTablesSchema.SqlText = txtSqltext.Text;
if (reportTablesSchemaId != 0)
reportsManager.Update(original_reportTablesSchema, reportTablesSchema);
else
{
reportsManager.Insert(reportTablesSchema);
Response.Redirect("DynamicReport.aspx?ReportTablesSchemaId=" + reportTablesSchema.ReportTablesSchemaId);
}
// Server.Transfer("dynamicReports.aspx");
// Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "location='Customer.aspx?CustomerId=" + customer.CustomerId + "';", true);
}
protected void btnSave_Click(object sender, EventArgs e)
{
ReportTablesSchema original_reportTablesSchema = new ReportTablesSchema();
reportsManager = new ReportsManager(this);
reportTablesSchema = new ReportTablesSchema();
if (reportTablesSchemaId != 0)
{
original_reportTablesSchema = reportsManager.GetTableSchema(reportTablesSchemaId);
reportTablesSchema.CopyPropertiesFrom(original_reportTablesSchema);
}
reportTablesSchema.Name = txtName.Text;
reportTablesSchema.SqlText = txtSqltext.Text;
if (reportTablesSchemaId != 0)
{
reportsManager.Update(original_reportTablesSchema, reportTablesSchema);
}
else
{
reportsManager.Insert(reportTablesSchema);
Response.Redirect("DynamicReport.aspx?ReportTablesSchemaId=" + reportTablesSchema.ReportTablesSchemaId);
}
// Server.Transfer("dynamicReports.aspx");
// Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "location='Customer.aspx?CustomerId=" + customer.CustomerId + "';", true);
}
protected void btnSaveReportColumnsSchema_Click(object sender, EventArgs e)
{
var reportsManager = new ReportsManager(this);
var reportColumnsSchema = new ReportColumnsSchema();
ReportColumnsSchema original_reportColumnsSchema = new ReportColumnsSchema();
if (reportTablesSchemaId > 0)
{
original_reportColumnsSchema = reportsManager.GetColumnSchema(reportTablesSchemaId, reportColumnsSchemaId);
reportColumnsSchema.CopyPropertiesFrom(original_reportColumnsSchema);
}
reportColumnsSchema.ReportTablesSchemaId = reportTablesSchemaId;
reportColumnsSchema.Name = txtReportColumnsSchemaName.Text;
reportColumnsSchema.Source = txtSource.Text;
reportColumnsSchema.ReportDataTypeId = Convert.ToInt32(cboReportDataType.SelectedValue);
reportColumnsSchema.ForeignKey = txtForeignKey.Text;
reportColumnsSchema.PrimaryKey = txtPrimaryKey.Text;
reportColumnsSchema.PrimaryTable = txtPrimaryTable.Text;
reportColumnsSchema.PrimaryLabelColumn = txtPrimaryLabelColumn.Text;
if (reportColumnsSchemaId > 0)
reportsManager.Update(original_reportColumnsSchema, reportColumnsSchema);
else
reportsManager.Insert(reportColumnsSchema);
Response.Redirect("DynamicReportFields.aspx?ReportTablesSchemaId=" + Request["ReportTablesSchemaId"]);
}
protected void btnSaveReportColumnsSchema_Click(object sender, EventArgs e)
{
var reportsManager = new ReportsManager(this);
var reportColumnsSchema = new ReportColumnsSchema();
ReportColumnsSchema original_reportColumnsSchema = new ReportColumnsSchema();
if (reportTablesSchemaId > 0)
{
original_reportColumnsSchema = reportsManager.GetColumnSchema(reportTablesSchemaId, reportColumnsSchemaId);
reportColumnsSchema.CopyPropertiesFrom(original_reportColumnsSchema);
}
reportColumnsSchema.ReportTablesSchemaId = reportTablesSchemaId;
reportColumnsSchema.Name = txtReportColumnsSchemaName.Text;
reportColumnsSchema.Source = txtSource.Text;
reportColumnsSchema.ReportDataTypeId = Convert.ToInt32(cboReportDataType.SelectedValue);
reportColumnsSchema.ForeignKey = txtForeignKey.Text;
reportColumnsSchema.PrimaryKey = txtPrimaryKey.Text;
reportColumnsSchema.PrimaryTable = txtPrimaryTable.Text;
reportColumnsSchema.PrimaryLabelColumn = txtPrimaryLabelColumn.Text;
if (reportColumnsSchemaId > 0)
{
reportsManager.Update(original_reportColumnsSchema, reportColumnsSchema);
}
else
{
reportsManager.Insert(reportColumnsSchema);
}
Response.Redirect("DynamicReportFields.aspx?ReportTablesSchemaId=" + Request["ReportTablesSchemaId"]);
}