protected void bt_Add_Click(object sender, EventArgs e)
{
SaveGrid();
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
IList <Rpt_ReportGridColumns> columns = report.GetGridColumns();
int maxsortid = 0;
if (columns.Count > 0)
{
maxsortid = columns.Max(p => p.ColumnSortID);
}
foreach (ListItem item in cbxl_Fields.Items)
{
if (item.Selected && columns.FirstOrDefault(p => p.DataSetField == new Guid(item.Value)) == null)
{
maxsortid++;
Rpt_ReportGridColumnsBLL column = new Rpt_ReportGridColumnsBLL();
column.Model.Report = (Guid)ViewState["ID"];
column.Model.DataSetField = new Guid(item.Value);
column.Model.DisplayName = item.Text;
column.Model.ColumnSortID = maxsortid;
column.Model.AddSummary = "N";
column.Model.Visible = "Y";
column.Add();
}
}
BindDataSetFields();
BindGrid();
}
protected void bt_Add_Click(object sender, EventArgs e)
{
SaveGrid();
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
IList<Rpt_ReportGridColumns> columns = report.GetGridColumns();
int maxsortid = 0;
if (columns.Count > 0) maxsortid = columns.Max(p => p.ColumnSortID);
foreach (ListItem item in cbxl_Fields.Items)
{
if (item.Selected && columns.FirstOrDefault(p => p.DataSetField == new Guid(item.Value)) == null)
{
maxsortid++;
Rpt_ReportGridColumnsBLL column = new Rpt_ReportGridColumnsBLL();
column.Model.Report = (Guid)ViewState["ID"];
column.Model.DataSetField = new Guid(item.Value);
column.Model.DisplayName = item.Text;
column.Model.ColumnSortID = maxsortid;
column.Model.AddSummary = "N";
column.Model.Visible = "Y";
column.Add();
}
}
BindDataSetFields();
BindGrid();
}
private void BindDataSetFields()
{
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
IList <Rpt_ReportGridColumns> columns = report.GetGridColumns();
IList <Rpt_DataSetFields> fields = new Rpt_DataSetBLL((Guid)ViewState["DataSet"]).GetFields();
foreach (Rpt_ReportGridColumns col in columns)
{
Rpt_DataSetFields f = fields.FirstOrDefault(p => p.ID == col.DataSetField);
if (f != null)
{
fields.Remove(f);
}
}
cbxl_Fields.DataSource = fields;
cbxl_Fields.DataBind();
}
private void BindGrid()
{
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
gv_List.BindGrid(report.GetGridColumns());
}
private void BindGrid()
{
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
gv_List.BindGrid(report.GetGridColumns());
}
private void BindDataSetFields()
{
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
IList<Rpt_ReportGridColumns> columns = report.GetGridColumns();
IList<Rpt_DataSetFields> fields = new Rpt_DataSetBLL((Guid)ViewState["DataSet"]).GetFields();
foreach (Rpt_ReportGridColumns col in columns)
{
Rpt_DataSetFields f = fields.FirstOrDefault(p => p.ID == col.DataSetField);
if (f != null) fields.Remove(f);
}
cbxl_Fields.DataSource = fields;
cbxl_Fields.DataBind();
}
