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(); }