示例#1
0
        private void update_btn_Click(object sender, EventArgs e)
        {
            string  errorMsg = "";
            bool    tempHold;
            decimal customVal;

            tempHold = decimal.TryParse(unBox.Text, out customVal);
            if (tempHold == false)
            {
                customVal = -1;
            }



            if (obCo.Text == "Student")
            {
                student stuOb = new student(obCo.Text, idBox.Text, firstBox.Text, lastBox.Text, unCo.Text, customVal);
                errorMsg = stuOb.ErrorMsg();
                if (errorMsg == "")// had to make these gross looking nested if statements to generate the errorMsg value twice to output SQL exceptions to the user (breaking the unique value restriction on BuddyId)
                {
                    stuOb.updateSQL(oldBox.Text);
                    errorMsg = stuOb.ErrorMsg();
                    if (errorMsg == "")
                    {
                        outLb.Text = stuOb.displayMe() + "\n\nStudent object updated successfully!";
                    }
                    else
                    {
                        outLb.Text = errorMsg;
                    }
                }
                else
                {
                    outLb.Text = errorMsg;
                }
            }

            if (obCo.Text == "Teacher")
            {
                teacher teaOb = new teacher(obCo.Text, idBox.Text, firstBox.Text, lastBox.Text, unCo.Text, customVal);
                errorMsg = teaOb.ErrorMsg();
                if (errorMsg == "")
                {
                    teaOb.updateSQL(oldBox.Text);
                    errorMsg = teaOb.ErrorMsg();
                    if (errorMsg == "")
                    {
                        outLb.Text = teaOb.displayMe() + "\n\nTeacher object updated successfully!";
                    }
                    else
                    {
                        outLb.Text = errorMsg;
                    }
                }
                else
                {
                    outLb.Text = errorMsg;
                }
            }

            if (obCo.Text == "Administrator")
            {
                administrator admOb = new administrator(obCo.Text, idBox.Text, firstBox.Text, lastBox.Text, unCo.Text, customVal);
                errorMsg = admOb.ErrorMsg();
                if (errorMsg == "")
                {
                    admOb.updateSQL(oldBox.Text);
                    errorMsg = admOb.ErrorMsg();
                    if (errorMsg == "")
                    {
                        outLb.Text = admOb.displayMe() + "\n\nAdministrator object updated successfully!";
                    }
                    else
                    {
                        outLb.Text = errorMsg;
                    }
                }
                else
                {
                    outLb.Text = errorMsg;
                }
            }


            if (errorMsg == "")
            {
                cancel_btn.Text    = "Finish";
                update_btn.Visible = false;
            }
        }
示例#2
0
        private void button1_Click(object sender, EventArgs e)
        {
            //new sql stuffffff



            /*
             * string connString = "Data Source = sql.neit.edu,4500; Initial Catalog =SE245_CBrown; User ID=se245_Cbrown; Password=Hsilop401;";
             * SqlConnection connection = new SqlConnection(connString);
             * string selectStatement = "SELECT ProductCode, Description, UnitPrice, OnHandQuantity FROM Products WHERE ProductCode= @ProductCode";
             * SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
             * selectCommand.Parameters.AddWithValue("@ProductCode", productID);
             * connection.Open();
             * SqlDataReader customerReader = selectCommand.ExecuteReader();
             * customerReader.Read();
             * connection.Close();
             *
             */

            //end of new sql stufffffffffff



            bool    fff;
            string  errorMsg = "";
            decimal customVal;

            fff = decimal.TryParse(unBox.Text, out customVal);
            if (fff == false)
            {
                customVal = -1;
            }



            if (obCo.Text == "Student")
            {
                student stuOb = new student(obCo.Text, idBox.Text, firstBox.Text, lastBox.Text, unCo.Text, customVal);
                if (errorMsg == "") // had to make these gross looking nested if statements to generate the errorMsg value twice to output SQL exceptions to the user (breaking the unique value restriction on BuddyId)
                {                   //no i didn't that was dumbbbb
                    stuOb.sendSQL();
                    errorMsg = stuOb.ErrorMsg();
                    if (errorMsg == "")
                    {
                        outLb.Text = stuOb.displayMe() + "\n\nStudent object created successfully!";
                    }
                    else
                    {
                        outLb.Text = errorMsg;
                    }
                }
                else
                {
                    outLb.Text = errorMsg;
                }
            }

            if (obCo.Text == "Teacher")
            {
                teacher teaOb = new teacher(obCo.Text, idBox.Text, firstBox.Text, lastBox.Text, unCo.Text, customVal);
                if (errorMsg == "")
                {
                    teaOb.sendSQL();
                    errorMsg = teaOb.ErrorMsg();
                    if (errorMsg == "")
                    {
                        outLb.Text = teaOb.displayMe() + "\n\nTeacher object created successfully!";
                    }
                    else
                    {
                        outLb.Text = errorMsg;
                    }
                }
                else
                {
                    outLb.Text = errorMsg;
                }
            }

            if (obCo.Text == "Administrator")
            {
                administrator admOb = new administrator(obCo.Text, idBox.Text, firstBox.Text, lastBox.Text, unCo.Text, customVal);
                if (errorMsg == "")
                {
                    admOb.sendSQL();
                    errorMsg = admOb.ErrorMsg();
                    if (errorMsg == "")
                    {
                        outLb.Text = admOb.displayMe() + "\n\nAdministrator object created successfully!";
                    }
                    else
                    {
                        outLb.Text = errorMsg;
                    }
                }
                else
                {
                    outLb.Text = errorMsg;
                }
            }
        }