private void BindPortfolios()
{
lbPortfolios.DataTextField = "Title";
lbPortfolios.DataValueField = "ProjectGroupId";
lbPortfolios.DataSource = ProjectGroup.GetProjectGroups();
lbPortfolios.DataBind();
}
private void BindValues()
{
using (IDataReader reader = ProjectGroup.GetProjectGroups(PGID))
{
if (reader.Read())
{
lblTitle.Text = reader["Title"].ToString();
lblDescr.Text = reader["Description"].ToString();
lblCreationDate.Text = ((DateTime)reader["CreationDate"]).ToShortDateString();
lblCreator.Text = CommonHelper.GetUserStatus((int)reader["CreatorId"]);
}
}
dgProjects.Columns[1].HeaderText = LocRM.GetString("title");
dgProjects.Columns[2].HeaderText = LocRM.GetString("manager");
dgProjects.Columns[3].Visible = bCanUpdate;
dgProjects.DataSource = Project.GetListProjectsByFilterDataTable("", 0, 0, 0, -1, PrimaryKeyId.Empty, PrimaryKeyId.Empty, 0, DateTime.Now, 0, DateTime.Now, 0, 0, 0, 0, -PGID, 0, false).DefaultView;
dgProjects.DataBind();
foreach (DataGridItem dgi in dgProjects.Items)
{
ImageButton ib = (ImageButton)dgi.FindControl("ibDelete");
if (ib != null)
{
ib.ToolTip = LocRM.GetString("Delete");
ib.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tWarning") + "')");
}
}
}
private void BindDefaultValues()
{
ddPrjGroup.DataSource = ProjectGroup.GetProjectGroups();
ddPrjGroup.DataTextField = "Title";
ddPrjGroup.DataValueField = "ProjectGroupId";
ddPrjGroup.DataBind();
ddPrjGroup.Items.Insert(0, new ListItem(LocRM.GetString("AllFem"), "0"));
ddPrjPhase.DataSource = Project.GetListProjectPhases();
ddPrjPhase.DataTextField = "PhaseName";
ddPrjPhase.DataValueField = "PhaseId";
ddPrjPhase.DataBind();
ddPrjPhase.Items.Insert(0, new ListItem(LocRM.GetString("AllFem"), "0"));
ddStatus.DataSource = Project.GetListProjectStatus();
ddStatus.DataTextField = "StatusName";
ddStatus.DataValueField = "StatusId";
ddStatus.DataBind();
ddStatus.Items.Insert(0, new ListItem(LocRM.GetString("All"), "0"));
//Client
ClientControl.ObjectType = String.Empty;
ClientControl.ObjectId = PrimaryKeyId.Empty;
btnApplyFilter.Text = LocRM.GetString("Apply");
btnResetFilter.Text = LocRM.GetString("Reset");
}
private void BindValues()
{
using (IDataReader reader = ProjectGroup.GetProjectGroups(PGID))
{
if (reader.Read())
{
txtTitle.Text = reader["Title"].ToString();
txtDescr.Text = reader["Description"].ToString();
}
}
}
private void BindToolbar()
{
if (ProjectId > 0)
{
secHeader.Title = LocRM.GetString("tAddRelProject") + "'" + Task.GetProjectTitle(ProjectId) + "'";
secHeader.AddLink("<img alt='' src='../Layouts/Images/cancel.gif'/> " + LocRM.GetString("tCancel"), "../Projects/ProjectView.aspx?ProjectId=" + ProjectId);
}
else
{
string sName = "";
using (IDataReader reader = ProjectGroup.GetProjectGroups(PGID))
{
if (reader.Read())
{
sName = reader["Title"].ToString();
}
}
secHeader.Title = LocRM.GetString("tAddToPortfolio") + " '" + sName + "'";
secHeader.AddLink("<img alt='' src='../Layouts/Images/cancel.gif'/> " + LocRM.GetString("tCancel"), "../Projects/ProjectGroupView.aspx?ProjectGroupId=" + PGID);
}
}
/// <summary>
/// Default data bind.
/// </summary>
private void DefaultDataBind()
{
//FieldSet
ddFieldSets.Items.Clear();
ddFieldSets.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Incident", "StandardFieldSet").ToString(), Project.ProjectFieldSet.ProjectsDefault.ToString()));
ddFieldSets.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Incident", "TimelineFieldSet").ToString(), Project.ProjectFieldSet.ProjectsLight.ToString()));
//Grouping
ddGroupField.Items.Clear();
ddGroupField.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Incident", "NoGroupBy").ToString(), Project.AvailableGroupField.NotSet.ToString()));
ddGroupField.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Project", "GroupByPortfolio").ToString(), Project.AvailableGroupField.Portfolio.ToString()));
if (PortalConfig.GeneralAllowClientField)
{
ddGroupField.Items.Add(new ListItem(GetGlobalResourceObject("IbnFramework.Project", "GroupByContacts").ToString(), Project.AvailableGroupField.Client.ToString()));
}
//Filters
//StartDate
dtcStartDate.SelectedDate = DateTime.Today;
ddSDType.Items.Clear();
ddSDType.Items.Add(new ListItem(LocRM.GetString("Any"), "0"));
ddSDType.Items.Add(new ListItem(LocRM.GetString("GE"), "1"));
ddSDType.Items.Add(new ListItem(LocRM.GetString("LE"), "2"));
ddSDType.Items.Add(new ListItem(LocRM.GetString("Equal"), "3"));
//EndDate
dtcEndDate.SelectedDate = DateTime.Now;
ddFDType.Items.Clear();
ddFDType.Items.Add(new ListItem(LocRM.GetString("Any"), "0"));
ddFDType.Items.Add(new ListItem(LocRM.GetString("GE"), "1"));
ddFDType.Items.Add(new ListItem(LocRM.GetString("LE"), "2"));
ddFDType.Items.Add(new ListItem(LocRM.GetString("Equal"), "3"));
//Status
ddStatus.Items.Clear();
ddStatus.DataSource = Project.GetListProjectStatus();
ddStatus.DataTextField = "StatusName";
ddStatus.DataValueField = "StatusId";
ddStatus.Items.Insert(0, new ListItem(LocRM.GetString("All"), "0"));
ddStatus.Items.Insert(1, new ListItem(LocRM.GetString("tOnlyActive"), "-1"));
ddStatus.Items.Insert(2, new ListItem(LocRM.GetString("tOnlyInactive"), "-2"));
// Phase
ddPrjPhases.Items.Clear();
ddPrjPhases.Items.Add(new ListItem(LocRM.GetString("All"), "0"));
using (IDataReader rdr = Project.GetListProjectPhases())
{
while (rdr.Read())
{
ddPrjPhases.Items.Add(new ListItem(rdr["PhaseName"].ToString(), rdr["PhaseId"].ToString()));
}
}
// Type
ddType.Items.Clear();
ddType.Items.Add(new ListItem(LocRM.GetString("All"), "0"));
using (IDataReader rdr = Project.GetListProjectTypes())
{
while (rdr.Read())
{
ddType.Items.Add(new ListItem((string)rdr["TypeName"], rdr["TypeId"].ToString()));
}
}
// Mananger
ddManager.Items.Clear();
ddManager.DataSource = Project.GetListProjectManagers();
ddManager.DataTextField = "UserName";
ddManager.DataValueField = "ManagerId";
ddManager.DataBind();
ddManager.Items.Insert(0, new ListItem(LocRM.GetString("All"), "0"));
ListItem lItem = new ListItem(GetGlobalResourceObject("IbnFramework.Incident", "CurrentUser").ToString(), "-5");
ddManager.Items.Insert(1, lItem);
// ExeMananger
ddExeManager.Items.Clear();
ddExeManager.DataSource = Project.GetListExecutiveManagers();
ddExeManager.DataTextField = "UserName";
ddExeManager.DataValueField = "ExecutiveManagerId";
ddExeManager.DataBind();
ddExeManager.Items.Insert(0, new ListItem(LocRM.GetString("All"), "0"));
lItem = new ListItem(GetGlobalResourceObject("IbnFramework.Incident", "CurrentUser").ToString(), "-5");
ddExeManager.Items.Insert(1, lItem);
// Priority
ddPriority.Items.Clear();
ddPriority.Items.Add(new ListItem(LocRM.GetString("All"), "-1"));
using (IDataReader rdr = Project.GetListPriorities())
{
while (rdr.Read())
{
ddPriority.Items.Add(new ListItem((string)rdr["PriorityName"], rdr["PriorityId"].ToString()));
}
}
//Client
ClientControl.ObjectType = String.Empty;
ClientControl.ObjectId = PrimaryKeyId.Empty;
// Project Groups
ddPrjGrpType.Items.Clear();
ddPrjGrpType.Items.Add(new ListItem(LocRM.GetString("Any2"), "0"));
ddPrjGrpType.Items.Add(new ListItem(LocRM.GetString("SelectedOnly"), "1"));
ddPrjGrpType.Items.Add(new ListItem(LocRM.GetString("ExcludeSelected"), "2"));
lbPrjGrps.Items.Clear();
lbPrjGrps.DataSource = ProjectGroup.GetProjectGroups();
lbPrjGrps.DataTextField = "Title";
lbPrjGrps.DataValueField = "ProjectGroupId";
lbPrjGrps.DataBind();
// General Categories
ddGenCatType.Items.Clear();
ddGenCatType.Items.Add(new ListItem(LocRM.GetString("Any2"), "0"));
ddGenCatType.Items.Add(new ListItem(LocRM.GetString("SelectedOnly"), "1"));
ddGenCatType.Items.Add(new ListItem(LocRM.GetString("ExcludeSelected"), "2"));
lbGenCats.Items.Clear();
lbGenCats.DataSource = Project.GetListCategoriesAll();
lbGenCats.DataTextField = "CategoryName";
lbGenCats.DataValueField = "CategoryId";
lbGenCats.DataBind();
// Project Categories
ddPrjCatType.Items.Clear();
ddPrjCatType.Items.Add(new ListItem(LocRM.GetString("Any2"), "0"));
ddPrjCatType.Items.Add(new ListItem(LocRM.GetString("SelectedOnly"), "1"));
ddPrjCatType.Items.Add(new ListItem(LocRM.GetString("ExcludeSelected"), "2"));
lbPrjCats.Items.Clear();
lbPrjCats.DataSource = Project.GetListProjectCategories();
lbPrjCats.DataTextField = "CategoryName";
lbPrjCats.DataValueField = "CategoryId";
lbPrjCats.DataBind();
if (Mediachase.IBN.Business.Security.IsUserInGroup(InternalSecureGroups.Partner))
{
trPrGroups.Visible = false;
}
cbIsPublic.Visible = Mediachase.IBN.Business.Security.IsUserInGroup(InternalSecureGroups.Administrator);
trGenCats.Visible = PortalConfig.GeneralAllowGeneralCategoriesField;
trClient.Visible = PortalConfig.GeneralAllowClientField;
trPriority.Visible = PortalConfig.GeneralAllowPriorityField;
}
private void BindInitialValues()
{
ddPrjGroup.DataSource = ProjectGroup.GetProjectGroups();
ddPrjGroup.DataTextField = "Title";
ddPrjGroup.DataValueField = "ProjectGroupId";
ddPrjGroup.DataBind();
ddPrjGroup.Items.Insert(0, new ListItem(LocRM.GetString("AllFem"), "0"));
ddPrjGroup.Items.Add(new ListItem(LocRM.GetString("tCustom"), "-1"));
switch (ProjectListType)
{
case "All":
if (ddPrjGroup.Items.FindByValue("0") != null)
{
ddPrjGroup.SelectedValue = "0";
}
break;
case "Custom":
if (ddPrjGroup.Items.FindByValue("-1") != null)
{
ddPrjGroup.SelectedValue = "-1";
}
break;
case "Portfolio":
if (ddPrjGroup.Items.FindByValue(ProjectListData) != null)
{
ddPrjGroup.SelectedValue = ProjectListData;
}
break;
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Id", typeof(int)));
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Rows.Add(new object[] { 1, LocRM.GetString("tWeekYear") });
dt.Rows.Add(new object[] { 2, LocRM.GetString("tMonthQuarterYear") });
dt.Rows.Add(new object[] { 3, LocRM.GetString("tQuarterYear") });
dt.Rows.Add(new object[] { 4, LocRM.GetString("tYear") });
dt.Rows.Add(new object[] { 5, LocRM.GetString("tTotalSum") });
ddFinanceType.DataSource = dt;
ddFinanceType.DataTextField = "Name";
ddFinanceType.DataValueField = "Id";
ddFinanceType.DataBind();
ddFinanceType.SelectedValue = FinanceType;
DataTable dt1 = new DataTable();
dt1.Columns.Add(new DataColumn("Id", typeof(int)));
dt1.Columns.Add(new DataColumn("Name", typeof(string)));
foreach (BasePlanSlot bps in BasePlanSlot.List())
{
DataRow dr = dt1.NewRow();
dr["Id"] = bps.BasePlanSlotId;
dr["Name"] = bps.Name;
dt1.Rows.Add(dr);
}
dt1.Rows.Add(new object[] { "-1", LocRM.GetString("tFact") });
dt1.Rows.Add(new object[] { "0", LocRM.GetString("tCurrent") });
DataView dv = dt1.DefaultView;
dv.Sort = "Id ASC";
ddBasePlan1.DataSource = dv;
ddBasePlan1.DataTextField = "Name";
ddBasePlan1.DataValueField = "Id";
ddBasePlan1.DataBind();
ddBasePlan1.SelectedValue = BasePlan1.ToString();
dt1.Rows.Add(new object[] { "-2", LocRM.GetString("tNotSelected") });
dv = dt1.DefaultView;
dv.Sort = "Id ASC";
ddBasePlan2.DataSource = dv;
ddBasePlan2.DataTextField = "Name";
ddBasePlan2.DataValueField = "Id";
ddBasePlan2.DataBind();
ddBasePlan2.SelectedValue = BasePlan2.ToString();
tbFromYear.Text = FromYear.ToString();
tbToYear.Text = ToYear.ToString();
ddGroupBy.Items.Clear();
ddGroupBy.Items.Add(new ListItem(LocRM.GetString("tByProject"), "false"));
ddGroupBy.Items.Add(new ListItem(LocRM.GetString("tByBusinessScore"), "true"));
ddGroupBy.SelectedValue = Reverse.ToString().ToLower();
}
private void BindStep1()
{
tbTitle.Text = String.Empty;
ddType.DataValueField = "TypeId";
ddType.DataTextField = "TypeName";
ddType.DataSource = Project.GetListProjectTypes();
ddType.DataBind();
ddCurrency.DataTextField = "CurrencySymbol";
ddCurrency.DataValueField = "CurrencyId";
ddCurrency.DataSource = Project.GetListCurrency();
ddCurrency.DataBind();
ddPhase.DataTextField = "PhaseName";
ddPhase.DataValueField = "PhaseId";
ddPhase.DataSource = Project.GetListProjectPhases();
ddPhase.DataBind();
ddPriority.DataTextField = "PriorityName";
ddPriority.DataValueField = "PriorityId";
ddPriority.DataSource = Project.GetListPriorities();
ddPriority.DataBind();
ddPriority.SelectedValue = ((int)Priority.Normal).ToString();
dtcStartDate.SelectedDate = User.GetLocalDate(Security.CurrentUser.TimeZoneId, DateTime.UtcNow.Date);
dtcEndDate.SelectedDate = dtcStartDate.SelectedDate.AddMonths(1);
ListItem li = new ListItem(LocRM.GetString("s4NotSet"), "0");
ddExecutive.Items.Add(li);
ArrayList alManagers = new ArrayList();
using (IDataReader iManagers = SecureGroup.GetListAllUsersInGroup((int)InternalSecureGroups.ProjectManager))
{
while (iManagers.Read())
{
li = new ListItem(iManagers["LastName"].ToString() + " " + iManagers["FirstName"].ToString(), iManagers["UserId"].ToString());
alManagers.Add(li);
}
}
for (int i = 0; i < alManagers.Count; i++)
{
ListItem liExecItem = new ListItem(((ListItem)alManagers[i]).Text, ((ListItem)alManagers[i]).Value);
ddExecutive.Items.Add(liExecItem);
}
lbCategories.DataTextField = "CategoryName";
lbCategories.DataValueField = "CategoryId";
lbCategories.DataSource = Project.GetListProjectCategories();
lbCategories.DataBind();
lbPortfolios.DataTextField = "Title";
lbPortfolios.DataValueField = "ProjectGroupId";
lbPortfolios.DataSource = ProjectGroup.GetProjectGroups();
lbPortfolios.DataBind();
ddlBlockType.DataTextField = "Title";
ddlBlockType.DataValueField = "primaryKeyId";
ddlBlockType.DataSource = Mediachase.IbnNext.TimeTracking.TimeTrackingBlockType.List(Mediachase.Ibn.Data.FilterElement.EqualElement("IsProject", "1"));
ddlBlockType.DataBind();
ddlCalendar.DataTextField = "CalendarName";
ddlCalendar.DataValueField = "CalendarId";
ddlCalendar.DataSource = Project.GetListCalendars(0);
ddlCalendar.DataBind();
cbNotify.Text = LocRM.GetString("s6Notify");
}
private void BindPortfolios()
{
grdPortfolios.DataSource = ProjectGroup.GetProjectGroups();
grdPortfolios.DataBind();
}
private void BindInitialValues()
{
ddPrjGroup.DataSource = ProjectGroup.GetProjectGroups();
ddPrjGroup.DataTextField = "Title";
ddPrjGroup.DataValueField = "ProjectGroupId";
ddPrjGroup.DataBind();
ddPrjGroup.Items.Insert(0, new ListItem(LocRM.GetString("AllFem"), "0"));
ddPrjGroup.Items.Add(new ListItem(LocRM.GetString("tCustom"), "-1"));
switch (ProjectListType)
{
case "All":
if (ddPrjGroup.Items.FindByValue("0") != null)
{
ddPrjGroup.SelectedValue = "0";
}
break;
case "Custom":
if (ddPrjGroup.Items.FindByValue("-1") != null)
{
ddPrjGroup.SelectedValue = "-1";
}
break;
case "Portfolio":
if (ddPrjGroup.Items.FindByValue(ProjectListData) != null)
{
ddPrjGroup.SelectedValue = ProjectListData;
}
break;
}
DataTable dt1 = new DataTable();
dt1.Columns.Add(new DataColumn("Id", typeof(int)));
dt1.Columns.Add(new DataColumn("Name", typeof(string)));
foreach (BasePlanSlot bps in BasePlanSlot.List())
{
DataRow dr = dt1.NewRow();
dr["Id"] = bps.BasePlanSlotId;
dr["Name"] = bps.Name;
dt1.Rows.Add(dr);
}
dt1.Rows.Add(new object[] { "-2", LocRM.GetString("tNotSelected") });
DataView dv = dt1.DefaultView;
dv.Sort = "Id ASC";
ddBasePlan.DataSource = dv;
ddBasePlan.DataTextField = "Name";
ddBasePlan.DataValueField = "Id";
ddBasePlan.DataBind();
ddBasePlan.SelectedValue = BasePlan2.ToString();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Id", typeof(int)));
dt.Columns.Add(new DataColumn("Name", typeof(string)));
foreach (BasePlanSlot bps in BasePlanSlot.List())
{
DataRow dr = dt.NewRow();
dr["Id"] = bps.BasePlanSlotId;
dr["Name"] = bps.Name;
dt.Rows.Add(dr);
}
dt.Rows.Add(new object[] { "0", LocRM.GetString("tCurrent") });
dv = dt.DefaultView;
dv.Sort = "Id ASC";
ddOrBasePlan.DataSource = dv;
ddOrBasePlan.DataTextField = "Name";
ddOrBasePlan.DataValueField = "Id";
ddOrBasePlan.DataBind();
ddOrBasePlan.SelectedValue = BasePlan1.ToString();
}