Implementation tasks Add / edit user groups Create a new ASP.NET page in Account
ID: 3661586 • Letter: I
Question
Implementation tasks
Add / edit user groups
Create a new ASP.NET page in Accounts folder - Group.aspx - to create groups. The page should have 2 fields - a text field for group name and a text area for group description. Group ID will be automatically generated in the database table (AUTO_INCREMENT). This page should create new roles AND update existing roles.
Database table: groups
List existing groups
Groups are used to group user accounts according to their affiliations.
Create a new ASP.NET page in Accounts folder - ManageGroups.aspx - to manage groups. This page should have a data grid listing all existing groups and their descriptions. You should use the DataGrid control to display the data. The grid should look like the following:
Group ID
Group Name
Description
Add or Remove Users
Edit Group
1
iSchool
University of Pittsburgh School of Information Sciences
2
SOM
University of Pittsburgh School of Medicine
Database table: groups
Add or remove users
Create a new ASP.NET page in Accounts folder - ManageGroupUsers.aspx - to add and/or remove users group groups. This page should allow users with administrative privileges to add/remove users to already existing groups.
Database table: users_groups (this is a junction table)
Add / edit role
Currently the system supports the following roles:
Role ID
Role Name
1
User
2
Admin
3
Author
4
Editor
5
Learner
Create a new ASP.NET page in Accounts folder - Role.aspx - to add and/or edit system roles.
Database table: roles
List existing roles
Create a new ASP.NET page in Accounts folder - ManageRoles.aspx - to list system roles. This page should have a data grid listing all existing roles. You should use the DataGrid control to display the data. The grid should look like the following:
Role ID
Role Name
Edit Role
2
Admin
4
Editor
Database table: roles
Scripts to generate data
These scripts should generate JSON files that comply to the API specifications (https://docs.google.com/document/d/1Q0nSeg99Zr2NHY4OyZoyMZUOx38ht3WDkQnGBeb9gww/edit)
Patient history
Gender
Age
Smoker
Drinker
Allergies
Immunizations
Diagnosis
Procedures
Labs
Prescriptions (medications)
Encounters
Import data
Description...
Import case
Description...
Import patient
Description…
Display conditional probability tables (CPT) from the BN models
Description...
Collaborative model editing
Description...
Collaborative CPT editing
Description...
Create case from data wizard
Description…
Create case from patient wizard
Description...
Patient creation/editing wizard:
Patient history
Treatment data points (see data generation/import)
Patient treatment timeline (most likely using D3.js):
d3js multi-time series, timeline or lane charts: http://www.garrettpatterson.com/2013/01/09/d3js-multi-time-series-timeline-or-lane-charts/
Focus+Context via Brushing: http://bl.ocks.org/mbostock/1667367
Swimlane chart: http://bl.ocks.org/bunkat/1962173
Gantt chart with D3: http://bl.ocks.org/dk8996/5449641
Event manager:
Add events to timeline one-by-one
Random events generated from BN
Case player
Description...
So I am using Visual Studio Web Form to complete this task. I have C# in the back end controlling all of the buttons, labels, data tables and what not. I need help linking all of the .aspx pages to one another. I am trying to transfer information a user enters in a textbox in one .aspx page, and transfer the information entered into another .aspx textbox. I also am trying to generate a given id, for every group or user that is entered by a user. I know I do this on the back end, in the C# coding methods of the buttons. I have attempted every way imaginable to link different .aspx pages together, but every way I have tried has been futile. Do you think you could help me? The drawing you created is nice, but I do not believe it is the best way to approach this. I will be using Roles.aspx and ManagedRoles.aspx together. Then Group.aspx, ManageGroupUsers.aspx, ManageGroups.aspx all together. I created separate .aspx of each and every one. So I am trying to link them together, so whatever a user enters it displays on the other .aspx page. I also have no idea how to do the ManageGroupUsers.aspx. Do you think you could help me with that?
Group ID
Group Name
Description
Add or Remove Users
Edit Group
1
iSchool
University of Pittsburgh School of Information Sciences
2
SOM
University of Pittsburgh School of Medicine
Explanation / Answer
PROCEDURE:
1. Click Start Programs Microsoft SQL Server.
2. Create new database and then create table.
3. Click Start Programs Microsoft Visual Studio 2008 Microsoft Visual Studio 2008.
4. Select File New Website.
5. Open the Windows application form.
6. Place a GRIDVIEW Control.
7. Place two textboxes and 3 buttons named as INSERT, UPDATE, DELETE.
8. Type the following code in insert button, update button, and delete button.
9. Run the application by pressing Ctrl+F5 key.
coding:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["empConnectionString"].
ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
conn.Open();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("Insert Into emp values('"TextBox1.Text +
"','" + TextBox2.Text + "')", conn);
cmd.ExecuteNonQuery();
Response.Write("<script language='javascript'> alert('1 ROW INSERTED
SUCCESSFULLY'); </script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "INSERTED");
Response.Redirect("default.aspx");
conn.Close();
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("update emp set EMPNAME = '" + TextBox1.Text
+ " ' where EMPNO = '" + TextBox2.Text + "'", conn);
cmd.ExecuteNonQuery();
Response.Write("<script language='javascript'> alert('1 ROW UPDATED
SUCCESSFULLY'); </script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "UPDATED");
Response.Redirect("default.aspx");
conn.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("delete from emp where empno="+
TextBox2.Text, conn);
cmd.ExecuteNonQuery();
Response.Write("<script language='javascript'> alert('1 ROW DELETED
SUCCESSFULLY'); </script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "DELETED");
Response.Redirect("default.aspx");
conn.Close();
}
}