public bool insertUser(string Username, string Password)
{
My_DB mydb = new My_DB();
SqlCommand cmd = new SqlCommand("INSERT INTO log (Username, Password)" +
"VALUES (@username, @pass)", mydb.GetConnection);
cmd.Parameters.Add("@username", SqlDbType.NVarChar).Value = Username;
cmd.Parameters.Add("@pass", SqlDbType.NVarChar).Value = Password;
mydb.openConnection();
if (cmd.ExecuteNonQuery() == 1)
{
mydb.closeConnection();
return(true);
}
else
{
mydb.closeConnection();
return(false);
}
}
public bool verifyAccountUser(string username)
{
My_DB db = new My_DB();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("SELECT * FROM log WHERE Username = @username", db.GetConnection);
command.Parameters.Add("@username", SqlDbType.NVarChar).Value = username;
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}