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