protected void storeGridView_DataBinding(object sender, EventArgs e) { if (!WebTools.UserInRole("ADMIN")) { storeGridView.AllowAutomaticDeletes = false; GridButtonColumn gridbutton = (GridButtonColumn)storeGridView.MasterTableView.Columns[1]; } else { string[] datafields = new string[1]; datafields[0] = "STORE_NAME"; GridButtonColumn gridbutton = (GridButtonColumn)storeGridView.MasterTableView.Columns[1]; gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow; gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?"; gridbutton.ConfirmTextFields = datafields; storeGridView.AllowAutomaticDeletes = true; } if (!WebTools.UserInRole("ADMIN")) { storeGridView.AllowAutomaticUpdates = false; } else { storeGridView.AllowAutomaticUpdates = true; } }
protected void itemsGrid_DataBinding(object sender, EventArgs e) { if (!WebTools.UserInRole("VENDOR_DELETE")) { itemsGrid.AllowAutomaticDeletes = false; GridButtonColumn gridbutton = (GridButtonColumn)itemsGrid.MasterTableView.Columns[1]; } else { string[] datafields = new string[1]; datafields[0] = "VENDOR_CODE"; GridButtonColumn gridbutton = (GridButtonColumn)itemsGrid.MasterTableView.Columns[1]; gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow; gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?"; gridbutton.ConfirmTextFields = datafields; itemsGrid.AllowAutomaticDeletes = true; } if (!WebTools.UserInRole("VENDOR_EDIT")) { itemsGrid.AllowAutomaticUpdates = false; } else { itemsGrid.AllowAutomaticUpdates = true; } }
protected void rgActionItem_ItemCreated(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) { } else { GridDataItem item = e.Item as GridDataItem; if (item != null) { GridButtonColumn gBtnCol = item.OwnerTableView.GetColumn("ArchiveColumn") as GridButtonColumn; ImageButton ImgBtn = item["ArchiveColumn"].Controls[0] as ImageButton; if (chkbArchive.Checked) { ImgBtn.ImageUrl = "images/show.png"; ImgBtn.CommandName = "unArchive"; gBtnCol.ConfirmText = "Are you sure you want to UnArchive?"; gBtnCol.ConfirmTitle = "UnArchive"; ImgBtn.ToolTip = "UnArchive"; } else { ImgBtn.ImageUrl = "images/hide.png"; ImgBtn.CommandName = "Archive"; gBtnCol.ConfirmText = "Are you sure you want to Archive?"; gBtnCol.ConfirmTitle = "Archive"; ImgBtn.ToolTip = "Archive"; } } } }
protected void gridPreservItems_DataBinding(object sender, EventArgs e) { if (!WebTools.UserInRole("PRESERVATION_DELETE")) { ItemsGrid.AllowAutomaticDeletes = false; GridButtonColumn gridbutton = (GridButtonColumn)ItemsGrid.MasterTableView.Columns[1]; } else { string[] datafields = new string[1]; datafields[0] = "MAT_CODE1_NO"; GridButtonColumn gridbutton = (GridButtonColumn)ItemsGrid.MasterTableView.Columns[1]; gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow; gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?"; gridbutton.ConfirmTextFields = datafields; ItemsGrid.AllowAutomaticDeletes = true; } if (!WebTools.UserInRole("PRESERVATION_DELETE")) { ItemsGrid.AllowAutomaticUpdates = false; } else { ItemsGrid.AllowAutomaticUpdates = true; } }
public GridButtonColumn AddButtonColumn(string buttonText, string commandName) { GridButtonColumn bc = new GridButtonColumn(); _grid.MasterTableView.Columns.Add(bc); bc.ButtonType = GridButtonColumnType.LinkButton; bc.ConfirmDialogType = GridConfirmDialogType.Classic; bc.Text = buttonText; bc.CommandName = commandName; bc.HeaderStyle.Width = ButtonColumnWidth; return(bc); }
public GridButtonColumn AddDeleteButtonColumn() { GridButtonColumn bc = new GridButtonColumn(); _grid.MasterTableView.Columns.Add(bc); bc.ButtonType = GridButtonColumnType.ImageButton; bc.Text = "Delete"; bc.CommandName = "Delete"; bc.HeaderStyle.Width = ButtonColumnWidth; bc.ConfirmDialogType = GridConfirmDialogType.RadWindow; bc.ConfirmTitle = "Delete Confirm"; return(bc); }
public override void AttachProperties(GridColumn gridColumn) { base.AttachProperties(gridColumn); GridButtonColumn column = (GridButtonColumn)gridColumn; column.ButtonType = GridButtonColumnType.ImageButton; column.Text = "Delete"; column.CommandName = RadGrid.DeleteCommandName; column.HeaderStyle.Width = ButtonColumnWidth; column.ConfirmDialogType = GridConfirmDialogType.RadWindow; column.ConfirmTitle = "Delete Confirm"; column.ConfirmText = ConfirmText; column.ConfirmTextFormatString = ConfirmTextFormatString; column.ConfirmTextFields = ConfirmTextFields; }
protected void ParticipantListGrid_PreRender(object sender, EventArgs e) { foreach (GridColumn col in ParticipantListGrid.MasterTableView.RenderColumns) { if (col.UniqueName == "Delete") { GridButtonColumn boundColumn = (GridButtonColumn)col; if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.NGOHead || UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.ProjectManager || UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.Schoolmaster) { boundColumn.Visible = true; } else { boundColumn.Visible = false; } } } }
public static void BuildGridDeleteColumn(BasePage page, RadGrid Grid, Grid GridObject, DeleteGridColumn Column, string ResourceKeyPrefix) { GridButtonColumn col = new GridButtonColumn(); col.CommandName = "Delete"; string HeaderText = Common.CoalesceStr(col.HeaderText, Column.HeaderText); string ConfirmText = Common.CoalesceStr(col.ConfirmText, Column.ConfirmText); string Text = Common.CoalesceStr(col.Text, Column.Text); col.HeaderText = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "HeaderText", HeaderText); col.SortExpression = Common.CoalesceStr(col.SortExpression, Column.SortExpression); col.ConfirmText = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "ConfirmText", ConfirmText); col.Text = GetGlobalResourceString(page, Column, ResourceKeyPrefix, "Text", Text); switch (Column.ButtonType) { case System.Web.UI.WebControls.ButtonType.Link: col.ButtonType = GridButtonColumnType.LinkButton; break; case System.Web.UI.WebControls.ButtonType.Button: col.ButtonType = GridButtonColumnType.PushButton; break; case System.Web.UI.WebControls.ButtonType.Image: col.ButtonType = GridButtonColumnType.ImageButton; col.ImageUrl = Common.CoalesceStr(col.ImageUrl, Column.ImageUrl); break; default: col.ButtonType = GridButtonColumnType.LinkButton; break; } FormatStyle(col, Column); Grid.MasterTableView.Columns.Add(col); }
protected void IssueGridView_DataBinding(object sender, EventArgs e) { try { if (!WebTools.UserInRole("MM_DELETE")) { IssueGridView.AllowAutomaticDeletes = false; GridButtonColumn gridbutton = (GridButtonColumn)IssueGridView.MasterTableView.Columns[1]; } else { string[] datafields = new string[1]; datafields[0] = "TRANSF_NO"; GridButtonColumn gridbutton = (GridButtonColumn)IssueGridView.MasterTableView.Columns[1]; gridbutton.ConfirmDialogType = GridConfirmDialogType.RadWindow; gridbutton.ConfirmTextFormatString = "Are you sure you want to delete {0} ?"; gridbutton.ConfirmTextFields = datafields; IssueGridView.AllowAutomaticDeletes = true; } } catch (Exception ex) { RadWindowManager1.RadAlert("Items Available in MATERIAL TRANSFER!", 400, 150, "Warning", ""); } if (!WebTools.UserInRole("MM_EDIT")) { IssueGridView.AllowAutomaticUpdates = false; } else { IssueGridView.AllowAutomaticUpdates = true; } }
public override GridColumn CreateColumn() { GridButtonColumn column = new GridButtonColumn(); return(column); }
private void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { GridEditCommandColumn GEC = new GridEditCommandColumn(); this.RadGrid1.MasterTableView.Columns.Add(GEC); GEC.UniqueName = "EditCommandColumn"; GEC.ButtonType = GridButtonColumnType.ImageButton; GEC.ItemStyle.Width = 20; GEC.OrderIndex = 0; GridButtonColumn GBC = new GridButtonColumn(); this.RadGrid1.MasterTableView.Columns.Add(GBC); GBC.CommandName = "Delete"; GBC.Text = "Delete"; GBC.ItemStyle.Width = 20; GBC.ButtonType = GridButtonColumnType.ImageButton; BLL.CustomFilteringColumn gridColumn2 = new BLL.CustomFilteringColumn(); this.RadGrid1.MasterTableView.Columns.Add(gridColumn2); gridColumn2.DataField = "FirstName"; gridColumn2.HeaderText = "First Name"; gridColumn2.ItemStyle.CssClass = "UseHand"; BLL.CustomFilteringColumn gridColumn3 = new BLL.CustomFilteringColumn(); this.RadGrid1.MasterTableView.Columns.Add(gridColumn3); gridColumn3.DataField = "LastName"; gridColumn3.HeaderText = "Last Name"; BLL.CustomFilteringColumn gridColumn4 = new BLL.CustomFilteringColumn(); this.RadGrid1.MasterTableView.Columns.Add(gridColumn4); gridColumn4.DataField = "Email"; gridColumn4.HeaderText = "Email"; gridColumn4.ItemStyle.Width = 400; GridDateTimeColumn gridColumn5 = new GridDateTimeColumn(); this.RadGrid1.MasterTableView.Columns.Add(gridColumn5); gridColumn5.DataField = "Birthday"; gridColumn5.HeaderText = "Birthday"; gridColumn5.ItemStyle.Width = 200; gridColumn5.AllowFiltering = false; GridCheckBoxColumn gridColumn6 = new GridCheckBoxColumn(); this.RadGrid1.MasterTableView.Columns.Add(gridColumn6); gridColumn6.DataField = "IsLockedOut"; gridColumn6.HeaderText = "Locked Out"; gridColumn6.AllowFiltering = false; //BLL.CustomFilteringColumn gridColumn7 = new BLL.CustomFilteringColumn(); //this.RadGrid1.MasterTableView.Columns.Add(gridColumn7); //gridColumn7.DataField = "Gender"; //gridColumn7.HeaderText = "Gender"; //gridColumn7.AllowFiltering = false; //RadComboBox gridColumn7 = new RadComboBox(); //this.RadGrid1.MasterTableView.Columns.Add(gridColumn7); //gridColumn7.Items[0].Text = "Male"; //gridColumn7.Items[0].Value = "Male"; //gridColumn7.Items[1].Text = "Female"; //gridColumn7.Items[1].Value = "Female"; } }
private void CreateColumns(Report report) { DataTable table = new DataTable(); using (SqlCommand command = new SqlCommand()) { command.CommandText = report.GetSqlOld(true, filterControl.ReportConditions); command.CommandType = CommandType.Text; Report.CreateParameters(UserSession.LoginUser, command, UserSession.LoginUser.UserID); using (SqlConnection connection = new SqlConnection(GetReportConnectionString())) { connection.Open(); command.Connection = connection; using (SqlDataAdapter adapter = new SqlDataAdapter(command)) { adapter.FillSchema(table, SchemaType.Source); adapter.Fill(table); } connection.Close(); } } ReportFields fields = new ReportFields(UserSession.LoginUser); fields.LoadByReportID(_reportID); foreach (ReportField field in fields) { if (field.IsCustomField == false && (field.LinkedFieldID == 30 || field.LinkedFieldID == 146)) { GridButtonColumn column = new GridButtonColumn(); gridReport.MasterTableView.Columns.Add(column); column.ButtonType = GridButtonColumnType.ImageButton; column.ImageUrl = "../images/icons/open.png"; column.UniqueName = "ButtonOpen"; column.CommandName = "OpenItem"; column.HeaderStyle.Width = new Unit(32, UnitType.Pixel); column.Resizable = false; break; } } if (fields.IsEmpty) { if (table.Columns.Contains("Ticket_Number")) { GridButtonColumn column = new GridButtonColumn(); gridReport.MasterTableView.Columns.Add(column); column.ButtonType = GridButtonColumnType.ImageButton; column.ImageUrl = "../images/icons/open.png"; column.UniqueName = "ButtonOpen"; column.CommandName = "OpenItem"; column.HeaderStyle.Width = new Unit(32, UnitType.Pixel); column.Resizable = false; } } foreach (DataColumn dataColumn in table.Columns) { GridBoundColumn gridColumn; if (dataColumn.DataType == typeof(System.DateTime)) { gridColumn = new GridDateTimeColumn(); gridColumn.DataFormatString = "{0:MM/dd/yyyy hh:mm tt}"; } else if (dataColumn.DataType == typeof(System.Decimal) || dataColumn.DataType == typeof(System.Double) ) { gridColumn = new GridNumericColumn(); gridColumn.DataFormatString = "{0:0.00}"; } else if (dataColumn.DataType == typeof(System.Int16) || dataColumn.DataType == typeof(System.Int32) || dataColumn.DataType == typeof(System.Int64)) { gridColumn = new GridNumericColumn(); gridColumn.DataFormatString = "{0:0}"; } else { gridColumn = new GridBoundColumn(); } gridReport.MasterTableView.Columns.Add(gridColumn); gridColumn.DataType = dataColumn.DataType; gridColumn.DataField = dataColumn.ColumnName.Replace(' ', '_'); gridColumn.UniqueName = gridColumn.DataField; gridColumn.HeaderText = dataColumn.ColumnName.Replace('_', ' '); gridColumn.HeaderStyle.Width = new Unit(200, UnitType.Pixel); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.Droplist_Tables.Items.Add("-Select One-"); var storeGenerator = new EntityStoreSchemaGenerator( "System.Data.SqlClient", ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString, "namespace"); storeGenerator.GenerateStoreMetadata(); var tables = storeGenerator.StoreItemCollection .GetItems<EntityContainer>() .Single() .BaseEntitySets .OfType<EntitySet>() .Where(s => !s.MetadataProperties.Contains("Type") || s.MetadataProperties["Type"].ToString() == "Tables"); foreach (var table in tables) { this.Droplist_Tables.Items.Add(table.Name); } //Add delete button to gridview //GridButtonColumn deleteButton = new GridButtonColumn(); //this.tableGrid.MasterTableView.Columns.Add(deleteButton); //deleteButton.UniqueName = "deleteButton"; //deleteButton.HeaderText = "Delete"; //deleteButton.Text = "Delete"; //deleteButton.ConfirmText = "Are you sure you want to delete this record?"; //deleteButton.ButtonType = GridButtonColumnType.LinkButton; //deleteButton.CommandName = "Delete"; //Add edit button to gridview GridButtonColumn detailsButton = new GridButtonColumn(); this.tableGrid.MasterTableView.Columns.Add(detailsButton); detailsButton.UniqueName = "detailsButton"; detailsButton.HeaderText = "Details"; detailsButton.Text = "Details"; detailsButton.ButtonType = GridButtonColumnType.LinkButton; detailsButton.CommandName = "Details"; } }
protected void ProjectSubDetailListGrid_PreRender(object sender, EventArgs e) { foreach (GridColumn col in ProjectSubDetailListGrid.MasterTableView.RenderColumns) { if (col.UniqueName == "Edit") { GridTemplateColumn boundColumn = (GridTemplateColumn)col; if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.NGOHead) { boundColumn.Visible = true; } else if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.ProjectManager && UserHelper.CurrentUser.Id == Convert.ToInt64(ProjectManagerId.Value)) { boundColumn.Visible = true; } else { boundColumn.Visible = false; } } if (col.UniqueName == "ActivityOperations") { GridButtonColumn boundColumn = (GridButtonColumn)col; if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.Volunteer) { boundColumn.Visible = true; } else { boundColumn.Visible = false; } } if (col.UniqueName == "ActivityConfirmationOperations" || col.UniqueName == "Participants") { GridButtonColumn boundColumn = (GridButtonColumn)col; if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.ProjectManager && UserHelper.CurrentUser.Id == Convert.ToInt64(ProjectManagerId.Value)) { boundColumn.Visible = true; } else { boundColumn.Visible = false; } } if (col.UniqueName == "SurveyProjectDetailResult") { GridButtonColumn boundColumn = (GridButtonColumn)col; if (UserHelper.CurrentUser.UserTypeId == (int)EnumUserType.NGOHead) { boundColumn.Visible = true; } else { boundColumn.Visible = false; } } } }
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(); }