/// <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>
/// Assign a project role to specified user profile.
/// </summary>
/// <param name="username">string: Username to assign.</param>
/// <param name="roleId">long: Role id to assign.</param>
/// <param name="role">string: Caller role being used.</param>
/// <param name="credentials">iCampaign.TACS.Client.Credentials: object.</param>
/// <returns>string: Status message.</returns>
public string AddUserRole(string username, long roleId, string role, Credentials credentials)
{
bool errorStatus = false;
string result = String.Empty;
// Check to see if user has sufficient access
if (!credentials.HasAccess(role, AccessLevelEnum.Owner) || credentials.AccountOwner)
{
errorStatus = true;
result = TacsSession.MSG_INSUFPRIV;
}
// Check for valid session token
if (!TacsSession.IsTokenValid(credentials.Username, credentials.SessionToken))
{
errorStatus = true;
result = TacsSession.MSG_INVALSESS;
}
// If no error condition exists, add go ahead and assign the user roles
if (!errorStatus)
{
Data.UserProjectsDs.UserProjectsDataTable dataTable =
new UserProjectsDs.UserProjectsDataTable();
Data.UserProjectsDs.UserProjectsRow dataRow = dataTable.NewUserProjectsRow();
Data.UserProjectsDsTableAdapters.UserProjectsTableAdapter tableAdapter =
new iCampaign.TACS.Data.UserProjectsDsTableAdapters.UserProjectsTableAdapter();
tableAdapter.Connection = new SqlConnection(TacsSession.ConnectionString);
try
{
dataRow.CreatedOn = System.DateTime.Now;
dataRow.RoleId = roleId;
dataRow.Project = credentials.Project;
dataRow.Username = username;
dataTable.AddUserProjectsRow(dataRow);
tableAdapter.Connection.Open();
tableAdapter.Update(dataTable);
result = TacsSession.MSG_SUCCESS;
}
catch (Exception ex)
{
errorStatus = true;
result = ex.Message;
}
finally
{
tableAdapter.Connection.Close();
}
}
return result;
}
