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); }