protected void addButton_Click(object sender, EventArgs e) { testNames = (List <TestNamesWithType>)ViewState["TestNames"]; TestNamesWithType testName = new TestNamesWithType(); testName.TestName = selectTestDropDownList.SelectedItem.Text; testName.Id = Convert.ToInt32(selectTestDropDownList.SelectedValue); testName.Fee = Convert.ToDouble(feeTextBox.Value); bool doesTestNameExist = false; foreach (TestNamesWithType test in testNames) { if (test.TestName == testName.TestName) { doesTestNameExist = true; break; } } if (doesTestNameExist) { messageLabel.Text = "<span style='color:red;font-size:15px;font-weight:bold;font-style:italic;'>Test Name already entered.</span>"; ViewState["TestNames"] = testNames; PopulateTestNameGridView(); } else { testNames.Add(testName); //showAllTestEntryGridView.DataSource = testNames; //showAllTestEntryGridView.DataBind(); ViewState["TestNames"] = testNames; PopulateTestNameGridView(); } }
public List <TestNamesWithType> GetAllTestNames() { Query = "SELECT * FROM TestNamesWithType ORDER BY testName"; Command = new SqlCommand(Query, Connection); List <TestNamesWithType> testNames = new List <TestNamesWithType>(); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { TestNamesWithType testNamesWithType = new TestNamesWithType(); testNamesWithType.Id = Convert.ToInt32(Reader["ID"]); testNamesWithType.Fee = Convert.ToDouble(Reader["fee"]); testNamesWithType.TestName = Reader["testName"].ToString(); testNamesWithType.TestType = Reader["testType"].ToString(); testNames.Add(testNamesWithType); } Reader.Close(); Connection.Close(); return(testNames); }