private void ShowData(int applicationEntityFieldLabelId) { oDetailButtonPanel.SetId = SetId; var data = new Framework.Components.UserPreference.ApplicationEntityFieldLabel.Data(); data.ApplicationEntityFieldLabelId = applicationEntityFieldLabelId; var dt = Framework.Components.UserPreference.ApplicationEntityFieldLabel.GetDetails(data, AuditId); if (dt.Rows.Count == 1) { var row = dt.Rows[0]; lblApplicationEntityFieldLabelId.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.ApplicationEntityFieldLabelId]); lblName.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Name]); lblValue.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Value]); lblSystemEntityTypeId.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.SystemEntityTypeId]); lblWidth.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Width]); lblFormatting.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Formatting]); lblControlType.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.ControlType]); lblHorizontalAlignment.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.HorizontalAlignment]); oUpdateInfo.LoadText(dt.Rows[0]); oHistoryList.Setup("AuditHistory", "Audit", "AuditHistoryId", true, true, (int)Framework.Components.DataAccess.SystemEntity.ApplicationEntityFieldLabel, applicationEntityFieldLabelId, "ApplicationEntityFieldLabel"); dynAuditHistory.Visible = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ApplicationEntityFieldLabel"); } else { Clear(); } }
private void ShowData(int applicationEntityFieldLabelModeId) { oDetailButtonPanel.SetId = SetId; var data = new Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.Data(); data.ApplicationEntityFieldLabelModeId = applicationEntityFieldLabelModeId; var dt = Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.GetDetails(data, AuditId); if (dt.Rows.Count == 1) { var row = dt.Rows[0]; lblApplicationEntityFieldLabelModeId.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.ApplicationEntityFieldLabelModeId]); lblName.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.Name]); lblDescription.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.Description]); lblSortOrder.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.SortOrder]); oUpdateInfo.LoadText(dt.Rows[0]); oHistoryList.Setup("AuditHistory", "Audit", "AuditHistoryId", true, true, (int)Framework.Components.DataAccess.SystemEntity.ApplicationEntityFieldLabelMode, applicationEntityFieldLabelModeId, "ApplicationEntityFieldLabelMode"); dynAuditHistory.Visible = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ApplicationEntityFieldLabelMode"); } else { Clear(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(SearchControlName)) { ApplicationCommon.CheckUserPreferenceCategoryExists(SearchControlName, "Search Control Name"); } else { throw new Exception("Search control is not named"); } var autoSearchOn = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.AutoSearchOn, SearchControlName); if (autoSearchOn) { drpSearchConditionSystemEntityType.AutoPostBack = true; } else { drpSearchConditionSystemEntityType.AutoPostBack = false; } var systemEntityTypeData = Framework.Components.Core.SystemEntityType.GetList(SessionVariables.AuditId); LoadDropDown(systemEntityTypeData, drpSearchConditionSystemEntityType, Framework.Components.Core.SystemEntityType.DataColumns.EntityName, Framework.Components.Core.SystemEntityType.DataColumns.SystemEntityTypeId); } }
public void LoadData(int applicationEntityFieldLabelId, bool showId) { var data = new Framework.Components.UserPreference.ApplicationEntityFieldLabel.Data(); data.ApplicationEntityFieldLabelId = applicationEntityFieldLabelId; var oApplicationEntityFieldLabelTable = Framework.Components.UserPreference.ApplicationEntityFieldLabel.GetDetails(data, AuditId); if (oApplicationEntityFieldLabelTable.Rows.Count == 1) { var row = oApplicationEntityFieldLabelTable.Rows[0]; if (!showId) { txtApplicationEntityFieldLabelId.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.ApplicationEntityFieldLabelId].ToString(); // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup("AuditHistory", "Audit", "AuditHistoryId", true, true, (int)Framework.Components.DataAccess.SystemEntity.ApplicationEntityFieldLabel, applicationEntityFieldLabelId, "ApplicationEntityFieldLabel"); dynAuditHistory.Visible = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ApplicationEntityFieldLabel"); } else { txtApplicationEntityFieldLabelId.Text = string.Empty; } txtValue.InnerText = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Value].ToString(); txtName.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Name].ToString(); txtWidth.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Width].ToString(); txtFormatting.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.Formatting].ToString(); txtControlType.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.ControlType].ToString(); txtSystemEntityTypeId.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.SystemEntityTypeId]); txtHorizontalAlignment.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.HorizontalAlignment]); drpSystemEntityTypeList.SelectedValue = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.SystemEntityTypeId]); txtGridViewPriority.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.GridViewPriority].ToString(); txtDetailsViewPriority.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.DetailsViewPriority].ToString(); txtApplicationEntityFieldLabelMode.Text = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.ApplicationEntityFieldLabelModeId]); ddlApplicationEntityFieldLabelMode.SelectedValue = Convert.ToString(row[Framework.Components.UserPreference.ApplicationEntityFieldLabel.DataColumns.ApplicationEntityFieldLabelModeId]); oUpdateInfo.LoadText(oApplicationEntityFieldLabelTable.Rows[0]); } else { txtApplicationEntityFieldLabelId.Text = string.Empty; txtValue.InnerText = string.Empty; txtName.Text = string.Empty; txtWidth.Text = string.Empty; txtFormatting.Text = string.Empty; txtControlType.Text = string.Empty; txtSystemEntityTypeId.Text = string.Empty; txtHorizontalAlignment.Text = string.Empty; txtGridViewPriority.Text = string.Empty; txtDetailsViewPriority.Text = string.Empty; txtApplicationEntityFieldLabelMode.Text = string.Empty; } }
// OnPageLoad Event Handler protected void Page_Load(object sender, EventArgs e) { // only need to set initial condition, else every other time it shoulld // be thee via state if (IsPostBack) { return; } if (!((bool)ViewState["PageLoad"])) { return; } // only go forward if settings are correct if (ViewState["TableName"] != null || ViewState["PrimaryKey"] != null) { // can not have this, as keys above are all blank SortGridView(string.Empty, SortDirection.Ascending.ToString()); } else { System.Diagnostics.Debug.WriteLine("Missing info ... "); } SessionVariables.SearchControlColumnsModeId = 10019; GridActionBarBackgroundColor = ApplicationCommon.GetApplicationUserPreferenceByKey(ApplicationCommon.GridActionBarBackgroundColor); GridActionBarForegroundColor = ApplicationCommon.GetApplicationUserPreferenceByKey(ApplicationCommon.GridActionBarForegroundColor); GridActionBarFontFamily = ApplicationCommon.GetApplicationUserPreferenceByKey(ApplicationCommon.GridActionBarFontFamily); GridActionBarFontSize = ApplicationCommon.GetApplicationUserPreferenceByKey(ApplicationCommon.GridActionBarFontSize); divGridActionBar.Attributes.Add("style", "border: 2px none; border-top-left-radius: 15px;border-top-right-radius: 15px;"); divGridActionBar.Style.Add("background-color", GridActionBarBackgroundColor); divGridActionBar.Style.Add("color", GridActionBarForegroundColor); divGridActionBar.Style.Add("font-family", GridActionBarFontFamily); divGridActionBar.Style.Add("font-size", GridActionBarFontSize); SetFontForGrid("12px", "smallfontgrid"); //AddCheckBox(); var isButtonPanelVisible = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.ControlVisible, this.SettingCategory + "ButtonPanel"); var isAdvancedButtonPanelVisible = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.ControlVisible, this.SettingCategory + "AdvancedButtonPanel"); buttonPanel.Visible = isButtonPanelVisible; advancedButtonpanel.Visible = isAdvancedButtonPanelVisible; }
public void LoadData(int ApplicationEntityFieldLabelModeId, bool showId) { var data = new Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.Data(); data.ApplicationEntityFieldLabelModeId = ApplicationEntityFieldLabelModeId; var oApplicationEntityFieldLabelModeTable = Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.GetDetails(data, AuditId); if (oApplicationEntityFieldLabelModeTable.Rows.Count == 1) { var row = oApplicationEntityFieldLabelModeTable.Rows[0]; if (!showId) { txtApplicationEntityFieldLabelModeId.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.ApplicationEntityFieldLabelModeId].ToString(); // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup("AuditHistory", "Audit", "AuditHistoryId", true, true, (int)Framework.Components.DataAccess.SystemEntity.ApplicationEntityFieldLabelMode, ApplicationEntityFieldLabelModeId, "ApplicationEntityFieldLabel"); dynAuditHistory.Visible = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "ApplicationEntityFieldLabelMode"); } else { txtApplicationEntityFieldLabelModeId.Text = string.Empty; } txtName.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.Name].ToString(); txtDescription.Value = row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.Description].ToString(); txtSortOrder.Text = row[Framework.Components.UserPreference.ApplicationEntityFieldLabelMode.DataColumns.SortOrder].ToString(); oUpdateInfo.LoadText(oApplicationEntityFieldLabelModeTable.Rows[0]); } else { txtApplicationEntityFieldLabelModeId.Text = string.Empty; txtName.Text = string.Empty; txtDescription.Value = string.Empty; txtSortOrder.Text = string.Empty; } }
private void BindColumns(DataTable dt, string tableName, string primaryKeyId, bool hideData, bool isTesting, string[] validColumns, string userPreferenceCategory) { gridFormatdt = GetGridFormatSettings(); // boolean values set for the fields and procedures in the GridView var procedureHide = hideData; var fieldHide = false; // Create a string array for DataNavigationUrlFields var str = new string[2]; str[0] = primaryKeyId; str[1] = dt.Columns[0].ColumnName; // Create rest of columns based on what user has access to ... var key = "Default"; var disableLink = hideData; var idColumn = new DataColumn(str[0]); if (idColumn != null) { for (var i = 0; i < validColumns.Length; i++) { if (validColumns[i].Equals(idColumn.ColumnName)) { if (!string.IsNullOrEmpty(GroupByField) || idColumn.ColumnName != GroupByField) { // dynamically add hyperlink fields from the data table SetHyperLink(idColumn, str, tableName, disableLink); } } } } foreach (DataRow row in gridFormatdt.Rows) { //Considering all the columns have their width fixed from the Database totalGridColumnWidth += Double.Parse(row[FieldConfiguration.DataColumns.Width].ToString()); } foreach (var t in validColumns) { // get the column from the data table if (!t.Equals(idColumn.ColumnName)) { var dataColumn = dt.Columns[t]; //var i = 0; //str[0] = t; //str[1] = t; if (dataColumn != null) { if (string.IsNullOrEmpty(GroupByField) || dataColumn.ColumnName != GroupByField) { //if (dataColumn.ColumnName.ToLower() != idColumn.ColumnName.ToLower()) // dynamically add hyperlink fields from the data table SetHyperLink(dataColumn, str, tableName, disableLink); } } } } if (SessionVariables.ApplicationUserRoles == null) { ApplicationCommon.SetApplicationUserRoles(); } var roles = SessionVariables.ApplicationUserRoles; var role = roles.Find(item => item.ApplicationRole == "System Coordinator"); if (role != null) { disabledelete = false; } else { disabledelete = true; } // based on another bool parameters indicating if action buttons should show // add action button / links if (IsUpdateColumn) { var userDetailVisibility = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.GridDetailLinkVisibleKey, userPreferenceCategory); if (userDetailVisibility) { var userAction = ApplicationCommon.GetUserPreferenceByKey(ApplicationCommon.GridDefaultClickActionKey); //var userAction = ApplicationCommon.GetDefaultActionLink(); if (userAction == "update") { ListHelper.AddProcedures(MainGridView, ViewState, str, VIEW_STATE_KEY_DETAIL, tableName, procedureHide); } else { ListHelper.AddProcedures(MainGridView, ViewState, str, VIEW_STATE_KEY_UPDATE, tableName, procedureHide); } } } if (IsDeleteColumn) { var userDeleteVisibility = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.GridDeleteLinkVisibleKey, userPreferenceCategory); if (userDeleteVisibility) { ListHelper.AddProcedures(MainGridView, ViewState, str, VIEW_STATE_KEY_DELETE, tableName, procedureHide); } } }
private void BindColumns(DataTable dt, string tableName, string primaryKeyId, bool hideData, bool isTesting) { gridFormatdt = GetGridFormatSettings(); // if (IsPostBack) return; // Create Column 0 --> PrimaryKey // Declare the bound field and allocate memory for the bound field. // Initalize the DataField value. //var bfield = new BoundField { DataField = primaryKeyId }; //bfield.ItemStyle.HorizontalAlign = HorizontalAlign.Center; //bfield.HeaderText = dt.Columns[0].ColumnName.Replace("Id", " Id"); //bfield.Visible = isTesting; //// ConvertStringArrayToString(dt.Columns[0].ColumnName.Split(new char[] { 'I' }, 1)); //// Add the newly created bound field to the GridView. //if(!dt.Columns[0].ColumnName.Equals("PersonId")) //MainGridView.Columns.Add(bfield); // boolean values set for the fields and procedures in the GridView var procedureHide = hideData; var fieldHide = false; // Create a string array for DataNavigationUrlFields var str = new string[2]; str[0] = primaryKeyId; str[1] = dt.Columns[0].ColumnName; // Create rest of columns based on what user has access to ... var key = "Default"; var disableLink = hideData; var validColumns = _getColumnDelegate(); //if (!string.IsNullOrEmpty(GroupByField) && validColumns.Contains(GroupByField)) //{ // //validColumns.d //} var idColumn = new DataColumn(str[0]); if (idColumn != null) { for (var i = 0; i < validColumns.Length; i++) { if (validColumns[i].Equals(idColumn.ColumnName)) { if (!string.IsNullOrEmpty(GroupByField) || idColumn.ColumnName != GroupByField) { // dynamically add hyperlink fields from the data table SetHyperLink(idColumn, str, tableName, disableLink); } } } } foreach (DataRow row in gridFormatdt.Rows) { //Considering all the columns have their width fixed from the Database totalGridColumnWidth += Double.Parse(row[FieldConfiguration.DataColumns.Width].ToString()); } foreach (var t in validColumns) { // get the column from the data table if (!t.Equals(idColumn.ColumnName)) { var dataColumn = dt.Columns[t]; //var i = 0; //str[0] = t; //str[1] = t; if (dataColumn != null) { if (string.IsNullOrEmpty(GroupByField) || dataColumn.ColumnName != GroupByField) { //if (dataColumn.ColumnName.ToLower() != idColumn.ColumnName.ToLower()) // dynamically add hyperlink fields from the data table SetHyperLink(dataColumn, str, tableName, disableLink); } } } } if (SessionVariables.ApplicationUserRoles == null) { ApplicationCommon.SetApplicationUserRoles(); } var roles = SessionVariables.ApplicationUserRoles; var role = roles.Find(item => item.ApplicationRole == "System Coordinator"); if (role != null) { disabledelete = false; } else { disabledelete = true; } // based on another bool parameters indicating if action buttons should show // add action button / links if (IsUpdateColumn) { var userDetailVisibility = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.GridDetailLinkVisibleKey, this.UserPreferenceCategory); if (userDetailVisibility) { var userAction = ApplicationCommon.GetUserPreferenceByKey(ApplicationCommon.GridDefaultClickActionKey); //var userAction = ApplicationCommon.GetDefaultActionLink(); if (userAction == "update") { ListHelper.AddProcedures(MainGridView, ViewState, str, VIEW_STATE_KEY_DETAIL, tableName, procedureHide); } else { ListHelper.AddProcedures(MainGridView, ViewState, str, VIEW_STATE_KEY_UPDATE, tableName, procedureHide); } } } if (IsDeleteColumn) { var userDeleteVisibility = ApplicationCommon.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.GridDeleteLinkVisibleKey, this.UserPreferenceCategory); if (userDeleteVisibility) { ListHelper.AddProcedures(MainGridView, ViewState, str, VIEW_STATE_KEY_DELETE, tableName, procedureHide); } } }