protected void btnAddSortColumn_Click(object sender, ImageClickEventArgs e)
{
ReportSort sortItem = new ReportSort();
sortItem.ReportTablesSchemaId = Page.Settings.Report.ReportTablesSchemaId.Value;
sortItem.ReportColumnsSchemaId = Convert.ToInt32(cboColumn.SelectedValue);
sortItem.Ascending = Convert.ToBoolean(cboOrder.SelectedValue);
sortItem.Name = cboColumn.SelectedItem.Text;
Page.Settings.SortedColumns.Add(sortItem);
BindGrid(-1);
}
protected void grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (e.RowIndex < Page.Settings.SortedColumns.Count)
Page.Settings.SortedColumns.RemoveAt(e.RowIndex);
int reportColumnsSchemaId = Convert.ToInt32((grid.Rows[e.RowIndex].Cells[0].Controls[1] as DropDownList).SelectedValue);
bool asc = Convert.ToBoolean((grid.Rows[e.RowIndex].Cells[1].Controls[1] as DropDownList).SelectedValue);
// Verifies if yet inserted
ReportSort sortItem = Page.Settings.SortedColumns.Find(p => p.ReportColumnsSchemaId == reportColumnsSchemaId);
if (sortItem == null)
{
sortItem = new ReportSort();
sortItem.ReportTablesSchemaId = Page.Settings.Report.ReportTablesSchemaId.Value;
sortItem.ReportColumnsSchemaId = reportColumnsSchemaId;
sortItem.Ascending = asc;
sortItem.Name = (grid.Rows[e.RowIndex].Cells[0].Controls[1] as DropDownList).SelectedItem.Text;
Page.Settings.SortedColumns.Insert(e.RowIndex, sortItem);
}
else
{
sortItem.Ascending = asc;
}
BindGrid(-1);
}
public void Insert(DataClasses.ReportSort sort)
{
DbContext.ReportSorts.InsertOnSubmit(sort);
DbContext.SubmitChanges();
}
private void detach_ReportSorts(ReportSort entity)
{
this.SendPropertyChanging();
entity.ReportColumnsSchema = null;
}
partial void DeleteReportSort(ReportSort instance);
partial void UpdateReportSort(ReportSort instance);
partial void InsertReportSort(ReportSort instance);
private void attach_ReportSorts(ReportSort entity)
{
this.SendPropertyChanging();
entity.Report = this;
}
