public bool signup_check(SignUpBLL s) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "SELECT * FROM users WHERE contact=@contact"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@contact", s.contact); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); conn.Open(); adapter.Fill(dt); if (dt.Rows.Count == 1) { isSuccess = false; } else { isSuccess = true; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool signup(SignUpBLL s) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "INSERT INTO Users (first_name, last_name, contact, password) VALUES(@first_name, @last_name, @contact, @password) "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@first_name", s.first_name); cmd.Parameters.AddWithValue("@last_name", s.last_name); cmd.Parameters.AddWithValue("@contact", s.contact); cmd.Parameters.AddWithValue("@password", s.password); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }