public static void InsertData(string Username, string Password) { DbCommuner.SetConn(); DbCommuner.Connect(); string UserInsertQuery = "INSERT INTO UserRegistration(Username, Password) VALUES (@username,@password)"; using (DbCommuner.NetBankConn) { using (SqlCommand QueryUserInsert = new SqlCommand(UserInsertQuery, DbCommuner.NetBankConn)) { QueryUserInsert.Parameters.Add("@username", System.Data.SqlDbType.VarChar, 50).Value = Username; QueryUserInsert.Parameters.Add("@password", System.Data.SqlDbType.VarChar, 100).Value = Password; try { QueryUserInsert.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message + "\n\n" + ex.StackTrace); throw ex; } } } DbCommuner.Disconnect(); }
public static void VerifyUniqueUserDb() { string usernameQuery = "SELECT UserName FROM UserRegistration WHERE UserName = '******'"; using (DbCommuner.NetBankConn) { void checkUsername() { DbCommuner.SetConn(); DbCommuner.Connect(); SqlCommand QueryUsername = new SqlCommand(usernameQuery, DbCommuner.NetBankConn); using (SqlDataReader reader = QueryUsername.ExecuteReader()) { if (reader.HasRows) { Console.WriteLine("The username is not unique"); _IsUnique = false; } else { Console.WriteLine("The username is unique"); _IsUnique = true; } reader.Close(); } } checkUsername(); DbCommuner.Disconnect(); } }