Example #1
0
        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);
        }