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