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