public DataTable GetApplicableSystemEntities(int ApplicationId)
{
var dt3 = Framework.Components.Core.SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile);
var entitiesdt = dt3.Clone();
var dt = FieldConfigurationUtility.GetFieldConfigurations(null, null, string.Empty);
var IsRequired = false;
for (var i = 0; i < dt3.Rows.Count; i++)
{
var systementitytypeId = int.Parse(dt3.Rows[i][SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId].ToString());
for (int j = 0; j < dt.Rows.Count; j++)
{
if (systementitytypeId.ToString().Equals
(dt.Rows[j][FieldConfigurationDataModel.DataColumns.SystemEntityTypeId].ToString()))
{
IsRequired = true;
}
}
if (IsRequired)
{
entitiesdt.ImportRow(dt3.Rows[i]);
IsRequired = false;
}
}
return(entitiesdt);
}
private string[] GetColumns()
{
if (!ddlFieldConfigurationMode.SelectedItem.Text.Equals(String.Empty))
{
return(FieldConfigurationUtility.GetEntityColumns(SystemEntity.ScheduleDetail, ddlFieldConfigurationMode.SelectedValue, SessionVariables.RequestProfile));
}
else
{
return(FieldConfigurationUtility.GetEntityColumns(SystemEntity.ScheduleDetail, "DBColumns", SessionVariables.RequestProfile));
}
}
private void BindData(int applicationId)
{
var dtc = FieldConfigurationUtility.GetFieldConfigurations(19000, -15001, string.Empty);
var odt = FieldConfigurationUtility.GetFieldConfigurations(SystemEntityTypeId, AEFLMode, string.Empty);
foreach (DataColumn col in odt.Columns)
{
var colexists = false;
foreach (DataColumn dcol in dtc.Columns)
{
if (dcol.ColumnName == col.ColumnName)
{
colexists = true;
continue;
}
}
if (!colexists)
{
odt.Columns.Remove(col.ColumnName);
}
}
foreach (DataColumn col in dtc.Columns)
{
//Declare the bound field and allocate memory for the bound field.
var bfield = new TemplateField();
////Initalize the DataField value.
//bfield.HeaderTemplate = new eSettingsTemplate(ListItemType.Header, col.ColumnName);
////Initialize the HeaderText field value.
//bfield.ItemTemplate = new eSettingsTemplate(ListItemType.Item, col.ColumnName);
//Add the newly created bound field to the GridView.
EditableGridView.Columns.Add(bfield);
}
EditableGridView.DataSource = odt;
EditableGridView.DataBind();
ReadOnlyGridView.DataSource = odt;
ReadOnlyGridView.DataBind();
ReadOnlyRepeater.DataSource = odt;
ReadOnlyRepeater.DataBind();
EditableRepeater.DataSource = odt;
EditableRepeater.DataBind();
Repeater2.DataSource = odt;
Repeater2.DataBind();
Repeater1.DataSource = odt;
Repeater1.DataBind();
if (!SessionVariables.IsTesting)
{
//EditableGridView.Columns[0].Visible = false;
//ReadOnlyGridView.Columns[0].Visible = false;
}
}
protected string[] GetEntityColumns()
{
if (!GroupListCore.FieldConfigurationMode.Equals(String.Empty))
{
return(FieldConfigurationUtility.GetEntityColumns(GroupListCore.FieldConfigurationMode, PrimaryEntity, SessionVariables.RequestProfile));
}
else
{
return(FieldConfigurationUtility.GetEntityColumns("DBColumns", PrimaryEntity, SessionVariables.RequestProfile));
}
}
protected void ItemBound(object sender, RepeaterItemEventArgs args)
{
var dtc = FieldConfigurationUtility.GetFieldConfigurations(19000, -15001, string.Empty);
var finalodt = new DataTable();
finalodt.Columns.Add(new DataColumn("Name"));
finalodt.Columns.Add(new DataColumn("Value"));
if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem)
{
var childRepeater = (Repeater)args.Item.FindControl("InnerRepeater");
var hdnfield = (HiddenField)args.Item.FindControl("hdncol");
if (hdnfield != null && childRepeater != null)
{
var odt = FieldConfigurationUtility.GetFieldConfigurations(SystemEntityTypeId, AEFLMode, hdnfield.Value);
foreach (DataColumn col in odt.Columns)
{
var colexists = false;
foreach (DataColumn dcol in dtc.Columns)
{
if (dcol.ColumnName == col.ColumnName)
{
colexists = true;
continue;
}
}
if (!colexists)
{
odt.Columns.Remove(col.ColumnName);
}
}
if (odt.Rows.Count >= 1)
{
foreach (DataColumn dcol in dtc.Columns)
{
var row = finalodt.NewRow();
row["Name"] = dcol.ColumnName;
if (odt.Columns.Contains(dcol.ColumnName))
{
row["Value"] = odt.Rows[0][dcol.ColumnName];
}
finalodt.Rows.Add(row);
}
}
}
childRepeater.DataSource = finalodt;
childRepeater.DataBind();
}
}
public override int?Save(string action)
{
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = FieldConfigurationId;
data.SystemEntityTypeId = SystemEntityTypeId;
data.ApplicationId = ApplicationId;
data.FieldConfigurationDisplayName = DisplayName;
data.Name = Name;
data.Value = Value;
data.Width = Width;
data.Formatting = Formatting;
data.ControlType = ControlType;
data.HorizontalAlignment = HorizontalAlignment;
data.GridViewPriority = GridViewPriority;
data.DetailsViewPriority = DetailsViewPriority;
data.FieldConfigurationModeId = FieldConfigurationModeId;
data.DisplayColumn = DisplayColumn;
data.CellCount = CellCount;
if (action == "Insert")
{
var dtFieldConfiguration = FieldConfigurationDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtFieldConfiguration.Rows.Count == 0)
{
data.FieldConfigurationId = FieldConfigurationDataManager.Create(data, SessionVariables.RequestProfile);
var dataDisplayName = new FieldConfigurationDisplayNameDataModel();
dataDisplayName.FieldConfigurationId = data.FieldConfigurationId;
dataDisplayName.Value = DisplayName;
dataDisplayName.LanguageId = ApplicationCommon.LanguageId;
dataDisplayName.IsDefault = 1;
FieldConfigurationDisplayNameDataManager.Create(dataDisplayName, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Unique Combination already exists.");
}
}
else
{
FieldConfigurationDataManager.Update(data, SessionVariables.RequestProfile);
}
FieldConfigurationUtility.SetFieldConfigurations();
// not correct ... when doing insert, we didn't get/change the value of FieldConfigurationId ?
return(data.FieldConfigurationId);
}
private string[] GetScheduleDetailColumns()
{
var fc = SessionVariables.FieldConfigurationMode;
var fcMode = string.Empty;
if (fc == 0)
{
fcMode = "DBColumns";
}
else
{
fcMode = fc.ToString();
}
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.ScheduleDetail, fcMode, SessionVariables.RequestProfile));
}
//
// GET: /FunctionalityDevelopmentStep/
public ActionResult Index(string searchString, int?page, int?pageSize)
{
var dtFCModes = FieldConfigurationUtility.GetApplicableModesList(Framework.Components.DataAccess.SystemEntity.DailyTaskItemQueueStatus);
var firstFCMode = PerferenceUtility.GetUserPreferenceByKeyAsInt(ApplicationCommon.FieldConfigurationMode, settingCategory);
var listItemsfieldConfigurationMode = MvcCommon.GetListItems(dtFCModes,
DataModel.Framework.Configuration.FieldConfigurationModeDataModel.DataColumns.FieldConfigurationModeId,
DataModel.Framework.Configuration.FieldConfigurationModeDataModel.DataColumns.Name,
firstFCMode);
ViewBag.FieldConfigurationMode = new SelectList(listItemsfieldConfigurationMode, "Value", "Text", firstFCMode);
ViewBag.KendoUIConfigurationString = GetKendoGridConfiguration(searchString, firstFCMode);
return(View());
}
// GET: /ReleaseNoteBusinessDifficulty/
public ActionResult Index(string searchString, int?page, int?pageSize)
{
var dtFCModes = FieldConfigurationUtility.GetApplicableModesList(SystemEntity.ReleaseNoteBusinessDifficulty);
var firstFCMode = PerferenceUtility.GetUserPreferenceByKeyAsInt(ApplicationCommon.FieldConfigurationMode, settingCategory);
var listItemsfieldConfigurationMode = MvcCommon.GetListItems(dtFCModes,
FieldConfigurationModeDataModel.DataColumns.FieldConfigurationModeId,
StandardDataModel.StandardDataColumns.Name,
firstFCMode);
ViewBag.FieldConfigurationMode = new SelectList(listItemsfieldConfigurationMode, "Value", "Text", firstFCMode);
ViewBag.KendoUIConfigurationString = GetKendoGridConfiguration(searchString, firstFCMode);
return(View());
}
public IEnumerable <FieldConfigurationModeDataModel> GetFCModes(string value)
{
var systemEntity = (SystemEntity)Enum.Parse(typeof(SystemEntity), value, true);
var dtFCModes = FieldConfigurationUtility.GetApplicableModesList(systemEntity);
var lstFCModes = new List <FieldConfigurationModeDataModel>();
foreach (DataRow dataRow in dtFCModes.Rows)
{
var model = new FieldConfigurationModeDataModel();
model.Name = dataRow["Name"].ToString();
model.FieldConfigurationModeId = int.Parse(dataRow["FieldConfigurationModeId"].ToString());
lstFCModes.Add(model);
}
return(lstFCModes);
}
private string[] GetColumns()
{
string[] validColumns;
if (ViewMode == GridViewMode.Advanced)
{
if (AdvancedModeGrouping == GridViewAdvancedModeGrouping.AuditAction)
{
validColumns = FieldConfigurationUtility.GetAuditHistoryColumns("FindByAuditAction", SessionVariables.RequestProfile);
}
else
{
validColumns = FieldConfigurationUtility.GetAuditHistoryColumns("Default", SessionVariables.RequestProfile);
}
}
else
{
validColumns = FieldConfigurationUtility.GetAuditHistoryColumns("Find", SessionVariables.RequestProfile);
}
return(validColumns);
}
private List <string> GetKendoColumnSetByFCMode(int fcModeId)
{
var lstColumns = new List <string>();
var systemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.DailyTaskItemQueueStatus;
var dtConfigurations = FieldConfigurationUtility.GetFieldConfigurations(systemEntityTypeId, fcModeId, string.Empty);
foreach (DataRow row in dtConfigurations.Rows)
{
var columnName = Convert.ToString(row[DataModel.Framework.Configuration.FieldConfigurationDataModel.DataColumns.Name]);
//var title = Convert.ToString(row[DataModel.Framework.Configuration.FieldConfigurationDataModel.DataColumns.FieldConfigurationDisplayName]);
//var width = Convert.ToString(row[DataModel.Framework.Configuration.FieldConfigurationDataModel.DataColumns.Width]);
//str.AppendLine(" { field: '" + columnName + "', title: '" + title + "', width: " + width + " },");
lstColumns.Add(columnName);
}
return(lstColumns);
}
private int SetUpDropDownFCMode()
{
//var systemEntityTypeId = (int)Enum.Parse(typeof(SystemEntity), "ScheduleDetail");
///var dt = GetApplicableModesList(systemEntityTypeId);
var systemEntityType = (SystemEntity)Enum.Parse(typeof(SystemEntity), "ScheduleDetail");
var dt = FieldConfigurationUtility.GetApplicableModesList(systemEntityType);
var modeSelected = SessionVariables.GetSessionInstanceFCMode("ScheduleDetail");
var settingCategory = "ScheduleDetailDefaultViewListControl";
var upcId = PerferenceUtility.CreateUserPreferenceCategoryIfNotExists(settingCategory, settingCategory);
var fcModeSelected = PerferenceUtility.GetUserPreferenceByKey(ApplicationCommon.FieldConfigurationMode, settingCategory);
var currentEntity = "ScheduleDetail";
if (dt.Rows.Count > 0)
{
ddlFieldConfigurationMode.DataSource = dt;
ddlFieldConfigurationMode.DataTextField = "Name";
ddlFieldConfigurationMode.DataValueField = "FieldConfigurationModeId";
ddlFieldConfigurationMode.DataBind();
ddlFieldConfigurationMode.SelectedValue = modeSelected.ToString();
if (Convert.ToInt32(fcModeSelected) > 0)
{
ddlFieldConfigurationMode.SelectedValue = fcModeSelected.ToString();
SessionVariables.SaveSessionInstanceFCMode(Convert.ToInt32(fcModeSelected), currentEntity);
modeSelected = (int)Session["ScheduleDetail" + "SelectedMode"];
}
else
{
ddlFieldConfigurationMode.SelectedValue = modeSelected.ToString();
}
}
else
{
ddlFieldConfigurationMode.Visible = false;
}
return(modeSelected);
}
public IEnumerable <FieldConfigurationDataModel> GetFieldConfigurations(string value, string value1)
{
var entityName = value1;
var lstColumns = new List <FieldConfigurationDataModel>();
var systemEntityTypeId = ((int)(SystemEntity)Enum.Parse(typeof(SystemEntity), entityName, true));
var dtConfigurations = FieldConfigurationUtility.GetFieldConfigurations(systemEntityTypeId, Convert.ToInt32(value), string.Empty);
foreach (DataRow row in dtConfigurations.Rows)
{
var fcObj = new FieldConfigurationDataModel();
fcObj.Name = row[FieldConfigurationDataModel.DataColumns.Name].ToString();
fcObj.FieldConfigurationDisplayName = row[FieldConfigurationDataModel.DataColumns.FieldConfigurationDisplayName].ToString();
fcObj.HorizontalAlignment = row[FieldConfigurationDataModel.DataColumns.HorizontalAlignment].ToString();
fcObj.GridViewPriority = int.Parse(row[FieldConfigurationDataModel.DataColumns.GridViewPriority].ToString());
fcObj.ControlType = row[FieldConfigurationDataModel.DataColumns.ControlType].ToString();
lstColumns.Add(fcObj);
}
return(lstColumns);
}
private string[] GetNeedXFeatureColumns()
{
var validColumns = FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.NeedXFeature, "Default", SessionVariables.RequestProfile);
return(validColumns);
}
private string[] GetScheduleItemColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.ScheduleItem, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetFunctionalityEntityStatusArchiveColumns()
{
//return Framework.Components.ApplicationSecurity.GetFunctionalityEntityStatusArchiveColumns("FunctionalityEntityStatusArchive_PC", SessionVariables.RequestProfile);
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.FunctionalityEntityStatusArchive, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetProductivityAreaFeatureXApplicationUserColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.ProductivityAreaFeatureXApplicationUser, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.UserPreferenceSelectedItem, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetColumns()
{
var validColumns = FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.ActivityXDeliverableArtifact, "DBColumns", SessionVariables.RequestProfile);
return(validColumns);
}
private string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.FunctionalityImageInstance, "DBColumns", SessionVariables.RequestProfile));
}
protected override string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(InlineUpdateColumnsModeId.ToString(), Framework.Components.DataAccess.SystemEntity.Menu, SessionVariables.RequestProfile));
}
private string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.UseCaseWorkFlowCategory, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetFunctionalityEntityStatusColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.FunctionalityEntityStatus, fesTabFCMode, SessionVariables.RequestProfile));
}
private string[] GetMilestoneXFeatureArchiveColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(SystemEntity.MilestoneXFeatureArchive, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetColumns()
{
var validColumns = FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.UseCasePackageXUseCase, "DBColumns", SessionVariables.RequestProfile);
return(validColumns);
}
private string[] GetQuestionColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(SystemEntity.Question, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.ApplicationMonitoredEventProcessingState, "DBColumns", SessionVariables.RequestProfile));
}
private string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(Framework.Components.DataAccess.SystemEntity.TabChildStructure, "DBColumns", SessionVariables.RequestProfile));
}
protected virtual string[] GetColumns()
{
return(FieldConfigurationUtility.GetEntityColumns(InlineUpdateColumnsModeId.ToString(), PrimaryEntity, SessionVariables.RequestProfile));
}
