/// <summary> /// Binds To and From Selects to show available and selected Contacts /// </summary> protected void BindContactsData() { ProjectManagementDa da = new ProjectManagementDa(); unassociatedContact = da.GetAllUnassignedContacts(projectId).DefaultView; associatedContacts = da.GetProjectContactsByProjectId(projectId).DefaultView; FromContactsOrgRptr.DataSource = da.GetProjectOrganizationsByProjectId(projectId).DefaultView; FromContactsOrgRptr.DataBind(); ToContactsOrgRptr.DataSource = da.GetProjectOrganizationsByProjectId(projectId).DefaultView; ToContactsOrgRptr.DataBind(); }
/// <summary> /// Bind grid to exitsing orgs for project /// </summary> protected void BindOrganizationData() { ProjectManagementDa da = new ProjectManagementDa(); // Set global views used for bind grid and dropdowns associatedOrgs = da.GetProjectOrganizationsByProjectId(projectId).DefaultView; // Insert helper column for sorting associated organizations string helpSortCol = "TempSortCol"; DataColumn bob = new DataColumn(helpSortCol); bob.DefaultValue = 1; associatedOrgs.Table.Columns.Add(bob); foreach (DataRow row in associatedOrgs.Table.Rows) { row[helpSortCol] = 0; } associatedOrgs.Sort = helpSortCol + " ASC," + ProjectOrganization.Name + " ASC"; // Unassociated organizations should also be sorted by name unAssociatedOrgs = da.GetAllProjectOrganizationsExcludingProject(projectId).DefaultView; unAssociatedOrgs.Sort = ProjectOrganization.Name + " ASC"; AssociatedOrgsGrid.DataSource = associatedOrgs; AssociatedOrgsGrid.DataBind(); }
/// <summary> /// Creates child ProjectStage, ProjectStageEvents and ProjectEventAttributes records /// based off of child/parent Lookup scheme. /// NOTE: Child records will not be created if any ProjectStage records exists. /// </summary> /// <param name="projBiz"></param> private static void CreateProjectRecords(Project projBiz) { int projectId = int.Parse(projBiz[Project.ProjectId].ToString()); ProjectManagementDa m = new ProjectManagementDa(); DataTable dt = m.GetProjectOrganizationsByProjectId(projectId); CreateProjectStagesRecords(projBiz, dt); }
/// <summary> /// Gets the DataSource for Organizations. Returns a list filtered /// by Project if records exits. /// </summary> /// <param name="sortExpr">Optional sort expression</param> /// <returns>A view of the Organizations List</returns> private DataView GetOrgDataSource(string sortExpr) { DataView dataSource = new DataView(); if (projectId != -1) { ProjectManagementDa projDA = new ProjectManagementDa(); DataTable dt = projDA.GetProjectOrganizationsByProjectId(projectId); dataSource = dt.DefaultView; } else { //ProjectOrganization biz = new ProjectOrganization(); //biz.GetAll(); //dataSource = biz.DataSourceView; dataSource = BusinessObject.GetAllAsDataView <ProjectOrganization>(); } dataSource.Sort = sortExpr; return(dataSource); }