protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var functionalityData = FunctionalityEntityStatusDataManager.GetUniqueIdList("Functionality", SessionVariables.RequestProfile);
var functionalityDataList = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
var filteredfunctionalityData = GetFilteredList("Functionality", functionalityData, functionalityDataList);
UIHelper.LoadDropDown(
filteredfunctionalityData
, drpSearchConditionFunctionality
, StandardDataModel.StandardDataColumns.Name
, FunctionalityDataModel.DataColumns.FunctionalityId
);
ddlGroupBy.Items.Add("Date");
LoadSubGroupData();
GetSettings();
GenerateChart();
oSearchActionBar.Setup("FESSummaryChart");
}
//GenerateChart();
SaveSettings();
}
public override void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl)
{
base.LoadDropDownListSources(fieldName, dropDownListControl);
if (fieldName.Equals("Application"))
{
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);
dropDownListControl.SelectedValue = SessionVariables.RequestProfile.ApplicationId.ToString();
}
else if (fieldName.Equals("systemEntityType"))
{
var systemEntityData = FunctionalityEntityStatusDataManager.GetUniqueIdList(
"systemEntityType", SessionVariables.RequestProfile);
var systemEntityDataList = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile);
var filteredsystemEntityData = GetFilteredList("systemEntityType", systemEntityData, systemEntityDataList);
filteredsystemEntityData.DefaultView.Sort = SystemEntityTypeDataModel.DataColumns.EntityName + " ASC";
var sorteddt = filteredsystemEntityData.DefaultView.ToTable();
UIHelper.LoadDropDown(sorteddt, dropDownListControl, SystemEntityTypeDataModel.DataColumns.EntityName,
SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId);
}
else if (fieldName.Equals("Functionality"))
{
var functionalityData = FunctionalityEntityStatusDataManager.GetUniqueIdList(
"Functionality", SessionVariables.RequestProfile);
var functionalityDataList = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
var filteredfunctionalityData = GetFilteredList("Functionality", functionalityData, functionalityDataList);
UIHelper.LoadDropDown(filteredfunctionalityData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
}
else if (fieldName.Equals("FunctionalityPriority"))
{
var functionalityPriorityData = FunctionalityPriorityDataManager.GetList(SessionVariables.RequestProfile);
var dv = functionalityPriorityData.DefaultView;
dv.Sort = "Name ASC";
UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityPriorityDataModel.DataColumns.FunctionalityPriorityId);
}
else if (fieldName.Equals("FunctionalityActiveStatus"))
{
var functionalityActiveStatusData = FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile);
var dv = functionalityActiveStatusData.DefaultView;
dv.Sort = "Name ASC";
UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId);
}
dropDownListControl.SelectedIndex = 0;
}
protected void ddlApplication_SelectedIndexChanged(object sender, EventArgs e)
{
ddlFunctionality.Items.Clear();
var functionalityData = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
var dataView = functionalityData.DefaultView;
dataView.RowFilter = StandardDataModel.StandardDataColumns.ApplicationId + "=" + ddlApplication.SelectedValue;
var dt = dataView.ToTable();
UIHelper.LoadDropDown(dt, ddlFunctionality,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
ddlFunctionality.Items.Insert(0, new ListItem("All", "-1"));
}
public void SetupDropDown()
{
var appData = Framework.Components.ApplicationUser.ApplicationDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(appData, ddlApplication, DataModel.Framework.AuthenticationAndAuthorization.ApplicationDataModel.DataColumns.Name,
DataModel.Framework.AuthenticationAndAuthorization.ApplicationDataModel.DataColumns.ApplicationId);
var functionalityData = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
var dataView = functionalityData.DefaultView;
dataView.RowFilter = StandardDataModel.StandardDataColumns.ApplicationId + "=" + ddlApplication.SelectedValue;
var dt = dataView.ToTable();
UIHelper.LoadDropDown(dt, ddlFunctionality,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
ddlFunctionality.Items.Insert(0, new ListItem("All", "-1"));
}
protected void Page_Load(object sender, EventArgs e)
{
int imageId = Convert.ToInt32(Request.QueryString["imageid"]);
var data = new FunctionalityDataModel();
data.FunctionalityId = imageId;
var dt = FunctionalityDataManager.GetDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count > 0)
{
if (!dt.Rows[0][FunctionalityImageDataModel.DataColumns.Image].Equals(DBNull.Value))
{
var imageData = ((byte[])(dt.Rows[0][FunctionalityImageDataModel.DataColumns.Image]));
Response.Clear();
Response.ContentType = "image/pjpeg";
Response.BinaryWrite(imageData);
Response.End();
}
}
}
protected override DataTable GetData()
{
var dt1 = FunctionalityDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
dt1.Columns.Add("FunctionalityImageId");
string str = string.Empty;
foreach (DataRow dr in dt1.Rows)
{
var functionalityId = Convert.ToInt32(dr["FunctionalityId"]);
var functionalityImageId = string.Empty;
var objFunctionalityXFunctionalityImage = new FunctionalityXFunctionalityImageDataModel();
objFunctionalityXFunctionalityImage.FunctionalityId = Convert.ToInt32(functionalityId);
var dtFunctionalityXFunctionalityImage = FunctionalityXFunctionalityImageDataManager.GetByFunctionality(functionalityId, SessionVariables.RequestProfile);
if (dtFunctionalityXFunctionalityImage != null && dtFunctionalityXFunctionalityImage.Rows.Count > 0)
{
foreach (DataRow drFunctionalityXFunctionalityImage in dtFunctionalityXFunctionalityImage.Rows)
{
if (string.IsNullOrEmpty(functionalityImageId))
{
functionalityImageId = drFunctionalityXFunctionalityImage["FunctionalityImageId"].ToString();
}
else
{
functionalityImageId += ", " + drFunctionalityXFunctionalityImage["FunctionalityImageId"].ToString();
}
}
}
dr["FunctionalityImageId"] = functionalityImageId;
}
return(dt1);
}
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);
}
}
private void SetupDropdown()
{
var isTesting = SessionVariables.IsTesting;
var systemEntityTypeData = SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(systemEntityTypeData, drpSystemEntityTypeList,
SystemEntityTypeDataModel.DataColumns.EntityName,
SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId);
var functionalityData = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityData, drpFunctionalityList,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
var functionalityStatusData = FunctionalityStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityStatusData, drpFunctionalityStatusList,
StandardDataModel.StandardDataColumns.Name,
FunctionalityStatusDataModel.DataColumns.FunctionalityStatusId);
var functionalityPriorityData = FunctionalityPriorityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityPriorityData, drpFunctionalityPriorityList,
StandardDataModel.StandardDataColumns.Name,
FunctionalityPriorityDataModel.DataColumns.FunctionalityPriorityId);
if (isTesting)
{
drpSystemEntityTypeList.AutoPostBack = true;
drpFunctionalityList.AutoPostBack = true;
drpFunctionalityStatusList.AutoPostBack = true;
drpFunctionalityPriorityList.AutoPostBack = true;
if (drpSystemEntityTypeList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtSystemEntityTypeId.Text.Trim()))
{
drpSystemEntityTypeList.SelectedValue = txtSystemEntityTypeId.Text;
}
else
{
txtSystemEntityTypeId.Text = drpSystemEntityTypeList.SelectedItem.Value;
}
}
if (drpFunctionalityList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtFunctionalityId.Text.Trim()))
{
drpFunctionalityList.SelectedValue = txtFunctionalityId.Text;
}
else
{
txtFunctionalityId.Text = drpFunctionalityList.SelectedItem.Value;
}
}
if (drpFunctionalityStatusList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtFunctionalityStatusId.Text.Trim()))
{
drpFunctionalityStatusList.SelectedValue = txtFunctionalityStatusId.Text;
}
else
{
txtFunctionalityStatusId.Text = drpFunctionalityStatusList.SelectedItem.Value;
}
}
if (drpFunctionalityPriorityList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtFunctionalityPriorityId.Text.Trim()))
{
drpFunctionalityPriorityList.SelectedValue = txtFunctionalityPriorityId.Text;
}
else
{
txtFunctionalityPriorityId.Text = drpFunctionalityPriorityList.SelectedItem.Value;
}
}
txtSystemEntityTypeId.Visible = true;
txtFunctionalityId.Visible = true;
txtFunctionalityStatusId.Visible = true;
txtFunctionalityPriorityId.Visible = true;
}
else
{
if (!string.IsNullOrEmpty(txtSystemEntityTypeId.Text.Trim()))
{
drpSystemEntityTypeList.SelectedValue = txtSystemEntityTypeId.Text;
}
if (!string.IsNullOrEmpty(txtFunctionalityId.Text.Trim()))
{
drpFunctionalityList.SelectedValue = txtFunctionalityId.Text;
}
if (!string.IsNullOrEmpty(txtFunctionalityStatusId.Text.Trim()))
{
drpFunctionalityStatusList.SelectedValue = txtFunctionalityStatusId.Text;
}
if (!string.IsNullOrEmpty(txtFunctionalityPriorityId.Text.Trim()))
{
drpFunctionalityPriorityList.SelectedValue = txtFunctionalityPriorityId.Text;
}
txtSystemEntityTypeId.Visible = false;
txtFunctionalityId.Visible = false;
txtFunctionalityStatusId.Visible = false;
txtFunctionalityPriorityId.Visible = false;
}
}
public virtual void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl)
{
DataTable dataSource = null;
if (fieldName.Equals("FunctionalityId"))
{
dataSource = FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
}
else if (fieldName.Equals("ProjectId"))
{
dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
ProjectDataModel.DataColumns.ProjectId);
}
else if (fieldName.Equals("DeveloperRoleId"))
{
dataSource = DeveloperRoleDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
DeveloperRoleDataModel.DataColumns.DeveloperRoleId);
}
else if (fieldName.Equals("UseCaseId"))
{
dataSource = UseCaseDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
UseCaseDataModel.DataColumns.UseCaseId);
}
else if (fieldName.Equals("NeedId"))
{
dataSource = NeedDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
NeedDataModel.DataColumns.NeedId);
}
else if (fieldName.Equals("ProjectUseCaseStatusId"))
{
dataSource = ProjectUseCaseStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(dataSource, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
ProjectUseCaseStatusDataModel.DataColumns.ProjectUseCaseStatusId);
}
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);
}
else if (fieldName.Equals("TabParentStructure"))
{
var drData = TabParentStructureDataManager.GetList(SessionVariables.RequestProfile);
CommonSearchParameters();
UIHelper.LoadDropDown(drData, dropDownListControl,
StandardDataModel.StandardDataColumns.Name,
TabParentStructureDataModel.DataColumns.TabParentStructureId);
}
}