示例#1
0
        protected void submitButton_Click(object sender, EventArgs e)
        {
            UserTypeRegistrationDao userTypeRegistrationDao = new UserTypeRegistrationDao();

            userTypeRegistrationDao.UserType = userTypeDDList.SelectedItem.Text;
            if (userTypeRegistrationDao.UserType != "--Select--")
            {
                userTypeRegistrationDao.UserName        = userNameTextBox.Text;
                userTypeRegistrationDao.Password        = passwordTextBox.Text;
                userTypeRegistrationDao.ConfirmPassword = confirmTextBox.Text;

                UserTypeRegistrationInsertDal userTypeRegistrationDal = new UserTypeRegistrationInsertDal();
                string insert = userTypeRegistrationDal.GetInsertUserRegistrationDB(userTypeRegistrationDao);
                if (insert != null)
                {
                    Response.Write("<script>alert('User Creat Succful.')</script>");
                    userNameTextBox.Text = "";
                    passwordTextBox.Text = "";
                    confirmTextBox.Text  = "";
                    userTypeDDList.ClearSelection();
                }
                else
                {
                    Response.Write("<script>alert('User Creat failed.')</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('Select user type!')</script>");
                userTypeDDList.Focus();
            }
        }
        public string GetInsertUserRegistrationDB(UserTypeRegistrationDao userTypeRegistrationDao)
        {
            string          isSuccess  = "";
            ConnectionClass connection = new ConnectionClass();
            string          query      = "Insert into Registration_Form_T values('" + userTypeRegistrationDao.UserName + "','" + userTypeRegistrationDao.Password + "','" + userTypeRegistrationDao.UserType + "')";

            try
            {
                SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
                cmd.ExecuteNonQuery();
                isSuccess = "Insert Successful";
            }
            catch (Exception r)
            {
                isSuccess = "Insert Failed!";
            }
            finally
            {
                connection.GetClose();
            }
            return(isSuccess);
        }