private void BuildContacts(int organizationId)
{
// build contacts
ContactsDa da = new ContactsDa();
var contactAndUsers = da.GetAllContactsAndUser(organizationId).DefaultView;
contactAndUsers.RowFilter = "OrganizationContactId IS NOT NULL";
ContactsRptr.DataSource = contactAndUsers;
ContactsRptr.DataBind();
NoContacsMessage.Visible = contactAndUsers.Count == 0;
// build projects
ProjectManagementDa projectDa = new ProjectManagementDa();
DataView projects = projectDa.GetAllProjectsForOrg(organizationId).DefaultView;
projects.Sort = Project.Title + " ASC";
ProjectsRptr.DataSource = projects;
ProjectsRptr.DataBind();
NoProjectsMessage.Visible = projects.Count == 0;
// build protocols
DataView protocols = ProtocolMgmtDa.GetProtocolsByOrganization(organizationId).DefaultView;
protocols.Sort = Protocol.ProtocolNum + " ASC";
ProtocolRptr.DataSource = protocols;
ProtocolRptr.DataBind();
NoProtocolsMessage.Visible = protocols.Count == 0;
}
private void BuildProtocolOrganizations(int protocolId)
{
var organizations = BusinessObject.GetAll <ProjectOrganization>();
Protocol protocol = new Protocol();
protocol.Get(protocolId);
if (!protocol.IsNull(Protocol.ProjectId))
{
int projectId = (int)protocol[Protocol.ProjectId];
Project project = new Project();
project.Get(projectId);
string projectName = project[Project.Title].ToString();
// get contacts
ContactsDa da = new ContactsDa();
var userContacts = da.GetAllContactsAndUser();
var projectOrganizations = BusinessObject.GetByFields <Project_ProjectOrganization>(new Dictionary <string, object> {
{ Project_ProjectOrganization.ProjectId, projectId }
});
var data_source = from organization in organizations
let organizationId = (int)organization[ProjectOrganization.OrganizationId]
join po in projectOrganizations on organizationId equals(int) po[Project_ProjectOrganization.OrganizationId] into g
let organizationName = organization[ProjectOrganization.Name].ToString()
let organizationType = g.Count() > 0 ? g.First()[Project_ProjectOrganization.OrganizationType] + "" : ""
orderby organizationName ascending
let contacts = (from contact in userContacts.AsEnumerable()
where !contact.IsNull(ProjectOrganization_ProjectContact.OrganizationId)
where (int)contact[ProjectOrganization_ProjectContact.OrganizationId] == organizationId
let lastName = contact[Contact.LastName].ToString()
let firstName = contact[Contact.FirstName].ToString()
orderby lastName ascending
select lastName + ", " + firstName).Distinct()
select new
{
Name = organizationName,
OrganizationId = organizationId,
OrganizationType = organizationType,
ProjectOrganizationId = g.Count() > 0 ? g.First()[Project_ProjectOrganization.ProjectOrganizationId] + "" : "",
Contacts = contacts.Count() > 0 ? Server.HtmlEncode("CONTACTS \n" + string.Join("\n", contacts.ToArray())) : "NO CONTACTS"
};
updateItems.Clear();
OrganizationsRptr.DataSource = data_source;
OrganizationsRptr.DataBind();
// show data entry panel
DataEntryPanel.Visible = true;
ProjectLabel.Text = "PROJECT: " + projectName;
ProjectIdField.Value = projectId.ToString();
}
}
private void Load_Associate_Contact()
{
if (Page.IsPostBack)
{
return;
}
int organizationId = int.Parse(Request.QueryString["organizationId"]);
ContactsDa da = new ContactsDa();
DataTable contactAndUsers = da.GetAllContactsAndUser(organizationId);
AssociateContactsRptr.DataSource = contactAndUsers;
AssociateContactsRptr.DataBind();
}
private void LoadContacts()
{
ProjectManagementDa projDA = new ProjectManagementDa();
DataTable contactsDataSource = new DataTable();
ContactsDa contactsDa = new ContactsDa();
contactsDataSource = contactsDa.GetAllContacts();
// Determine if there are any records and show message
if (contactsDataSource.Rows.Count > 0)
{
// Bind grid to datasource
var view = contactsDataSource.DefaultView;
view.Sort = "Name ASC";
ContactsRptr.DataSource = view;
ContactsRptr.DataBind();
NoResultsMsg.Visible = false;
}
}
private void LoadContactsGrid()
{
ProjectManagementDa projDA = new ProjectManagementDa();
DataTable contactsDataSource = new DataTable();
string filterBy = Request.QueryString["FilterBy"];
ContactsDa contactsDa = new ContactsDa();
if (isAdmin)
{
contactsDataSource = contactsDa.GetAllContacts();
}
else if (string.IsNullOrEmpty(filterBy))
{
if (contactType == "Project")
{
contactsDataSource = CombineRows(projDA.GetAllContactsWithOrgNameByProjectId(projectId), "Organization");
}
else
{
if (!string.IsNullOrEmpty(contactType))
{
contactsDataSource = contactsDa.GetContactByContactType(contactType);
}
}
}
else
{
switch (filterBy)
{
case ("Organization"):
contactsDataSource = CombineRows(projDA.GetAllContactsByOrgId(Int32.Parse(Request.QueryString["FilterID"])), "Organization");
break;
case ("Protocols"):
contactsDataSource = CombineRows(projDA.GetAllContactsByProtocol(Int32.Parse(Request.QueryString["FilterID"])), "Organization");
break;
case ("Projects"):
contactsDataSource = CombineRows(projDA.GetAllContactsWithOrgNameByProjectId(Int32.Parse(Request.QueryString["FilterID"])), "Organization");
break;
default:
break;
}
}
// Bind grid to datasource
ContactsGrid.DataSource = contactsDataSource;
ContactsGrid.DataBind();
// Determine if there are any records and show message
if (contactsDataSource.Rows.Count == 0)
{
EmptyMessageLabel.Visible = true;
}
else
{
EmptyMessageLabel.Visible = false;
}
}
