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