protected void Page_Init()
{
string Querry = Session["supplist"].ToString();
string[] SupplierList = Querry.Split(',');
for (int i = 0; i < SupplierList.Length - 1; i++)
{
string Col_supp = SupplierList[i].ToString();
GridBoundColumn boundColumn;
boundColumn = new GridBoundColumn();
boundColumn.HeaderText = Col_supp + " " + "Quoted Qty";
boundColumn.DataField = Col_supp + "_OFFERED_QTY";
boundColumn.UniqueName = Col_supp + "_OFFERED_QTY";
boundColumn.DataFormatString = "{0:F2}";
boundColumn.MaxLength = 100;
boundColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
rgdItmSpecView.MasterTableView.Columns.Add(boundColumn);
boundColumn = new GridBoundColumn();
boundColumn.HeaderText = Col_supp + " " + "Item Type";
boundColumn.DataField = Col_supp + "_Item_Type";
boundColumn.UniqueName = Col_supp + "_Item_Type";
//boundColumn.DataFormatString = "{0:F2}";
boundColumn.MaxLength = 100;
boundColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
rgdItmSpecView.MasterTableView.Columns.Add(boundColumn);
}
}
private void ConfiguraPeriodosColumna(string pColumna, int pWidth, string pEncabezado, bool pVisible, bool pGenerarEncabezado, bool pFiltrarColumna, bool pCentrar)
{
GridBoundColumn ColumnPeriodo = new GridBoundColumn();
ColumnPeriodo.HeaderText = "<div style=\"height: 30px;font-size: 10pt;\">" + pColumna + "</div>";
ColumnPeriodo.DataField = pColumna;
ColumnPeriodo.HeaderStyle.Width = pWidth;
ColumnPeriodo.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
ColumnPeriodo.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
ColumnPeriodo.HeaderStyle.Font.Bold = true;
ColumnPeriodo.ColumnGroupName = "Desempeno";
if (pFiltrarColumna & pVisible)
{
if (pWidth <= 60)
{
(ColumnPeriodo as GridBoundColumn).FilterControlWidth = Unit.Pixel(pWidth);
}
else
{
(ColumnPeriodo as GridBoundColumn).FilterControlWidth = Unit.Pixel(pWidth - 60);
}
}
else
{
(ColumnPeriodo as GridBoundColumn).AllowFiltering = false;
}
rgBonosComparativos.MasterTableView.Columns.Add(ColumnPeriodo);
}
public void Should_create_displayfor_builder()
{
var column = new GridBoundColumn <User, bool>(GridTestHelper.CreateGrid <User>(), u => u.Active);
var builder = column.CreateDisplayBuilder(null);
builder.ShouldBeType <GridDisplayForCellBuilder <User, bool> >();
}
/// <summary>
/// Sets the grid bound dataRows columns.
/// </summary>
/// <param name="data">The dataRows.</param>
public void SetGridBoundDataColumns(IEnumerable <DataRow> data)
{
if (data.Any())
{
var _dataTable = data.CopyToDataTable();
foreach (DataColumn _column in _dataTable.Columns)
{
var _gridColumn = new GridBoundColumn
{
HeaderText = _column.Caption
};
_gridColumn.StyleInfo.Font.Bold = true;
_gridColumn.StyleInfo.BackColor = ColorConfig.FormBackColorDark;
_gridColumn.StyleInfo.TextColor = Color.White;
_gridColumn.BackColor = ColorConfig.FormBackColorDark;
_gridColumn.MappingName = _column.ColumnName;
GridBoundColumns.Add(_gridColumn);
}
PascalizeHeaders(data, GridBoundColumns);
SetColumnWidth(GridBoundColumns);
}
}
public void Should_create_template_builder_if_inline_template_is_set()
{
var column = new GridBoundColumn <User, bool>(GridTestHelper.CreateGrid <User>(), u => u.Active);
column.InlineTemplate = delegate { return(null); };
column.CreateDisplayBuilder(null).ShouldBeType <GridTemplateCellBuilder <User> >();
}
private void CreateCustomColumns()
{
//if (ViewState[GetSettingKey("CustomColumnsCreated")] != null) return;
//ViewState[GetSettingKey("CustomColumnsCreated")] = "1";
CustomFields fields = new CustomFields(UserSession.LoginUser);
fields.LoadByReferenceType(UserSession.LoginUser.OrganizationID, ReferenceType.OrganizationProducts);
int count = 0;
foreach (CustomField field in fields)
{
if (count >= 25)
{
break;
}
if (gridProducts.Columns.FindByUniqueNameSafe("CustomField" + field.CustomFieldID.ToString()) == null)
{
GridBoundColumn column = new GridBoundColumn();
gridProducts.MasterTableView.Columns.Add(column);
column.HeaderText = field.Name;
column.DataField = field.Name;
column.UniqueName = "CustomField" + field.CustomFieldID.ToString();
column.HeaderStyle.Width = new Unit(100, UnitType.Pixel);
}
else
{
return;
}
count++;
}
gridProducts.Rebind();
}
public GridBoundColumnBuilder <T> Bound <TValue>(string name, Func <T, TValue> func)
{
var column = new GridBoundColumn <T, TValue>(GridModel, name, func);
GridModel.ColumnList.Add(column);
return(new GridBoundColumnBuilder <T>(column));
}
public void ClientTemplate_sanitized()
{
var column = new GridBoundColumn <User, string>(GridTestHelper.CreateGrid <User>(), u => u.Name);
column.ClientTemplate = "<#= Name #>";
Assert.Equal("<#= Name #>", column.ClientTemplate);
}
public void Should_serialize_filters()
{
var grid = GridTestHelper.CreateGrid <Customer>();
((IGridBindingContext)grid).FilterDescriptors.Add(new CompositeFilterDescriptor
{
LogicalOperator = FilterCompositionLogicalOperator.And,
FilterDescriptors =
{
new FilterDescriptor
{
Member = "Id",
Operator = FilterOperator.IsEqualTo,
Value = 1
},
new FilterDescriptor
{
Member = "Id",
Operator = FilterOperator.IsGreaterThan,
Value = 1
}
}
});
var column = new GridBoundColumn <Customer, int>(grid, c => c.Id);
var result = column.CreateSerializer().Serialize();
var filters = ((IList <IDictionary <string, object> >)result["filters"]);
Assert.Equal("eq", filters[0]["operator"]);
Assert.Equal(1, filters[0]["value"]);
Assert.Equal("gt", filters[1]["operator"]);
Assert.Equal(1, filters[1]["value"]);
}
public void MontaGrid_Procedimento()
{
try
{
////<MasterTableView DataKeyNames="ProductID">
objGrid.ID = "grdProcedimentos";
objGrid.AutoGenerateColumns = false;
objGrid.AllowPaging = true;
objGrid.AllowSorting = true;
objGrid.AllowFilteringByColumn = true;
//objGrid.GridLines = "none";
objGrid.Skin = "DorSkin";
//Coluna TextoBox
GridBoundColumn ColunaTexPRC01 = new GridBoundColumn();
ColunaTexPRC01.DataField = "DSPRC";
ColunaTexPRC01.HeaderText = "Descrição";
objGrid.Columns.Add(ColunaTexPRC01);
//Coluna DateTime
GridDateTimeColumn ColunaDtaPRC01 = new GridDateTimeColumn();
ColunaDtaPRC01.DataField = "DTPRC";
ColunaDtaPRC01.HeaderText = "Data";
objGrid.Columns.Add(ColunaDtaPRC01);
}
catch
{
}
}
public void ClientTemplate_sanitized()
{
var column = new GridBoundColumn<User, string>(GridTestHelper.CreateGrid<User>(), u => u.Name);
column.ClientTemplate = "<#= Name #>";
Assert.Equal("<#= Name #>", column.ClientTemplate);
}
private void CreateQuoteLogGrid()
{
//RadWindowManager1.RadAlert("CreateQuoteLogGrid", 330, 180, "Message", "");
grid = new RadGrid();
grid.ID = "RadGrid1";
grid.MasterTableView.AutoGenerateColumns = false;
grid.EnableViewState = true;
//grid.NeedDataSource += Grid_NeedDataSource;
GridBoundColumn boundColumn = new GridBoundColumn();
grid.MasterTableView.Columns.Add(boundColumn);
boundColumn.DataField = "QuoteNumber";
boundColumn.HeaderText = "QuoteNumber";
PlaceHolder1.Controls.Add(grid);
btn = new Button();
PlaceHolder1.Controls.Add(btn);
tbx1 = new TextBox();
tbx1.ID = "tbx1";
PlaceHolder1.Controls.Add(tbx1);
}
public void Should_return_display_builder_if_readonly()
{
var column = new GridBoundColumn <User, bool>(GridTestHelper.CreateGrid <User>(), u => u.Active);
column.ReadOnly = true;
column.CreateEditBuilder(null).ShouldBeType <GridDisplayForCellBuilder <User, bool> >();
}
public void Should_not_add_attributes_if_hidden_is_set_to_false()
{
var grid = GridTestHelper.CreateGrid <Customer>();
var column = new GridBoundColumn <Customer, int>(grid, c => c.Id);
column.Hidden = false;
column.HtmlAttributes.ContainsKey("style").ShouldBeFalse();
}
public void Name_should_be_extracted_correctly_from_indexer_expression_with_bound_argument()
{
var argument = 0;
var column = new GridBoundColumn <Product, string>(GridTestHelper.CreateGrid <Product>(), p => p.Categories[argument].Owner.Name);
Assert.Equal("Categories[0].Owner.Name", column.Member);
}
public GridBoundColumn AddBoundColumn(string dataField, string headerText, bool isReadOnly)
{
GridBoundColumn c = new GridBoundColumn();
_grid.MasterTableView.Columns.Add(c);
SetBoundColumn(c, dataField, headerText, isReadOnly);
return(c);
}
public void Should_create_edit_builder_if_column_is_readonly()
{
var column = new GridBoundColumn <User, bool>(GridTestHelper.CreateGrid <User>(), u => u.Active);
var builder = column.CreateEditBuilder(null);
builder.ShouldBeType <GridEditorForCellBuilder <User, bool> >();
}
private static IDictionary <string, object> JsonForBoundColumn <T, TValue>(Expression <Func <T, TValue> > expression, Action <GridBoundColumn <T, TValue> > configure)
where T : class
{
var column = new GridBoundColumn <T, TValue>(GridTestHelper.CreateGrid <T>(), expression);
configure(column);
return(column.CreateSerializer().Serialize());
}
/// <summary>
/// Defines a bound column.
/// </summary>
/// <typeparam name="TValue"></typeparam>
/// <param name="expression"></param>
/// <returns></returns>
public virtual GridBoundColumnBuilder <TModel> Bound <TValue>(Expression <Func <TModel, TValue> > expression)
{
GridBoundColumn <TModel, TValue> column = new GridBoundColumn <TModel, TValue>(Container, expression);
Container.Columns.Add(column);
return(new GridBoundColumnBuilder <TModel>(column));
}
public override void AttachProperties(Telerik.Web.UI.GridColumn gridColumn)
{
base.AttachProperties(gridColumn);
GridBoundColumn column = (GridBoundColumn)gridColumn;
column.CurrentFilterFunction = GridKnownFunction.Contains;
}
public void Should_add_attributes_if_hidden()
{
var grid = GridTestHelper.CreateGrid<Customer>();
var column = new GridBoundColumn<Customer, int>(grid, c => c.Id);
column.Hidden = true;
((string)column.HtmlAttributes["style"]).ShouldContain("display:none;");
}
void GetGridStructure()
{
try
{
DataTable dt;
dt = BLL.get_EmpLOB(-1);
Rg_LOB.Columns.Clear();
GridBoundColumn GCol = new GridBoundColumn();
GCol.DataField = "EMP_ID";
GCol.HeaderText = "ID";
GCol.UniqueName = "EMP_ID";
GCol.Visible = false;
Rg_LOB.Columns.Add(GCol);
GCol = new GridBoundColumn();
GCol.DataField = "EMP_CODE";
GCol.HeaderText = "Employee Code";
GCol.UniqueName = "EMP_CODE";
Rg_LOB.Columns.Add(GCol);
GCol = new GridBoundColumn();
GCol.DataField = "EMP_NAME";
GCol.HeaderText = "Employee Name";
GCol.UniqueName = "EMP_NAME";
Rg_LOB.Columns.Add(GCol);
GCol = new GridBoundColumn();
GCol.DataField = "EMP_DOJ";
GCol.HeaderText = "Date of Join";
GCol.UniqueName = "EMP_DOJ";
Rg_LOB.Columns.Add(GCol);
GridTemplateColumn GtCol;
for (int i = 4; i < dt.Columns.Count; i++)
{
GtCol = new GridTemplateColumn();
GtCol.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
GtCol.UniqueName = dt.Columns[i].ColumnName;
GtCol.DataField = dt.Columns[i].ColumnName;
GtCol.ItemTemplate = new myNTemplate(dt.Columns[i].ColumnName, i.ToString());
//GtCol.ItemTemplate = new myNTemplate(i.ToString(),i.);
char[] splitchar = { '-' };
GtCol.HeaderText = dt.Columns[i].ColumnName.Split(splitchar)[1];
Rg_LOB.Columns.Add(GtCol);
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_leaveopeningbalances", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public override void AttachProperties(GridColumn gridColumn)
{
base.AttachProperties(gridColumn);
GridBoundColumn column = (GridBoundColumn)gridColumn;
column.DataField = DataFieldKey;
column.ReadOnly = IsReadOnly;
column.MaxLength = MaxLength;
}
public void Should_add_attributes_if_hidden()
{
var grid = GridTestHelper.CreateGrid <Customer>();
var column = new GridBoundColumn <Customer, int>(grid, c => c.Id);
column.Hidden = true;
((string)column.HtmlAttributes["style"]).ShouldContain("display:none;");
}
public void Should_remove_attributes_if_hidden_is_set_to_false()
{
var grid = GridTestHelper.CreateGrid <Customer>();
var column = new GridBoundColumn <Customer, int>(grid, c => c.Id);
column.Hidden = true;
column.Hidden = false;
((string)column.HtmlAttributes["style"]).ShouldNotContain("display:none;width:0;");
}
public void Should_not_use_display_for_if_format_is_set()
{
var column = new GridBoundColumn <User, bool>(GridTestHelper.CreateGrid <User>(), u => u.Active);
column.Format = "{0}";
var builder = column.CreateDisplayBuilder(null);
builder.ShouldBeType <GridDataCellBuilder <User, bool> >();
}
public void Should_not_use_display_for_if_encoded_is_false()
{
var column = new GridBoundColumn <User, bool>(GridTestHelper.CreateGrid <User>(), u => u.Active);
column.Encoded = false;
var builder = column.CreateDisplayBuilder(null);
builder.ShouldBeType <GridDataCellBuilder <User, bool> >();
}
protected void Reconcilation_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
if (e.Column.UniqueName.Contains("BAL_QTY"))
{
GridBoundColumn bndcol = (GridBoundColumn)e.Column;
bndcol.Aggregate = GridAggregateFunction.Sum;
}
e.Column.HeaderText = e.Column.UniqueName.ToString().Replace('_', ' ');
}
public void Should_not_serialize_editor_html_in_server_binding_mode()
{
var grid = GridTestHelper.CreateGrid <Customer>();
grid.Editing.Enabled = true;
var result = new GridBoundColumn <Customer, int>(grid, c => c.Id).CreateSerializer().Serialize();
Assert.False(result.ContainsKey("editor"));
}
public void Should_return_sortable_header_builder_if_sortable()
{
var grid = GridTestHelper.CreateGrid <Customer>();
grid.Sorting.Enabled = true;
var column = new GridBoundColumn <Customer, int>(grid, c => c.Id);
column.Settings.Sortable = true;
column.CreateHeaderBuilder().ShouldBeType <GridSortableHeaderCellBuilder>();
}
public void Should_not_serialize_client_template_if_not_set()
{
var grid = GridTestHelper.CreateGrid <Customer>();
grid.Ajax.Enabled = true;
var result = new GridBoundColumn <Customer, int>(grid, c => c.Id).CreateSerializer().Serialize();
Assert.False(result.ContainsKey("template"));
}
protected void Page_Load(object sender, EventArgs e)
{
ntf.VisibleOnPageLoad = false;
// Pi-solution developer - multi languages
if (!IsPostBack)
{
language = (Session["myapplication.language"] == null) ? "vi" : Session["myapplication.language"].ToString();
List <t_LanguageTranslate> list = languageBL.FindAll(x => x.Language == language && x.Noted.Contains("/Supervisor/Logger/Daily_Monthly.aspx")).ToList();
//Parse content to form
var var1 = list.Where(x => x.ControlId.Contains("lbFrom")).FirstOrDefault();
lbFrom.Text = (var1 == null) ? "" : var1.Contents;
var var2 = list.Where(x => x.ControlId.Contains("lbTo")).FirstOrDefault();
lbTo.Text = (var2 == null) ? "" : var2.Contents;
var var3 = list.Where(x => x.ControlId.Contains("btnView")).FirstOrDefault();
btnView.Text = (var3 == null) ? "" : var3.Contents;
var var4 = list.Where(x => x.ControlId.Contains("btnExport")).FirstOrDefault();
btnExport.Text = (var4 == null) ? "" : var4.Contents;
// Change header of rad grid
var var5 = list.Where(x => x.ControlId.Contains("grv_TimeStamp")).FirstOrDefault();
grv.MasterTableView.GetColumn("Time").HeaderText = (var5 == null) ? "" : var5.Contents;
var var6 = list.Where(x => x.ControlId.Contains("grv_SiteAliasName")).FirstOrDefault();
grv.MasterTableView.GetColumn("column13").HeaderText = (var6 == null) ? "" : var6.Contents;
var var7 = list.Where(x => x.ControlId.Contains("grv_MaxFlowRate")).FirstOrDefault();
grv.MasterTableView.GetColumn("column14").HeaderText = (var7 == null) ? "" : var7.Contents;
var var8 = list.Where(x => x.ControlId.Contains("grv_MinFlowRate")).FirstOrDefault();
grv.MasterTableView.GetColumn("column17").HeaderText = (var8 == null) ? "" : var8.Contents;
var var9 = list.Where(x => x.ControlId.Contains("grv_Output")).FirstOrDefault();
grv.MasterTableView.GetColumn("Output").HeaderText = (var9 == null) ? "" : var9.Contents;
var var10 = list.Where(x => x.ControlId.Contains("grv_MaxPressure")).FirstOrDefault();
grv.MasterTableView.GetColumn("column15").HeaderText = (var10 == null) ? "" : var10.Contents;
var var13 = list.Where(x => x.ControlId.Contains("grv_Output_footer")).FirstOrDefault();
GridBoundColumn outputColumn = grv.MasterTableView.GetColumn("Output") as GridBoundColumn;
outputColumn.FooterAggregateFormatString = (var13 == null) ? "" : var13.Contents;
var var11 = list.Where(x => x.ControlId.Contains("grv_MinPressure")).FirstOrDefault();
grv.MasterTableView.GetColumn("column16").HeaderText = (var11 == null) ? "" : var11.Contents;
var var12 = list.Where(x => x.ControlId.Contains("grv_Trending")).FirstOrDefault();
grv.MasterTableView.GetColumn("lnkColumn").HeaderText = (var12 == null) ? "" : var12.Contents;
// Popup
var var14 = list.Where(x => x.ControlId.Contains("grv_Trending_winTable")).FirstOrDefault();
winTable.Title = (var14 == null) ? "" : var14.Contents;
var var15 = list.Where(x => x.ControlId.Contains("grv_Trending_winChart")).FirstOrDefault();
winChart.Title = (var15 == null) ? "" : var15.Contents;
}
}
public void Should_return_decorated_header_builder_if_hidden()
{
var grid = GridTestHelper.CreateGrid <Customer>();
var column = new GridBoundColumn <Customer, int>(grid, c => c.Id);
column.Hidden = true;
var headerBuilder = column.CreateHeaderBuilder();
headerBuilder.Decorators.OfType <GridHiddenCellBuilderDecorator>().Any().ShouldBeTrue();
}
protected virtual void InitColumn(PropertyInfo pi, GridBoundColumn clmn)
{
clmn.DataField = pi.Name;
clmn.UniqueName = pi.Name;
clmn.HeaderText = pi.Name;
KeyAttribute keyAtt = pi.GetCustomAttribute<KeyAttribute>();
if (null != keyAtt)
{
clmn.Visible = false;
clmn.ReadOnly = true;
clmn.HeaderText = String.Empty;
clmn.AllowFiltering = false;
clmn.AllowSorting = false;
base.MasterTableView.DataKeyNames = new string[] { pi.Name };
}
else
{
AutoGeneratedAttribute att = pi.GetCustomAttribute<AutoGeneratedAttribute>();
if (null != att)
{
clmn.Visible = att.Visible;
clmn.ReadOnly = att.ReadOnly;
if (!String.IsNullOrEmpty(att.DisplayName))
clmn.HeaderText = att.DisplayName;
if (!String.IsNullOrEmpty(att.DataFormatString))
clmn.DataFormatString = att.DataFormatString;
if (att.Aggregate != GridAggregateFunction.None)
clmn.Aggregate = att.Aggregate.Cast<int>().Cast<GridAggregateFunction>();
if (att.Width != 0)
{
clmn.ItemStyle.Width = att.Width;
clmn.HeaderStyle.Width = att.Width;
}
clmn.AllowFiltering = att.Filterable;
clmn.AllowSorting = att.Sortable;
clmn.Groupable = att.Groupable;
}
}
}
protected override ControlCollection CreateControlCollection()
{
if (null != this.ItemsSource)
{
if (!(base.Page.IsPostBack && base.Columns.Count == this.CustomColumnCount))
{
int index = 0;
foreach (DataColumn dataColumn in this.ItemsSource.Columns)
{
GridBoundColumn clmn;
if (!base.Page.IsPostBack)
{
clmn = new GridBoundColumn();
base.Columns.Add(clmn);
}
else
{
try
{
clmn = (GridBoundColumn)base.Columns[this.CustomColumnCount + index++];
}
catch (Exception ex)
{
if (ex is Telerik.Web.UI.GridException && ex.Message.Contains("Failed accessing GridColumn by index"))
{
throw new GridException("CustomColumnCount set incorecctly. Please check this Property and set CustomColumnCount corecctly");
}
throw;
}
}
this.InitColumn(dataColumn, clmn);
var handler = this.AutoGeneratedColumnCreated;
if (handler != null)
{
handler(this, new GridColumnCreatedEventArgs(clmn, this.MasterTableView));
}
}
}
}
return base.CreateControlCollection();
}
protected virtual void InitColumn(DataColumn dataColumn, GridBoundColumn clmn)
{
clmn.DataField = dataColumn.ColumnName;
clmn.UniqueName = dataColumn.ColumnName;
clmn.HeaderText = dataColumn.Caption;
if (dataColumn.Ordinal == 0)
{
clmn.Visible = false;
clmn.ReadOnly = true;
clmn.HeaderText = String.Empty;
clmn.AllowFiltering = false;
clmn.AllowSorting = false;
base.MasterTableView.DataKeyNames = new string[] { dataColumn.ColumnName };
}
else
{
clmn.ReadOnly = dataColumn.ReadOnly;
}
}
public void Should_not_use_display_for_if_format_is_set()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
column.Format = "{0}";
var builder = column.CreateDisplayBuilder(null);
builder.ShouldBeType<GridDataCellBuilder<User, bool>>();
}
public static void BindTelerikGrid(
ref RadGrid Grid
, DataTable Dt_Source
, List<ClsBindGridColumn_Web_Telerik> List_Gc
, string Key = ""
, bool AllowSort = true
, bool HasDelete = false
, eSelectorType SelectorType = eSelectorType.None
)
{
Grid.DataSource = Dt_Source;
if (Grid.Columns.Count > 0)
{ Grid.Columns.Clear(); }
Grid.AutoGenerateColumns = false;
if (SelectorType != eSelectorType.None)
{
Grid.ClientSettings.Selecting.AllowRowSelect = true;
Grid.ClientSettings.Selecting.UseClientSelectColumnOnly = true;
}
Grid.AllowMultiRowSelection = SelectorType == eSelectorType.Multiple;
//Grid.ClientSettings.Resizing.AllowColumnResize = true;
//Grid.ClientSettings.Resizing.AllowResizeToFit = true;
TableItemStyle Tis = null;
foreach (ClsBindGridColumn_Web_Telerik Inner_Gc in List_Gc)
{
if (!Inner_Gc.mIsVisible)
{
continue;
}
switch (Inner_Gc.mFieldType)
{
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Text:
{
GridBoundColumn Gc = new GridBoundColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.DataField = Inner_Gc.mFieldName;
Gc.ReadOnly = !Inner_Gc.mEnabled;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Checkbox:
{
GridCheckBoxColumn Gc = new GridCheckBoxColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.DataField = Inner_Gc.mFieldName;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.ReadOnly = !Inner_Gc.mEnabled;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_DateTime:
{
GridDateTimeColumn Gc = new Telerik.Web.UI.GridDateTimeColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.DataField = Inner_Gc.mFieldName;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.ReadOnly = !Inner_Gc.mEnabled;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button:
{
GridButtonColumn Gc = new GridButtonColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.CommandName = Inner_Gc.mCommandName;
if (Inner_Gc.mFieldName == "")
{ Gc.Text = Inner_Gc.mFieldText; }
else
{ Gc.DataTextField = Inner_Gc.mFieldName; }
switch (Inner_Gc.mButtonType)
{
case ButtonColumnType.PushButton:
Gc.ButtonType = Telerik.Web.UI.GridButtonColumnType.PushButton;
break;
case ButtonColumnType.LinkButton:
Gc.ButtonType = Telerik.Web.UI.GridButtonColumnType.LinkButton;
break;
}
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_HyperLink:
{
GridHyperLinkColumn Gc = new GridHyperLinkColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.Text = Inner_Gc.mFieldText;
Gc.DataNavigateUrlFormatString = Inner_Gc.mFieldNavigateUrl_Text;
Gc.DataNavigateUrlFields = new string[] { Inner_Gc.mFieldNavigateUrl_Field };
Tis = Gc.ItemStyle;
break;
}
default:
{
GridBoundColumn Gc = new GridBoundColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.DataField = Inner_Gc.mFieldName;
Gc.ReadOnly = true;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Tis = Gc.ItemStyle;
break;
}
}
//Tis.Width = Inner_Gc.mUnit_Width;
}
if (HasDelete) { }
switch (SelectorType)
{
case eSelectorType.Single:
case eSelectorType.Multiple:
{
GridClientSelectColumn Gc = new GridClientSelectColumn();
Grid.Columns.Insert(0, Gc);
Gc.UniqueName = "Select";
Gc.HeaderText = "";
Gc.HeaderStyle.Width = new Unit("40px");
break;
}
}
if (Key != "")
{ Grid.MasterTableView.DataKeyNames = new string[] { Key }; }
Grid.DataBind();
}
public void Should_not_add_attributes_if_hidden_is_set_to_false()
{
var grid = GridTestHelper.CreateGrid<Customer>();
var column = new GridBoundColumn<Customer, int>(grid, c => c.Id);
column.Hidden = false;
column.HtmlAttributes.ContainsKey("style").ShouldBeFalse();
}
public void Name_should_be_extracted_correctly_from_nested_expression()
{
var column = new GridBoundColumn<Product, string>(GridTestHelper.CreateGrid<Product>(), p => p.Category.Owner.Name);
Assert.Equal("Category.Owner.Name", column.Member);
}
public void Type_should_be_set()
{
var column = new GridBoundColumn<Customer, int>(GridTestHelper.CreateGrid<Customer>(), c => c.Id);
Assert.Equal(typeof(int), column.MemberType);
}
public void Should_return_sortable_header_builder_if_sortable()
{
var grid = GridTestHelper.CreateGrid<Customer>();
grid.Sorting.Enabled = true;
var column = new GridBoundColumn<Customer, int>(grid, c => c.Id);
column.Settings.Sortable = true;
column.CreateHeaderBuilder().ShouldBeType<GridSortableHeaderCellBuilder>();
}
public void Should_return_decorated_header_builder_if_hidden()
{
var grid = GridTestHelper.CreateGrid<Customer>();
var column = new GridBoundColumn<Customer, int>(grid, c => c.Id);
column.Hidden = true;
var headerBuilder = column.CreateHeaderBuilder();
headerBuilder.Decorators.OfType<GridHiddenCellBuilderDecorator>().Any().ShouldBeTrue();
}
public void Should_return_decorated_header_builder_if_filtarable()
{
var grid = GridTestHelper.CreateGrid<Customer>();
grid.Filtering.Enabled = true;
var column = new GridBoundColumn<Customer, int>(grid, c => c.Id);
column.Settings.Filterable = true;
var headerBuilder = column.CreateHeaderBuilder();
headerBuilder.Decorators.OfType<GridFilterCellDecorator>().Any().ShouldBeTrue();
}
private void AddColumnsToGrid(DataTable columnsDT)
{
gridResults.Columns.Clear();
//Level Column
var levelColumn = new GridBoundColumn();
gridResults.Columns.Add(levelColumn);
levelColumn.DataField = "LevelText";
levelColumn.HeaderText = "Level";
levelColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
//Label Column
var labelColumn = new GridBoundColumn();
gridResults.Columns.Add(labelColumn);
labelColumn.HeaderText = "";
labelColumn.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
switch (_displayOption)
{
case "Level":
labelColumn.DataFormatString = "Counts<br/>Distribution%";
break;
case "Score":
labelColumn.DataFormatString = "Counts<br/>Scores";
break;
case "All":
labelColumn.DataFormatString = "Counts<br/>Distribution%<br/>Scores";
break;
}
//Column for each demographic
foreach (DataRow r in columnsDT.Rows)
{
var column = new GridNumericColumn();
gridResults.Columns.Add(column);
column.HeaderText = r["DemoLabel"].ToString();
_addedColumns++;
}
}
private void BuildTheColumns(TGDetail selectedViewBy, DataRow dataRow, string StandardLevel = "")
{
GridBoundColumn gridBoundColumn = new GridBoundColumn
{
DataField = selectedViewBy + "Name",
HeaderText = "",
ShowSortIcon = true,
AllowSorting = true
};
radGridResults.MasterTableView.Columns.Add(gridBoundColumn);
GridHyperLinkColumn hyperLinkColumn = new GridHyperLinkColumn
{
HeaderText = "StandardLevel",
DataTextField = "StandardName",
DataNavigateUrlFields = new[] { "EncryptedID" },
DataNavigateUrlFormatString = "~/Record/StandardsPage.aspx?xID={0}",
Target = "_new",
ShowSortIcon = true,
AllowSorting = true
};
radGridResults.MasterTableView.Columns.Add(hyperLinkColumn);
if (StandardLevel != null && StandardLevel != string.Empty)
{
GridBoundColumn TotalCompletencies = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(TotalCompletencies);
TotalCompletencies.HeaderText = "Competencies";
TotalCompletencies.DataField = "TotalCompetencies";
TotalCompletencies.Display = true;
}
//GridBoundColumn StudentID = new GridBoundColumn();
//radGridResults.MasterTableView.Columns.Add(StudentID);
//StudentID.DataField = "StudentID";
//StudentID.Display = false;
GridBoundColumn StudentID = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(StudentID);
StudentID.DataField = "StudentID";
StudentID.Display = false;
GridBoundColumn TeacherID = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(TeacherID);
TeacherID.DataField = "TeacherID";
TeacherID.Display = false;
GridBoundColumn StanderdID = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(StanderdID);
StanderdID.DataField = "StandardId";
StanderdID.Display = false;
GridBoundColumn WorksheetID = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(WorksheetID);
WorksheetID.DataField = "WorksheetID";
WorksheetID.Display = false;
GridBoundColumn included = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(included);
included.DataField = "Included";
included.Display = false;
GridBoundColumn total = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(total);
total.DataField = "Total";
total.Display = false;
GridBoundColumn excluded = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(excluded);
excluded.DataField = "Excluded";
excluded.Display = false;
GridBoundColumn scoreColumnA = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(scoreColumnA);
scoreColumnA.DataField = "DateA";
scoreColumnA.HeaderText = dataRow["ScoreColumnA"].ToString();
scoreColumnA.DataFormatString = "{0:MM/dd/yy}";
GridBoundColumn countColumnA = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(countColumnA);
countColumnA.DataField = "CountA";
countColumnA.Display = false;
GridBoundColumn scoreColumnB = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(scoreColumnB);
scoreColumnB.DataField = "DateB";
scoreColumnB.HeaderText = dataRow["ScoreColumnB"].ToString();
scoreColumnB.DataFormatString = "{0:MM/dd/yy}";
GridBoundColumn countColumnB = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(countColumnB);
countColumnB.DataField = "CountB";
countColumnB.Display = false;
GridBoundColumn scoreColumnC = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(scoreColumnC);
scoreColumnC.DataField = "DateC";
scoreColumnC.HeaderText = dataRow["ScoreColumnC"].ToString();
scoreColumnC.DataFormatString = "{0:MM/dd/yy}";
GridBoundColumn countColumnC = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(countColumnC);
countColumnC.DataField = "CountC";
countColumnC.Display = false;
GridBoundColumn scoreColumnD = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(scoreColumnD);
scoreColumnD.DataField = "DateD";
scoreColumnD.HeaderText = dataRow["ScoreColumnD"].ToString();
scoreColumnD.DataFormatString = "{0:MM/dd/yy}";
GridBoundColumn countColumnD = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(countColumnD);
countColumnD.DataField = "CountD";
countColumnD.Display = false;
GridBoundColumn scoreColumnE = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(scoreColumnE);
scoreColumnE.DataField = "DateE";
scoreColumnE.HeaderText = dataRow["ScoreColumnE"].ToString();
scoreColumnE.DataFormatString = "{0:MM/dd/yy}";
GridBoundColumn countColumnE = new GridBoundColumn();
radGridResults.MasterTableView.Columns.Add(countColumnE);
countColumnE.DataField = "CountE";
countColumnE.Display = false;
//GridBoundColumn perA = new GridBoundColumn();
//radGridResults.MasterTableView.Columns.Add(perA);
//perA.DataField = "PerA";
//perA.Display = false;
//GridBoundColumn perB = new GridBoundColumn();
//radGridResults.MasterTableView.Columns.Add(perB);
//perB.DataField = "PerB";
//perB.Display = false;
//GridBoundColumn perC = new GridBoundColumn();
//radGridResults.MasterTableView.Columns.Add(perC);
//perC.DataField = "PerC";
//perC.Display = false;
//GridBoundColumn perD = new GridBoundColumn();
//radGridResults.MasterTableView.Columns.Add(perD);
//perD.DataField = "PerD";
//perD.Display = false;
//GridBoundColumn perE = new GridBoundColumn();
//radGridResults.MasterTableView.Columns.Add(perE);
//perE.DataField = "PerE";
//perE.Display = false;
}
public void Should_return_display_builder_if_readonly()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
column.ReadOnly = true;
column.CreateEditBuilder(null).ShouldBeType<GridDisplayForCellBuilder<User, bool>>();
}
public void Name_should_be_equal_to_member_when_complex_member_expression_is_supplied()
{
var column = new GridBoundColumn<Customer, int>(GridTestHelper.CreateGrid<Customer>(), c => c.RegisterAt.Day);
Assert.Equal("RegisterAt.Day", column.Member);
}
public void Name_should_be_extracted_correctly_from_indexer_expression_with_bound_argument()
{
var argument = 0;
var column = new GridBoundColumn<Product, string>(GridTestHelper.CreateGrid<Product>(), p => p.Categories[argument].Owner.Name);
Assert.Equal("Categories[0].Owner.Name", column.Member);
}
public void Name_should_be_extracted_from_expression()
{
var column = new GridBoundColumn<Customer, int>(GridTestHelper.CreateGrid<Customer>(), c => c.Id);
Assert.Equal("Id", column.Member);
}
public void Readonly_is_populated_from_metadata()
{
var column = new GridBoundColumn<User, string>(GridTestHelper.CreateGrid<User>(), u => u.Name);
Assert.Equal(true, column.ReadOnly);
}
public void Should_create_template_builder_if_template_is_set()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
column.Template = delegate { };
column.CreateDisplayBuilder(null).ShouldBeType<GridTemplateCellBuilder<User>>();
}
public void Should_create_displayfor_builder()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
var builder = column.CreateDisplayBuilder(null);
builder.ShouldBeType<GridDisplayForCellBuilder<User, bool>>();
}
public void Should_remove_attributes_if_hidden_is_set_to_false()
{
var grid = GridTestHelper.CreateGrid<Customer>();
var column = new GridBoundColumn<Customer, int>(grid, c => c.Id);
column.Hidden = true;
column.Hidden = false;
((string)column.HtmlAttributes["style"]).ShouldNotContain("display:none;width:0;");
}
public void Should_create_editor_builder_when_in_insert_mode()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
column.CreateInsertBuilder(null).ShouldBeType<GridEditorForCellBuilder<User, bool>>();
}
public void Should_create_edit_builder_if_column_is_readonly()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
var builder = column.CreateEditBuilder(null);
builder.ShouldBeType<GridEditorForCellBuilder<User, bool>>();
}
public void Should_not_use_display_for_if_encoded_is_false()
{
var column = new GridBoundColumn<User, bool>(GridTestHelper.CreateGrid<User>(), u => u.Active);
column.Encoded = false;
var builder = column.CreateDisplayBuilder(null);
builder.ShouldBeType<GridDataCellBuilder<User, bool>>();
}
public GridBoundColumnBuilderTests()
{
column = new GridBoundColumn<Customer, int>(GridTestHelper.CreateGrid<Customer>(), c=>c.Id);
builder = new GridBoundColumnBuilder<Customer>(column);
}
private void AddColumns()
{
reportGrid.Columns.Clear();
var nameColumn = new GridBoundColumn();
nameColumn.DataField = "LevelName";
nameColumn.HeaderText = "Name";
nameColumn.HeaderStyle.Wrap = false;
nameColumn.ItemStyle.Wrap = false;
reportGrid.Columns.Add(nameColumn);
var columns = (from DataRow dRow in _columnData.Rows
select new
{
TestYear = dRow["TestYear"].ToString(),
TypeAbbr = dRow["TypeAbbr"].ToString(),
Score = dRow["Score"].ToString(),
StandardName = dRow["StandardName"].ToString(),
StandardNameLeft = dRow["StanNameLeft"].ToString(),
StandardNameRight = dRow["StanNameRight"].ToString(),
StandardID = dRow["StandardID"].ToString(),
StandardCCSSName = dRow["CCSSStandardName"].ToString(),
StandardCCSSDesc = dRow["CCSSDesc"].ToString(),
StandardSSDesc = dRow["SSDesc"].ToString()
}).Where(t => t.StandardName.Length > 0 );
foreach (var column in columns)
{
var col = new Telerik.Web.UI.GridBoundColumn();
var tooltip = (column.StandardSSDesc) ?? "";
tooltip += (column.StandardCCSSDesc) ?? "";
col.HeaderText = column.TestYear + "<br/>" + column.TypeAbbr
+ "<br/><a href='javascript: window.open(\"StandardsPage.aspx?xID=" + Standpoint.Core.Classes.Encryption.EncryptString(column.StandardID) + "\");' style='color: blue; text-decoration:underline;' title=" + tooltip + " alt='" + tooltip + "'>" + column.StandardNameLeft
+ "<br/>" + column.StandardNameRight + "</a><br/>" + column.Score;
col.UniqueName = column.StandardName;
col.HeaderStyle.Font.Size = FontUnit.XSmall;
reportGrid.Columns.Add(col);
}
}
