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