public DataTable GetUserCountries()
{
try
{
//Instantiate the DBCurrentUser object
DBCurrentUser = new DBCurrentUser(this.CurrentConnectionManager);
//Get the table containing the user information
DataTable userTable = DBCurrentUser.GetUserCountries(_InergyLogin);
return(userTable);
}
catch (Exception ex)
{
throw new IndException(ex);
}
}
public int LoadUserDetails()
{
try
{
//Instantiate the DBCurrentUser object
DBCurrentUser = new DBCurrentUser(this.CurrentConnectionManager);
//Get the table containing the user information
DataTable userTable = DBCurrentUser.GetUserDetails(_InergyLogin, _IdCountry);
//If the user contains a row, initialize this object with the data from the row
if (userTable.Rows.Count == 1)
{
DataRow userRow = userTable.Rows[0];
Initialize((int)userRow["IdAssociate"], userRow["AssociateName"].ToString(), _InergyLogin, (int)userRow["IdCountry"], userRow["CountryName"].ToString(), (int)userRow["IdCurrency"], userRow["CodeCurrency"].ToString(), userRow["CountryCode"].ToString());
BuildProjectInformation();
if (_ProgramManagerProjects.Count > 0)
{
GetProgramManagerPermissions();
}
if (_CoreTeamProjects.Count > 0)
{
GetCoreTeamMemberPermissions();
}
if (_ProgramReaderProjects.Count > 0)
{
GetProgramReaderPermissions();
}
BuildRoleInformation();
}
//Else instantiate the object with default values
else
{
Initialize(ApplicationConstants.INT_NULL_VALUE, String.Empty, String.Empty, ApplicationConstants.INT_NULL_VALUE, String.Empty, ApplicationConstants.INT_NULL_VALUE, String.Empty, String.Empty);
}
return(userTable.Rows.Count);
}
catch (Exception ex)
{
throw new IndException(ex);
}
}
public void VerifyCurrentUser()
{
DBCurrentUser dbCurrentUserEntity = new DBCurrentUser(connManager);
DataTable tableVerifyDetail = dbCurrentUserEntity.GetUserDetails(DATestUtils.DEFAULT_USER, ApplicationConstants.INT_NULL_VALUE);
//Verifies that the table is not null
Assert.IsNotNull(tableVerifyDetail, "The table returned should not be null");
//Verifies that the table returns the correct columns
DATestUtils.CheckColumn(tableVerifyDetail, 0, "IdAssociate");
DATestUtils.CheckColumn(tableVerifyDetail, 1, "AssociateName");
DATestUtils.CheckColumn(tableVerifyDetail, 2, "IdCountry");
DATestUtils.CheckColumn(tableVerifyDetail, 3, "CountryName");
tableVerifyDetail.Dispose();
DataSet setVerifyPermissions = dbCurrentUserEntity.GetUserPermissions((int)tableVerifyDetail.Rows[0][0], (int)tableVerifyDetail.Rows[0][2]);
DATestUtils.CheckColumn(setVerifyPermissions.Tables[0], 0, "IdRole");
DATestUtils.CheckColumn(setVerifyPermissions.Tables[0], 1, "RoleName");
DATestUtils.CheckColumn(setVerifyPermissions.Tables[1], 0, "ModuleCode");
DATestUtils.CheckColumn(setVerifyPermissions.Tables[1], 1, "IdOperation");
DATestUtils.CheckColumn(setVerifyPermissions.Tables[1], 2, "IdPermission");
setVerifyPermissions.Dispose();
DataTable tableVerifyProjects = dbCurrentUserEntity.GetUserProjects((int)tableVerifyDetail.Rows[0][0]);
DATestUtils.CheckColumn(tableVerifyProjects, 0, "IdProject");
DATestUtils.CheckColumn(tableVerifyProjects, 1, "ProjectName");
DATestUtils.CheckColumn(tableVerifyProjects, 2, "IdFunction");
DATestUtils.CheckColumn(tableVerifyProjects, 3, "ProjectFunction");
tableVerifyProjects.Dispose();
DataTable tableVerifyRolePermissions = dbCurrentUserEntity.GetRolePermissions((int)setVerifyPermissions.Tables[0].Rows[0][0]);
DATestUtils.CheckColumn(tableVerifyRolePermissions, 0, "ModuleCode");
DATestUtils.CheckColumn(tableVerifyRolePermissions, 1, "IdOperation");
DATestUtils.CheckColumn(tableVerifyRolePermissions, 2, "IdPermission");
tableVerifyRolePermissions.Dispose();
}
