private void FillGridView() { DataTable table = new DataTable(); /* Fill table with Company information */ string connectionString = ConfigurationManager.ConnectionStrings["AMSConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(connectionString)) { string sql = "SELECT CompanyID, CompanyName, CompanyAddress, CompanyPhone FROM Company ORDER BY CompanyID"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) { ad.Fill(table); } } } /* Adding URL column for Add User Admin to the table */ table.Columns.Add("UserAdmins", typeof(String)); table.Columns.Add("AddUserAdmin", typeof(String)); foreach (DataRow dr in table.Rows) { /* "User Admins" */ //get a list of administrator names which are in company id=x int companyID = Convert.ToInt32(dr["CompanyID"]); AMSEntities ae = new AMSEntities();; /* Users: list of users in a particular company */ List <User> users = ae.CreateObjectSet <User>().Where <User>(e => e.CompanyID == companyID).AsQueryable <User>().ToList <User>(); string usernameList = ""; foreach (User user in users) { int userID = user.MembershipUserID; /* UserProfiles: list of UserProfiles in a particular company */ List <UserProfile> userProfiles = ae.CreateObjectSet <UserProfile>().Where <UserProfile>(e => e.UserId == userID).AsQueryable <UserProfile>().ToList <UserProfile>(); foreach (UserProfile userProfile in userProfiles) { int userProfileID = userProfile.UserId; string username = userProfile.UserName; if (Roles.IsUserInRole(username, "User Admin")) { usernameList += username + " "; } } } dr["UserAdmins"] = usernameList; /* "Add User Admins" */ dr["AddUserAdmin"] = companyID; } GridViewCompanies.DataSource = table; GridViewCompanies.DataBind(); }
private void FillGridView() { DataTable table = new DataTable(); /* Fill table with Company information */ string connectionString = ConfigurationManager.ConnectionStrings["AMSConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(connectionString)) { string sql = "SELECT CompanyID, CompanyName, CompanyAddress, CompanyPhone FROM Company ORDER BY CompanyID"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) { ad.Fill(table); } } } /* Adding URL column for Add User Admin to the table */ table.Columns.Add("UserAdmins" , typeof(String)); table.Columns.Add("AddUserAdmin", typeof(String)); foreach (DataRow dr in table.Rows) { /* "User Admins" */ //get a list of administrator names which are in company id=x int companyID = Convert.ToInt32( dr["CompanyID"] ); AMSEntities ae = new AMSEntities();; /* Users: list of users in a particular company */ List<User> users = ae.CreateObjectSet<User>().Where<User>(e => e.CompanyID == companyID).AsQueryable<User>().ToList<User>(); string usernameList = ""; foreach (User user in users) { int userID = user.MembershipUserID; /* UserProfiles: list of UserProfiles in a particular company */ List<UserProfile> userProfiles = ae.CreateObjectSet<UserProfile>().Where<UserProfile>(e => e.UserId == userID).AsQueryable<UserProfile>().ToList<UserProfile>(); foreach (UserProfile userProfile in userProfiles) { int userProfileID = userProfile.UserId; string username = userProfile.UserName; if(Roles.IsUserInRole(username, "User Admin")){ usernameList += username + " "; } } } dr["UserAdmins"] = usernameList; /* "Add User Admins" */ dr["AddUserAdmin"] = companyID; } GridViewCompanies.DataSource = table; GridViewCompanies.DataBind(); }