/// <summary> /// Initialize all the ADO.NET objects. /// </summary> private void InitializeData() { dataTable = new iCampaign.TACS.Data.UserDs.UsersDataTable(); tableAdapter = new iCampaign.TACS.Data.UserDsTableAdapters.UsersTableAdapter(); tableAdapter.Connection = new System.Data.SqlClient.SqlConnection(TacsSession.ConnectionString); userAdapter = new iCampaign.TACS.Data.UserRolesDsTableAdapters.UserRoleViewTableAdapter(); userAdapter.Connection = new System.Data.SqlClient.SqlConnection(TacsSession.ConnectionString); roleTable = new iCampaign.TACS.Data.UserRoleViewDs.UserRoleViewDataTable(); roleAdapter = new iCampaign.TACS.Data.UserRoleViewDsTableAdapters.UserRoleViewTableAdapter(); roleAdapter.Connection = new SqlConnection(TacsSession.ConnectionString); projectTable = new iCampaign.TACS.Data.UserProjectsDs.UserProjectsDataTable(); projectAdapter = new iCampaign.TACS.Data.UserProjectsDsTableAdapters.UserProjectsTableAdapter(); projectAdapter.Connection = new SqlConnection(TacsSession.ConnectionString); }
/// <summary> /// Get the roles for the requested project and user. /// </summary> /// <param name="project">string: Project name.</param> /// <param name="user">string: Username.</param> /// <returns>System.Collections.Generic.List: as type Role.</returns> private List<IRole> GetRoles(string project, string user) { List<IRole> roles = new List<IRole>(); Data.UserRolesDs.UserRoleViewDataTable dataTable = new UserRolesDs.UserRoleViewDataTable(); Data.UserRolesDsTableAdapters.UserRoleViewTableAdapter tableAdapter = new iCampaign.TACS.Data.UserRolesDsTableAdapters.UserRoleViewTableAdapter(); tableAdapter.Connection = new SqlConnection(TacsSession.ConnectionString); // Get project roles for requested user try { tableAdapter.Connection.Open(); tableAdapter.FillByUserProject(dataTable, user, project); } catch (Exception ex) { throw ex; } finally { tableAdapter.Connection.Close(); } // Load into the generic list collection foreach (Data.UserRolesDs.UserRoleViewRow row in dataTable) { roles.Add(new Role(row.RoleName, (AccessLevelEnum)row.AccessLevel)); } return roles; }