public static List <CmbItem> GetRole()
{
conn.Open();
SqlCommand sqlCmd = new SqlCommand("select ID, Description from Role where ID != '" + "R5" + "'", conn);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
List <CmbItem> roleList = new List <CmbItem>();
while (sqlReader.Read())
{
var cmbItem = new CmbItem(sqlReader["ID"].ToString(), sqlReader["Description"].ToString());
roleList.Add(cmbItem);
}
return(roleList);
}
public void TestcaseList()
{
conn.Open();
List <CmbItem> tcList = new List <CmbItem>();
SqlCommand TestcaseQuery = new SqlCommand("SELECT ID, (ID + ' ' + Name) as Name FROM Testcases WHERE SubSystemID = '" + SubSystemIDTemp + "' order by DateTime ASC", conn);
SqlDataReader TestcaseRead = TestcaseQuery.ExecuteReader();
while (TestcaseRead.Read())
{
var cmbItem = new CmbItem(TestcaseRead["ID"].ToString(), TestcaseRead["Name"].ToString());
tcList.Add(cmbItem);
}
conn.Close();
cmbTestcase.DataSource = tcList;
cmbTestcase.DisplayMember = "Text";
cmbTestcase.ValueMember = "Text";
cmbTestcase.SelectedIndex = 0;
}
void ProjectInfo()
{
conn.Open();
List <CmbItem> itemList = new List <CmbItem>();
SqlCommand sqlCmd = new SqlCommand("select ID, Name from Projects", conn);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
var cmbItem = new CmbItem(sqlReader["ID"].ToString(), sqlReader["Name"].ToString());
itemList.Add(cmbItem);
}
conn.Close();
cmbProject.DataSource = itemList;
cmbProject.DisplayMember = "Text";
cmbProject.ValueMember = "ID";
cmbProject.SelectedIndex = 0;
}
void subsystemlist()
{
string projectID = cmbProject.SelectedValue.ToString();
conn.Open();
SqlCommand sqlCmd = new SqlCommand("select ID, Description from SubSystem Where ProjectID = '" + projectID + "'", conn);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
List <CmbItem> itemList = new List <CmbItem>();
while (sqlReader.Read())
{
var cmbItem = new CmbItem(sqlReader["ID"].ToString(), sqlReader["Description"].ToString());
itemList.Add(cmbItem);
}
conn.Close();
cmbSubSystem.DataSource = itemList;
cmbSubSystem.DisplayMember = "Text";
cmbSubSystem.ValueMember = "Id";
}
void AssigneeList()
{
subsystemid();
conn.Open();
List <CmbItem> asList = new List <CmbItem>();
SqlCommand AssigneeQuery = new SqlCommand("SELECT ID, Name FROM Users where ID in (select UserID from Assignment where UserID != '"
+ this.UserIDDD.ToString() + "' AND SubSystemID = '" + subSystem.ToString() + "')", conn);
SqlDataReader AssigneeRead = AssigneeQuery.ExecuteReader();
while (AssigneeRead.Read())
{
var cmbItem = new CmbItem(AssigneeRead["ID"].ToString(), AssigneeRead["Name"].ToString());
asList.Add(cmbItem);
}
conn.Close();
cmbAssignee.DataSource = asList;
cmbAssignee.DisplayMember = "Text";
cmbAssignee.ValueMember = "Text";
}