private void FillEditArea()
{
try {
int userID = Convert.ToInt32(grdUserResults.SelectedRow.Cells[0].Text);
// Add User's Roles
lstUserEditRole.SelectedIndex = -1;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCSecurity.SecurityGetUserRoles(conn, userID)) {
while (dr.Read())
{
string roleID = dr.GetInt32(dr.GetOrdinal("sro_role_id")).ToString();
foreach (ListItem li in lstUserEditRole.Items)
{
if (li.Value == roleID)
{
li.Selected = true;
break;
}
}
}
}
// Add User's Regions
lstUserEditRegion.SelectedIndex = -1;
using (SqlDataReader dr = WSCSecurity.SecurityGetUserRegions(conn, userID)) {
while (dr.Read())
{
string regionID = dr.GetInt32(dr.GetOrdinal("rgn_region_id")).ToString();
foreach (ListItem li in lstUserEditRegion.Items)
{
if (li.Value == regionID)
{
li.Selected = true;
break;
}
}
}
}
}
// Check whether user is active
string isActive = grdUserResults.SelectedRow.Cells[3].Text;
chkUserEditIsActive.Checked = (isActive == "Y");
}
catch (Exception ex) {
Common.CException wex = new Common.CException("Security.FillEditArea", ex);
throw (wex);
}
}
