void PersistColumnsSelected() { ReportsManager manager = new ReportsManager(null); if (!String.IsNullOrEmpty(Request["OrderedColumnsHidden"])) { Page.Settings.Columns.Clear(); string[] values = Request["OrderedColumnsHidden"].Trim(',').Split(','); foreach (string value in values) { if (!String.IsNullOrEmpty(value)) { ReportColumnsSchema columnSchema = manager.GetColumnSchema(Page.Settings.Report.ReportTablesSchemaId.Value, Convert.ToInt32(value)); ReportColumn column = new ReportColumn(); column.ReportColumnsSchemaId = columnSchema.ReportColumnsSchemaId; column.ReportTablesSchemaId = columnSchema.ReportTablesSchemaId; column.ReportDataTypeId = columnSchema.ReportDataTypeId; column.Name = columnSchema.Name; Page.Settings.Columns.Add(column); } } } }
private void AddColumnInQuery(DataClasses.ReportColumn column) { DataClasses.ReportColumnsSchema columnSchema = null; // DataClasses.ReportDataFunction function; //if (column.ReportDataFunctionId == null) //{ columnSchema = GetColumnSchema(column.ReportTablesSchemaId, column.ReportColumnsSchemaId); query.Append(columnSchema.Source + " as [" + columnSchema.Name + "], "); //} //else //{ // function = null; // query.Append(function.SqlText.Replace("[=Column=]", columnSchema.Source) + ", "); //} }
public void Insert(DataClasses.ReportColumn column) { DbContext.ReportColumns.InsertOnSubmit(column); DbContext.SubmitChanges(); }
private void detach_ReportColumns(ReportColumn entity) { this.SendPropertyChanging(); entity.ReportColumnsSchema = null; }
partial void DeleteReportColumn(ReportColumn instance);
partial void UpdateReportColumn(ReportColumn instance);
partial void InsertReportColumn(ReportColumn instance);
private void attach_ReportColumns(ReportColumn entity) { this.SendPropertyChanging(); entity.Report = this; }