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);
}
}
}
