private void SetupDropdown() { var isTesting = SessionVariables.IsTesting; drpParentMenu.ClearSelection(); var parentMenudata = MenuDataManager.GetList(null, SessionVariables.RequestProfile); UIHelper.LoadDropDown(parentMenudata, drpParentMenu, MenuDataModel.DataColumns.MenuDisplayName, MenuDataModel.DataColumns.MenuId); if (isTesting) { drpParentMenu.AutoPostBack = true; if (drpParentMenu.Items.Count > 0) { if (!string.IsNullOrEmpty(txtParentMenuId.Text.Trim())) { drpParentMenu.SelectedValue = txtParentMenuId.Text; } else { txtParentMenuId.Text = drpParentMenu.SelectedItem.Value; } } txtParentMenuId.Visible = true; } else { if (!string.IsNullOrEmpty(txtParentMenuId.Text.Trim())) { drpParentMenu.SelectedValue = txtParentMenuId.Text; } } }
protected override void ShowData(int menuid) { oDetailButtonPanel.SetId = SetId; var data = new MenuDataModel(); data.MenuId = menuid; var items = MenuDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblMenuId.Text = item.MenuId.ToString(); lblName.Text = item.Name; lblDescription.Text = item.Description; lblSortOrder.Text = item.SortOrder.ToString(); lblParentMenuId.Text = item.ParentMenuId.ToString(); lblPrimaryDeveloper.Text = item.PrimaryDeveloper; lblIsVisible.Text = item.IsVisible.ToString(); lblIsChecked.Text = item.IsChecked.ToString(); lblNavigateURL.Text = item.NavigateURL; oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, menuid, "Menu"); } else { Clear(); } }
public void LoadData(int menuId, bool showId) { // clear UI Clear(); // set up parameters var data = new MenuDataModel(); data.MenuId = menuId; // get data var items = MenuDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; txtDescription.Value = item.Description; txtName.Text = item.Name; txtSortOrder.Text = item.SortOrder.ToString(); txtDisplayName.Text = item.MenuDisplayName; txtNavigateURL.Text = item.NavigateURL; txtParentMenuId.Text = item.ParentMenuId.ToString(); txtApplicationId.Text = item.ApplicationId.ToString(); txtPrimaryDeveloper.Text = item.PrimaryDeveloper; txtSortOrder.Text = item.SortOrder.ToString(); txtApplicationModule.Text = item.ApplicationModule; if (item.ParentMenuId != null) { var parentMenu = new MenuDataModel(); parentMenu.ParentMenuId = item.ParentMenuId; parentMenu.Name = item.Name; parentMenu.PrimaryDeveloper = item.PrimaryDeveloper; var parentMenudata = MenuDataManager.GetDetails(parentMenu, SessionVariables.RequestProfile); drpParentMenu.SelectedItem.Value = parentMenudata.ToString(); } if (!showId) { txtMenuId.Text = item.MenuId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, menuId, PrimaryEntityKey); } else { txtMenuId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
protected override void Update(Dictionary <string, string> values) { // set data var data = new MenuDataModel(); // copies properties from values dictionary object to Menu data object PropertyMapper.CopyProperties(data, values); // save datga MenuDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
protected void btnCreate_Click(object sender, EventArgs e) { var dataFES = new FunctionalityEntityStatusDataModel(); dataFES.FunctionalityId = FunctionalityId; var fesData = FunctionalityEntityStatusDataManager.Search(dataFES, SessionVariables.RequestProfile); if (fesData.Rows.Count == 0) { var dtMenu = MenuDataManager.GetList(SessionVariables.RequestProfile); var entitydt = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); //get data based on Entity Name from Menu and SystemEntity table to get the Primary Developer value var assignedTo = from tblMenu in dtMenu.AsEnumerable() join tblEntity in entitydt.AsEnumerable() on tblMenu.Field <string>(MenuDataModel.DataColumns.Name) equals tblEntity.Field <string>(SystemEntityTypeDataModel.DataColumns.EntityName) select tblEntity; //get data from SystemEntity table which doesnt have matching entries in Menu table var assignedToAdmin = from tblEntity in entitydt.AsEnumerable() where !assignedTo.Contains(tblEntity) select tblEntity; string assignedToValue = string.Empty; //data inserted to FES with AssignedTo value as PrimaryDeveloper value for (int i = 0; i < assignedTo.Count(); i++) { var primaryDeveloper = from tblMenu in dtMenu.AsEnumerable() join tblEntity in entitydt.AsEnumerable() on tblMenu.Field <string>(MenuDataModel.DataColumns.Name) equals tblEntity.Field <string>(SystemEntityTypeDataModel.DataColumns.EntityName) where tblMenu.Field <string>(MenuDataModel.DataColumns.Name) == assignedTo.CopyToDataTable().Rows[i][SystemEntityTypeDataModel.DataColumns.EntityName].ToString() select tblMenu[MenuDataModel.DataColumns.PrimaryDeveloper]; assignedToValue = primaryDeveloper.First().ToString(); Insert(assignedTo.CopyToDataTable().Rows[i], assignedToValue); } //data inserted to FES with AssignedTo value as "Admin" for (int j = 0; j < assignedToAdmin.Count(); j++) { assignedToValue = "Admin"; Insert(assignedToAdmin.CopyToDataTable().Rows[j], assignedToValue); } } }
public override int?Save(string action) { var data = new MenuDataModel(); data.Name = Name; data.Description = Description; data.SortOrder = SortOrder; data.MenuDisplayName = DisplayName; data.NavigateURL = NavigateURL; data.IsChecked = IsChecked; data.IsVisible = IsVisible; data.ParentMenuId = ParentMenuId; data.PrimaryDeveloper = PrimaryDeveloper; data.ApplicationId = ApplicationId; data.ApplicationModule = ApplicationModule; if (action == "Insert") { var dtMenu = MenuDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtMenu.Rows.Count == 0) { data.MenuId = MenuDataManager.Create(data, SessionVariables.RequestProfile); var dataDisplayName = new MenuDisplayNameDataModel(); dataDisplayName.MenuId = data.MenuId; dataDisplayName.Value = DisplayName; dataDisplayName.LanguageId = ApplicationCommon.LanguageId; dataDisplayName.IsDefault = 1; MenuDisplayNameDataManager.Create(dataDisplayName, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { data.MenuId = MenuId; MenuDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of ClientID ? return(data.MenuId); }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var menudata = new MenuDataModel(); selectedrows = MenuDataManager.GetDetails(menudata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { menudata.MenuId = entityKey; var result = MenuDataManager.GetDetails(menudata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { menudata.MenuId = SetId; var result = MenuDataManager.GetDetails(menudata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
protected override DataTable GetData() { var dt = MenuDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile); return(dt); }
public virtual void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl) { DataTable dataSource = null; if (fieldName.Equals("Application")) { dataSource = ApplicationDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, BaseDataModel.BaseDataColumns.ApplicationId); dropDownListControl.SelectedValue = SessionVariables.RequestProfile.ApplicationId.ToString(); } else if (fieldName.Equals("ParentMenu")) { var data = new MenuDataModel(); var appId = BaseSearchFilterControl.GetParameterValueAsInt("Application"); if (appId.HasValue) { data.ApplicationId = appId.Value; } else { data.ApplicationId = SessionVariables.RequestProfile.ApplicationId; } dataSource = MenuDataManager.ListOfParentMenuOnly(data, SessionVariables.RequestProfile); dataSource.DefaultView.Sort = StandardDataModel.StandardDataColumns.Name + " ASC"; dataSource = dataSource.DefaultView.ToTable(); dropDownListControl.Items.Clear(); dropDownListControl.Items.Add(new ListItem("All", "-1")); dropDownListControl.DataSource = dataSource; dropDownListControl.DataTextField = StandardDataModel.StandardDataColumns.Name; dropDownListControl.DataValueField = MenuDataModel.DataColumns.MenuId; dropDownListControl.DataBind(); } else if (fieldName.Equals("FunctionalityId")) { dataSource = FunctionalityDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityDataModel.DataColumns.FunctionalityId); } else if (fieldName.Equals("DeveloperRoleId")) { dataSource = DeveloperRoleDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, DeveloperRoleDataModel.DataColumns.DeveloperRoleId); } else if (fieldName.Equals("FeatureOwnerStatusId")) { dataSource = FeatureOwnerStatusDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FeatureOwnerStatusDataModel.DataColumns.FeatureOwnerStatusId); } else if (fieldName.Equals("EntityId")) { dataSource = Framework.Components.Core.SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, DataModel.Framework.Core.SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); } else if (fieldName.Equals("ProjectId")) { dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, ProjectDataModel.DataColumns.ProjectId); } else if (fieldName.Equals("ApplicationId")) { var applicationData = ApplicationDataManager.GetList(SessionVariables.RequestProfile); var dv = applicationData.DefaultView; dv.Sort = "Name ASC"; UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl, StandardDataModel.StandardDataColumns.Name, BaseDataModel.BaseDataColumns.ApplicationId); } else if (fieldName.Equals("FunctionalityOwner")) { var drData = FunctionalityOwnerDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); var originalList = new ArrayList(); var duplicateList = new ArrayList(); foreach (DataRow dtRow in drData.Rows) { if (originalList.Contains(dtRow["Developer"])) { duplicateList.Add(dtRow); } else { originalList.Add(dtRow["Developer"]); } } foreach (DataRow dtRow in duplicateList) { drData.Rows.Remove(dtRow); } UIHelper.LoadDropDown(drData, dropDownListControl, FunctionalityOwnerDataModel.DataColumns.Developer, FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId); } else if (fieldName.Equals("FunctionalityActiveStatus")) { var drData = FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId); } else if (fieldName.Equals("FunctionalityImage")) { var drData = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, FunctionalityImageDataModel.DataColumns.Title, FunctionalityImageDataModel.DataColumns.FunctionalityImageId); } else if (fieldName.Equals("FunctionalityImageAttribute")) { var drData = FunctionalityImageAttributeDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId); } }