private void DeveloperDropDownList_SelectedIndexChanged(object sender, System.EventArgs e)
{
/*
* get developer info and display it ...
*
* */
//initialize the DB object
DBDriver myDB = new DBDriver();
//set the appropriate SQL query
myDB.Query = "select person.ID, firstName, lastName, competence"
+ " from person, compLevels"
+ " where person.ID = compLevels.ID and person.ID=@devID;";
myDB.addParam("@devID", DeveloperDropDownList.SelectedValue);
//initialize the datareader
SqlDataReader dr = myDB.createReader();
//fill the datareader
dr.Read();
this.CancelButton.Visible = true; //reset buttons
this.SaveButton.Visible = true;
this.CompetenceDropDownList.Visible = true;
try
{
this.devFirstLabel.Text = Convert.ToString(dr["firstName"]);
this.devLastLabel.Text = Convert.ToString(dr["lastName"]);
this.CompetenceDropDownList.SelectedValue = dr["competence"].ToString();
}
catch
{
this.devFirstLabel.Text = "ERROR";
this.devLastLabel.Text = "ERROR";
}
myDB.close();
DeveloperPanel.Visible = true;
}
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
DBDriver myDB=new DBDriver();
string mID=Request.QueryString["id"];
myDB.Query="select u.userName sender, m.subject subject, m.timestamp date, m.body body from users u, messages m where m.ID=@mID and u.ID=m.senderID;";
myDB.addParam("@mID", mID);
SqlDataReader dr=myDB.createReader();
dr.Read();
this.subjectLabel.Text=Convert.ToString(dr["subject"]);
this.senderLabel.Text=Convert.ToString(dr["sender"]);
this.dateLabel.Text=Convert.ToString(dr["date"]);
this.messageLabel.Text=Convert.ToString(dr["body"]);
myDB.close();
}
private void syncCompetenceText()
{
//initialize the DB object
DBDriver myDB = new DBDriver();
//set the appropriate SQL query
myDB.Query = "select ID, competence"
+ " from compLevels"
+ " where compLevels.ID=@devID;";
myDB.addParam("@devID", DeveloperDropDownList.SelectedValue);
//initialize the datareader
SqlDataReader dr = myDB.createReader();
//fill the datareader
dr.Read();
this.CompetenceDropDownList.SelectedValue = Convert.ToString(dr["competence"]);
myDB.close();
}
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
DBDriver myDB = new DBDriver();
string mID = Request.QueryString["id"];
myDB.Query = "select u.userName sender, m.subject subject, m.timestamp date, m.body body from users u, messages m where m.ID=@mID and u.ID=m.senderID;";
myDB.addParam("@mID", mID);
SqlDataReader dr = myDB.createReader();
dr.Read();
this.subjectLabel.Text = Convert.ToString(dr["subject"]);
this.senderLabel.Text = Convert.ToString(dr["sender"]);
this.dateLabel.Text = Convert.ToString(dr["date"]);
this.messageLabel.Text = Convert.ToString(dr["body"]);
myDB.close();
}
private void DeveloperDropDownList_SelectedIndexChanged(object sender, System.EventArgs e)
{
/*
* get developer info and display it ...
*
* */
//initialize the DB object
DBDriver myDB=new DBDriver();
//set the appropriate SQL query
myDB.Query = "select person.ID, firstName, lastName, competence"
+ " from person, compLevels"
+ " where person.ID = compLevels.ID and person.ID=@devID;";
myDB.addParam("@devID", DeveloperDropDownList.SelectedValue);
//initialize the datareader
SqlDataReader dr = myDB.createReader();
//fill the datareader
dr.Read();
this.CancelButton.Visible = true; //reset buttons
this.SaveButton.Visible = true;
this.CompetenceDropDownList.Visible= true;
try
{
this.devFirstLabel.Text=Convert.ToString(dr["firstName"]);
this.devLastLabel.Text=Convert.ToString(dr["lastName"]);
this.CompetenceDropDownList.SelectedValue = dr["competence"].ToString();
}
catch
{
this.devFirstLabel.Text="ERROR";
this.devLastLabel.Text="ERROR";
}
myDB.close();
DeveloperPanel.Visible = true;
}
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if (!Page.IsPostBack)
{
/// fill drop down list
// initialize the DB object
DBDriver myDB = new DBDriver();
//set the query to select all projects
myDB.Query = "select p.ID as ID, p.lastName as lastName, p.firstName as firstName\n"
+ "from users u, person p\n"
+ "where u.security = 'Developer'\n"
+ "and p.ID = u.ID;";
//create a data set
//DataSet ds=new DataSet();
//initialize the data adapter
//fill the data set with the data adapter
SqlDataReader dr = myDB.createReader();
int i = 1;
DeveloperDropDownList.Items.Insert(0, "");
while (dr.Read())
{
DeveloperDropDownList.Items.Insert(i, dr["lastName"].ToString() + ", " + dr["firstName"].ToString());
DeveloperDropDownList.Items[i].Value = dr["ID"].ToString();
i++;
}
myDB.close();
CompetenceDropDownList.Items.Insert(0, "Low");
CompetenceDropDownList.Items[0].Value = "Low";
CompetenceDropDownList.Items.Insert(1, "Medium");
CompetenceDropDownList.Items[1].Value = "Medium";
CompetenceDropDownList.Items.Insert(2, "High");
CompetenceDropDownList.Items[2].Value = "High";
}
}
private void syncCompetenceText()
{
//initialize the DB object
DBDriver myDB=new DBDriver();
//set the appropriate SQL query
myDB.Query="select ID, competence"
+" from compLevels"
+" where compLevels.ID=@devID;";
myDB.addParam("@devID", DeveloperDropDownList.SelectedValue);
//initialize the datareader
SqlDataReader dr = myDB.createReader();
//fill the datareader
dr.Read();
this.CompetenceDropDownList.SelectedValue = Convert.ToString(dr["competence"]);
myDB.close();
}
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if(!Page.IsPostBack)
{
/// fill drop down list
// initialize the DB object
DBDriver myDB=new DBDriver();
//set the query to select all projects
myDB.Query = "select p.ID as ID, p.lastName as lastName, p.firstName as firstName\n"
+ "from users u, person p\n"
+ "where u.security = 'Developer'\n"
+ "and p.ID = u.ID;";
//create a data set
//DataSet ds=new DataSet();
//initialize the data adapter
//fill the data set with the data adapter
SqlDataReader dr = myDB.createReader();
int i = 1;
DeveloperDropDownList.Items.Insert(0,"");
while( dr.Read() )
{
DeveloperDropDownList.Items.Insert(i,dr["lastName"].ToString() + ", " + dr["firstName"].ToString());
DeveloperDropDownList.Items[i].Value = dr["ID"].ToString();
i++;
}
myDB.close();
CompetenceDropDownList.Items.Insert(0,"Low");
CompetenceDropDownList.Items[0].Value= "Low";
CompetenceDropDownList.Items.Insert(1,"Medium");
CompetenceDropDownList.Items[1].Value= "Medium";
CompetenceDropDownList.Items.Insert(2,"High");
CompetenceDropDownList.Items[2].Value= "High";
}
}
