protected void bt_Decrease_Click(object sender, EventArgs e)
{
SaveGrid();
int rowindex = ((GridViewRow)((Button)sender).Parent.Parent).RowIndex;
if (rowindex > 0)
{
Guid id = (Guid)gv_List.DataKeys[rowindex][0];
Rpt_ReportGridColumnsBLL bll = new Rpt_ReportGridColumnsBLL(id);
if (bll.Model.ColumnSortID > 0)
{
bll.Model.ColumnSortID--;
}
bll.Update();
id = (Guid)gv_List.DataKeys[rowindex - 1][0];
bll = new Rpt_ReportGridColumnsBLL(id);
bll.Model.ColumnSortID++;
bll.Update();
}
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();
}
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 SaveGrid()
{
foreach (GridViewRow row in gv_List.Rows)
{
Guid id = (Guid)gv_List.DataKeys[row.RowIndex][0];
Rpt_ReportGridColumnsBLL column = new Rpt_ReportGridColumnsBLL(id);
column.Model.DisplayName = ((TextBox)row.FindControl("tbx_DisplayName")).Text;
column.Model.Visible = ((RadioButtonList)row.FindControl("rbl_Visible")).SelectedValue;
column.Model.AddSummary = ((RadioButtonList)row.FindControl("rbl_AddSummary")).SelectedValue;
column.Update();
}
}
protected void gv_List_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Guid id = (Guid)gv_List.DataKeys[e.Row.RowIndex][0];
Rpt_ReportGridColumns c = new Rpt_ReportGridColumnsBLL(id).Model;
if (c != null)
{
RadioButtonList rbl_Visible = (RadioButtonList)e.Row.FindControl("rbl_Visible");
rbl_Visible.SelectedValue = c.Visible == "Y" ? "Y" : "N";
RadioButtonList rbl_AddSummary = (RadioButtonList)e.Row.FindControl("rbl_AddSummary");
rbl_AddSummary.SelectedValue = c.AddSummary == "Y" ? "Y" : "N";
}
}
}
protected void bt_Decrease_Click(object sender, EventArgs e)
{
SaveGrid();
int rowindex = ((GridViewRow)((Button)sender).Parent.Parent).RowIndex;
if (rowindex > 0)
{
Guid id = (Guid)gv_List.DataKeys[rowindex][0];
Rpt_ReportGridColumnsBLL bll = new Rpt_ReportGridColumnsBLL(id);
if (bll.Model.ColumnSortID > 0) bll.Model.ColumnSortID--;
bll.Update();
id = (Guid)gv_List.DataKeys[rowindex - 1][0];
bll = new Rpt_ReportGridColumnsBLL(id);
bll.Model.ColumnSortID++;
bll.Update();
}
BindGrid();
}
private void SaveGrid()
{
foreach (GridViewRow row in gv_List.Rows)
{
Guid id = (Guid)gv_List.DataKeys[row.RowIndex][0];
Rpt_ReportGridColumnsBLL column = new Rpt_ReportGridColumnsBLL(id);
column.Model.DisplayName = ((TextBox)row.FindControl("tbx_DisplayName")).Text;
column.Model.Visible = ((RadioButtonList)row.FindControl("rbl_Visible")).SelectedValue;
column.Model.AddSummary = ((RadioButtonList)row.FindControl("rbl_AddSummary")).SelectedValue;
column.Update();
}
}
protected void gv_List_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Guid id = (Guid)gv_List.DataKeys[e.Row.RowIndex][0];
Rpt_ReportGridColumns c = new Rpt_ReportGridColumnsBLL(id).Model;
if (c != null)
{
RadioButtonList rbl_Visible = (RadioButtonList)e.Row.FindControl("rbl_Visible");
rbl_Visible.SelectedValue = c.Visible == "Y" ? "Y" : "N";
RadioButtonList rbl_AddSummary = (RadioButtonList)e.Row.FindControl("rbl_AddSummary");
rbl_AddSummary.SelectedValue = c.AddSummary == "Y" ? "Y" : "N";
}
}
}
