public void TestMethodRegisterUser()
        {
            inputName      = "TestUser";
            inputPassword  = "******";
            inputPasswordV = "ts0987";
            inputFullName  = "TestUserFull";

            bool expectedRegister = true;
            bool expectedLogin    = true;
            bool expectedDelete   = true;

            var c = new SqlConnection(Properties.Settings.Default.dbConnectionString);

            bool actualRegister = userRegister.Register(inputName, inputPassword, inputPasswordV, inputFullName);
            bool actualLogin    = userData.LogIn(inputName, inputPassword);
            int  actualUserId   = userData.UserID;

            ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM UserData WHERE UserName = '******'");
            int expectedUserId = Int32.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());

            Assert.AreEqual(expectedRegister, actualRegister);
            Assert.AreEqual(expectedLogin, actualLogin);
            Assert.AreEqual(expectedUserId, actualUserId);

            DBDelete dbD          = new DBDelete();
            bool     actualDelete = dbD.deleteRow("DELETE FROM UserData WHERE UserName = '******'", c);

            Assert.AreEqual(expectedDelete, actualDelete);
            c.Close();
        }
예제 #2
0
        public void TestMethodRegisterUser1()
        {
            inputName      = "Doll";
            inputPassword  = "******";
            inputPasswordV = "lb123";
            inputFullName  = "User1";

            bool expectedRegister = false;


            var c = new SqlConnection(Properties.Settings.Default.dbConnectionString);

            bool actualRegister = userRegister.Register(inputName, inputPassword, inputPasswordV, inputFullName);

            DBDelete dbD          = new DBDelete();
            bool     actualDelete = dbD.deleteRow("DELETE FROM UserData WHERE UserName = '******'", c);

            Assert.AreEqual(expectedRegister, actualRegister);

            c.Close();
        }
예제 #3
0
        public Boolean DELETE_FROM_TABLE(string stmt)
        {
            Boolean  flag = false;
            var      conn = new SqlConnection(Properties.Settings.Default.dbConnectionString);
            DBDelete dbD  = new DBDelete();

            try
            {
                flag = dbD.deleteRow(stmt, conn);
                return(flag);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
                return(false);
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
            }
        }