/// <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>
/// Check to see if there are any users assigned to specified project.
/// </summary>
/// <param name="project">string: Project name.</param>
/// <returns>bool: Result.</returns>
private bool CheckForUsers(string project)
{
bool usersExist = true;
int recordCount = 0;
// Initialize data objects
iCampaign.TACS.Data.UserRoleViewDsTableAdapters.UserRoleViewTableAdapter userTableAdapter =
new iCampaign.TACS.Data.UserRoleViewDsTableAdapters.UserRoleViewTableAdapter();
userTableAdapter.Connection.ConnectionString = TacsSession.ConnectionString;
// Get the record count
try
{
userTableAdapter.Connection.Open();
recordCount = (int)userTableAdapter.CountProjectUsers(project);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "An error occurred", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
userTableAdapter.Connection.Close();
}
if (recordCount > 0)
usersExist = true;
else
usersExist = false;
return usersExist;
}
