/// <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 account id of the specified username. /// </summary> /// <param name="user">string: Username.</param> /// <returns>long: Account id.</returns> internal static long GetUserAccountId(string user) { long acctid = -1; // Create the ADO.NET objects required Data.UserDs.UsersDataTable usersTable = new iCampaign.TACS.Data.UserDs.UsersDataTable(); Data.UserDs.UsersRow usersRow = null; Data.UserDsTableAdapters.UsersTableAdapter tableAdapter = new iCampaign.TACS.Data.UserDsTableAdapters.UsersTableAdapter(); tableAdapter.Connection = new SqlConnection(TacsSession.ConnectionString); // Lookup the record in the database try { tableAdapter.Connection.Open(); tableAdapter.FillByUserAcctId(usersTable, user); if (usersTable.Rows.Count != 0) { usersRow = usersTable[0]; acctid = usersRow.AcctId; } } catch (Exception ex) { throw ex; } finally { tableAdapter.Connection.Close(); } return acctid; }