//************************************************************************** /// <Description> /// This method uses to get all role of user /// </Description> /// <Inputs> /// user id /// </Inputs> /// <Outputs> /// array list /// </Outputs> /// <Returns> /// ArrayList /// </Returns> /// <Authors> /// DungLA /// </Authors> /// <History> /// 06-Apr-2005 /// </History> /// <Notes> /// </Notes> //************************************************************************** public ArrayList GetRoles(string pstrUserName) { int intUserID = new Sys_UserDS().GetUserIDByUserName(pstrUserName); Sys_UserToRoleDS dsUserRole = new Sys_UserToRoleDS(); return(dsUserRole.ListRoleByUser(intUserID)); }
/// <summary> /// Save a list of selected role into database /// Get a list of current role granted to this user from database in dataset /// and then use this dataset to input a new role /// call the DS method to update this dataset /// </summary> /// <param name="pintUserID"></param> /// <param name="pdtListOfRole"></param> /// <Author> Thien HD, Jan 11, 2005</Author> public void SaveRoleToUser(int pintUserID, DataTable pdtListOfRole) { try { //Get the list of current granted role of this user. Sys_UserToRoleDS objSys_UserToRoleDS = new Sys_UserToRoleDS(); DataSet dstCurrentRole = objSys_UserToRoleDS.ListRoleToUser(pintUserID); dstCurrentRole.Tables[0].Columns[Sys_UserToRoleTable.ID_FLD].AutoIncrement = true; //Get the highest value for this column dstCurrentRole.Tables[0].Columns[Sys_UserToRoleTable.ID_FLD].AutoIncrementSeed = objSys_UserToRoleDS.GetMaxID() + 1; dstCurrentRole.Tables[0].Columns[Sys_UserToRoleTable.ID_FLD].AutoIncrementStep = 1; for (int i = 0; i < dstCurrentRole.Tables[0].Rows.Count; i++) { dstCurrentRole.Tables[0].Rows[i].Delete(); } pdtListOfRole.AcceptChanges(); foreach (DataRow dr in pdtListOfRole.Rows) { DataRow drNewRow = dstCurrentRole.Tables[0].NewRow(); drNewRow[Sys_UserToRoleTable.ROLEID_FLD] = dr[Sys_RoleTable.ROLEID_FLD]; drNewRow[Sys_UserToRoleTable.USERID_FLD] = pintUserID; dstCurrentRole.Tables[0].Rows.Add(drNewRow); } //Update this data set into database objSys_UserToRoleDS.UpdateDataSet(dstCurrentRole); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw ex; } }