/// <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;
}
