private DataTable GetData()
{
var data = new FunctionalityEntityStatusDataModel();
var dt = FunctionalityEntityStatusDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public override int?Save(string action)
{
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = FunctionalityEntityStatusId;
data.FunctionalityId = FunctionalityId;
data.FunctionalityPriorityId = FunctionalityPriorityId;
data.FunctionalityStatusId = FunctionalityStatusId;
data.Memo = Memo;
data.StartDate = StartDate;
data.TargetDate = TargetDate;
data.SystemEntityTypeId = SystemEntityTypeId;
data.AssignedTo = AssignedTo;
if (action == "Insert")
{
var dtClient = FunctionalityEntityStatusDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtClient.Rows.Count == 0)
{
FunctionalityEntityStatusDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
FunctionalityEntityStatusDataManager.Update(data, SessionVariables.RequestProfile);
}
// not correct ... when doing insert, we didn't get/change the value of ClientID ?
return(data.FunctionalityEntityStatusId);
}
protected override void ShowData(int functionalityEntityStatusid)
{
oDetailButtonPanel.SetId = SetId;
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = functionalityEntityStatusid;
var items = FunctionalityEntityStatusDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count == 1)
{
var item = items[0];
lblFunctionalityEntityStatusId.Text = item.FunctionalityEntityStatusId.ToString();
lblSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString();
lblFunctionalityId.Text = Convert.ToString(item.FunctionalityId);
lblFunctionalityStatusId.Text = Convert.ToString(item.FunctionalityStatusId);
lblFunctionalityPriorityId.Text = Convert.ToString(item.FunctionalityPriorityId);
lblAssignedTo.Text = Convert.ToString(item.AssignedTo);
lblMemo.Text = Convert.ToString(item.Memo);
lblTargetDate.Text = Convert.ToString(item.TargetDate);
lblStartDate.Text = Convert.ToString(item.StartDate);
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
oHistoryList.Setup(PrimaryEntity, functionalityEntityStatusid, "FunctionalityEntityStatus");
}
else
{
Clear();
}
}
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 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);
}
}
}
protected override DataTable GetData()
{
Log4Net.LogInfo("Step3 Get FES Search results START", "FES Search", SessionVariables.RequestProfile.ApplicationId);
var dt = FunctionalityEntityStatusDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
if (oSearchFilter.ShowGraph)
{
oGroupList.Visible = false;
FESChart1.Visible = true;
}
else
{
oGroupList.Visible = true;
FESChart1.Visible = false;
}
Log4Net.LogInfo("Step3 Get FES Search results END", "FES Search", SessionVariables.RequestProfile.ApplicationId);
return(dt);
}
public void Insert(DataRow dtRow, string assignedTo)
{
var data = new FunctionalityEntityStatusDataModel();
data.SystemEntityTypeId = Convert.ToInt32(dtRow[SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId]);
data.ApplicationId = Convert.ToInt32(ddlApplication.SelectedValue);
data.FunctionalityId = FunctionalityId;
data.Memo = Functionality;;
data.AssignedTo = assignedTo;
data.FunctionalityPriorityId = ApplicationCommon.FunctionalityPriority;
data.FunctionalityStatusId = ApplicationCommon.FunctionalityStatus;
data.StartDate = DateTime.Now;
data.TargetDate = DateTime.Now.AddDays(7);
var dtFES = FunctionalityEntityStatusDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtFES.Rows.Count == 0)
{
FunctionalityEntityStatusDataManager.Create(data, SessionVariables.RequestProfile);
}
}
public void LoadData(int functionalityEntityStatusid, bool showId)
{
// clear UI
Clear();
// set up parameters
var data = new FunctionalityEntityStatusDataModel();
data.FunctionalityEntityStatusId = functionalityEntityStatusid;
// get data
var items = FunctionalityEntityStatusDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
// should only have single match -- should log exception.
if (items.Count != 1)
{
return;
}
var item = items[0];
txtFunctionalityEntityStatusId.Text = item.FunctionalityEntityStatusId.ToString();
txtFunctionalityId.Text = item.FunctionalityId.ToString();
txtFunctionalityPriorityId.Text = item.FunctionalityPriorityId.ToString();
txtFunctionalityStatusId.Text = item.FunctionalityStatusId.ToString();
txtSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString();
txtAssignedTo.Text = item.AssignedTo;
txtMemo.Text = item.Memo;
txtTargetDate.Text = item.TargetDate.Value.ToString(SessionVariables.UserDateFormat);
txtStartDate.Text = item.StartDate.Value.ToString(SessionVariables.UserDateFormat);
drpSystemEntityTypeList.SelectedValue = item.SystemEntityTypeId.ToString();
drpFunctionalityList.SelectedValue = item.FunctionalityId.ToString();
drpFunctionalityStatusList.SelectedValue = item.FunctionalityStatusId.ToString();
drpFunctionalityPriorityList.SelectedValue = item.FunctionalityPriorityId.ToString();
if (!showId)
{
txtFunctionalityEntityStatusId.Text = item.FunctionalityEntityStatusId.ToString();
//PlaceHolderAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup(PrimaryEntity, functionalityEntityStatusid, PrimaryEntityKey);
var listControl = (DetailsWithChildrenControl)Page.LoadControl(ApplicationCommon.DetailsWithChildrenListControl);
listControl.Setup("FunctionalityEntityStatusArchive", "", "FunctionalityEntityStatusArchiveId", functionalityEntityStatusid, true, GetData, GetFunctionalityEntityStatusArchiveColumns, "FunctionalityEntityStatusArchive");
listControl.SetSession("true");
listControl.HideControls();
plcControlHolder.Controls.Add(listControl);
plcControlHolder.Controls.Add(new Literal()
{
Text = "<br />"
});
}
else
{
txtFunctionalityEntityStatusId.Text = String.Empty;
}
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
public void GenerateChart()
{
var startDate = DateTime.Now.AddMonths(-3);
var endDate = DateTime.Now;
DataTable functionalityEntityStatusGroupByData = null;
if (txtSearchConditionToDate1.Text != "" && txtSearchConditionToDate2.Text != "")
{
startDate = DateTime.ParseExact(txtSearchConditionToDate1.Text, SessionVariables.UserDateFormat, DateTimeFormatInfo.InvariantInfo);
endDate = DateTime.ParseExact(txtSearchConditionToDate2.Text, SessionVariables.UserDateFormat, DateTimeFormatInfo.InvariantInfo);
}
if (ddlGroupBy.SelectedValue == "Date")
{
//functionalityEntityStatusGroupByData = FunctionalityEntityStatusDataManager.GetDateRangeList(drpSearchConditionFunctionality.SelectedItem.Text, startDate, endDate);
}
else
{
if (lnkGridSummary.Text.Contains("Stack"))
{
functionalityEntityStatusGroupByData = FunctionalityEntityStatusDataManager.GetAggregateList(Convert.ToInt32(drpSearchConditionFunctionality.SelectedItem.Value), ddlSubGroupBy.SelectedValue, ddlGroupBy.SelectedValue, startDate, endDate, SessionVariables.RequestProfile);
}
else
{
functionalityEntityStatusGroupByData = FunctionalityEntityStatusDataManager.GetAggregateList(Convert.ToInt32(drpSearchConditionFunctionality.SelectedItem.Value), ddlGroupBy.SelectedValue, ddlSubGroupBy.SelectedValue, startDate, endDate, SessionVariables.RequestProfile);
}
}
if (functionalityEntityStatusGroupByData != null)
{
for (var i = 0; i < functionalityEntityStatusGroupByData.Rows.Count; i++)
{
var strSubGroup = functionalityEntityStatusGroupByData.Rows[i][3].ToString();
if (Chart1.Series.Count == 0)
{
Chart1.Series.Add(strSubGroup);
}
Series series = Chart1.Series.FindByName(strSubGroup);
if (series == null)
{
Chart1.Series.Add(strSubGroup);
}
if (lnkGridSummary.Text.Contains("Stack"))
{
Chart1.Series[strSubGroup].ChartType = SeriesChartType.Pie;
}
Chart1.Series[strSubGroup].ChartType = SeriesChartType.StackedColumn;
Chart1.Series[strSubGroup].Points.AddXY(functionalityEntityStatusGroupByData.Rows[i][2].ToString(), Convert.ToInt32(functionalityEntityStatusGroupByData.Rows[i][0]));
Chart1.Series[strSubGroup].IsValueShownAsLabel = true;
if (lnkGridSummary.Text.Contains("Stack"))
{
Chart1.Series[strSubGroup].ChartType = SeriesChartType.Pie;
}
else
{
Chart1.Series[strSubGroup].ChartType = SeriesChartType.StackedColumn;
}
}
}
}
